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