private void x_configurationGrid_AddingNewItem(object sender, AddingNewItemEventArgs e)
{
try
{
NewConfiguration = new GroupMaterialPurposeMedium();
NewConfiguration.Id = 0;
NewConfiguration.Group = "";
NewConfiguration.Material = "";
NewConfiguration.Purpose = "";
NewConfiguration.Medium = "";
NewConfiguration.IsEdit = true;
var col = from t in context.d_Group_of_Study select t.Group_of_Study;
NewConfiguration.ListGroup = col.ToList();
col = from t in context.d_Material select t.material;
NewConfiguration.ListMaterial = col.ToList();
col = from t in context.d_Purpose_of_study select t.purpose;
NewConfiguration.ListPurpose = col.ToList();
col = from t in context.d_Medium select t.medium;
NewConfiguration.ListMedium = col.ToList();
e.NewItem = NewConfiguration;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
}
}
//добавление существующих конфигураций
private ObservableCollection <GroupMaterialPurposeMedium> FillConfiguration()
{
try
{
ObservableCollection <GroupMaterialPurposeMedium> myCol = new ObservableCollection <GroupMaterialPurposeMedium>();
var elCol = context.d_Group_of_Study;
if (elCol != null)
{
foreach (var el in elCol)
{
var elCol2 = el.p_Group_Material;
foreach (var el2 in elCol2)
{
var elCol3 = el2.p_Group_Material_Purpose;
foreach (var el3 in elCol3)
{
var elCol4 = el3.p_Group_Material_Purpose_Medium;
foreach (var el4 in elCol4)
{
GroupMaterialPurposeMedium item = new GroupMaterialPurposeMedium();
item.Id = el4.id;
item.Group = el.Group_of_Study;
item.Material = el2.d_Material.material;
item.Purpose = el3.d_Purpose_of_study.purpose;
item.Medium = el4.d_Medium.medium;
item.IsEdit = false;
myCol.Add(item);
}
}
}
}
}
return(myCol);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.StackTrace);
return(null);
}
}