public bool Handle(CreateSpecialistCommand request) { var model = request.Adapt <MedicalSpecialist>(); string tempHash = Hash.FindHash(model.PasswordHash); model.PasswordHash = tempHash; using (MySqlConnection conn = _context.GetConnection()) { conn.Open(); string query = string.Format("insert into Specialists(last_name, first_name, middle_name, email, password_hash, Health_Facilities_faculty_id) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')", model.LastName, model.FirstName, model.MiddleName, model.Email, model.PasswordHash, model.HealthFacilitiesFacultyId); MySqlCommand cmd = new MySqlCommand(query, conn); try { cmd.ExecuteNonQuery(); } catch { return(false); } finally { conn.CloseAsync(); } } return(true); }
public bool Handle(CreateSpecialistCommand request) { var model = request.Adapt <Model.Specialist>(); string tempHash = Hash.FindHash(model.PasswordHash); model.PasswordHash = tempHash; using (MySqlConnection conn = _context.GetConnection()) { conn.Open(); string query = string.Format("INSERT INTO specialists(last_name, first_name, middle_name, " + "email, password_hash, birthday, education, position, " + "admission_date, dismissal_date, wage_rate, " + "Subunits_subunit_id, Units_unit_id, Parlours_parlour_id) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}')", model.LastName, model.FirstName, model.MiddleName, model.Email, model.PasswordHash, model.Birthday.ToString("yyyy-MM-dd HH:mm:ss"), model.Education, model.Position, model.AdmissionDate.ToString("yyyy-MM-dd HH:mm:ss"), model.DismissalDate.ToString("yyyy-MM-dd HH:mm:ss"), model.WageRate.ToString(), model.SubunitId.ToString(), model.UnitId.ToString(), model.ParlourId.ToString()); MySqlCommand cmd = new MySqlCommand(query, conn); try { cmd.ExecuteNonQuery(); } catch { return(false); } finally { conn.CloseAsync(); } } return(true); }
public bool Handle(int specialistId, CreateSpecialistCommand request) { var model = request.Adapt <Model.MedicalSpecialist>(); using (MySqlConnection conn = _context.GetConnection()) { conn.Open(); string query = string.Format("update specialists set `last_name`='{1}', `first_name`='{2}', `middle_name`='{3}'," + "`email`='{4}', `password_hash`='{5}', `Health_Facilities_faculty_id`={6} where `specialist_id`={0}", specialistId.ToString(), model.LastName, model.FirstName, model.MiddleName, model.Email, model.PasswordHash, model.HealthFacilitiesFacultyId); MySqlCommand cmd = new MySqlCommand(query, conn); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message; return(false); } finally { conn.CloseAsync(); } } return(true); }