C# Class Priya.InfoList.Data.DataSource

Mostra file Open project: Srid68/Priya.InfoList

Public Properties

Property	Type	Description
CheckSetupDb	bool
ConnectionString	string
DbName	string
ProviderNameFactory	string
UseFileSystem	bool
UseSharedConnection	bool

Public Methods

Method	Description
AbortTransaction ( ) : void
BeginTransaction ( ) : void
CompleteTransaction ( ) : void
DeleteCndData ( long cndDataId ) : void
DeleteCnsDataRefType ( long cnsDataRefTypeId ) : void
DeleteCnsDataType ( long cnsDataTypeId ) : void
DeleteLtdInfoCategory ( long ltdInfoCategoryId ) : void
DeleteLtdInfoDetail ( long ltdInfoDetailId ) : void
DeleteLtdInfoPage ( long ltdInfoPageId ) : void
DeleteLtdInfoSection ( long ltdInfoSectionId ) : void
DeleteLtdSubscriber ( long ltdSubscriberId ) : void
DeleteSysVersion ( long sysVersionId ) : void
GetCndData ( long dataID, string orWhereClause ) : CND_Data
GetCnsDataRefType ( long dataRefTypeID, string orWhereClause ) : CNS_DataRefType
GetCnsDataRefType ( string dataRefType ) : CNS_DataRefType
GetCnsDataType ( long dataTypeID, string orWhereClause ) : CNS_DataType
GetCnsDataType ( string dataType ) : CNS_DataType
GetDefaultCnsDataRefType ( ) : CNS_DataRefType
GetDefaultCnsDataRefTypeId ( ) : long
GetDefaultCnsDataType ( ) : CNS_DataType
GetDefaultCnsDataTypeId ( ) : long
GetDefaultLtdInfoCategory ( ) : LTD_InfoCategory
GetJsonRecord ( string tableName, long minRevisionNo, long pageNo, long itemsPerPage, long &retTotalPages, long &retTotalItems ) : string
GetLtdInfoCategory ( long infoCategoryID, string orWhereClause ) : LTD_InfoCategory
GetLtdInfoCategory ( string infoCategoryName ) : LTD_InfoCategory
GetLtdInfoDetail ( long infoDetailID, string orWhereClause ) : LTD_InfoDetail
GetLtdInfoPage ( long infoPageID, string orWhereClause ) : LTD_InfoPage
GetLtdInfoSection ( long infoSectionID, string orWhereClause ) : LTD_InfoSection
GetLtdSubscriber ( long subscriberID, string orWhereClause ) : LTD_Subscriber
GetLtdSubscriber ( string subscriberEmail ) : LTD_Subscriber
GetLtdSubscriberCount ( ) : long
GetMaxCndDataId ( string whereClause ) : long
GetMaxCnsDataRefTypeId ( string whereClause ) : long
GetMaxCnsDataTypeId ( string whereClause ) : long
GetMaxLtdInfoCategoryId ( string whereClause ) : long
GetMaxLtdInfoDetailId ( string whereClause ) : long
GetMaxLtdInfoPageId ( string whereClause ) : long
GetMaxLtdInfoSectionId ( string whereClause ) : long
GetMaxLtdSubscriberId ( string whereClause ) : long
GetMaxRevisionNo ( string tableName ) : long
GetMaxSysVersionId ( string whereClause ) : double
GetPagedCndData ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedCnsDataRefType ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedCnsDataType ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedLtdInfoCategory ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedLtdInfoDetail ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedLtdInfoPage ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedLtdInfoSection ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedLtdSubscriber ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetPagedSysVersion ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
GetSysVersion ( double versionNo, string orWhereClause ) : SYS_Version
InsertCndData ( CND_Data cndData ) : long
InsertCnsDataRefType ( CNS_DataRefType cnsDataRefType ) : long
InsertCnsDataType ( CNS_DataType cnsDataType ) : long
InsertLtdInfoCategory ( LTD_InfoCategory ltdInfoCategory ) : long
InsertLtdInfoDetail ( LTD_InfoDetail ltdInfoDetail ) : long
InsertLtdInfoPage ( LTD_InfoPage ltdInfoPage ) : long
InsertLtdInfoSection ( LTD_InfoSection ltdInfoSection ) : long
InsertLtdSubscriber ( LTD_Subscriber ltdSubscriber ) : long
InsertSysVersion ( SYS_Version sysVersion ) : double
SaveJsonRecord ( string tableName, string jsonRecordList ) : void
UpdateCndData ( CND_Data cndData ) : bool
UpdateCnsDataRefType ( CNS_DataRefType cnsDataRefType ) : bool
UpdateCnsDataType ( CNS_DataType cnsDataType ) : bool
UpdateLtdInfoCategory ( LTD_InfoCategory ltdInfoCategory ) : bool
UpdateLtdInfoDetail ( LTD_InfoDetail ltdInfoDetail ) : bool
UpdateLtdInfoPage ( LTD_InfoPage ltdInfoPage ) : bool
UpdateLtdInfoSection ( LTD_InfoSection ltdInfoSection ) : bool
UpdateLtdSubscriber ( LTD_Subscriber ltdSubscriber ) : bool
UpdateSysVersion ( SYS_Version sysVersion ) : bool

