private void ProcedureEdit_FormClosed(object sender, FormClosedEventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Procedures.Find(id) == null) { var temp1 = db.WorkerProcedures.Where(x => x.DeleteTime == null && x.Procedure_ID == id); List <WorkerProcedures> vplist = temp1.ToList(); if (listBox1.Items.Count != 0) { foreach (WorkerProcedures vp in vplist) { db.WorkerProcedures.Remove(vp); db.SaveChanges(); } } var temp2 = db.FilesProcedures.Where(x => x.Procedure_ID == id); List <FilesProcedures> fp = temp2.ToList(); if (listBox2.Items.Count != 0) { foreach (FilesProcedures f in fp) { db.FilesProcedures.Remove(f); db.SaveChanges(); } } } } }
private void SaveBtn_Click(object sender, EventArgs e) { Cabinets temp = new Cabinets(); using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Cabinets.Find(id) == null) { Cabinets c = new Cabinets(); c.Id = id; c.Name = NameTxtBx.Text; c.Description = DescTxtBx.Text; db.Cabinets.Add(c); db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); this.Close(); } else { var temp1 = db.Cabinets.Where(x => x.Id == id).FirstOrDefault <Cabinets>(); temp = temp1; temp.Name = NameTxtBx.Text; temp.Description = DescTxtBx.Text; db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } } }
private void SaveBtn_Click(object sender, EventArgs e) { Workers temp = new Workers(); using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Workers.Find(id) == null) { Workers w = new Workers(); w.Id = id; w.Name = NameLbl.Text; w.Specialization = SpecializationLbl.Text; w.TelephoneNumber = TelephoneNmbrLbl.Text; db.Workers.Add(w); db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); this.Close(); } else { var temp1 = db.Workers.Where(x => x.Id == id).FirstOrDefault <Workers>(); temp = temp1; temp.Name = NameLbl.Text; temp.Specialization = SpecializationLbl.Text; temp.TelephoneNumber = TelephoneNmbrLbl.Text; db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } } }
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 SaveBtn_Click(object sender, EventArgs e) { TypeOfProcedures temp = new TypeOfProcedures(); using (ClinicEntities1 db = new ClinicEntities1()) { if (db.TypeOfProcedures.Find(id) == null) { TypeOfProcedures t = new TypeOfProcedures(); t.Id = id; t.Name = NameLbl.Text; t.KindOfProcedure_ID = db.KindOfProcedures.Find(KOPcmbx.SelectedIndex + 1).Id; t.Price = Convert.ToDouble(PriceLbl.Text); t.Description = DescLbl.Text; db.TypeOfProcedures.Add(t); db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); this.Close(); } else { var temp1 = db.TypeOfProcedures.Where(x => x.Id == id).FirstOrDefault <TypeOfProcedures>(); temp = temp1; temp.Name = NameLbl.Text; temp.KindOfProcedure_ID = KOPcmbx.SelectedIndex + 1; temp.Price = Convert.ToDouble(PriceLbl.Text); temp.Description = DescLbl.Text; db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } } }
private void TreatmentPlanEdit_FormClosed(object sender, FormClosedEventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { if (db.TreatmentPlans.Find(id) == null) { var temp1 = db.TreatmentPlanProcedures.Where(x => x.DeleteTime == null && x.TreatmentPlan_ID == id); List <TreatmentPlanProcedures> vplist = temp1.ToList(); if (dataGridView1.RowCount != 0) { foreach (TreatmentPlanProcedures vp in vplist) { db.TreatmentPlanProcedures.Remove(vp); db.Procedures.Remove(db.Procedures.Find(vp.Procedure_ID)); db.WorkerProcedures.Remove(db.WorkerProcedures.Where(x => x.Procedure_ID == vp.Procedure_ID).FirstOrDefault <WorkerProcedures>()); db.SaveChanges(); } } var temp2 = db.TreatmentPlanDagnosises.Where(x => x.DeleteTime == null && x.TreatmentPlan_ID == id); List <TreatmentPlanDagnosises> vpslist = temp2.ToList(); if (DiagnosisesLstBx.Items.Count != 0) { foreach (TreatmentPlanDagnosises tpd in vpslist) { db.TreatmentPlanDagnosises.Remove(tpd); db.SaveChanges(); } } } } }
private void SaveBtn_Click(object sender, EventArgs e) { Patients temp = new Patients(); using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Patients.Find(id) == null) { Patients p = new Patients(); p.Id = id; p.Name = textBox2.Text; p.TelephoneNumber = textBox3.Text; p.Height = Convert.ToDouble(textBox4.Text); p.Weight = Convert.ToDouble(textBox5.Text); p.Comment = textBox1.Text; db.Patients.Add(p); db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); this.Close(); } else { var temp1 = db.Patients.Where(x => x.Id == id).FirstOrDefault <Patients>(); temp = temp1; temp.Name = textBox2.Text; temp.TelephoneNumber = textBox3.Text; temp.Height = Convert.ToDouble(textBox4.Text); temp.Weight = Convert.ToDouble(textBox5.Text); temp.Comment = textBox1.Text; db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } } }
private void Save_Click(object sender, EventArgs e) { WorkingHours temp = new WorkingHours(); using (ClinicEntities1 db = new ClinicEntities1()) { if (radioButton2.Checked == true) { radioButton1.Checked = false; DateTime start = DTPStart.Value; DateTime end = DTPEnd.Value; DateTime date = dateTimePicker1.Value; while (end <= date) { WorkingHours c = new WorkingHours(); c.Id = db.WorkingHours.Count() + 1; c.Worker_ID = db.Workers.Where(x => x.Name == WorkerCmbx.Text).FirstOrDefault <Workers>().Id; c.Cabinet_ID = db.Cabinets.Where(x => x.Name == CabinetCmbx.Text).FirstOrDefault <Cabinets>().Id; c.TimeStart = start; start = start.AddDays(7); c.TimeEnd = end; end = end.AddDays(7); db.WorkingHours.Add(c); db.SaveChanges(); } MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } if (radioButton1.Checked == true) { radioButton2.Checked = false; DateTime start = DTPStart.Value; DateTime end = DTPEnd.Value; int count = 1; while (count <= Convert.ToInt16(numericUpDown1.Value)) { count++; WorkingHours c = new WorkingHours(); c.Id = db.WorkingHours.Count() + 1; c.Worker_ID = db.Workers.Where(x => x.Name == WorkerCmbx.Text).FirstOrDefault <Workers>().Id; c.Cabinet_ID = db.Cabinets.Where(x => x.Name == CabinetCmbx.Text).FirstOrDefault <Cabinets>().Id; c.TimeStart = start; start = start.AddDays(7); c.TimeEnd = end; end = end.AddDays(7); db.WorkingHours.Add(c); db.SaveChanges(); } MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } } }
private void FileDelBtn_Click(object sender, EventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { FilesProcedures fp = db.FilesProcedures.Where(x => x.Procedure_ID == id && x.Path == listBox2.SelectedItem.ToString()).FirstOrDefault <FilesProcedures>(); db.FilesProcedures.Remove(fp); db.SaveChanges(); FillFilesListBox(); } }
private void SaveBtn_Click(object sender, EventArgs e) { Diagnosises temp = new Diagnosises(); using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Diagnosises.Find(id) == null) { try { Diagnosises c = new Diagnosises(); c.Id = id; c.Patient_ID = db.Patients.Where(x => x.Name == PatientLbl.Text).FirstOrDefault <Patients>().Id; c.Worker_ID = db.Workers.Where(x => x.Name == WorkerCmbx.Text).FirstOrDefault <Workers>().Id; c.Name = Diagnosisname.Text; c.Date = Convert.ToDateTime(DateDTP.Value); c.Status = StatusCmbx.Text; c.Description = Desc.Text; db.Diagnosises.Add(c); db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); this.Close(); } catch { MessageBox.Show("Вы не выбрали пациента"); } } else { var temp1 = db.Diagnosises.Where(x => x.Id == id).FirstOrDefault <Diagnosises>(); 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 == WorkerCmbx.Text).FirstOrDefault <Workers>().Id; temp.Name = Diagnosisname.Text; temp.Date = Convert.ToDateTime(DateDTP.Value); temp.Description = Desc.Text; db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } } }
private void button4_Click(object sender, EventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { Patients c = db.Patients.Where(x => x.Id == id).FirstOrDefault <Patients>(); c.DeleteTime = DateTime.Now; MessageBox.Show("Пациент успешно удален!", "Ортопедическая клиника"); db.SaveChanges(); this.Close(); } }
private void DelBtn_Click(object sender, EventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { Diagnosises c = db.Diagnosises.Where(x => x.Id == id).FirstOrDefault <Diagnosises>(); c.DeleteTime = DateTime.Now; MessageBox.Show("Диагноз успешно удален!", "Ортопедическая клиника"); db.SaveChanges(); this.Close(); } }
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 DelBtn_Click(object sender, EventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { TypeOfProcedures t = db.TypeOfProcedures.Where(x => x.Id == id).FirstOrDefault <TypeOfProcedures>(); t.DeleteTime = DateTime.Now; MessageBox.Show("Тип процедур успешно удален!", "Ортопедическая клиника"); db.SaveChanges(); 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 DelBtn_Click(object sender, EventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { WorkingHours w = db.WorkingHours.Where(x => x.Id == id).FirstOrDefault <WorkingHours>(); w.DeleteTime = DateTime.Now; MessageBox.Show("Запись расписания успешно удалена!", "Ортопедическая клиника"); db.SaveChanges(); this.Close(); } }
private void DelProced_Click(object sender, EventArgs e) { int index = Convert.ToInt32(this.dataGridView1.CurrentRow.Cells[0].Value); using (ClinicEntities1 db = new ClinicEntities1()) { TreatmentPlanProcedures cp = db.TreatmentPlanProcedures.Where(x => x.TreatmentPlan_ID == id && x.Procedure_ID == index).FirstOrDefault <TreatmentPlanProcedures>(); db.TreatmentPlanProcedures.Remove(cp); db.SaveChanges(); FillGrid(); } }
private void WorkerDelBtn_Click(object sender, EventArgs e) { //int index = Convert.ToInt32(this.listBox1.SelectedIndex); using (ClinicEntities1 db = new ClinicEntities1()) { Workers w = db.Workers.Where(x => x.Name == listBox1.SelectedItem.ToString()).FirstOrDefault <Workers>(); WorkerProcedures cp = db.WorkerProcedures.Where(x => x.Procedure_ID == id && x.Worker_ID == w.Id).FirstOrDefault <WorkerProcedures>();; db.WorkerProcedures.Remove(cp); db.SaveChanges(); FillListBox(); } }
private void DelDiag_Click(object sender, EventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { string name = DiagnosisesLstBx.SelectedItem.ToString(); int index = db.Diagnosises.Where(x => x.Name == name).FirstOrDefault <Diagnosises>().Id; TreatmentPlanDagnosises tp = db.TreatmentPlanDagnosises.Where(x => x.TreatmentPlan_ID == id && x.Diagnosis_ID == index).FirstOrDefault <TreatmentPlanDagnosises>(); db.TreatmentPlanDagnosises.Remove(tp); db.SaveChanges(); FillListBox(); } }
private void DelCabProc_Click(object sender, EventArgs e) { int index = Convert.ToInt32(this.dataGridView7.CurrentRow.Cells[0].Value); using (ClinicEntities1 db = new ClinicEntities1()) { CabinetProcedures cp = db.CabinetProcedures.Where(x => x.Cabinet_ID == id && x.ProcedureType_ID == index).FirstOrDefault <CabinetProcedures>();; db.CabinetProcedures.Remove(cp); db.SaveChanges(); FillGrid(); } }
private void DelProcedure_Click(object sender, EventArgs e) { //int index = Convert.ToInt32(this.listBox2.SelectedIndex); using (ClinicEntities1 db = new ClinicEntities1()) { string typename = listBox2.SelectedItem.ToString(); TypeOfProcedures tp = db.TypeOfProcedures.Where(x => x.Name == typename).FirstOrDefault <TypeOfProcedures>(); WorkerTypeOfProcedures cp = db.WorkerTypeOfProcedures.Where(x => x.Worker_ID == id && x.TypeOfProcedure_ID == tp.Id).FirstOrDefault <WorkerTypeOfProcedures>();; db.WorkerTypeOfProcedures.Remove(cp); db.SaveChanges(); FillListBox(); } }
private void PayProc_Click(object sender, EventArgs e) { int index = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value); using (ClinicEntities1 db = new ClinicEntities1()) { Pays temp = db.Pays.Find(index); temp.Status = 1; temp.Date = Convert.ToDateTime(DateTime.Now); db.SaveChanges(); } RefreshFormData(); }
private void AddProcedureBtn_Click(object sender, EventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { ProcedureEdit procedureedit = new ProcedureEdit(); procedureedit.ShowDialog(); VisitProcedures temp = new VisitProcedures(); temp.Visit_ID = id; temp.Procedure_ID = procedureedit.Currentid; db.VisitProcedures.Add(temp); db.SaveChanges(); } 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(); } } }
private void CabinetEdit_FormClosed(object sender, FormClosedEventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Cabinets.Find(id) == null) { var temp1 = db.CabinetProcedures.Where(x => x.DeleteTime == null && x.Cabinet_ID == id); List <CabinetProcedures> vplist = temp1.ToList(); if (dataGridView7.RowCount != 0) { foreach (CabinetProcedures vp in vplist) { db.CabinetProcedures.Remove(vp); db.SaveChanges(); } } } } }
private void FileAddBtn_Click(object sender, EventArgs e) { OpenFileDialog dialog = new OpenFileDialog(); if (dialog.ShowDialog() == DialogResult.OK) { string str = dialog.FileName; listBox2.Items.Add(str); using (ClinicEntities1 db = new ClinicEntities1()) { FilesProcedures fp = new FilesProcedures(); fp.Procedure_ID = id; fp.Path = str; db.FilesProcedures.Add(fp); db.SaveChanges(); } } FillFilesListBox(); }
private void WorkerEdit_FormClosed(object sender, FormClosedEventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Workers.Find(id) == null) { var temp2 = db.WorkerTypeOfProcedures.Where(x => x.DeleteTime == null && x.Worker_ID == id); List <WorkerTypeOfProcedures> vpslist = temp2.ToList(); if (listBox2.Items.Count != 0) { foreach (WorkerTypeOfProcedures tpd in vpslist) { db.WorkerTypeOfProcedures.Remove(tpd); db.SaveChanges(); } } } } }
private void VisitEdit_FormClosed(object sender, FormClosedEventArgs e) { using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Visits.Find(id) == null) { var temp1 = db.VisitProcedures.Where(x => x.DeleteTime == null && x.Visit_ID == id); List <VisitProcedures> vplist = temp1.ToList(); if (dataGridView1.RowCount != 0) { foreach (VisitProcedures vp in vplist) { db.VisitProcedures.Remove(vp); db.Procedures.Remove(db.Procedures.Find(vp.Procedure_ID)); db.WorkerProcedures.Remove(db.WorkerProcedures.Where(x => x.Procedure_ID == vp.Procedure_ID).FirstOrDefault <WorkerProcedures>()); db.SaveChanges(); } } } } }
private void savebtn_Click(object sender, EventArgs e) { Procedures temp = new Procedures(); using (ClinicEntities1 db = new ClinicEntities1()) { if (db.Procedures.Find(id) == null) { Procedures c = new Procedures(); c.Id = id; c.Name = NameTxtBx.Text; if (label10.Text != "Выберите") { c.Patient_ID = db.Patients.Where(x => x.Name == label10.Text).FirstOrDefault <Patients>().Id; } c.Description = DescTxtBx.Text; c.DateFact = Convert.ToDateTime(DateFactDTP.Value); TimeSpan tss = TimeStartEventDTP.Value.TimeOfDay; TimeSpan tse = TimeEndEventDTP.Value.TimeOfDay; c.DateEventStart = Convert.ToDateTime(DateEventDTP.Value).Date.Add(tss); c.DateEventEnd = Convert.ToDateTime(DateEventEndDTP.Value).Date.Add(tse); c.KindOfProcedure_ID = db.KindOfProcedures.Where(x => x.Name == KinfOfProcedure.Text).FirstOrDefault <KindOfProcedures>().Id; c.TypeOfProcedure_ID = db.TypeOfProcedures.Where(x => x.Name == TypeOfProcedures.Text).FirstOrDefault <TypeOfProcedures>().Id; c.Cabinet_ID = db.Cabinets.Where(x => x.Name == CabinetCmbx.Text).FirstOrDefault <Cabinets>().Id; if (IsOurCheck.Checked == true) { c.IsOurs = 1; } else { c.IsOurs = 2; } ////////////////////////////////////////////////////////////////////raspisanie///////////////////////////////////////////////// DateTime procstart = Convert.ToDateTime(c.DateEventStart); DateTime procend = Convert.ToDateTime(c.DateEventEnd); TimeSpan dif = procend - procstart; //получим в часах длительность процедуры DateTime procduration = procstart.Add(dif); List <WorkerProcedures> workerlist = db.WorkerProcedures.Where(x => x.Procedure_ID == id).ToList(); foreach (WorkerProcedures wp in workerlist) { List <WorkingHours> whlist = db.WorkingHours.Where(x => x.Worker_ID == wp.Worker_ID).ToList(); WorkingHours wh = whlist.Where(x => Convert.ToDateTime(x.TimeStart).Day == procstart.Day).FirstOrDefault <WorkingHours>(); if (wh == null) { MessageBox.Show("Работник:" + " " + wp.Workers.Name + " " + "не работает в этот день, пожалуйста выберите другого!", "Ортопедическая клиника"); savebtn.Enabled = false; } else { DateTime whstart = Convert.ToDateTime(wh.TimeStart); DateTime whend = Convert.ToDateTime(wh.TimeEnd); if (procstart >= whstart && procduration <= whend) { List <Procedures> lastlist2 = db.Procedures.Where(x => x.Worker_ID == c.Worker_ID).ToList(); List <Procedures> lastlist = lastlist2.Where(x => procstart >= x.DateEventStart && procduration <= x.DateEventEnd).ToList(); if (lastlist.Count == 0) { db.Procedures.Add(c); Pays p = new Pays();//пробный вариант добавления платежа p.Id = db.Pays.Count() + 1; p.Patient_ID = c.Patient_ID; p.Procedure_ID = c.Id; db.Pays.Add(p); db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); this.Close(); } else { foreach (Procedures p in lastlist) { DateTime pstart = Convert.ToDateTime(p.DateEventStart); DateTime pend = Convert.ToDateTime(p.DateEventEnd); if (procstart >= pstart && procduration <= pend) { MessageBox.Show("Врач занят в это время"); } else { db.Procedures.Add(c); Pays q = new Pays();//пробный вариант добавления платежа q.Id = db.Pays.Count() + 1; q.Patient_ID = c.Patient_ID; q.Procedure_ID = c.Id; db.Pays.Add(q); db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); this.Close(); } } } } else { MessageBox.Show("Работник:" + " " + wp.Workers.Name + " " + "не работает в это время, пожалуйста выберите другого!", "Ортопедическая клиника"); savebtn.Enabled = false; } } } //db.Procedures.Add(c); //Pays p = new Pays();//пробный вариант добавления платежа //p.Id = db.Pays.Count() + 1; //p.Patient_ID = c.Patient_ID; //p.Procedure_ID = c.Id; //db.Pays.Add(p); //db.SaveChanges(); //MessageBox.Show("Сохранение успешно", "Ортопедическая клиника!"); //this.Close(); } else { var temp1 = db.Procedures.Where(x => x.Id == id).FirstOrDefault <Procedures>(); temp = temp1; temp.Name = NameTxtBx.Text; temp.Patient_ID = db.Patients.Where(x => x.Name == label10.Text).FirstOrDefault <Patients>().Id; temp.Description = DescTxtBx.Text; temp.DateFact = Convert.ToDateTime(DateFactDTP.Value); TimeSpan tss = TimeStartEventDTP.Value.TimeOfDay; TimeSpan tse = TimeEndEventDTP.Value.TimeOfDay; temp.DateEventStart = Convert.ToDateTime(DateEventDTP.Value).Date.Add(tss); temp.DateEventEnd = Convert.ToDateTime(DateEventEndDTP.Value).Date.Add(tse); temp.KindOfProcedure_ID = db.KindOfProcedures.Where(x => x.Name == KinfOfProcedure.Text).FirstOrDefault <KindOfProcedures>().Id; temp.TypeOfProcedure_ID = db.TypeOfProcedures.Where(x => x.Name == TypeOfProcedures.Text).FirstOrDefault <TypeOfProcedures>().Id; temp.Cabinet_ID = db.Cabinets.Where(x => x.Name == CabinetCmbx.Text).FirstOrDefault <Cabinets>().Id; if (IsOurCheck.Checked == true) { temp.IsOurs = 1; } else { temp.IsOurs = 2; } db.SaveChanges(); MessageBox.Show("Сохранение успешно", "Ортопедическая клиника"); this.Close(); } } }