public void SetDatesToToday(int daysChange, ClinicalStudyContext dbContext) { Stopwatch stopwatch = Stopwatch.StartNew(); foreach (var patient in dbContext.Set<Patient>()) { patient.EnrollDate = AddDays(daysChange, patient.EnrollDate); patient.RandomisationDate = AddDays(daysChange, patient.RandomisationDate); } foreach (var visit in dbContext.Set<Visit>()) { visit.VisitDate = AddDays(daysChange, visit.VisitDate); visit.ExpectedVisitDate = AddDays(daysChange, visit.ExpectedVisitDate); } foreach (var question in dbContext.Set<RepeatableInventoryData>().Select(rid => rid.DateUsed)) { question.Value = AddDays(daysChange, question.Value); } foreach (var formData in dbContext.Set<InventoryFormData>()) { formData.ReceiptDate.Value = AddDays(daysChange, formData.ReceiptDate.Value); formData.ShipDate.Value = AddDays(daysChange, formData.ShipDate.Value); } foreach (var query in dbContext.Set<Query>()) { query.QueryTime = AddDays(daysChange, query.QueryTime); query.AnswerTime = AddDays(daysChange, query.AnswerTime); } foreach (var changeNote in dbContext.Set<ChangeNote>()) { changeNote.ChangeDate = AddDays(daysChange, changeNote.ChangeDate); } dbContext.SaveChanges(); stopwatch.Stop(); }