//URL: /Find_Doctor/Update
public ActionResult Update(int id)
{
//need information about a particular Doctor
Find_Doctor doctor = db.Find_Doctor.SqlQuery("select * from Find_Doctor where doctor_id = @doctor_id", new SqlParameter("@doctor_id", id)).FirstOrDefault();
return(View(doctor));
}
//URL: /Find_Doctor/DeleteConfirm
public ActionResult DeleteConfirm(int id)
{
string query = "select * from Find_Doctor where doctor_id= @doctor_id";
SqlParameter param = new SqlParameter("@doctor_id", id);
Find_Doctor doctor = db.Find_Doctor.SqlQuery(query, param).FirstOrDefault();
return(View(doctor));
}
// GET: Find_Doctor/Details/5
public ActionResult Show(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Find_Doctor doctor = db.Find_Doctor.SqlQuery("select * from Find_Doctor where doctor_id=@doctor_id", new SqlParameter("@doctor_id", id)).FirstOrDefault();
if (doctor == null)
{
return(HttpNotFound());
}
return(View(doctor));
}
