C# 클래스 Engage.Dnn.Locator.Data.DataProvider

An abstract representation of the data access for Engage: Locator

파일 보기 프로젝트 열기: EngageSoftware/Engage-Locator

공개 메소드들

메소드	설명
AddAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
AddAttributeDefinition ( int portalId, int locationTypeId, int dataType, string defaultValue, string attributeName, bool required, string validationExpression, int viewOrder, bool visible, int length ) : int
ClearLocations ( int portalId ) : void
ClearTempLocations ( ) : void
CopyData ( ) : string
DeleteAttributeDefinition ( int definitionId ) : void
DeleteComment ( int commentId ) : void
DeleteLocation ( int locationId ) : void
DeleteLocationType ( int locationTypeId ) : void
GetAllLocations ( int portalId, bool approved, string sortColumn, int index, int pageSize ) : DataTable
GetAllLocationsByDistance ( double latitude, double longitude, int radius, int portalId, int locationTypeIds, int pageIndex, int pageSize ) : IDataReader	Gets a list of the locations in the given locationTypeIds, ordered by their distance from the given coordinates
GetAllLocationsByType ( int portalId, int locationTypeIds, int pageIndex, int pageSize ) : IDataReader	Gets a list of the locations in the given locationTypeIds.
GetAttributeDefinition ( int definitionId ) : IDataReader
GetAttributeDefinitionByName ( int locationTypeId, string name ) : IDataReader
GetAttributeDefinitions ( int locationTypeId ) : DataTable
GetAttributeDefinitionsById ( int locationTypeId ) : IDataReader
GetAttributeValues ( int locationId ) : DataTable
GetComment ( int commentId ) : Comment
GetComments ( int locationId, bool approved ) : DataSet
GetCountriesList ( int portalId ) : DataTable
GetEmailByFileId ( int fileId ) : DataTable
GetEngageLocatorTabModules ( int portalId ) : DataTable
GetFilesToImport ( ) : DataTable
GetImportedLocationStatistics ( int portalId ) : DataTable
GetLastImportIndex ( ) : int
GetLatitudeLongitude ( string address, string city ) : DataTable
GetLocation ( int locationId ) : IDataReader
GetLocationType ( int id ) : DataTable
GetLocationTypeCount ( string type ) : int
GetLocationTypeName ( int id ) : DataTable
GetLocationTypes ( ) : DataTable
GetLocations ( int typeId, int portalId ) : DataTable
GetLocationsByCountry ( int countryId, int portalId, int pageIndex, int pageSize ) : IDataReader	Gets the locations in a given country.
GetNClosestLocations ( double latitude, double longitude, int count, int portalId ) : DataTable
GetNewSubmittedComments ( int portalId, bool approved ) : DataTable
GetTabModuleIdByFileId ( int fileId ) : int
InsertComment ( int locationId, string comment, string submittedBy, bool approved ) : void
InsertFileInfo ( int fileId, int userId, int tabModuleId, int portalId, System.DateTime uploadDate, bool succeeded, bool processed ) : void
InsertLocationType ( string locationTypeName ) : int
SaveComment ( Comment comment ) : void
SaveLocation ( Location loc ) : int
SaveTempLocation ( Location loc, bool successful ) : int
UpdateAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
UpdateAttributeDefinition ( int definitionId, int dataType, string defaultValue, string attributeName, bool required, string validationExpression, int viewOrder, bool visible, int length ) : int
UpdateComment ( int locationId, string comment, string submittedBy, bool approved, int userId ) : void
UpdateImportedLocationRow ( int fileId ) : void
UpdateLocation ( Location loc ) : int
UpdateLocationType ( int locationTypeId, string locationTypeName ) : void

비공개 메소드들

메소드	설명
GetConnectionString ( ) : string	Gets the configured connection string for this site's data provider.
Instance ( ) : DataProvider

메소드 상세

AddAttribute() 공개 추상적인 메소드

public abstract AddAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
attributeDefinitionId	int
locationId	int
attributeValue	string
리턴	void

AddAttributeDefinition() 공개 추상적인 메소드

public abstract AddAttributeDefinition ( int portalId, int locationTypeId, int dataType, string defaultValue, string attributeName, bool required, string validationExpression, int viewOrder, bool visible, int length ) : int
portalId	int
locationTypeId	int
dataType	int
defaultValue	string
attributeName	string
required	bool
validationExpression	string
viewOrder	int
visible	bool
length	int
리턴	int

ClearLocations() 공개 추상적인 메소드

public abstract ClearLocations ( int portalId ) : void
portalId	int
리턴	void