Private Methods

Method	Description
GetMaxCndDataRevisionNo ( ) : long
GetMaxCnsDataRefTypeRevisionNo ( ) : long
GetMaxCnsDataTypeRevisionNo ( ) : long
GetMaxLtdInfoCategoryRevisionNo ( ) : long
GetMaxLtdInfoDetailRevisionNo ( ) : long
GetMaxLtdInfoPageRevisionNo ( ) : long
GetMaxLtdInfoSectionRevisionNo ( ) : long
GetMaxLtdSubscriberRevisionNo ( ) : long
GetUserInfo ( ) : UserInfo
GetWhereList ( string whereClause ) : string>.Dictionary
HaveDb ( ) : PetaPoco.Database
InitDb ( ) : void
OnDBException ( Exception ex, string lastCommand, string lastSQL, PetaPoco.Database db ) : void

Method Details

AbortTransaction() public static method

public static AbortTransaction ( ) : void
return	void

BeginTransaction() public static method

public static BeginTransaction ( ) : void
return	void

CompleteTransaction() public static method

public static CompleteTransaction ( ) : void
return	void

DeleteCndData() public static method

public static DeleteCndData ( long cndDataId ) : void
cndDataId	long
return	void

DeleteCnsDataRefType() public static method

public static DeleteCnsDataRefType ( long cnsDataRefTypeId ) : void
cnsDataRefTypeId	long
return	void

DeleteCnsDataType() public static method

public static DeleteCnsDataType ( long cnsDataTypeId ) : void
cnsDataTypeId	long
return	void

DeleteLtdInfoCategory() public static method

public static DeleteLtdInfoCategory ( long ltdInfoCategoryId ) : void
ltdInfoCategoryId	long
return	void

DeleteLtdInfoDetail() public static method

public static DeleteLtdInfoDetail ( long ltdInfoDetailId ) : void
ltdInfoDetailId	long
return	void

DeleteLtdInfoPage() public static method

public static DeleteLtdInfoPage ( long ltdInfoPageId ) : void
ltdInfoPageId	long
return	void

DeleteLtdInfoSection() public static method

public static DeleteLtdInfoSection ( long ltdInfoSectionId ) : void
ltdInfoSectionId	long
return	void

DeleteLtdSubscriber() public static method

public static DeleteLtdSubscriber ( long ltdSubscriberId ) : void
ltdSubscriberId	long
return	void

DeleteSysVersion() public static method

public static DeleteSysVersion ( long sysVersionId ) : void
sysVersionId	long
return	void

GetCndData() public static method

public static GetCndData ( long dataID, string orWhereClause ) : CND_Data
dataID	long
orWhereClause	string
return	Priya.InfoList.Entity.CND_Data

GetCnsDataRefType() public static method

public static GetCnsDataRefType ( long dataRefTypeID, string orWhereClause ) : CNS_DataRefType
dataRefTypeID	long
orWhereClause	string
return	Priya.InfoList.Entity.CNS_DataRefType

GetCnsDataRefType() public static method

public static GetCnsDataRefType ( string dataRefType ) : CNS_DataRefType
dataRefType	string
return	Priya.InfoList.Entity.CNS_DataRefType

GetCnsDataType() public static method

public static GetCnsDataType ( long dataTypeID, string orWhereClause ) : CNS_DataType
dataTypeID	long
orWhereClause	string
return	Priya.InfoList.Entity.CNS_DataType

GetCnsDataType() public static method

public static GetCnsDataType ( string dataType ) : CNS_DataType
dataType	string
return	Priya.InfoList.Entity.CNS_DataType

GetDefaultCnsDataRefType() public static method

public static GetDefaultCnsDataRefType ( ) : CNS_DataRefType
return	Priya.InfoList.Entity.CNS_DataRefType

GetDefaultCnsDataRefTypeId() public static method

public static GetDefaultCnsDataRefTypeId ( ) : long
return	long

GetDefaultCnsDataType() public static method

public static GetDefaultCnsDataType ( ) : CNS_DataType
return	Priya.InfoList.Entity.CNS_DataType

GetDefaultCnsDataTypeId() public static method

public static GetDefaultCnsDataTypeId ( ) : long
return	long

