C# Класс Engage.Dnn.Locator.Data.SqlDataProvider

A concrete implementation of DataProvider for SQL Server (2000+ compatible)
Наследование: DataProvider
Показать файл Открыть проект

Открытые методы

Метод Описание
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

Приватные методы

Метод Описание
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.

Описание методов

AddAttribute() публичный Метод

public AddAttribute ( int attributeDefinitionId, int locationId, string attributeValue ) : void
attributeDefinitionId int
locationId int
attributeValue string
Результат void

AddAttributeDefinition() публичный Метод

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
Результат int

ClearLocations() публичный Метод

public ClearLocations ( int portalId ) : void
portalId int
Результат void

ClearTempLocations() публичный Метод

public ClearTempLocations ( ) : void
Результат void

CopyData() публичный Метод

public CopyData ( ) : string
Результат string

DeleteAttributeDefinition() публичный Метод

public DeleteAttributeDefinition ( int attributeDefinitionId ) : void
attributeDefinitionId int
Результат void

DeleteComment() публичный Метод

public DeleteComment ( int commentId ) : void
commentId int
Результат void

DeleteLocation() публичный Метод

public DeleteLocation ( int locationId ) : void
locationId int
Результат void

DeleteLocationType() публичный Метод

public DeleteLocationType ( int locationTypeId ) : void
locationTypeId int
Результат void

GetAllLocations() публичный Метод

public 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, 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.
Результат IDataReader

GetAllLocationsByType() публичный Метод

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.
Результат IDataReader

GetAttributeDefinition() публичный Метод

public GetAttributeDefinition ( int attributeDefinitionId ) : IDataReader
attributeDefinitionId int
Результат IDataReader

GetAttributeDefinitionByName() публичный Метод

public GetAttributeDefinitionByName ( int locationTypeId, string name ) : IDataReader
locationTypeId int
name string
Результат IDataReader

GetAttributeDefinitions() публичный Метод

public GetAttributeDefinitions ( int locationTypeId ) : DataTable
locationTypeId int
Результат System.Data.DataTable

GetAttributeDefinitionsById() публичный Метод

public GetAttributeDefinitionsById ( int locationTypeId ) : IDataReader
locationTypeId int
Результат IDataReader

GetAttributeValues() публичный Метод

public GetAttributeValues ( int locationId ) : DataTable
locationId int
Результат System.Data.DataTable

GetComment() публичный Метод

public GetComment ( int commentId ) : Comment
commentId int
Результат Comment

GetComments() публичный Метод

public GetComments ( int locationId, bool approved ) : DataSet
locationId int
approved bool
Результат System.Data.DataSet

GetCountriesList() публичный Метод

public GetCountriesList ( int portalId ) : DataTable
portalId int
Результат System.Data.DataTable

GetEmailByFileId() публичный Метод

public GetEmailByFileId ( int fileId ) : DataTable
fileId int
Результат System.Data.DataTable

GetEngageLocatorTabModules() публичный Метод

public GetEngageLocatorTabModules ( int portalId ) : DataTable
portalId int
Результат System.Data.DataTable

GetFilesToImport() публичный Метод

public GetFilesToImport ( ) : DataTable
Результат System.Data.DataTable

GetImportedLocationStatistics() публичный Метод

public GetImportedLocationStatistics ( int portalId ) : DataTable
portalId int
Результат System.Data.DataTable

GetLastImportIndex() публичный Метод

public GetLastImportIndex ( ) : int
Результат int

GetLatitudeLongitude() публичный Метод

public GetLatitudeLongitude ( string address, string city ) : DataTable
address string
city string
Результат System.Data.DataTable

GetLocation() публичный Метод

public GetLocation ( int locationId ) : IDataReader
locationId int
Результат IDataReader

GetLocationType() публичный Метод

public GetLocationType ( int id ) : DataTable
id int
Результат System.Data.DataTable

GetLocationTypeCount() публичный Метод

public GetLocationTypeCount ( string type ) : int
type string
Результат int

GetLocationTypeName() публичный Метод

public GetLocationTypeName ( int id ) : DataTable
id int
Результат System.Data.DataTable

GetLocationTypes() публичный Метод

public GetLocationTypes ( ) : DataTable
Результат System.Data.DataTable

GetLocations() публичный Метод

public GetLocations ( int typeId, int portalId ) : DataTable
typeId int
portalId int
Результат System.Data.DataTable

GetLocationsByCountry() публичный Метод

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.
Результат IDataReader

GetNClosestLocations() публичный Метод

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.
Результат System.Data.DataTable

GetNewSubmittedComments() публичный Метод

public GetNewSubmittedComments ( int portalId, bool approved ) : DataTable
portalId int
approved bool
Результат System.Data.DataTable

GetTabModuleIdByFileId() публичный Метод

public GetTabModuleIdByFileId ( int fileId ) : int
fileId int
Результат int

InsertComment() публичный Метод

public InsertComment ( int locationId, string text, string submittedBy, bool approved ) : void
locationId int
text string
submittedBy string
approved bool
Результат void

InsertFileInfo() публичный Метод

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
Результат void

InsertLocationType() публичный Метод

public InsertLocationType ( string locationTypeName ) : int
locationTypeName string
Результат int

SaveComment() публичный Метод

public SaveComment ( Comment myComment ) : void
myComment Comment
Результат void

SaveLocation() публичный Метод

public SaveLocation ( Location loc ) : int
loc Location
Результат int

SaveTempLocation() публичный Метод

public SaveTempLocation ( Location loc, bool successful ) : int
loc Location
successful bool
Результат int

SqlDataProvider() публичный Метод

public SqlDataProvider ( ) : System
Результат System

UpdateAttribute() публичный Метод

public UpdateAttribute ( int locationAttributeId, int locationId, string attributeValue ) : void
locationAttributeId int
locationId int
attributeValue string
Результат void

UpdateAttributeDefinition() публичный Метод

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
Результат int

UpdateComment() публичный Метод

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
Результат void

UpdateImportedLocationRow() публичный Метод

public UpdateImportedLocationRow ( int fileId ) : void
fileId int
Результат void

UpdateLocation() публичный Метод

public UpdateLocation ( Location loc ) : int
loc Location
Результат int

UpdateLocationType() публичный Метод

public UpdateLocationType ( int locationTypeId, string locationTypeName ) : void
locationTypeId int
locationTypeName string
Результат void