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