public bool Handle(CreateCertificationTestCommand request)
{
var model = request.Adapt <Model.CertificationTest>();
using (MySqlConnection conn = _context.GetConnection())
{
conn.Open();
string query = string.Format("insert into Certification_Tests(date, result, Specialists_specialist_id, Courses_course_id) " +
"values('{0}', '{1}', '{2}', '{3}' )",
model.Date.ToString("yyyy-MM-dd HH:mm:ss"), model.Result, model.SpecialistId, model.CourseId);
MySqlCommand cmd = new MySqlCommand(query, conn);
try
{
cmd.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
conn.CloseAsync();
}
}
return(true);
}
public bool UpdateCertificationTest(int id, [FromBody] CreateCertificationTestCommand request)
{
CertificationTestContext context = HttpContext.RequestServices.GetService(typeof(CertificationTestContext)) as CertificationTestContext;
UpdateCertificationTestHandler handler = new UpdateCertificationTestHandler(context);
return(handler.Handle(id, request));
}
public bool Handle(int certificationTestId, CreateCertificationTestCommand request)
{
var model = request.Adapt <Model.CertificationTest>();
using (MySqlConnection conn = _context.GetConnection())
{
conn.Open();
string query = string.Format("update Certification_Tests set date = {1}, result = {2}, Specialists_specialist_id = {3}, Courses_course_id = {4}" +
"where certification_id={0}",
certificationTestId.ToString(),
model.Date.ToString("yyyy-MM-dd HH:mm:ss"),
model.Result,
model.SpecialistId,
model.CourseId);
MySqlCommand cmd = new MySqlCommand(query, conn);
try
{
cmd.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
conn.CloseAsync();
}
}
return(true);
}
