C# Class SensorShare.DatabaseHelper

Helper class to consolidate database access functions into one location

显示文件 Open project: MarkPaxton/SensorShare3

Public Methods

Method	Description
DeleteServerConfigData ( System.Guid id, SQLiteConnection database ) : void
GetAllServerData ( SQLiteConnection database ) : List
GetSensorData ( ScienceScope.SensorID idToFind, SQLiteConnection database ) : ScienceScope.SensorDefinition
GetServerByID ( SQLiteConnection connection, System.Guid serverID ) : ServerData
GetServerNameByID ( SQLiteConnection connection, System.Guid serverID ) : ServerData
GetServerSaved ( SQLiteConnection connection, System.Guid serverID ) : bool
SaveLogMessage ( SQLiteConnection connection, String message ) : void
SaveQuestionMessage ( QuestionMessage question, SQLiteConnection database ) : void
SaveServerConfigData ( SQLiteConnection connection, ServerData data ) : void
deleteAnnotation ( System.Guid id, SQLiteConnection database ) : void
getAnnotation ( System.Guid id, SQLiteConnection database ) : IAnnotation	Gets an annotation from the client annotation database
getAnnotation ( System.Guid id, SQLiteConnection database, string whereCondition ) : IAnnotation	Gets an annotation from the client annotation database and the where condition specified
getAnswer ( System.Guid question_id, System.Guid author_id, SQLiteConnection database ) : QuestionAndAnswerAnnotation
getQuestionMessage ( System.Guid id, SQLiteConnection database ) : QuestionMessage
getSavedAnnotation ( System.Guid id, SQLiteConnection database ) : IAnnotation
getStats ( System.Guid server_id, string whereCondition, SQLiteConnection database ) : double[]
getStdDev ( System.Guid server_id, double means, int count, SQLiteConnection database ) : double[]
isAnnotationSaved ( System.Guid id, SQLiteConnection database ) : bool
saveAnnotation ( System.Guid id, System.DateTime time, System.Guid author_id, string author, AnnotationType type, string text, string picture_location, System.Guid question_id, System.Guid server_id, SQLiteConnection database ) : void
saveAnnotation ( System.Guid id, System.DateTime time, System.Guid author_id, string author, AnnotationType type, string text, string picture_location, System.Guid question_id, System.Guid server_id, bool saved, SQLiteConnection database ) : void
saveAnnotation ( System.Guid id, System.DateTime time, System.Guid author_id, string author, AnnotationType type, string text, string picture_location, System.Guid server_id, SQLiteConnection database ) : void
saveSensorReadings ( SensorReadings data, SQLiteConnection database ) : void
saveSensorReadingsList ( List dataList, SQLiteConnection database ) : void
saveSensorReadingsList ( List dataList, SQLiteConnection database ) : void

Private Methods

Method	Description
ResultToServerData ( SQLiteDataReader result ) : ServerData

Method Details

DeleteServerConfigData() public static method

public static DeleteServerConfigData ( System.Guid id, SQLiteConnection database ) : void
id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	void

GetAllServerData() public static method

public static GetAllServerData ( SQLiteConnection database ) : List
database	System.Data.SQLite.SQLiteConnection
return	List

GetSensorData() public static method

public static GetSensorData ( ScienceScope.SensorID idToFind, SQLiteConnection database ) : ScienceScope.SensorDefinition
idToFind	ScienceScope.SensorID
database	System.Data.SQLite.SQLiteConnection
return	ScienceScope.SensorDefinition

GetServerByID() public static method

public static GetServerByID ( SQLiteConnection connection, System.Guid serverID ) : ServerData
connection	System.Data.SQLite.SQLiteConnection
serverID	System.Guid
return	ServerData

GetServerNameByID() public static method

public static GetServerNameByID ( SQLiteConnection connection, System.Guid serverID ) : ServerData
connection	System.Data.SQLite.SQLiteConnection
serverID	System.Guid
return	ServerData

GetServerSaved() public static method

public static GetServerSaved ( SQLiteConnection connection, System.Guid serverID ) : bool
connection	System.Data.SQLite.SQLiteConnection
serverID	System.Guid
return	bool

SaveLogMessage() public static method

public static SaveLogMessage ( SQLiteConnection connection, String message ) : void
connection	System.Data.SQLite.SQLiteConnection
message	String
return	void

