internal async Task AssertAll(string expected = null) { var nodes = (await _connection.QueryAsync <Node>($"SELECT * FROM {SqlStuff.Escape(Table)}")).ToDictionary(x => x.Id, x => x); await DropTable().ExecuteAsync(_connection); var asserter = new Asserter(nodes, expected ?? _expected); asserter.AssertAll(); }
public ActionResult StudyReport(int?id) { var sqlStuff = new SqlStuff(); var data = sqlStuff.StudyReport(); var model = new List <StudyReportViewModel>(); model = ConvertDataTable <StudyReportViewModel>(data); return(View(model)); }
public ActionResult DoctorReport(int?id) { var sqlStuff = new SqlStuff(); var data = sqlStuff.DoctorReport((int)id); var model = new List <DoctorReportViewModel>(); model = ConvertDataTable <DoctorReportViewModel>(data); return(View(model)); }
public ActionResult AppointmentStatistics() { var sqlStuff = new SqlStuff(); var data = sqlStuff.AppointmentStatistics(); var model = new List <AppointmentStatisticsViewModel>(); model = ConvertDataTable <AppointmentStatisticsViewModel>(data); return(View(model)); }
protected async Task <LRTest> Test(string tree) { var tableName = CreateTableName(); await CreateTable.New("[%_Node_%]", SqlStuff.Escape(tableName)).ExecuteAsync(_connection); await Arrange(tree, SqlStuff.Escape(tableName), _connection); await MigrationFactory.CreateScript(tableName, "Id", "Parent_Id").ExecuteAsync(_connection); return(new LRTest(tableName, tree, _connection)); }
public ActionResult Index() { int currentUser = SessionManager.CurrentUser.usePID; var sqlStuff = new SqlStuff(); var theData = sqlStuff.Dashboard(currentUser); var dashboardByID = new List <DashboardViewModel>(); dashboardByID = ConvertDataTable <DashboardViewModel>(theData); return(View("Index", dashboardByID)); }
public ActionResult Appointments(int studyArmPID) { int currentUser = SessionManager.CurrentUser.usePID; var sqlStuff = new SqlStuff(); var theData = sqlStuff.AppointmentDetail(studyArmPID); var appointments = new List <AppointmentViewModel>(); appointments = ConvertDataTable <AppointmentViewModel>(theData); return(View("Appointments", appointments)); }
public ActionResult StudyArmDetailsView(int?id) { var sqlStuff = new SqlStuff(); var dbDoctors = sqlStuff.DoctorsByStudyArm((int)id); var dbSubjects = sqlStuff.SubjectsByStudyArm((int)id); var dbDocuments = sqlStuff.DocumentsByStudyArm((int)id); var dbVisits = sqlStuff.VisitsByStudyArm((int)id); var dbActivites = sqlStuff.ActivitesByStudyArm((int)id); var dbAppointments = sqlStuff.AppointmentsByStudyArm((int)id); var model = new StudyArmDetailsViewModel(); model.doctors = ConvertDataTable <Doctor>(dbDoctors); //model.subjects = ConvertDataTable<Subject>(dbSubjects); model.documents = ConvertDataTable <DocumentInfo>(dbDocuments); model.visits = ConvertDataTable <Visit>(dbVisits); model.activities = ConvertDataTable <Activity>(dbActivites); model.appointments = ConvertDataTable <Appointment>(dbAppointments); model.VisitActivitiesCheckBoxes = new List <CheckBox>(); model.studyArmID = Convert.ToInt32(id); using (var context = new SiteContext()) { var assigned = context.SubAssigned.Where(x => x.satStudyArmLinkID == model.studyArmID).ToList(); foreach (var item in assigned) { var sub = context.Subjects.FirstOrDefault(x => x.subPID == item.satSubjectLinkID); model.subjects.Add(sub); } } foreach (Appointment app in model.appointments) { var box = new CheckBox(); box.appPID = app.appPID; box.isChecked = true; model.VisitActivitiesCheckBoxes.Add(box); } return(View("StudyArmDetailsView", model)); }
public ActionResult StudyReportByID(int?id) { var sqlStuff = new SqlStuff(); var data = sqlStuff.StudyReportByID((int)id); var dbmodel = new List <StudyDetailViewModel>(); dbmodel = ConvertDataTable <StudyDetailViewModel>(data); var model = new StudyReportBIGModel(); model.studyDetails = dbmodel; using (var sc = new SiteContext()) { var armIDs = sc.StudyArms.Where(x => x.sarStudyLinkID == id).ToList(); model.subjects = new List <Subject>(); model.doctors = new List <Doctor>(); foreach (var item in armIDs) { var docAssigned = sc.DocAssigned.Where(x => x.datStudyArmLinkID == item.sarPID).ToList(); foreach (var doc in docAssigned) { var dbDoctor = sc.Doctors.FirstOrDefault(x => x.docPID == doc.datDoctorLinkID); model.doctors.Add(dbDoctor); } var subAssigned = sc.SubAssigned.Where(x => x.satStudyArmLinkID == item.sarPID).ToList(); foreach (var sub in subAssigned) { var dbSubject = sc.Subjects.FirstOrDefault(x => x.subPID == sub.satSubjectLinkID); model.subjects.Add(dbSubject); } } } return(View(model)); }
private Script DropTable() { return(TestsBase.DropTable.New("[Node]", SqlStuff.Escape(Table))); }