private void VisitEdit_Load(object sender, EventArgs e)
{
FillCmbxWithCabinets();
using (ClinicEntities1 db = new ClinicEntities1())
{
if (db.Visits.Find(id) != null)
{
Visits temp = db.Visits.Where(x => x.Id == id).FirstOrDefault <Visits>();
PatientLbl.Text = temp.Patients.Name;
CabinetCmbx.Text = temp.Cabinets.Name;
dateStartDTP.Value = Convert.ToDateTime(temp.DateStart);
DateEndDTP.Value = Convert.ToDateTime(temp.DateEnd);
PatientLbl.Text = temp.Patients.Name;
DescTxtBx.Text = temp.Description;
ResultTxtBx.Text = temp.Result;
FillGrid();
}
else
{
SaveBtn.Enabled = false;
Visits c = new Visits();
c.Id = db.Visits.Count() + 1;
Currentid = Convert.ToInt16(c.Id);
CabinetCmbx.SelectedIndex = 0;
}
}
}
private void DelBtn_Click(object sender, EventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
Visits v = db.Visits.Where(x => x.Id == id).FirstOrDefault <Visits>();
v.DeleteTime = DateTime.Now;
MessageBox.Show("Приём успешно удален!", "Ортопедическая клиника");
db.SaveChanges();
this.Close();
}
}
private void RefreshFormData(int id)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
Visits temp = db.Visits.Where(x => x.Id == id).FirstOrDefault <Visits>();
CabinetLkLbl.Text = db.Cabinets.Find(temp.Cabinet_ID).Name;
dateStartDTP.Value = Convert.ToDateTime(temp.DateStart);
dateEndDTP.Value = Convert.ToDateTime(temp.DateEnd);
PatientLkLbl.Text = db.Patients.Find(temp.Patient_ID).Name;
DescTxtBx.Text = temp.Description;
ResultTxtBx.Text = temp.Result;
FillGrid();
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
Visits temp = new Visits();
using (ClinicEntities1 db = new ClinicEntities1())
{
if (db.Visits.Find(id) == null)
{
Visits t = new Visits();
t.Id = id;
t.Cabinet_ID = db.Cabinets.Where(x => x.Name == CabinetCmbx.Text && x.DeleteTime == null).FirstOrDefault <Cabinets>().Id;
t.DateStart = Convert.ToDateTime(dateStartDTP.Value);
t.DateEnd = Convert.ToDateTime(DateEndDTP.Value);
t.Patient_ID = db.Patients.Where(x => x.Name == PatientLbl.Text && x.DeleteTime == null).FirstOrDefault <Patients>().Id;
t.Description = DescTxtBx.Text;
t.Result = ResultTxtBx.Text;
db.Visits.Add(t);
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!");
this.Close();
}
else
{
var temp1 = db.Visits.Where(x => x.Id == id).FirstOrDefault <Visits>();
temp = temp1;
temp.Patient_ID = db.Patients.Where(x => x.Name == PatientLbl.Text).FirstOrDefault <Patients>().Id;
temp.Cabinet_ID = db.Cabinets.Where(x => x.Name == CabinetCmbx.Text && x.DeleteTime == null).FirstOrDefault <Cabinets>().Id;
temp.DateStart = Convert.ToDateTime(dateStartDTP.Value);
temp.DateEnd = Convert.ToDateTime(DateEndDTP.Value);
temp.Description = DescTxtBx.Text;
temp.Result = ResultTxtBx.Text;
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!");
this.Close();
}
}
}
