public ActionResult Show(string id)
{
//find data about the individual patient
string main_query = "Select * from Patients where PatientID = @id";
var pk_parameter = new SqlParameter("@id", id);
Patient Patient = db.Patients.SqlQuery(main_query, pk_parameter).FirstOrDefault();
//find data about invoice that this patient has
string invoice_query = "Select * from Invoices where Invoices.PatientID=@id";
var invoice_parameter = new SqlParameter("@id", id);
List <Invoice> Invoices = db.Invoices.SqlQuery(invoice_query, invoice_parameter).ToList();
ShowPatient viewmodel = new ShowPatient();
viewmodel.patient = Patient;
viewmodel.invoices = Invoices;
return(View(viewmodel));
}
public ActionResult Show(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Patient Patient = db.Patients.SqlQuery("select * from patients WHERE id=@id", new SqlParameter("@id", id)).FirstOrDefault();
if (Patient == null)
{
return(HttpNotFound());
}
ShowPatient viewmodel = new ShowPatient();
viewmodel.patient = Patient;
return(View(viewmodel));
}
