public ActionResult AppointmentForm(int id = 0) { ////Drop down Box for doctors Functionality //myDataBaseAuthEntities1 dbContext = new myDataBaseAuthEntities1(); //IEnumerable<SelectListItem> items1 = dbContext.Event1.Select(c => new SelectListItem //{ // Value = c.text, // Text = c.text //}); //ViewBag.Doctors = items1; ////Drop down ends here //Getting user Ids //db.Items.Where(x=> x.userid == user_ID).Select(x=>x.Id).Distinct(); //IEnumerable<SelectListItem> items2 = dbc.AspNetUserRoles.Select(u => new SelectListItem //{ // Value = u.UserId, // Text = u.UserId //}); myDataBaseAuthEntities2 dbc = new myDataBaseAuthEntities2(); IEnumerable <SelectListItem> items2 = dbc.AspNetUserRoles.Where(x => x.RoleId == "e8f1347d-a369-4842-ac06-a4dee22150f1").Select(u => new SelectListItem { Value = u.UserId, Text = u.UserId }); ViewBag.Doctors = items2; Appointment2 appointmentModel = new Appointment2(); return(View(appointmentModel)); }
public ActionResult AppointmentForm(Appointment2 appointmentModel) { using (AppointmentModel2 appModel = new AppointmentModel2()) { appModel.Appointment2.Add(appointmentModel); appModel.SaveChanges(); } ModelState.Clear(); ViewBag.SuccessMessage = "Booking Successful."; var items = e1.text.ToList(); if (items != null) { ViewBag.data = items; } return(View("AppointmentForm", new Appointment2())); }