public ActionResult AssignPatients(int id) { EHMSEntities ent = new EHMSEntities(); DemandPatientAssignmentModel model = new DemandPatientAssignmentModel(); model.OpdModelList = new List <OpdModel>(); model.DemandId = id; var list = (from om in ent.OpdMasters join pa in ent.DemandPatientAssignments on om.OpdID equals pa.OpdId join dm in ent.ItemDemandMasters on pa.DemandId equals dm.ItemDemandID where pa.DemandId == model.DemandId && pa.Status == true select new { om, pa, dm }).ToList(); foreach (var item in list) { OpdModel omodel = new OpdModel(); omodel.FirstName = item.om.FirstName; omodel.MiddleName = item.om.MiddleName; omodel.LastName = item.om.LastName; omodel.MobileNumber = item.pa.Remarks; omodel.RegistrationMode = item.dm.ItemDemandNo; omodel.OpdID = item.om.OpdID; model.OpdModelList.Add(omodel); } return(View(model)); }
public ActionResult PatientList() { DemandPatientAssignmentModel model = new DemandPatientAssignmentModel(); model.OpdModelList = new List <OpdModel>(); return(PartialView("PatientList")); }
public void AssignPatients(DemandPatientAssignmentModel model) { EHMSEntities ent = new EHMSEntities(); DemandPatientAssignment obj = new DemandPatientAssignment(); try { foreach (var item in model.OpdModelList) { if (ent.DemandPatientAssignments.Where(x => x.OpdId == item.OpdID && x.Status == true).Any() == false) { obj.DemandId = model.DemandId; obj.OpdId = item.OpdID; obj.Remarks = model.Remarks; obj.Status = true; ent.DemandPatientAssignments.Add(obj); ent.SaveChanges(); } } } catch { } }
public ActionResult AssignPatients(DemandPatientAssignmentModel model) { pro.AssignPatients(model); return(RedirectToAction("Index")); }