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(); }
public void TestCreation() { Database.SetInitializer(new DropCreateDatabaseAlways<ClinicalStudyContext>()); var connectionString = ConfigurationManager.ConnectionStrings["ClinicalStudyContext"].ConnectionString; ClinicalStudyContext db = new ClinicalStudyContext(connectionString); var x = db.Users.FirstOrDefault(); }
public InMemoryPerSessionInitialisator(ClinicalStudyContext dbContext) { this.dbContext = dbContext; }
public int GetDaysChange(ClinicalStudyContext dbContext) { var timepoint = dbContext.Timepoints.First(); var timeSpan = DateTime.Now.Date - timepoint.DateAndTime.Date; return (int)timeSpan.TotalDays; }