SaveQuestionMessage() public static method

public static SaveQuestionMessage ( QuestionMessage question, SQLiteConnection database ) : void
question	QuestionMessage
database	System.Data.SQLite.SQLiteConnection
return	void

SaveServerConfigData() public static method

public static SaveServerConfigData ( SQLiteConnection connection, ServerData data ) : void
connection	System.Data.SQLite.SQLiteConnection
data	ServerData
return	void

deleteAnnotation() public static method

public static deleteAnnotation ( System.Guid id, SQLiteConnection database ) : void
id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	void

getAnnotation() public static method

Gets an annotation from the client annotation database

public static getAnnotation ( System.Guid id, SQLiteConnection database ) : IAnnotation
id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	IAnnotation

getAnnotation() public static method

Gets an annotation from the client annotation database and the where condition specified

public static getAnnotation ( System.Guid id, SQLiteConnection database, string whereCondition ) : IAnnotation
id	System.Guid
database	System.Data.SQLite.SQLiteConnection
whereCondition	string
return	IAnnotation

getAnswer() public static method

public static getAnswer ( System.Guid question_id, System.Guid author_id, SQLiteConnection database ) : QuestionAndAnswerAnnotation
question_id	System.Guid
author_id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	QuestionAndAnswerAnnotation

getQuestionMessage() public static method

public static getQuestionMessage ( System.Guid id, SQLiteConnection database ) : QuestionMessage
id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	QuestionMessage

getSavedAnnotation() public static method

public static getSavedAnnotation ( System.Guid id, SQLiteConnection database ) : IAnnotation
id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	IAnnotation

getStats() public static method

public static getStats ( System.Guid server_id, string whereCondition, SQLiteConnection database ) : double[]
server_id	System.Guid
whereCondition	string
database	System.Data.SQLite.SQLiteConnection
return	double[]

getStdDev() public static method

public static getStdDev ( System.Guid server_id, double means, int count, SQLiteConnection database ) : double[]
server_id	System.Guid
means	double
count	int
database	System.Data.SQLite.SQLiteConnection
return	double[]

isAnnotationSaved() public static method

public static isAnnotationSaved ( System.Guid id, SQLiteConnection database ) : bool
id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	bool

saveAnnotation() public static method

public static saveAnnotation ( System.Guid id, System.DateTime time, System.Guid author_id, string author, AnnotationType type, string text, string picture_location, System.Guid question_id, System.Guid server_id, SQLiteConnection database ) : void
id	System.Guid
time	System.DateTime
author_id	System.Guid
author	string
type	AnnotationType
text	string
picture_location	string
question_id	System.Guid
server_id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	void

saveAnnotation() public static method

public static saveAnnotation ( System.Guid id, System.DateTime time, System.Guid author_id, string author, AnnotationType type, string text, string picture_location, System.Guid question_id, System.Guid server_id, bool saved, SQLiteConnection database ) : void
id	System.Guid
time	System.DateTime
author_id	System.Guid
author	string
type	AnnotationType
text	string
picture_location	string
question_id	System.Guid
server_id	System.Guid
saved	bool
database	System.Data.SQLite.SQLiteConnection
return	void

saveAnnotation() public static method

public static saveAnnotation ( System.Guid id, System.DateTime time, System.Guid author_id, string author, AnnotationType type, string text, string picture_location, System.Guid server_id, SQLiteConnection database ) : void
id	System.Guid
time	System.DateTime
author_id	System.Guid
author	string
type	AnnotationType
text	string
picture_location	string
server_id	System.Guid
database	System.Data.SQLite.SQLiteConnection
return	void

saveSensorReadings() public static method

public static saveSensorReadings ( SensorReadings data, SQLiteConnection database ) : void
data	SensorReadings
database	System.Data.SQLite.SQLiteConnection
return	void

saveSensorReadingsList() public static method

public static saveSensorReadingsList ( List dataList, SQLiteConnection database ) : void
dataList	List
database	System.Data.SQLite.SQLiteConnection
return	void

saveSensorReadingsList() public static method

public static saveSensorReadingsList ( List dataList, SQLiteConnection database ) : void
dataList	List
database	System.Data.SQLite.SQLiteConnection
return	void