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

A concrete implementation of DataProvider for SQL Server (2000+ compatible)
상속: DataProvider
파일 보기 프로젝트 열기: 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 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