ClearTempLocations() 공개 추상적인 메소드

public abstract ClearTempLocations ( ) : void
리턴	void

CopyData() 공개 추상적인 메소드

public abstract CopyData ( ) : string
리턴	string

DeleteAttributeDefinition() 공개 추상적인 메소드

public abstract DeleteAttributeDefinition ( int definitionId ) : void
definitionId	int
리턴	void

DeleteComment() 공개 추상적인 메소드

public abstract DeleteComment ( int commentId ) : void
commentId	int
리턴	void

DeleteLocation() 공개 추상적인 메소드

public abstract DeleteLocation ( int locationId ) : void
locationId	int
리턴	void

DeleteLocationType() 공개 추상적인 메소드

public abstract DeleteLocationType ( int locationTypeId ) : void
locationTypeId	int
리턴	void

GetAllLocations() 공개 추상적인 메소드

public abstract GetAllLocations ( int portalId, bool approved, string sortColumn, int index, int pageSize ) : DataTable
portalId	int
approved	bool
sortColumn	string
index	int
pageSize	int
리턴	System.Data.DataTable

GetAllLocationsByDistance() 공개 추상적인 메소드

Gets a list of the locations in the given locationTypeIds, ordered by their distance from the given coordinates

public abstract GetAllLocationsByDistance ( double latitude, double longitude, int radius, int portalId, int locationTypeIds, int pageIndex, int pageSize ) : IDataReader
latitude	double	The latitude of the search location.
longitude	double	The longitude of the search location.
radius	int
portalId	int	The portal ID.
locationTypeIds	int	The IDs of the types of locations to retrieve.
pageIndex	int	Index of the page, or null if not paging.
pageSize	int	Size of the page, or null if not paging.
리턴	IDataReader

GetAllLocationsByType() 공개 추상적인 메소드

Gets a list of the locations in the given locationTypeIds.

public abstract GetAllLocationsByType ( int portalId, int locationTypeIds, int pageIndex, int pageSize ) : IDataReader
portalId	int	The portal ID.
locationTypeIds	int	The IDs of the types of locations to retrieve.
pageIndex	int	Index of the page, or null if not paging.
pageSize	int	Size of the page, or null if not paging.
리턴	IDataReader

GetAttributeDefinition() 공개 추상적인 메소드

public abstract GetAttributeDefinition ( int definitionId ) : IDataReader
definitionId	int
리턴	IDataReader

GetAttributeDefinitionByName() 공개 추상적인 메소드

public abstract GetAttributeDefinitionByName ( int locationTypeId, string name ) : IDataReader
locationTypeId	int
name	string
리턴	IDataReader

GetAttributeDefinitions() 공개 추상적인 메소드

public abstract GetAttributeDefinitions ( int locationTypeId ) : DataTable
locationTypeId	int
리턴	System.Data.DataTable

GetAttributeDefinitionsById() 공개 추상적인 메소드

public abstract GetAttributeDefinitionsById ( int locationTypeId ) : IDataReader
locationTypeId	int
리턴	IDataReader

GetAttributeValues() 공개 추상적인 메소드

public abstract GetAttributeValues ( int locationId ) : DataTable
locationId	int
리턴	System.Data.DataTable

GetComment() 공개 추상적인 메소드

public abstract GetComment ( int commentId ) : Comment
commentId	int
리턴	Comment

GetComments() 공개 추상적인 메소드

public abstract GetComments ( int locationId, bool approved ) : DataSet
locationId	int
approved	bool
리턴	System.Data.DataSet

GetCountriesList() 공개 추상적인 메소드

public abstract GetCountriesList ( int portalId ) : DataTable
portalId	int
리턴	System.Data.DataTable

GetEmailByFileId() 공개 추상적인 메소드

public abstract GetEmailByFileId ( int fileId ) : DataTable
fileId	int
리턴	System.Data.DataTable

GetEngageLocatorTabModules() 공개 추상적인 메소드

public abstract GetEngageLocatorTabModules ( int portalId ) : DataTable
portalId	int
리턴	System.Data.DataTable

GetFilesToImport() 공개 추상적인 메소드

public abstract GetFilesToImport ( ) : DataTable
리턴	System.Data.DataTable

GetImportedLocationStatistics() 공개 추상적인 메소드

public abstract GetImportedLocationStatistics ( int portalId ) : DataTable
portalId	int
리턴	System.Data.DataTable

GetLastImportIndex() 공개 추상적인 메소드

public abstract GetLastImportIndex ( ) : int
리턴	int

GetLatitudeLongitude() 공개 추상적인 메소드

