public ActionResult Edit(BloodCamp blood_camp) { string q1 = $"update blood_camp set driver_name='{blood_camp.driver_name}'where blood_camp_id ={blood_camp.blood_camp_id}"; dbm.ExecuteNonQuery(q1); if (ModelState.IsValid) { return(RedirectToAction("Index")); } ViewBag.hospital_id = new SelectList(db.hospitals, "hospital_id", "username", blood_camp.hospital_id); return(View(blood_camp)); }
public ActionResult Create(BloodCamp blood_camp) { string q1 = $"insert into blood_camp values('{blood_camp.hospital_id}', '{blood_camp.driver_name}')"; dbm.ExecuteNonQuery(q1); if (ModelState.IsValid) { // db.blood_camp.Add(blood_camp); //db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.hospital_id = new SelectList(db.hospitals, "hospital_id", "username", blood_camp.hospital_id); return(View(blood_camp)); }
public ActionResult AddCamp(BloodCamp camp) { Hospital inputHospital = (Hospital)TempData["inputHospital"]; if (inputHospital != null) { TempData["inputHospital"] = inputHospital; } else { return(RedirectToAction("SignIn", "Hospitals")); } Dictionary <string, object> Parameters1 = new Dictionary <string, object>(); Parameters1.Add("@hospital_id", inputHospital.hospital_id); Parameters1.Add("@driver_name", camp.driver_name); dbm.ExecuteNonQuery_proc("AddBloodCamp", Parameters1); return(Redirect("BloodCamps")); }
public ActionResult RemoveCamp(BloodCamp camp) { Hospital inputHospital = (Hospital)TempData["inputHospital"]; if (inputHospital != null) { TempData["inputHospital"] = inputHospital; } else { return(RedirectToAction("SignIn", "Hospitals")); } Dictionary <string, object> Parameters1 = new Dictionary <string, object>(); Parameters1.Add("@blood_camp_id", camp.blood_camp_id); dbm.ExecuteNonQuery_proc("RemoveBloodCamp", Parameters1); TempData["inputHospital"] = inputHospital; return(Redirect("BloodCamps")); }