public int DeleteDataRecords()
{
SQLDB sqlDB = new SQLDB(connectionString);
int deletedCount;
sqlDB.OpenConnection();
sqlDB.OpenTransaction();
deletedCount = dataRecord.DeleteAllData(sqlDB);
sqlDB.SetDataBlockState(DATA_BLOCK_ID, 3);
sqlDB.CommitConnection();
sqlDB.CloseConnection();
return deletedCount;
}
/// <summary>
/// Инициализировать базу данных
/// </summary>
/// <param name="password">пароль - ввести qqq</param>
public void InitDataBase(string password)
{
if (password == "qqq")
{
DBI sqlDB = new SQLDB(connectionString);
try
{
sqlDB.OpenConnection();
sqlDB.OpenTransaction();
sqlDB.DataBaseInit();
sqlDB.CommitConnection();
}
catch (Exception ex)
{
sqlDB.RollbackConnection();
Console.WriteLine(ex.Message);
}
finally
{
sqlDB.CloseConnection();
}
}
}
public int DeleteDataBlockAndRecords()
{
SQLDB sqlDB = new SQLDB(connectionString);
int deletedCount = 3;
try
{
sqlDB.OpenConnection();
sqlDB.OpenTransaction();
// deletedCount = dataRecord.DeleteAllData(sqlDB);
sqlDB.DeleteAllDataRecordsFast(DATA_BLOCK_ID);
sqlDB.DeleteDataBlock(DATA_BLOCK_ID);
sqlDB.CommitConnection();
sqlDB.CloseConnection();
}
catch (Exception ex)
{
sqlDB.RollbackConnection();
sqlDB.CloseConnection();
throw ex;
}
return deletedCount + 1;
}
