public static int GetNumberOfInspectors() { using (InspectionContext db = new InspectionContext()) { var inspectorDB = db.Inspectors.Where(inspector => inspector.Status.ToLower() == "готов").ToList(); return(inspectorDB.Count()); } }
public static void FillWithDatabaseValues(List <InspectionClass> inspectionCollection) { using (InspectionContext db = new InspectionContext()) { var inspectionsDB = db.Inspections.ToList(); foreach (var inspection in inspectionsDB) { inspectionCollection.Add(new InspectionClass(inspection.InspectionId, inspection.Time, 0, DateTime.Parse(inspection.Date))); } } }
public static void AssignInspector(List <int> idCollection, int i) { using (InspectionContext db = new InspectionContext()) { var inspectionsDB = db.Inspections.Where(inspection => idCollection.Contains(inspection.InspectionId)).ToList(); var inspectorsDB = db.Inspectors.ToList(); foreach (var inspection in inspectionsDB) { inspection.ActingInspector = inspectorsDB[i].Name; } db.SaveChanges(); } }