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