C# Class Priya.InfoList.Data.DataSource

Show 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 static property

public static bool CheckSetupDb
return	bool

ConnectionString public static property

public static string ConnectionString
return	string

DbName public static property

public static string DbName
return	string

ProviderNameFactory public static property

public static string ProviderNameFactory
return	string

UseFileSystem public static property

public static bool UseFileSystem
return	bool

UseSharedConnection public static property

public static bool UseSharedConnection
return	bool