internal bool RestoreTable(DataBaseName dbName)
{
bool result = false;
switch (dbName)
{
case DataBaseName.Users:
result = LoadSQLTextFile(SQLStatement.GetInsertUserQuery());
break;
case DataBaseName.Category:
result = LoadSQLTextFile(SQLStatement.GetInsertCategoryQuery());
break;
case DataBaseName.Period_Type:
result = LoadSQLTextFile(SQLStatement.GetInsertPeriodTypeQuery());
break;
case DataBaseName.Period:
break;
case DataBaseName.Staff:
break;
case DataBaseName.All:
result = (LoadSQLTextFile(SQLStatement.GetInsertUserQuery()) &&
LoadSQLTextFile(SQLStatement.GetInsertCategoryQuery()) &&
LoadSQLTextFile(SQLStatement.GetInsertPeriodTypeQuery()));
break;
}
return(result);
}
void InitDatabase()
{
LoadSQLTextFile(SQLStatement.GetCreateUserTableQuery());
LoadSQLTextFile(SQLStatement.GetCreateStaffTableQuery());
LoadSQLTextFile(SQLStatement.GetCreatePeriodTypeTableQuery());
LoadSQLTextFile(SQLStatement.GetCreatePeriodTableQuery());
LoadSQLTextFile(SQLStatement.GetCreateCategoryTableQuery());
LoadSQLTextFile(SQLStatement.GetCreatePaymentTableQuery());
LoadSQLTextFile(SQLStatement.GetInsertUserQuery());
LoadSQLTextFile(SQLStatement.GetInsertCategoryQuery());
LoadSQLTextFile(SQLStatement.GetInsertPeriodTypeQuery());
}
