public void DropInspection(object e) { if (SelectedInspection == null) { MessageBox.Show("Не выбрана инспекция"); } else { using (var con = new UserContext()) { try { foreach (var i in SelectedInspection.Remarks) { con.Remarks.Remove(con.Remarks.Find(i.Id)); con.SaveChanges(); } con.Inspections.Remove(con.Inspections.Find(SelectedInspection.Id)); con.SaveChanges(); } catch (Exception exception) { MessageBox.Show(exception.ToString()); } FilterInspections.Remove(SelectedInspection); Inspections.Remove(SelectedInspection); } } }
public void Filter() { if (NameInfo != null && FilterInspector != null) { if (FilterInspector.Id != -1) { FilterInspections.Clear(); foreach (var element in Inspections) { if (element.Inspector.Id == FilterInspector.Id && element.InspectionName.Name.Contains(NameInfo)) { FilterInspections.Add(element.ShallowCopy()); } } return; } } if (NameInfo != null) { FilterInspections.Clear(); foreach (var element in Inspections) { if (element.InspectionName.Name.Contains(NameInfo)) { FilterInspections.Add(element.ShallowCopy()); } } return; } if (FilterInspector != null) { if (FilterInspector.Id != -1) { FilterInspections.Clear(); foreach (var element in Inspections) { if (element.Inspector.Id == FilterInspector.Id) { FilterInspections.Add(element.ShallowCopy()); } } } else { foreach (var element in Inspections) { FilterInspections.Add(element.ShallowCopy()); } } } }
public void Init() { using (var con = new UserContext()) { var i = con.Inspections.Include("InspectionName") .Include("Remarks").Select(x => new { Id = x.Id, Date = x.Date, Comment = x.Comment, Rm = x.Remarks.Select(o => new { Id = o.Id, Date = o.Date, Comment = o.Comment, RemarkName = o.RemarkName != null ? new { Id = o.RemarkName.Id, Name = o.RemarkName.Name } : null }), InsName = x.InspectionName != null ? new { Id = x.InspectionName.Id, Name = x.InspectionName.Name } : null, Inspect = x.Inspector != null ? new { Id = x.Inspector.Id, FIO = x.Inspector.FIO } : null }) .AsEnumerable().Select(y => new Inspection { Id = y.Id, Date = y.Date, Comment = y.Comment, InspectionName = new InspectionName { Id = y.InsName.Id, Name = y.InsName.Name }, Inspector = new Inspector { Id = y.Inspect.Id, FIO = y.Inspect.FIO }, Remarks = y.Rm.Select(o => new Remark { Id = o.Id, Date = o.Date, Comment = o.Comment, RemarkName = o.RemarkName != null ? new RemarkName { Id = o.RemarkName.Id, Name = o.RemarkName.Name } : null }).ToList().ToObservableCollection() }).ToList(); Inspections = i.ToObservableCollection(); foreach (var copy in Inspections) { FilterInspections.Add(copy.ShallowCopy()); } } using (var con = new UserContext()) { var i = con.Inspectors.Select(x => new { Id = x.Id, FIO = x.FIO }).AsEnumerable().Select(y => new Inspector { Id = y.Id, FIO = y.FIO }).ToList(); Inspectors = i.ToObservableCollection(); //InfoInspectors = Inspectors.Select(x => x.ShallowCopy()).ToObservableCollection(); InfoInspectors.Add(new Inspector { Id = -1, FIO = "Все" }); foreach (var index in Inspectors) { InfoInspectors.Add(index.ShallowCopy()); } } }