C# Class Engage.Dnn.Locator.Data.DataProvider

An abstract representation of the data access for Engage: Locator

Afficher le fichier Open project: EngageSoftware/Engage-Locator

Méthodes publiques

Méthode	Description
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

Private Methods

Méthode	Description
GetConnectionString ( ) : string	Gets the configured connection string for this site's data provider.
Instance ( ) : DataProvider

Method Details

AddAttribute() public abstract méthode

public abstract AddAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
attributeDefinitionId	int
locationId	int
attributeValue	string
Résultat	void

AddAttributeDefinition() public abstract méthode

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
Résultat	int

ClearLocations() public abstract méthode

public abstract ClearLocations ( int portalId ) : void
portalId	int
Résultat	void

ClearTempLocations() public abstract méthode

public abstract ClearTempLocations ( ) : void
Résultat	void

CopyData() public abstract méthode

public abstract CopyData ( ) : string
Résultat	string

DeleteAttributeDefinition() public abstract méthode

public abstract DeleteAttributeDefinition ( int definitionId ) : void
definitionId	int
Résultat	void

DeleteComment() public abstract méthode

public abstract DeleteComment ( int commentId ) : void
commentId	int
Résultat	void

DeleteLocation() public abstract méthode

public abstract DeleteLocation ( int locationId ) : void
locationId	int
Résultat	void

DeleteLocationType() public abstract méthode

public abstract DeleteLocationType ( int locationTypeId ) : void
locationTypeId	int
Résultat	void

GetAllLocations() public abstract méthode

public abstract GetAllLocations ( int portalId, bool approved, string sortColumn, int index, int pageSize ) : DataTable
portalId	int
approved	bool
sortColumn	string
index	int
pageSize	int
Résultat	System.Data.DataTable

GetAllLocationsByDistance() public abstract méthode

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.
Résultat	IDataReader

GetAllLocationsByType() public abstract méthode

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.
Résultat	IDataReader

GetAttributeDefinition() public abstract méthode

public abstract GetAttributeDefinition ( int definitionId ) : IDataReader
definitionId	int
Résultat	IDataReader

GetAttributeDefinitionByName() public abstract méthode

public abstract GetAttributeDefinitionByName ( int locationTypeId, string name ) : IDataReader
locationTypeId	int
name	string
Résultat	IDataReader

GetAttributeDefinitions() public abstract méthode

public abstract GetAttributeDefinitions ( int locationTypeId ) : DataTable
locationTypeId	int
Résultat	System.Data.DataTable

GetAttributeDefinitionsById() public abstract méthode

public abstract GetAttributeDefinitionsById ( int locationTypeId ) : IDataReader
locationTypeId	int
Résultat	IDataReader

GetAttributeValues() public abstract méthode

public abstract GetAttributeValues ( int locationId ) : DataTable
locationId	int
Résultat	System.Data.DataTable

GetComment() public abstract méthode

public abstract GetComment ( int commentId ) : Comment
commentId	int
Résultat	Comment

GetComments() public abstract méthode

public abstract GetComments ( int locationId, bool approved ) : DataSet
locationId	int
approved	bool
Résultat	System.Data.DataSet

GetCountriesList() public abstract méthode

public abstract GetCountriesList ( int portalId ) : DataTable
portalId	int
Résultat	System.Data.DataTable

GetEmailByFileId() public abstract méthode

public abstract GetEmailByFileId ( int fileId ) : DataTable
fileId	int
Résultat	System.Data.DataTable

GetEngageLocatorTabModules() public abstract méthode

public abstract GetEngageLocatorTabModules ( int portalId ) : DataTable
portalId	int
Résultat	System.Data.DataTable

GetFilesToImport() public abstract méthode

public abstract GetFilesToImport ( ) : DataTable
Résultat	System.Data.DataTable

GetImportedLocationStatistics() public abstract méthode

public abstract GetImportedLocationStatistics ( int portalId ) : DataTable
portalId	int
Résultat	System.Data.DataTable

GetLastImportIndex() public abstract méthode

public abstract GetLastImportIndex ( ) : int
Résultat	int

GetLatitudeLongitude() public abstract méthode

public abstract GetLatitudeLongitude ( string address, string city ) : DataTable
address	string
city	string
Résultat	System.Data.DataTable

GetLocation() public abstract méthode

public abstract GetLocation ( int locationId ) : IDataReader
locationId	int
Résultat	IDataReader

GetLocationType() public abstract méthode

public abstract GetLocationType ( int id ) : DataTable
id	int
Résultat	System.Data.DataTable

GetLocationTypeCount() public abstract méthode

public abstract GetLocationTypeCount ( string type ) : int
type	string
Résultat	int

GetLocationTypeName() public abstract méthode

public abstract GetLocationTypeName ( int id ) : DataTable
id	int
Résultat	System.Data.DataTable

GetLocationTypes() public abstract méthode

public abstract GetLocationTypes ( ) : DataTable
Résultat	System.Data.DataTable

GetLocations() public abstract méthode

public abstract GetLocations ( int typeId, int portalId ) : DataTable
typeId	int
portalId	int
Résultat	System.Data.DataTable

GetLocationsByCountry() public abstract méthode

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.
Résultat	IDataReader

GetNClosestLocations() public abstract méthode

public abstract GetNClosestLocations ( double latitude, double longitude, int count, int portalId ) : DataTable
latitude	double
longitude	double
count	int
portalId	int
Résultat	System.Data.DataTable

GetNewSubmittedComments() public abstract méthode

public abstract GetNewSubmittedComments ( int portalId, bool approved ) : DataTable
portalId	int
approved	bool
Résultat	System.Data.DataTable

GetTabModuleIdByFileId() public abstract méthode

public abstract GetTabModuleIdByFileId ( int fileId ) : int
fileId	int
Résultat	int

InsertComment() public abstract méthode

public abstract InsertComment ( int locationId, string comment, string submittedBy, bool approved ) : void
locationId	int
comment	string
submittedBy	string
approved	bool
Résultat	void

InsertFileInfo() public abstract méthode

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
Résultat	void

InsertLocationType() public abstract méthode

public abstract InsertLocationType ( string locationTypeName ) : int
locationTypeName	string
Résultat	int

SaveComment() public abstract méthode

public abstract SaveComment ( Comment comment ) : void
comment	Comment
Résultat	void

SaveLocation() public abstract méthode

public abstract SaveLocation ( Location loc ) : int
loc	Location
Résultat	int

SaveTempLocation() public abstract méthode

public abstract SaveTempLocation ( Location loc, bool successful ) : int
loc	Location
successful	bool
Résultat	int

UpdateAttribute() public abstract méthode

public abstract UpdateAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
attributeDefinitionId	int
locationId	int
attributeValue	string
Résultat	void

UpdateAttributeDefinition() public abstract méthode

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
Résultat	int

UpdateComment() public abstract méthode

public abstract UpdateComment ( int locationId, string comment, string submittedBy, bool approved, int userId ) : void
locationId	int
comment	string
submittedBy	string
approved	bool
userId	int
Résultat	void

UpdateImportedLocationRow() public abstract méthode

public abstract UpdateImportedLocationRow ( int fileId ) : void
fileId	int
Résultat	void

UpdateLocation() public abstract méthode

public abstract UpdateLocation ( Location loc ) : int
loc	Location
Résultat	int

UpdateLocationType() public abstract méthode

public abstract UpdateLocationType ( int locationTypeId, string locationTypeName ) : void
locationTypeId	int
locationTypeName	string
Résultat	void