public ActionResult Edit(int id) { dbPatientBillingEntities6 dbBedavail = new dbPatientBillingEntities6(); var dbBedTbl = dbBedavail.Beds_Available.ToList(); foreach (var item in dbBedTbl) { var bedToupdate = dbBedTbl.Where(e => e.service_No == id).FirstOrDefault(); if (bedToupdate != null) { if (bedToupdate.bed_Availability == "YES") { bedToupdate.bed_Availability = "NO"; dbBedavail.SaveChanges(); } else { bedToupdate.bed_Availability = "YES"; dbBedavail.SaveChanges(); } } break; } return(RedirectToAction("BedsAvailability")); }
public ActionResult BedsAvailability() { dbPatientBillingEntities6 dbBeds = new dbPatientBillingEntities6(); var bedTbl = dbBeds.Beds_Available.ToList(); //ViewBag.operatortList = OperatorTbl; return(View(bedTbl)); }