public List <TreatmentDTO> GetTreatments() { List <TreatmentDTO> treatments = new List <TreatmentDTO>(); String query = "SELECT * FROM Treatment"; MySqlCommand cmd = new MySqlCommand(query, dbConn); dbConn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int id = (int)reader["treat_id"]; String n = reader["treat_name"].ToString(); String sym = reader["symptom"].ToString(); TreatmentDTO p = new TreatmentDTO(id, n, sym); treatments.Add(p); } reader.Close(); dbConn.Close(); return(treatments); }
public ActionResult <Treatment> PutTreatment(int id, TreatmentDTO treatment) { Hairdresser hairdresser = _hairdresserRepository.GetByEmail(User.Identity.Name); if (hairdresser == null) { return(NotFound()); } if (id != treatment.Id) { return(BadRequest()); } Treatment treatment2 = new Treatment(treatment.Name, new TimeSpan(treatment.Duration.Hours, treatment.Duration.Minutes, treatment.Duration.Seconds), treatment.Category, treatment.Price) { Id = treatment.Id }; bool result = hairdresser.UpdateTreatment(treatment2); if (result == false) { return(NotFound()); } _hairdresserRepository.SaveChanges(); return(NoContent()); }
private void btnSave_Click(object sender, EventArgs e) { String n = nameTxt.Text; String syn = symTxt.Text; int t = 0; //check our input if (string.IsNullOrWhiteSpace(nameTxt.Text)) { ePro.SetError(nameTxt, "Vui lòng nhập tên bệnh"); return; } else { ePro.SetError(nameTxt, ""); if (string.IsNullOrWhiteSpace(symTxt.Text)) { ePro.SetError(symTxt, "Vui lòng nhập biểu hiện bệnh"); return; } else { ePro.SetError(symTxt, ""); } } switch (function_check) { case 1: //Check privacy foreach (ListViewItem item in listView.Items) { if (item.SubItems[1].Text == n) { MessageBox.Show("Tên bệnh đã có trong hệ thống hãy kiểm tra lại?", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); nameTxt.Text = ""; symTxt.Text = ""; return; } } currentTreat = treatBus.Insert(n, syn); break; case 2: //Check privacy treatBus.Update(id_checked, n, syn); break; } currentTreat = null; nameTxt.Text = ""; symTxt.Text = ""; // Enable_Uneable_Function(true); Hide_Show_Buttons(false); Block_or_Unlock_Textbox(false); // LoadAll(); }
public static Treatment DTOtoTreatment(TreatmentDTO treatmentDTO) { return(new Treatment { Name = treatmentDTO.Name, Price = treatmentDTO.Price }); }
public static TreatmentViewModel DTOtoTreatmentVM(TreatmentDTO treatmentDTO) { return(new TreatmentViewModel { Id = treatmentDTO.Id, Name = treatmentDTO.Name, Price = treatmentDTO.Price, PriceString = treatmentDTO.Price.ToString("c", new CultureInfo("fr-FR")) }); }
private void Diseases_load(object sender, EventArgs e) { //LOCK OUR TEXT BOXES Block_or_Unlock_Textbox(false); Hide_Show_Buttons(false); currentTreat = new TreatmentDTO(); treatBus = new TreatmentBUS(); currentTreat = null; LoadAll(); name_suggestion(); quantity_suggestion(); }
private void btnCancel_Click(object sender, EventArgs e) { Enable_Uneable_Function(true); Hide_Show_Buttons(false); Block_or_Unlock_Textbox(false); currentTreat = null; nameTxt.Text = ""; symTxt.Text = ""; //Deal with Error Provider ePro.SetError(nameTxt, ""); ePro.SetError(symTxt, ""); }
private void listView_SelectedIndexChanged(object sender, EventArgs e) { if (listView.SelectedItems.Count > 0) { ListViewItem item = listView.SelectedItems[0]; currentTreat = (TreatmentDTO)item.Tag; int id = id_checked = currentTreat.treat_id; String n = currentTreat.name; String syn = currentTreat.symptom; nameTxt.Text = n; symTxt.Text = syn; flag = 1; } }
public ActionResult <Treatment> PostTreatment(TreatmentDTO treatment) { Hairdresser hairdresser = _hairdresserRepository.GetByEmail(User.Identity.Name); if (hairdresser == null) { return(NotFound()); } Treatment treatmenToCreate = new Treatment(treatment.Name, new TimeSpan(treatment.Duration.Hours, treatment.Duration.Minutes, treatment.Duration.Seconds), treatment.Category, treatment.Price); hairdresser.AddTreatment(treatmenToCreate); _hairdresserRepository.SaveChanges(); return(Ok(treatmenToCreate)); }
public TreatmentDTO Insert(String n, String sy) { String query = string.Format("INSERT INTO Treatment(treat_name,symptom) VALUES " + "('{0}', '{1}')", n, sy); MySqlCommand cmd = new MySqlCommand(query, dbConn); dbConn.Open(); cmd.ExecuteNonQuery(); int id = (int)cmd.LastInsertedId; TreatmentDTO p = new TreatmentDTO(id, n, sy); dbConn.Close(); return(p); }
public bool addTreatment(TreatmentDTO t) { try { string query = "insert into Treatment (Name, Cost) values ('" + t.Name + "'," + t.Cost + ")"; c.sqlComm = new SqlCommand(query, c.sqlConn); c.sqlComm.ExecuteNonQuery(); query = "CREATE TABLE " + t.Name + " (pID int, dID int, tooth varchar(50), quantity int, cost int, date varchar(50));"; c.sqlComm = new SqlCommand(query, c.sqlConn); c.sqlComm.ExecuteNonQuery(); c.sqlConn.Close(); return(true); } catch (Exception e) { return(false); } }