public ActionResult DeleteConfirmed(int id)
        {
            GrpRoomReservation grpRoomReservation = db.GrpRoomReservations.Find(id);

            db.GrpRoomReservations.Remove(grpRoomReservation);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "GrpRoomReservationId,StudentEmail,RoomNumber,DateReserved,DateFor,TimeIn,TimeOut,Status")] GrpRoomReservation grpRoomReservation)
 {
     if (ModelState.IsValid)
     {
         db.Entry(grpRoomReservation).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(grpRoomReservation));
 }
        public ActionResult Create([Bind(Include = "GrpRoomReservationId,StudentEmail,RoomNumber,DateReserved,DateFor,TimeIn,TimeOut,Status,capacity")] GrpRoomReservation grpRoomReservation)
        {
            var grpRoomId = Convert.ToInt32(Session["id"].ToString());
            var userName  = User.Identity.GetUserName();

            if (ModelState.IsValid)
            {
                if (Logic.checkAvailability(grpRoomReservation, grpRoomId) == false)
                {
                    if (Logic.checkTime(grpRoomReservation) == false)
                    {
                        if (Logic.checkTimeDifference(grpRoomReservation) == false)
                        {
                            if (Logic.checkCapacity(grpRoomId, grpRoomReservation.capacity) == false)
                            {
                                grpRoomReservation.RoomNumber   = Logic.getRoomNumber(grpRoomId);
                                grpRoomReservation.GroupRoomId  = grpRoomId;
                                grpRoomReservation.StudentEmail = userName;
                                grpRoomReservation.Status       = "Booked";
                                grpRoomReservation.DateReserved = DateTime.Now.Date;
                                db.GrpRoomReservations.Add(grpRoomReservation);
                                db.SaveChanges();
                                return(RedirectToAction("Confirm", new { id = grpRoomReservation.GrpRoomReservationId }));
                            }
                            else
                            {
                                ModelState.AddModelError("", "Limit reached");
                                return(View(grpRoomReservation));
                            }
                        }
                        else
                        {
                            ModelState.AddModelError("", "Time should be 2 hours or less");
                            return(View(grpRoomReservation));
                        }
                    }
                    else
                    {
                        ModelState.AddModelError("", "The library is not operational at those times");
                        return(View(grpRoomReservation));
                    }
                }
                else
                {
                    ModelState.AddModelError("", "The Room is already booked");
                    return(View(grpRoomReservation));
                }
            }
            return(View(grpRoomReservation));
        }
        public ActionResult Confirm(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            GrpRoomReservation grpRoomReservation = db.GrpRoomReservations.Find(id);

            if (grpRoomReservation == null)
            {
                return(HttpNotFound());
            }
            return(View(grpRoomReservation));
        }