public ActionResult CheckAvailibility(int doctorid, DateTime datesid) { PreRegistrationProvider pro = new PreRegistrationProvider(); string day = datesid.DayOfWeek.ToString(); PreRegistrationDoctorTime model = new PreRegistrationDoctorTime(); model.PreRegistrationDoctorTimeList = pro.DoctorTime(doctorid, day); return(PartialView(model)); }
public List <PreRegistrationDoctorTime> DoctorTime(int id, string day) { using (EHMSEntities ent = new EHMSEntities()) { List <PreRegistrationDoctorTime> doctortime = new List <PreRegistrationDoctorTime>(); PreRegistrationDoctorTime model = new PreRegistrationDoctorTime(); var result = (from a in ent.SetupDoctorAvailableTimes where a.DoctorID == id && a.DoctorDays == day select new PreRegistrationDoctorTime { StartTime = (TimeSpan)a.StartTime, EndTime = (TimeSpan)a.EndTime }).ToList(); foreach (var item in result) { doctortime.Add(item); } return(doctortime); } }