public DeskSettSor() { context = new DeskSetContext(); if (context.DeskSets.Select(s => s).Count() == 0) { DeskSet dispset = new DeskSet() { Name = "default", isSelected = true }; context.DeskSets.Add(dispset); context.SaveChanges(); var defid = context.DeskSets.Where(s => s.Name == "default").Select(s => s.Id).FirstOrDefault(); ColStor firstName = new ColStor() { Name = "FirstName", DeskSetId = defid }; ColStor lastName = new ColStor() { Name = "LastName", DeskSetId = defid }; ColStor Company = new ColStor() { Name = "Company", DeskSetId = defid }; context.ColStors.Add(firstName); context.ColStors.Add(lastName); context.ColStors.Add(Company); context.SaveChanges(); int fnid = context.ColStors.Where(s => s.Name == "Firstname").Select(s => s.Id).FirstOrDefault(); int lnid = context.ColStors.Where(s => s.Name == "LastName").Select(s => s.Id).FirstOrDefault(); int coid = context.ColStors.Where(s => s.Name == "Company").Select(s => s.Id).FirstOrDefault(); ColSet firstname = new ColSet() { Alias = "Имя", Visible = true, Width = 100, ColStorId = fnid }; ColSet lastname = new ColSet { Alias = "Фамилия", Visible = true, Width = 100, ColStorId = lnid }; ColSet company = new ColSet { Alias = "Компания", Visible = true, Width = 100, ColStorId = coid }; context.ColSets.Add(firstname); context.ColSets.Add(lastname); context.ColSets.Add(company); context.SaveChanges(); } deskSets = context.DeskSets.Select(s => s).ToList(); var sel_set_id = context.DeskSets.Where(s => s.isSelected == true).Select(s => s.Id).FirstOrDefault(); colStors = context.ColStors.Where(s => s.DeskSetId == sel_set_id).Select(s => s).ToList(); colSets = context.ColSets.ToList(); }
public VMDeskSet() { storage = new DeskSettSor(); collection_setting = storage.DeskSets; collection_column = storage.ColStors; selected_column = collection_column.FirstOrDefault(); selected_setting = collection_setting.Where(s => s.isSelected = true).FirstOrDefault(); selected_column_setting = storage.ColSets.Where(s => s.ColStorId == selected_column.Id).FirstOrDefault(); }