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()); }