GetDefaultLtdInfoCategory() public static method

public static GetDefaultLtdInfoCategory ( ) : LTD_InfoCategory
return	Priya.InfoList.Entity.LTD_InfoCategory

GetJsonRecord() public static method

public static GetJsonRecord ( string tableName, long minRevisionNo, long pageNo, long itemsPerPage, long &retTotalPages, long &retTotalItems ) : string
tableName	string
minRevisionNo	long
pageNo	long
itemsPerPage	long
retTotalPages	long
retTotalItems	long
return	string

GetLtdInfoCategory() public static method

public static GetLtdInfoCategory ( long infoCategoryID, string orWhereClause ) : LTD_InfoCategory
infoCategoryID	long
orWhereClause	string
return	Priya.InfoList.Entity.LTD_InfoCategory

GetLtdInfoCategory() public static method

public static GetLtdInfoCategory ( string infoCategoryName ) : LTD_InfoCategory
infoCategoryName	string
return	Priya.InfoList.Entity.LTD_InfoCategory

GetLtdInfoDetail() public static method

public static GetLtdInfoDetail ( long infoDetailID, string orWhereClause ) : LTD_InfoDetail
infoDetailID	long
orWhereClause	string
return	Priya.InfoList.Entity.LTD_InfoDetail

GetLtdInfoPage() public static method

public static GetLtdInfoPage ( long infoPageID, string orWhereClause ) : LTD_InfoPage
infoPageID	long
orWhereClause	string
return	Priya.InfoList.Entity.LTD_InfoPage

GetLtdInfoSection() public static method

public static GetLtdInfoSection ( long infoSectionID, string orWhereClause ) : LTD_InfoSection
infoSectionID	long
orWhereClause	string
return	Priya.InfoList.Entity.LTD_InfoSection

GetLtdSubscriber() public static method

public static GetLtdSubscriber ( long subscriberID, string orWhereClause ) : LTD_Subscriber
subscriberID	long
orWhereClause	string
return	Priya.InfoList.Entity.LTD_Subscriber

GetLtdSubscriber() public static method

public static GetLtdSubscriber ( string subscriberEmail ) : LTD_Subscriber
subscriberEmail	string
return	Priya.InfoList.Entity.LTD_Subscriber

GetLtdSubscriberCount() public static method

public static GetLtdSubscriberCount ( ) : long
return	long

GetMaxCndDataId() public static method

public static GetMaxCndDataId ( string whereClause ) : long
whereClause	string
return	long

GetMaxCnsDataRefTypeId() public static method

public static GetMaxCnsDataRefTypeId ( string whereClause ) : long
whereClause	string
return	long

GetMaxCnsDataTypeId() public static method

public static GetMaxCnsDataTypeId ( string whereClause ) : long
whereClause	string
return	long

GetMaxLtdInfoCategoryId() public static method

public static GetMaxLtdInfoCategoryId ( string whereClause ) : long
whereClause	string
return	long

GetMaxLtdInfoDetailId() public static method

public static GetMaxLtdInfoDetailId ( string whereClause ) : long
whereClause	string
return	long

GetMaxLtdInfoPageId() public static method

public static GetMaxLtdInfoPageId ( string whereClause ) : long
whereClause	string
return	long

GetMaxLtdInfoSectionId() public static method

public static GetMaxLtdInfoSectionId ( string whereClause ) : long
whereClause	string
return	long

GetMaxLtdSubscriberId() public static method

public static GetMaxLtdSubscriberId ( string whereClause ) : long
whereClause	string
return	long

GetMaxRevisionNo() public static method

public static GetMaxRevisionNo ( string tableName ) : long
tableName	string
return	long

GetMaxSysVersionId() public static method

public static GetMaxSysVersionId ( string whereClause ) : double
whereClause	string
return	double

GetPagedCndData() public static method

public static GetPagedCndData ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedCnsDataRefType() public static method

public static GetPagedCnsDataRefType ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedCnsDataType() public static method

public static GetPagedCnsDataType ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedLtdInfoCategory() public static method

public static GetPagedLtdInfoCategory ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedLtdInfoDetail() public static method

public static GetPagedLtdInfoDetail ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedLtdInfoPage() public static method

public static GetPagedLtdInfoPage ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedLtdInfoSection() public static method

public static GetPagedLtdInfoSection ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedLtdSubscriber() public static method

public static GetPagedLtdSubscriber ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetPagedSysVersion() public static method

public static GetPagedSysVersion ( long pageNo, long itemsPerPage, long &totalPages, long &totalItems, string orderByClause, string whereClause ) : List
pageNo	long
itemsPerPage	long
totalPages	long
totalItems	long
orderByClause	string
whereClause	string
return	List

GetSysVersion() public static method

