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)); }
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)); }