public ActionResult Create([Bind(Include = "ReservationID,ReservationDescription,ReservationDate")] MaintenanceReservation maintenanceReservation)
        {
            if (ModelState.IsValid)
            {
                var MainIssue = (from s in db.MaintenanceRequests
                                 where maintenanceReservation.MaintenanceId == s.MaintenanceId
                                 select s.MainIssue
                                 ).FirstOrDefault();
                var Date = (from s in db.MaintenanceRequests
                            where maintenanceReservation.MaintenanceId == s.MaintenanceId
                            select s.RoomAval
                            ).FirstOrDefault();
                var Rooms = (from s in db.MaintenanceRequests
                             where maintenanceReservation.MaintenanceId == s.MaintenanceId
                             select s.RoomNumber
                             ).FirstOrDefault();
                var userName = User.Identity.GetUserName();
                //maintenanceReservation.ReservationDate = Date;
                //maintenanceReservation.ReservationDescription = MainIssue;
                //maintenanceReservation.Rooms = lo.GetRoomNumber(userName);
                //maintenanceReservation.Room = Rooms;
                db.MaintenanceReservations.Add(maintenanceReservation);

                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(maintenanceReservation));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            MaintenanceReservation maintenanceReservation = db.MaintenanceReservations.Find(id);

            db.MaintenanceReservations.Remove(maintenanceReservation);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "ReservationID,ReservationDescription,ReservationDate")] MaintenanceReservation maintenanceReservation)
 {
     if (ModelState.IsValid)
     {
         db.Entry(maintenanceReservation).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(maintenanceReservation));
 }
Esempio n. 4
0
 public bool AddRes(MaintenanceReservation b)
 {
     try
     {
         db.MaintenanceReservations.Add(b);
         db.SaveChanges();
         return(true);
     }
     catch (Exception ex)
     { return(false); }
 }
        // GET: MaintenanceReservations/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            MaintenanceReservation maintenanceReservation = db.MaintenanceReservations.Find(id);

            if (maintenanceReservation == null)
            {
                return(HttpNotFound());
            }
            return(View(maintenanceReservation));
        }
        public ActionResult Create(MaintenanceRequest maintenanceRequest, HttpPostedFileBase filelist)
        {
            if (ModelState.IsValid)
            {
                if (maintenanceRequest.RoomAval < DateTime.Now.Date)
                {
                    TempData["message"] = "Date can not be of the past";
                    RedirectToAction("Create", maintenanceRequest);
                }
                else
                {
                    if (filelist != null && filelist.ContentLength > 0)
                    {
                        maintenanceRequest.Image = ConvertToBytes(filelist);
                    }
                    MaintenanceReservation b = new MaintenanceReservation();
                    //b.ReservationID = 1;
                    b.ReservationDate        = maintenanceRequest.RoomAval;
                    b.ReservationDescription = maintenanceRequest.MainIssue;

                    var userName = User.Identity.GetUserName();
                    maintenanceRequest.UserName  = userName;
                    maintenanceRequest.DateLoged = DateTime.UtcNow.ToLongDateString();
                    maintenanceRequest.UserName  = userName;
                    maintenanceRequest.Status    = "Awaiting..";

                    if (User.IsInRole("Student"))
                    {
                        maintenanceRequest.RoomNumber    = lo.GetRoomNumber(userName);
                        maintenanceRequest.ResidenceName = lo.GetResForMaintenance(userName);
                    }

                    Event e = new Event();
                    maintenanceRequest.MainIssue  = e.Description;
                    maintenanceRequest.RoomNumber = e.Subject;
                    maintenanceRequest.RoomAval   = e.Start;
                    maintenanceRequest.RoomAval   = e.End;
                    Bs.AddEvents(e);
                    Bs.AddMaintenanceRequest(maintenanceRequest);
                    db.MaintenanceReservations.Add(b);
                    db.SaveChanges();

                    return(RedirectToAction("Index"));
                }
            }

            return(View(maintenanceRequest));
        }