public static GetSysVersion ( double versionNo, string orWhereClause ) : SYS_Version
versionNo	double
orWhereClause	string
return	Priya.InfoList.Entity.SYS_Version

InsertCndData() public static method

public static InsertCndData ( CND_Data cndData ) : long
cndData	Priya.InfoList.Entity.CND_Data
return	long

InsertCnsDataRefType() public static method

public static InsertCnsDataRefType ( CNS_DataRefType cnsDataRefType ) : long
cnsDataRefType	Priya.InfoList.Entity.CNS_DataRefType
return	long

InsertCnsDataType() public static method

public static InsertCnsDataType ( CNS_DataType cnsDataType ) : long
cnsDataType	Priya.InfoList.Entity.CNS_DataType
return	long

InsertLtdInfoCategory() public static method

public static InsertLtdInfoCategory ( LTD_InfoCategory ltdInfoCategory ) : long
ltdInfoCategory	Priya.InfoList.Entity.LTD_InfoCategory
return	long

InsertLtdInfoDetail() public static method

public static InsertLtdInfoDetail ( LTD_InfoDetail ltdInfoDetail ) : long
ltdInfoDetail	Priya.InfoList.Entity.LTD_InfoDetail
return	long

InsertLtdInfoPage() public static method

public static InsertLtdInfoPage ( LTD_InfoPage ltdInfoPage ) : long
ltdInfoPage	Priya.InfoList.Entity.LTD_InfoPage
return	long

InsertLtdInfoSection() public static method

public static InsertLtdInfoSection ( LTD_InfoSection ltdInfoSection ) : long
ltdInfoSection	Priya.InfoList.Entity.LTD_InfoSection
return	long

InsertLtdSubscriber() public static method

public static InsertLtdSubscriber ( LTD_Subscriber ltdSubscriber ) : long
ltdSubscriber	Priya.InfoList.Entity.LTD_Subscriber
return	long

InsertSysVersion() public static method

public static InsertSysVersion ( SYS_Version sysVersion ) : double
sysVersion	Priya.InfoList.Entity.SYS_Version
return	double

SaveJsonRecord() public static method

public static SaveJsonRecord ( string tableName, string jsonRecordList ) : void
tableName	string
jsonRecordList	string
return	void

UpdateCndData() public static method

public static UpdateCndData ( CND_Data cndData ) : bool
cndData	Priya.InfoList.Entity.CND_Data
return	bool

UpdateCnsDataRefType() public static method

public static UpdateCnsDataRefType ( CNS_DataRefType cnsDataRefType ) : bool
cnsDataRefType	Priya.InfoList.Entity.CNS_DataRefType
return	bool

UpdateCnsDataType() public static method

public static UpdateCnsDataType ( CNS_DataType cnsDataType ) : bool
cnsDataType	Priya.InfoList.Entity.CNS_DataType
return	bool

UpdateLtdInfoCategory() public static method

public static UpdateLtdInfoCategory ( LTD_InfoCategory ltdInfoCategory ) : bool
ltdInfoCategory	Priya.InfoList.Entity.LTD_InfoCategory
return	bool

UpdateLtdInfoDetail() public static method

public static UpdateLtdInfoDetail ( LTD_InfoDetail ltdInfoDetail ) : bool
ltdInfoDetail	Priya.InfoList.Entity.LTD_InfoDetail
return	bool

UpdateLtdInfoPage() public static method

public static UpdateLtdInfoPage ( LTD_InfoPage ltdInfoPage ) : bool
ltdInfoPage	Priya.InfoList.Entity.LTD_InfoPage
return	bool

UpdateLtdInfoSection() public static method

public static UpdateLtdInfoSection ( LTD_InfoSection ltdInfoSection ) : bool
ltdInfoSection	Priya.InfoList.Entity.LTD_InfoSection
return	bool

UpdateLtdSubscriber() public static method

public static UpdateLtdSubscriber ( LTD_Subscriber ltdSubscriber ) : bool
ltdSubscriber	Priya.InfoList.Entity.LTD_Subscriber
return	bool

UpdateSysVersion() public static method

public static UpdateSysVersion ( SYS_Version sysVersion ) : bool
sysVersion	Priya.InfoList.Entity.SYS_Version
return	bool

Property Details

CheckSetupDb public_oe static_oe property

public static bool CheckSetupDb
return	bool

ConnectionString public_oe static_oe property

public static string ConnectionString
return	string

DbName public_oe static_oe property

public static string DbName
return	string

ProviderNameFactory public_oe static_oe property

public static string ProviderNameFactory
return	string

UseFileSystem public_oe static_oe property

public static bool UseFileSystem
return	bool

UseSharedConnection public_oe static_oe property

public static bool UseSharedConnection
return	bool