/// <summary>
/// Совершает SQL-транзакцию для двух таблиц
/// </summary>
/// <param name="info">Экземпляр TableInfo</param>
/// <param name="control">Экземпляр TableControl</param>
public bool ExecuteSqlTransaction(TableInfo info, TableControl control)
{
using (SQLiteCommand commandDB = new SQLiteCommand(connectionDB))
{
SQLiteTransaction transaction;
OpenConnection();
transaction = connectionDB.BeginTransaction();
commandDB.Connection = connectionDB;
commandDB.Transaction = transaction;
try
{
InsertIntoTableInfo(info);
InsertIntoTableControl(control);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
return(false);
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
}
/// <summary>
/// INSERT таблицу Control
/// </summary>
/// <param name="control">Экземпляр TableControl</param>
private bool InsertIntoTableControl(TableControl control)
{
using (SQLiteCommand commandDB = new SQLiteCommand(connectionDB))
{
commandDB.CommandText =
"INSERT INTO control ("
+ "dataFile, "
+ "tableDefects, "
+ "controlConfig, "
+ "usFiles"
+ ")"
+ " VALUES(?,?,?,?)";
SQLiteParameter dataFileParam = new SQLiteParameter
{
Value = control.DataFile,
DbType = DbType.Binary
};
commandDB.Parameters.Add(dataFileParam);
SQLiteParameter defectsTableParam = new SQLiteParameter
{
Value = control.TableDefects,
DbType = DbType.String
};
commandDB.Parameters.Add(defectsTableParam);
SQLiteParameter controlConfigParam = new SQLiteParameter
{
Value = control.ControlConfig,
DbType = DbType.Binary
};
commandDB.Parameters.Add(controlConfigParam);
SQLiteParameter usFilesParam = new SQLiteParameter
{
Value = control.UsFiles,
DbType = DbType.Binary
};
commandDB.Parameters.Add(usFilesParam);
try
{
commandDB.CommandType = CommandType.Text;
commandDB.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
throw new Exception(ex.Message);
}
}
}