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); }