public bool Handle(CreateTestCommand request)
{
var test = request.Adapt <TrainingTest>();
try
{
using (MySqlConnection conn = _context.GetConnection())
{
conn.Open();
string query = string.Format("insert into Training_Tests(date, result, Specialists_specialist_id, Topics_topic_id, topics_courses_course_id) " +
"values ('{0}', {1}, {2}, {3}, {4})",
test.Date.ToString("yyyy-MM-dd HH:mm:ss"),
test.Result,
test.SpecialistId,
test.TopicId,
test.CourseId);
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.CloseAsync();
}
return(true);
}
catch (Exception ex)
{
string s = ex.Message;
return(false);
}
}
public bool Handle(int testId, CreateTestCommand request)
{
var model = request.Adapt <Model.TrainingTest>();
using (MySqlConnection conn = _context.GetConnection())
{
conn.Open();
string query = string.Format("update training_tests set date = '{1}', result= {2}, specialists_specialist_id = {3}, " +
"topics_topic_id = {4}, topics_courses_course_id={5} where training_id={0}",
testId.ToString(),
model.Date.ToString("yyyy-MM-dd HH:mm:ss"),
model.Result,
model.SpecialistId,
model.TopicId,
model.CourseId
);
MySqlCommand cmd = new MySqlCommand(query, conn);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
string s = ex.Message;
return(false);
}
finally
{
conn.CloseAsync();
}
}
return(true);
}
