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