public ActionResult DeleteConfirmed(int id)
        {
            book_an_appointment book_an_appointment = db.book_an_appointment.Find(id);

            db.book_an_appointment.Remove(book_an_appointment);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Id,dr_id,First_Name,Last_Name,Email_id,contact_no,avail_id,Date")] book_an_appointment book_an_appointment)
 {
     if (ModelState.IsValid)
     {
         db.Entry(book_an_appointment).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.dr_id    = new SelectList(db.doctors, "Id", "Name", book_an_appointment.dr_id);
     ViewBag.avail_id = new SelectList(db.DoctorAvailabilities, "Id", "time", book_an_appointment.avail_id);
     return(View(book_an_appointment));
 }
        // GET: book_an_appointment/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            book_an_appointment book_an_appointment = db.book_an_appointment.Find(id);

            if (book_an_appointment == null)
            {
                return(HttpNotFound());
            }
            return(View(book_an_appointment));
        }
        // GET: book_an_appointment/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            book_an_appointment book_an_appointment = db.book_an_appointment.Find(id);

            if (book_an_appointment == null)
            {
                return(HttpNotFound());
            }
            ViewBag.dr_id    = new SelectList(db.doctors, "Id", "Name", book_an_appointment.dr_id);
            ViewBag.avail_id = new SelectList(db.DoctorAvailabilities, "Id", "time", book_an_appointment.avail_id);
            return(View(book_an_appointment));
        }
        public ActionResult Create([Bind(Include = "Id,dr_id,First_Name,Last_Name,Email_id,contact_no,avail_id,Date ")] book_an_appointment book_an_appointment)
        {
            if (ModelState.IsValid)
            {
                db.book_an_appointment.Add(book_an_appointment);
                db.SaveChanges();

                DoctorAvailability doctorAvailability = db.DoctorAvailabilities.Find(book_an_appointment.avail_id);
                doctorAvailability.status          = "Book";
                db.Entry(doctorAvailability).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("SuccessMessage"));
            }

            ViewBag.dr_id    = new SelectList(db.doctors, "Id", "Name", book_an_appointment.dr_id);
            ViewBag.avail_id = new SelectList(db.DoctorAvailabilities, "Id", "time", book_an_appointment.avail_id);
            return(View(book_an_appointment));
        }