public UnitOfWork()
{
BearingResult = new BearingResultRepos();
Machine = new MachineRepos();
FL = new FLRepos();
EngineResult = new EngineResultRepos();
Repairs = new RepairsRepos();
ShaftResult = new ShaftResultRepos();
StateClass = new StateClassRepos();
}
public bool Add(Machine value, List <StateClass> ShaftClasses, List <StateClass> BearingClasses)
{
StateClassRepos stateClassRepos = new StateClassRepos();
string sql = "start transaction;" +
"insert into `machine` (`marking`,`number`,`speed`,`power`,`countpairs`,`head`) values (" +
"\'" + value.Marking + "\'," + "\'" + value.Number + "\'," + value.Speed + ","
+ value.Power + "," + value.CountPairs + "," + value.Head + ");";
StateClassController.AddShaft(ShaftClasses, ref sql);
StateClassController.AddBearing(BearingClasses, ref sql);
//stateClassRepos.AddShaftClasses(ShaftClasses, ref sql);
//stateClassRepos.AddBearingClasses(BearingClasses, ref sql);
sql += "commit;";
string sqlrb = "rollback;";
MySqlCommand cmd = new MySqlCommand();
MySqlCommand cmdrb = new MySqlCommand();
using (MySqlConnection conn = DBUtils.GetDBConnection())
{
try
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
MessageBox.Show("Машина успешно добавлена!");
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
cmd.CommandText = sqlrb;
cmd.ExecuteNonQuery();
return(false);
}
}
}