public void Initialize(DataBaseRequest request)
{
try {
Connection.Execute(request.Query);
} catch (SQLiteException exception) {
string errorMessage = exception.Message;
}
}
public void Initialize(string databaseFileName)
{
Assembly assemble = typeof(DataBaseService).GetTypeInfo().Assembly;
Stream stream = assemble.GetManifestResourceStream("CXS.Mpos.Core.Resource." + databaseFileName);
string line = "";
StringBuilder dbRequest = new StringBuilder();
StreamReader fileReader = new StreamReader(stream);
while ((line = fileReader.ReadLine()) != null)
{
dbRequest.Append(line);
}
string[] split = dbRequest.ToString().Split(new char[] { ';' });
foreach (string s in split)
{
DataBaseRequest dbInitRequest = new DataBaseRequest(s);
Initialize(dbInitRequest);
}
}
public List <T> PerformRequest <T> (DataBaseRequest request) where T : new()
{
List <T> result = new List <T> ();
if (request is DataBaseSelectRequest)
{
result = PerformSelect <T> ((DataBaseSelectRequest)request);
}
if (request is DataBaseUpdateRequest)
{
result = PerformUpdate <T> ((DataBaseUpdateRequest)request);
}
if (request is DataBaseInsertRequest)
{
result = PerformInsert <T> ((DataBaseInsertRequest)request);
}
return(result);
}
