public ActionResult Analysis() { var model = new AnalysisModel(); model.OriginalIDs = GetValidOriginalIDs(); model.StudySeries = GetStudySeries(model); return View(model); }
public ActionResult Analysis(AnalysisModel model) { model.OriginalIDs = GetValidOriginalIDs(); if (model.StudySeries== null || model.StudySeries.Count() < 1) { model.StudySeries = GetStudySeries(model); } if (ModelState.IsValid) { } return View(model); }
private IEnumerable<SelectListItem> GetStudySeries(AnalysisModel m) { if (m.originalID > 0) { string query_string = "SELECT Series.seriesDescription, Study.studyDate FROM Patient INNER JOIN Study ON Patient.patientID = Study.patientID INNER JOIN Series ON Study.studyID = Series.studyID WHERE Patient.originalID = @p1"; SqlConnection db = new SqlConnection(@"Data Source="",1044;Initial Catalog="";User ID="";Password="""); SqlCommand Command = new SqlCommand(query_string); Command.Connection = db; Command.Parameters.AddWithValue("@p1", m.originalID.ToString()); db.Open(); SqlDataReader reader = Command.ExecuteReader(); AuditController.CreateAuditEntry(Session["userID"].ToString(), Session["username"].ToString(), "Patient", "originalID", "Select"); AuditController.CreateAuditEntry(Session["userID"].ToString(), Session["username"].ToString(), "Study", null, "Select"); AuditController.CreateAuditEntry(Session["userID"].ToString(), Session["username"].ToString(), "Series", null, "Select"); var ss = new List<SelectListItem>(); while (reader.Read()) { ss.Add(new SelectListItem { Value = reader["studyDate"] + " - " + reader["seriesDescription"], Text = reader["studyDate"] + " - " + reader["seriesDescription"] }); } db.Close(); if (ss.Count < 1) { ss.Add(new SelectListItem { Value = "No data", Text = "No data" } ); } return ss; } return new List<SelectListItem>(); }