public abstract GetLatitudeLongitude ( string address, string city ) : DataTable
address	string
city	string
리턴	System.Data.DataTable

GetLocation() 공개 추상적인 메소드

public abstract GetLocation ( int locationId ) : IDataReader
locationId	int
리턴	IDataReader

GetLocationType() 공개 추상적인 메소드

public abstract GetLocationType ( int id ) : DataTable
id	int
리턴	System.Data.DataTable

GetLocationTypeCount() 공개 추상적인 메소드

public abstract GetLocationTypeCount ( string type ) : int
type	string
리턴	int

GetLocationTypeName() 공개 추상적인 메소드

public abstract GetLocationTypeName ( int id ) : DataTable
id	int
리턴	System.Data.DataTable

GetLocationTypes() 공개 추상적인 메소드

public abstract GetLocationTypes ( ) : DataTable
리턴	System.Data.DataTable

GetLocations() 공개 추상적인 메소드

public abstract GetLocations ( int typeId, int portalId ) : DataTable
typeId	int
portalId	int
리턴	System.Data.DataTable

GetLocationsByCountry() 공개 추상적인 메소드

Gets the locations in a given country.

public abstract GetLocationsByCountry ( int countryId, int portalId, int pageIndex, int pageSize ) : IDataReader
countryId	int	The country ID.
portalId	int	The portal ID.
pageIndex	int	Index of the page, or null if not paging.
pageSize	int	Size of the page, or null if not paging.
리턴	IDataReader

GetNClosestLocations() 공개 추상적인 메소드

public abstract GetNClosestLocations ( double latitude, double longitude, int count, int portalId ) : DataTable
latitude	double
longitude	double
count	int
portalId	int
리턴	System.Data.DataTable

GetNewSubmittedComments() 공개 추상적인 메소드

public abstract GetNewSubmittedComments ( int portalId, bool approved ) : DataTable
portalId	int
approved	bool
리턴	System.Data.DataTable

GetTabModuleIdByFileId() 공개 추상적인 메소드

public abstract GetTabModuleIdByFileId ( int fileId ) : int
fileId	int
리턴	int

InsertComment() 공개 추상적인 메소드

public abstract InsertComment ( int locationId, string comment, string submittedBy, bool approved ) : void
locationId	int
comment	string
submittedBy	string
approved	bool
리턴	void

InsertFileInfo() 공개 추상적인 메소드

public abstract InsertFileInfo ( int fileId, int userId, int tabModuleId, int portalId, System.DateTime uploadDate, bool succeeded, bool processed ) : void
fileId	int
userId	int
tabModuleId	int
portalId	int
uploadDate	System.DateTime
succeeded	bool
processed	bool
리턴	void

InsertLocationType() 공개 추상적인 메소드

public abstract InsertLocationType ( string locationTypeName ) : int
locationTypeName	string
리턴	int

SaveComment() 공개 추상적인 메소드

public abstract SaveComment ( Comment comment ) : void
comment	Comment
리턴	void

SaveLocation() 공개 추상적인 메소드

public abstract SaveLocation ( Location loc ) : int
loc	Location
리턴	int

SaveTempLocation() 공개 추상적인 메소드

public abstract SaveTempLocation ( Location loc, bool successful ) : int
loc	Location
successful	bool
리턴	int

UpdateAttribute() 공개 추상적인 메소드

public abstract UpdateAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
attributeDefinitionId	int
locationId	int
attributeValue	string
리턴	void

UpdateAttributeDefinition() 공개 추상적인 메소드

public abstract UpdateAttributeDefinition ( int definitionId, int dataType, string defaultValue, string attributeName, bool required, string validationExpression, int viewOrder, bool visible, int length ) : int
definitionId	int
dataType	int
defaultValue	string
attributeName	string
required	bool
validationExpression	string
viewOrder	int
visible	bool
length	int
리턴	int

UpdateComment() 공개 추상적인 메소드

public abstract UpdateComment ( int locationId, string comment, string submittedBy, bool approved, int userId ) : void
locationId	int
comment	string
submittedBy	string
approved	bool
userId	int
리턴	void

UpdateImportedLocationRow() 공개 추상적인 메소드

public abstract UpdateImportedLocationRow ( int fileId ) : void
fileId	int
리턴	void

UpdateLocation() 공개 추상적인 메소드

public abstract UpdateLocation ( Location loc ) : int
loc	Location
리턴	int

UpdateLocationType() 공개 추상적인 메소드

public abstract UpdateLocationType ( int locationTypeId, string locationTypeName ) : void
locationTypeId	int
locationTypeName	string
리턴	void