//добавление новой строки
private void x_MainGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (newAB == null)
{
return;
}
try
{
if (newAB.Name == "")
{
MessageBox.Show("Заповніть поле \"Назва\"");
return;
}
if (newAB.Group == "")
{
MessageBox.Show("Заповніть поле \"Група\"");
return;
}
var col = context.d_Antibiotics.Where(c => c.name == newAB.Name);
if (col.Count() != 0)
{
newAB.Name = "";
MessageBox.Show("Антибіотик з такою назвою вже існує");
return;
}
d_Antibiotics ab = new d_Antibiotics();
ab.name = newAB.Name;
ab.id_group_AB = context.d_Antibiotics_groups.Where(c => c.antibiotics_groups == newAB.Group).FirstOrDefault().id;
context.d_Antibiotics.Add(ab);
context.SaveChanges();
newAB.Id = ab.id;
newAB = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
}
}
private static void ApplyStyle(bool alternate)
{
var resourceDictionary = new ResourceDictionary
{
Source = new Uri(@"pack://application:,,,/Dragablz;component/Themes/materialdesign.xaml")
};
var styleKey = alternate ? "MaterialDesignAlternateTabablzControlStyle" : "MaterialDesignTabablzControlStyle";
var style = (Style)resourceDictionary[styleKey];
foreach (var tabablzControl in Dragablz.TabablzControl.GetLoadedInstances())
{
tabablzControl.Style = style;
}
var st = context.StyleApps.Where(c => c.id == 1).FirstOrDefault();
st.style = alternate.ToString();
context.SaveChanges();
}
//добавление новой строки
private void x_MainGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (newItem == null)
{
return;
}
try
{
if (newItem.Name == "")
{
MessageBox.Show("Заповніть поле \"Назва\"");
return;
}
var col = context.d_Category_of_patient.Where(c => c.category == newItem.Name);
if (col.Count() != 0)
{
newItem.Name = "";
MessageBox.Show("Група з такою назвою вже існує");
return;
}
d_Category_of_patient newRow = new d_Category_of_patient();
newRow.category = newItem.Name;
context.d_Category_of_patient.Add(newRow);
context.SaveChanges();
newItem.Id = newRow.id;
newItem = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
}
}
//добавление новой строки
private void x_MainGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (newItem == null)
{
return;
}
try
{
if (newItem.Name == "")
{
MessageBox.Show("Заповніть поле \"Назва\"");
return;
}
var col = context.d_Antibiotics_groups.Where(c => c.antibiotics_groups == newItem.Name);
if (col.Count() != 0)
{
newItem.Name = "";
MessageBox.Show("Група з такою назвою вже існує");
return;
}
d_Antibiotics_groups abgr = new d_Antibiotics_groups();
abgr.antibiotics_groups = newItem.Name;
context.d_Antibiotics_groups.Add(abgr);
context.SaveChanges();
newItem.Id = abgr.id;
newItem = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
}
}
//добавление новой конфигурации
private void x_configurationGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (NewConfiguration == null)
{
return;
}
try
{
if (NewConfiguration.Group == "")
{
MessageBox.Show("Заповніть поле \"Група\"");
return;
}
if (NewConfiguration.Material == "")
{
MessageBox.Show("Заповніть поле \"Матеріал\"");
return;
}
if (NewConfiguration.Purpose == "")
{
MessageBox.Show("Заповніть поле \"Мета\"");
return;
}
if (NewConfiguration.Medium == "")
{
MessageBox.Show("Заповніть поле \"Середовище\"");
return;
}
int id_group = context.d_Group_of_Study.
Where(c => c.Group_of_Study == NewConfiguration.Group).
FirstOrDefault().id;
int id_material = context.d_Material.
Where(c => c.material == NewConfiguration.Material).
FirstOrDefault().id;
int id_purpose = context.d_Purpose_of_study.
Where(c => c.purpose == NewConfiguration.Purpose).
FirstOrDefault().id;
int id_medium = context.d_Medium.
Where(c => c.medium == NewConfiguration.Medium).
FirstOrDefault().id;
var group_materia_purpose_medium = context.p_Group_Material_Purpose_Medium.
Where(c => c.id_Medium == id_medium && c.id_group_material_purpose == context.p_Group_Material_Purpose.
Where(a => a.id_purpose == id_purpose && a.id_group_material == context.p_Group_Material.
Where(b => b.id_material == id_material && b.id_group_of_study == id_group).FirstOrDefault().id).FirstOrDefault().id).FirstOrDefault();
if (group_materia_purpose_medium != null)
{
MessageBox.Show("Така конфігурація вже існює: Id " + group_materia_purpose_medium.id.ToString());
return;
}
var group_material = context.p_Group_Material.
Where(c => c.id_material == id_material && c.id_group_of_study == id_group).
FirstOrDefault();
if (group_material == null)
{
context.p_Group_Material.Add(new p_Group_Material()
{
id_material = id_material, id_group_of_study = id_group
});
context.SaveChanges();
group_material = context.p_Group_Material.
Where(c => c.id_material == id_material && c.id_group_of_study == id_group).
FirstOrDefault();
}
var group_material_purpose = context.p_Group_Material_Purpose.
Where(c => c.id_group_material == group_material.id && c.id_purpose == id_purpose).
FirstOrDefault();
if (group_material_purpose == null)
{
context.p_Group_Material_Purpose.Add(new p_Group_Material_Purpose()
{
id_group_material = group_material.id, id_purpose = id_purpose
});
context.SaveChanges();
group_material_purpose = context.p_Group_Material_Purpose.
Where(c => c.id_group_material == group_material.id && c.id_purpose == id_purpose).
FirstOrDefault();
}
context.p_Group_Material_Purpose_Medium.Add(new p_Group_Material_Purpose_Medium()
{
id_group_material_purpose = group_material_purpose.id, id_Medium = id_medium
});
context.SaveChanges();
var group_material_purpose_medium = context.p_Group_Material_Purpose_Medium.
Where(c => c.id_group_material_purpose == group_material_purpose.id && c.id_Medium == id_medium).
FirstOrDefault();
NewConfiguration.Id = group_material_purpose_medium.id;
NewConfiguration.IsEdit = false;
NewConfiguration = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.StackTrace);
}
}
