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

A concrete implementation of DataProvider for SQL Server (2000+ compatible)

Inheritance: DataProvider

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 attributeDefinitionId ) : 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, within the given mile radius
GetAllLocationsByType ( int portalId, int locationTypeIds, int pageIndex, int pageSize ) : IDataReader	Gets a list of the locations in the given locationTypeIds.
GetAttributeDefinition ( int attributeDefinitionId ) : 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	Gets the count closest locations.
GetNewSubmittedComments ( int portalId, bool approved ) : DataTable
GetTabModuleIdByFileId ( int fileId ) : int
InsertComment ( int locationId, string text, 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 myComment ) : void
SaveLocation ( Location loc ) : int
SaveTempLocation ( Location loc, bool successful ) : int
SqlDataProvider ( ) : System
UpdateAttribute ( int locationAttributeId, int locationId, string attributeValue ) : void
UpdateAttributeDefinition ( int attributeDefinitionId, 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
ExecuteDataset ( string storedProcedureName ) : DataSet	Executes a SQL stored procedure, returning the results as a DataSet.
ExecuteNonQuery ( string storedProcedureName ) : int	Executes a SQL stored procedure without returning any value.
ExecuteReader ( string storedProcedureName ) : System.Data.SqlClient.SqlDataReader	Executes a SQL stored procedure, returning the results as a SqlDataReader.
ExecuteScalar ( string storedProcedureName ) : object	Executes a SQL stored procedure, returning a single value.

Method Details

AddAttribute() public méthode

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

AddAttributeDefinition() public méthode

public 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 méthode

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

ClearTempLocations() public méthode

public ClearTempLocations ( ) : void
Résultat	void

CopyData() public méthode

public CopyData ( ) : string
Résultat	string

DeleteAttributeDefinition() public méthode

public DeleteAttributeDefinition ( int attributeDefinitionId ) : void
attributeDefinitionId	int
Résultat	void

DeleteComment() public méthode

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

DeleteLocation() public méthode

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

DeleteLocationType() public méthode

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

GetAllLocations() public méthode

public 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 méthode

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

public 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	The radius in miles.
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 méthode

Gets a list of the locations in the given locationTypeIds.

public 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 méthode

public GetAttributeDefinition ( int attributeDefinitionId ) : IDataReader
attributeDefinitionId	int
Résultat	IDataReader

GetAttributeDefinitionByName() public méthode

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

GetAttributeDefinitions() public méthode

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

GetAttributeDefinitionsById() public méthode

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

GetAttributeValues() public méthode

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

GetComment() public méthode

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

GetComments() public méthode

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

GetCountriesList() public méthode

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

GetEmailByFileId() public méthode

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

GetEngageLocatorTabModules() public méthode

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

GetFilesToImport() public méthode

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

GetImportedLocationStatistics() public méthode

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

GetLastImportIndex() public méthode

public GetLastImportIndex ( ) : int
Résultat	int

GetLatitudeLongitude() public méthode

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

GetLocation() public méthode

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

GetLocationType() public méthode

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

GetLocationTypeCount() public méthode

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

GetLocationTypeName() public méthode

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

GetLocationTypes() public méthode

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

GetLocations() public méthode

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

GetLocationsByCountry() public méthode

Gets the locations in a given country.

public 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 méthode

Gets the count closest locations.

public GetNClosestLocations ( double latitude, double longitude, int count, int portalId ) : DataTable
latitude	double	The latitude.
longitude	double	The longitude.
count	int	The number of locations to return.
portalId	int	The portal id.
Résultat	System.Data.DataTable

GetNewSubmittedComments() public méthode

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

GetTabModuleIdByFileId() public méthode

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

InsertComment() public méthode

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

InsertFileInfo() public méthode

public 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 méthode

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

SaveComment() public méthode

public SaveComment ( Comment myComment ) : void
myComment	Comment
Résultat	void

SaveLocation() public méthode

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

SaveTempLocation() public méthode

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

SqlDataProvider() public méthode

public SqlDataProvider ( ) : System
Résultat	System

UpdateAttribute() public méthode

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

UpdateAttributeDefinition() public méthode

public UpdateAttributeDefinition ( int attributeDefinitionId, int dataType, string defaultValue, string attributeName, bool required, string validationExpression, int viewOrder, bool visible, int length ) : int
attributeDefinitionId	int
dataType	int
defaultValue	string
attributeName	string
required	bool
validationExpression	string
viewOrder	int
visible	bool
length	int
Résultat	int

UpdateComment() public méthode

The method or operation is not implemented.

public 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 méthode

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

UpdateLocation() public méthode

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

UpdateLocationType() public méthode

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