public ActionResult EditDoc(int id) { dbPatientBillingEntities7 dbDocavail = new dbPatientBillingEntities7(); var dbDocTbl = dbDocavail.Doc_Available.ToList(); foreach (var item in dbDocTbl) { var bedToupdate = dbDocTbl.Where(e => e.Doctor_No == id).FirstOrDefault(); if (bedToupdate != null) { if (bedToupdate.Doc_Availability == "YES") { bedToupdate.Doc_Availability = "NO"; dbDocavail.SaveChanges(); } else { bedToupdate.Doc_Availability = "YES"; dbDocavail.SaveChanges(); } } break; } return(RedirectToAction("DoctorAvailability")); }
public ActionResult DoctorAvailability() { dbPatientBillingEntities7 dbDocAva = new dbPatientBillingEntities7(); var docAvalTbl = dbDocAva.Doc_Available.ToList(); //ViewBag.operatortList = OperatorTbl; return(View(docAvalTbl)); }