public ActionResult PostAppointment(DoctorAppointmentModel model) { int mid = Convert.ToInt32(Session["MemberId"]); string apStatus = "Requested"; using (ProjectEntities db = new ProjectEntities()) { var pid = db.Patients.FirstOrDefault(a => a.MemberId == mid); int id = pid.PatientId; if (model.AppointmentDate > DateTime.Now) { db.InsertDoctorAppointment(id, model.DoctorId, model.Subject, model.Description, model.AppointmentDate, apStatus); ViewBag.Message = "Appointment Fixed"; } else { ViewBag.Message = "Appointment date must be in future"; } } List <SelectListItem> lst = new List <SelectListItem>(); // populate ddlDoctor after submit using (ProjectEntities db = new ProjectEntities()) { var getdata = db.Doctors.ToList(); foreach (var item in getdata) { lst.Add(new SelectListItem { Value = item.DoctorId.ToString(), Text = item.FirstName }); } } DoctorAppointmentModel model1 = new DoctorAppointmentModel(); model1.lstDoctor = lst; return(View("DoctorAppointment", model1)); }