private void удалитьЗаписьToolStripMenuItem_Click(object sender, EventArgs e)
{
Medicine_Data data = new Medicine_Data();
MedicineContext context = new MedicineContext();
GlobalVar gl = new GlobalVar();
switch (GlobalVar.TabIndex)
{
case 0:
{
GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView1.SelectedCells[0].Value);
data.DeleteONE_Attendaces_Record(GlobalVar.selected_reception_ID, GlobalVar.selected_ListRowIndex);
dataGridView1.Rows.Clear();
foreach (var r in context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList())
{
string _ser_name = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_name).FirstOrDefault().ToString();
string _ser_price = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_price).FirstOrDefault().ToString();
dataGridView1.Rows.Add(r.service_id, _ser_name, _ser_price);
}
gl.SetContextMenu_Collumns(dataGridView1, id_context);
break;
}
case 1:
{
GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView2.SelectedCells[0].Value);
data.Delete_Complaint_Record(GlobalVar.selected_ListRowIndex);
dataGridView2.Rows.Clear();
foreach (var r in context.Complaints.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList())
{
string _compl_name = context.Complaints.Where(c => c.reception_id == r.reception_id).Select(c => c.complaint_value).FirstOrDefault().ToString();
dataGridView2.Rows.Add(r.complaint_id, _compl_name);
}
gl.SetContextMenu_Collumns(dataGridView2, id_context);
break;
}
case 2:
{
break;
}
case 3:
{
GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView3.SelectedCells[0].Value);
data.Delete_AnVitae_Record(GlobalVar.selected_ListRowIndex);
dataGridView3.Rows.Clear();
if (context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0)
{
foreach (var r in context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList())
{
string _vit_name = context.AnVitaes.Where(c => c.vitae_id == r.vitae_id).Select(c => c.vitae_value).FirstOrDefault().ToString();
dataGridView3.Rows.Add(r.vitae_id, _vit_name);
}
gl.SetContextMenu_Collumns(dataGridView3, id_context);
}
break;
}
case 4:
{
GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView4.SelectedCells[0].Value);
data.Delete_Diseas_Record(GlobalVar.selected_ListRowIndex);
dataGridView4.Rows.Clear();
if (context.Diseases.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0)
{
foreach (var r in context.Diseases.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList())
{
string _dis_name = context.Diseases.Where(c => c.dis_id == r.dis_id).Select(c => c.disease_value).FirstOrDefault().ToString();
dataGridView4.Rows.Add(r.dis_id, _dis_name);
}
gl.SetContextMenu_Collumns(dataGridView4, id_context);
}
break;
}
case 5:
{
break;
}
case 6:
{
GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView5.SelectedCells[0].Value);
data.Delete_Diagnosis_Recird(GlobalVar.selected_ListRowIndex);
dataGridView5.Rows.Clear();
if (context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0)
{
foreach (var r in context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList())
{
string _diag_name = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_value).FirstOrDefault().ToString();
string _diag_type = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_type).FirstOrDefault().ToString();
dataGridView5.Rows.Add(r.diag_id, _diag_name, _diag_type);
}
gl.SetContextMenu_Collumns(dataGridView5, id_context);
}
break;
}
case 7:
{
GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView6.SelectedCells[0].Value);
data.Delete_Inspection_Record(GlobalVar.selected_ListRowIndex);
dataGridView6.Rows.Clear();
if (context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0)
{
foreach (var r in context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList())
{
string _ins_name = context.Researches.Where(c => c.ins_id == r.ins_id).Select(c => c.ins_name).FirstOrDefault().ToString();
string _ins_status = context.Inspections.Where(c => c.ins_id == r.ins_id).Select(c => c.inspection_status).FirstOrDefault().ToString();
dataGridView6.Rows.Add(r.selected_ins_id, _ins_name, _ins_status);
}
gl.SetContextMenu_Collumns(dataGridView6, id_context);
}
break;
}
case 8:
{
GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView7.SelectedCells[0].Value);
data.Delete_Medication_Record(GlobalVar.selected_ListRowIndex);
dataGridView7.Rows.Clear();
if (context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0)
{
foreach (var r in context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList())
{
string _med_name = context.Preparations.Where(c => c.med_id == r.med_id).Select(c => c.med_name).FirstOrDefault().ToString();
string _med_days = context.Medications.Where(c => c.med_id == r.med_id).Select(c => c.med_days).FirstOrDefault().ToString();
dataGridView7.Rows.Add(r.selected_med_id, _med_name, _med_days);
}
gl.SetContextMenu_Collumns(dataGridView7, id_context);
}
break;
}
}
;
}
