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

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

Inheritance: DataProvider

Show file Open project: EngageSoftware/Engage-Locator

Public Methods

Method	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

Method	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 method

public AddAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
attributeDefinitionId	int
locationId	int
attributeValue	string
return	void

AddAttributeDefinition() public method

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
return	int

ClearLocations() public method

public ClearLocations ( int portalId ) : void
portalId	int
return	void

ClearTempLocations() public method

public ClearTempLocations ( ) : void
return	void

CopyData() public method

public CopyData ( ) : string
return	string

DeleteAttributeDefinition() public method

public DeleteAttributeDefinition ( int attributeDefinitionId ) : void
attributeDefinitionId	int
return	void

DeleteComment() public method

public DeleteComment ( int commentId ) : void
commentId	int
return	void

DeleteLocation() public method

public DeleteLocation ( int locationId ) : void
locationId	int
return	void

DeleteLocationType() public method

public DeleteLocationType ( int locationTypeId ) : void
locationTypeId	int
return	void

GetAllLocations() public method

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

GetAllLocationsByDistance() public method

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.
return	IDataReader

GetAllLocationsByType() public method

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.
return	IDataReader

GetAttributeDefinition() public method

public GetAttributeDefinition ( int attributeDefinitionId ) : IDataReader
attributeDefinitionId	int
return	IDataReader

GetAttributeDefinitionByName() public method

public GetAttributeDefinitionByName ( int locationTypeId, string name ) : IDataReader
locationTypeId	int
name	string
return	IDataReader

GetAttributeDefinitions() public method

public GetAttributeDefinitions ( int locationTypeId ) : DataTable
locationTypeId	int
return	System.Data.DataTable

GetAttributeDefinitionsById() public method

public GetAttributeDefinitionsById ( int locationTypeId ) : IDataReader
locationTypeId	int
return	IDataReader

GetAttributeValues() public method

public GetAttributeValues ( int locationId ) : DataTable
locationId	int
return	System.Data.DataTable

GetComment() public method

public GetComment ( int commentId ) : Comment
commentId	int
return	Comment

GetComments() public method

public GetComments ( int locationId, bool approved ) : DataSet
locationId	int
approved	bool
return	System.Data.DataSet

GetCountriesList() public method

public GetCountriesList ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetEmailByFileId() public method

public GetEmailByFileId ( int fileId ) : DataTable
fileId	int
return	System.Data.DataTable

GetEngageLocatorTabModules() public method

public GetEngageLocatorTabModules ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetFilesToImport() public method

public GetFilesToImport ( ) : DataTable
return	System.Data.DataTable

GetImportedLocationStatistics() public method

public GetImportedLocationStatistics ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetLastImportIndex() public method

public GetLastImportIndex ( ) : int
return	int

GetLatitudeLongitude() public method

public GetLatitudeLongitude ( string address, string city ) : DataTable
address	string
city	string
return	System.Data.DataTable

GetLocation() public method

public GetLocation ( int locationId ) : IDataReader
locationId	int
return	IDataReader

GetLocationType() public method

public GetLocationType ( int id ) : DataTable
id	int
return	System.Data.DataTable

GetLocationTypeCount() public method

public GetLocationTypeCount ( string type ) : int
type	string
return	int

GetLocationTypeName() public method

public GetLocationTypeName ( int id ) : DataTable
id	int
return	System.Data.DataTable

GetLocationTypes() public method

public GetLocationTypes ( ) : DataTable
return	System.Data.DataTable

GetLocations() public method

public GetLocations ( int typeId, int portalId ) : DataTable
typeId	int
portalId	int
return	System.Data.DataTable

GetLocationsByCountry() public method

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.
return	IDataReader

GetNClosestLocations() public method

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.
return	System.Data.DataTable

GetNewSubmittedComments() public method

public GetNewSubmittedComments ( int portalId, bool approved ) : DataTable
portalId	int
approved	bool
return	System.Data.DataTable

GetTabModuleIdByFileId() public method

public GetTabModuleIdByFileId ( int fileId ) : int
fileId	int
return	int

InsertComment() public method

public InsertComment ( int locationId, string text, string submittedBy, bool approved ) : void
locationId	int
text	string
submittedBy	string
approved	bool
return	void

InsertFileInfo() public method

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
return	void

InsertLocationType() public method

public InsertLocationType ( string locationTypeName ) : int
locationTypeName	string
return	int

SaveComment() public method

public SaveComment ( Comment myComment ) : void
myComment	Comment
return	void

SaveLocation() public method

public SaveLocation ( Location loc ) : int
loc	Location
return	int

SaveTempLocation() public method

public SaveTempLocation ( Location loc, bool successful ) : int
loc	Location
successful	bool
return	int

SqlDataProvider() public method

public SqlDataProvider ( ) : System
return	System

UpdateAttribute() public method

public UpdateAttribute ( int locationAttributeId, int locationId, string attributeValue ) : void
locationAttributeId	int
locationId	int
attributeValue	string
return	void

UpdateAttributeDefinition() public method

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
return	int

UpdateComment() public method

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
return	void

UpdateImportedLocationRow() public method

public UpdateImportedLocationRow ( int fileId ) : void
fileId	int
return	void

UpdateLocation() public method

public UpdateLocation ( Location loc ) : int
loc	Location
return	int

UpdateLocationType() public method

public UpdateLocationType ( int locationTypeId, string locationTypeName ) : void
locationTypeId	int
locationTypeName	string
return	void