private void SaveBtn_Click(object sender, EventArgs e)
{
TreatmentPlans temp = new TreatmentPlans();
using (ClinicEntities1 db = new ClinicEntities1())
{
if (db.TreatmentPlans.Find(id) == null)
{
TreatmentPlans t = new TreatmentPlans();
t.Id = id;
t.Description = textBox1.Text;
t.Worker_ID = db.Workers.Where(x => x.Name == workerscmbx.Text).FirstOrDefault <Workers>().Id;
t.Patient_ID = db.Patients.Where(x => x.Name == PatientLbl.Text).FirstOrDefault <Patients>().Id;
db.TreatmentPlans.Add(t);
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!");
this.Close();
}
else
{
var temp1 = db.TreatmentPlans.Where(x => x.Id == id).FirstOrDefault <TreatmentPlans>();
temp = temp1;
temp.Patient_ID = db.Patients.Where(x => x.Name == PatientLbl.Text).FirstOrDefault <Patients>().Id;
temp.Worker_ID = db.Workers.Where(x => x.Name == workerscmbx.Text).FirstOrDefault <Workers>().Id;
temp.Description = textBox1.Text;
db.SaveChanges();
MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!");
this.Close();
}
}
}
private void DelBtn_Click(object sender, EventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
TreatmentPlans t = db.TreatmentPlans.Where(x => x.Id == id).FirstOrDefault <TreatmentPlans>();
t.DeleteTime = DateTime.Now;
MessageBox.Show("План лечения успешно удален!", "Ортопедическая клиника");
db.SaveChanges();
this.Close();
}
}
private void RefreshFormData(int id)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
TreatmentPlans temp = db.TreatmentPlans.Where(x => x.Id == id).FirstOrDefault <TreatmentPlans>();
PatientLkLbl.Text = db.Patients.Find(temp.Patient_ID).Name;
WorkerLkLbl.Text = db.Workers.Find(temp.Worker_ID).Name;
textBox1.Text = temp.Description;
FillGrid();
FillListBox();
}
}
private void ShowTreatmentPlan_Click(object sender, EventArgs e)
{
using (ClinicEntities1 db = new ClinicEntities1())
{
try
{
TreatmentPlans tp = db.TreatmentPlans.Where(x => x.Patient_ID == id).FirstOrDefault <TreatmentPlans>();
TreatmentPlanCard tpcard = new TreatmentPlanCard();
tpcard.Currentid = tp.Id;
tpcard.ShowDialog();
}
catch
{
MessageBox.Show("У данного пациента нет плана лечения!", "Ортопедическая клиника");
}
}
}
private void TreatmentPlanEdit_Load(object sender, EventArgs e)
{
FillCmbxWithWorkers();
using (ClinicEntities1 db = new ClinicEntities1())
{
if (db.TreatmentPlans.Find(id) != null)
{
TreatmentPlans temp = db.TreatmentPlans.Where(x => x.Id == id).FirstOrDefault <TreatmentPlans>();
PatientLbl.Text = temp.Patients.Name;
workerscmbx.Text = temp.Workers.Name;
textBox1.Text = temp.Description;
FillGrid();
FillListBox();
}
else
{
SaveBtn.Enabled = false;
TreatmentPlans c = new TreatmentPlans();
c.Id = db.TreatmentPlans.Count() + 1;
Currentid = Convert.ToInt16(c.Id);
workerscmbx.SelectedIndex = 0;
}
}
}
