C# Class Etupirka.DBManager

Show file Open project: Aixile/Etupirka Class Usage Examples

Public Properties

Property Type Description
conn SQLiteConnection

Public Methods

Method Description
AddPlayTime ( TimeData>.Dictionary timeDict ) : void
DBManager ( string file ) : System
DeleteGame ( string uid ) : void
GetPlayTime ( ) : TimeData>.Dictionary
GetPlayTime ( List a ) : TimeData>.Dictionary
InsertOrIgnoreGame ( ObservableCollection items ) : void
InsertOrReplaceGame ( GameExecutionInfo i ) : void
InsertOrReplaceGame ( ObservableCollection items ) : void
InsertOrReplaceTime ( TimeData>.Dictionary timeDict ) : void
InsertOrReplaceTime ( string date, string game, int value ) : void
LoadGame ( ObservableCollection items ) : void
LoadGameDisplayInfo ( string UID ) : DisplayInfo
QueryGamePlayTime ( string uid ) : List
UpdateGame ( GameExecutionInfo i ) : void
UpdateGameInfoAndExec ( GameExecutionInfo i ) : void
UpdateGameTimeInfo ( string uid, int time, DateTime firstplay, DateTime lastplay ) : void
UpdateTimeNow ( string game, int value ) : void

Method Details

AddPlayTime() public method

public AddPlayTime ( TimeData>.Dictionary timeDict ) : void
timeDict TimeData>.Dictionary
return void

DBManager() public method

public DBManager ( string file ) : System
file string
return System

DeleteGame() public method

public DeleteGame ( string uid ) : void
uid string
return void

GetPlayTime() public method

public GetPlayTime ( ) : TimeData>.Dictionary
return TimeData>.Dictionary

GetPlayTime() public method

public GetPlayTime ( List a ) : TimeData>.Dictionary
a List
return TimeData>.Dictionary

InsertOrIgnoreGame() public method

public InsertOrIgnoreGame ( ObservableCollection items ) : void
items ObservableCollection
return void

InsertOrReplaceGame() public method

public InsertOrReplaceGame ( GameExecutionInfo i ) : void
i GameExecutionInfo
return void

InsertOrReplaceGame() public method

public InsertOrReplaceGame ( ObservableCollection items ) : void
items ObservableCollection
return void

InsertOrReplaceTime() public method

public InsertOrReplaceTime ( TimeData>.Dictionary timeDict ) : void
timeDict TimeData>.Dictionary
return void

InsertOrReplaceTime() public method

public InsertOrReplaceTime ( string date, string game, int value ) : void
date string
game string
value int
return void

LoadGame() public method

public LoadGame ( ObservableCollection items ) : void
items ObservableCollection
return void

LoadGameDisplayInfo() public method

public LoadGameDisplayInfo ( string UID ) : DisplayInfo
UID string
return DisplayInfo

QueryGamePlayTime() public method

public QueryGamePlayTime ( string uid ) : List
uid string
return List

UpdateGame() public method

public UpdateGame ( GameExecutionInfo i ) : void
i GameExecutionInfo
return void

UpdateGameInfoAndExec() public method

public UpdateGameInfoAndExec ( GameExecutionInfo i ) : void
i GameExecutionInfo
return void

UpdateGameTimeInfo() public method

public UpdateGameTimeInfo ( string uid, int time, DateTime firstplay, DateTime lastplay ) : void
uid string
time int
firstplay DateTime
lastplay DateTime
return void

UpdateTimeNow() public method

public UpdateTimeNow ( string game, int value ) : void
game string
value int
return void

Property Details

conn public property

public SQLiteConnection conn
return SQLiteConnection