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();
}
}
