public List <PreRegistrationModel> GetList() { using (EHMSEntities ent = new EHMSEntities()) { List <PreRegistrationModel> model = new List <PreRegistrationModel>(); model = AutoMapper.Mapper.Map <IEnumerable <PreRegistration>, IEnumerable <PreRegistrationModel> >(ent.PreRegistrations).Where(x => x.PreregistrationPreferDetailsModel.PreferDate >= DateTime.Today).ToList(); foreach (var item in model) { var data = ent.PreRegistrationPreferDetails.Where(x => x.PreRegistrationID == item.PreRegistrationID).FirstOrDefault(); if (data != null) { var temp = from C in ent.SetupDepartments where C.DeptID == data.DepartmentID select C.DeptName; PreRegistrationPreferDetailsModel m = new PreRegistrationPreferDetailsModel() { DoctorID = data.DoctorID, DepartmentID = data.DepartmentID, PreferDetailsID = data.PreferDetailsID }; item.PreregistrationPreferDetailsModel = m; } } return(model); } }
public ActionResult AddMoreDepartmentDoctors() { using (EHMSEntities ent = new EHMSEntities()) { PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel(); return(PartialView("AddMoreDepartmentDoctors", models)); } }
public PreRegistrationPreferDetailsModel GetListForPrintNext(int id) { using (EHMSEntities ent = new EHMSEntities()) { PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel(); models = AutoMapper.Mapper.Map <IEnumerable <PreRegistrationPreferDetail>, IEnumerable <PreRegistrationPreferDetailsModel> >(ent.PreRegistrationPreferDetails).Where(x => x.PreRegistrationID == id).FirstOrDefault(); return(models); } }
public List <PreRegistrationModel> GetResult() { List <PreRegistrationModel> model = new List <PreRegistrationModel>(); PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel(); using (EHMSEntities ent = new EHMSEntities()) { DateTime today = DateTime.Today; var result = (from a in ent.PreRegistrations join b in ent.PreRegistrationPreferDetails on a.PreRegistrationID equals b.PreRegistrationID where b.PreferDate.Equals(today) && a.Status == true select new PreRegistrationModel { FirstName = a.FirstName, MiddleName = a.MiddleName, LastName = a.LastName, RegistrationDate = a.RegistrationDate, Sex = a.Sex, MobileNumber = a.MobileNumber, ContactName = a.ContactNumber, AgeYear = (int)a.AgeYear, Address = a.Address, //ZoneId = a.ZoneId, //DistrictID = a.DistrictID, //vdcID = a.vdcID, RegistrationMode = a.RegistrationMode, DepartMentID = b.DepartmentID, DoctorID = b.DoctorID, PreferDate = b.PreferDate, PreferTime = b.PreferTime, PrefailID = b.PreferDetailsID, PreRegistrationID = a.PreRegistrationID, Email = a.Email }).GroupBy(x => x.PreRegistrationID).Select(g => g.FirstOrDefault()); foreach (var item in result) { model.Add(item); } return(model); } }
public List <PreRegistrationModel> GetResults() { List <PreRegistrationModel> model = new List <PreRegistrationModel>(); PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel(); using (EHMSEntities ent = new EHMSEntities()) { DateTime today = DateTime.Today; var result = (from a in ent.PreRegistrations join b in ent.PreRegistrationPreferDetails on a.PreRegistrationID equals b.PreRegistrationID join c in ent.SetupDepartments on b.DepartmentID equals c.DeptID join d in ent.SetupDoctorMasters on b.DoctorID equals d.DoctorID where b.PreferDate >= (today) select new PreRegistrationModel { FirstName = a.FirstName + " " + (a.MiddleName + " " ?? string.Empty) + a.LastName, RegistrationDate = a.RegistrationDate, Sex = a.Sex, MobileNumber = a.MobileNumber, AgeYear = (int)a.AgeYear, Address = a.Address, RegistrationMode = a.RegistrationMode, DepartmentName = c.DeptName, DoctorName = d.FirstName + " " + (d.MiddleName + " " ?? string.Empty) + d.LastName, PreferDate = b.PreferDate, PreferTime = b.PreferTime, PreRegistrationID = a.PreRegistrationID }).ToList(); foreach (var item in result) { model.Add(item); } return(model); } }