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