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