public ActionResult Cancel(int id) { using (System.Models.RoomSystemEntities db = new System.Models.RoomSystemEntities()) { System.Models.Reservations reservation = (from s in db.Reservations where s.Id == id select s).First(); reservation.Disable = true; db.SaveChanges(); } return(RedirectToAction("Record", "Home")); }
//public RoomSystem.Models.AspNetUsers AspNetUsers { get; set; } //public RoomSystem.Models.Rooms Rooms { get; set; } public ReservationModel(System.Models.Reservations r) { Id = r.Id; BorrowerList = r.BorrowerList; Disable = r.Disable; AspNetUserId = r.AspNetUserId; RoomId = r.RoomId; SessionNo = r.SessionNo; Date = r.Date; //AspNetUsers = new RoomSystem.Models.AspNetUsers(r.AspNetUsers); //Rooms = new RoomSystem.Models.Rooms(r.Rooms); using (System.Models.RoomSystemEntities db = new System.Models.RoomSystemEntities()) { System.Models.ReservationCenters center = (from s in db.ReservationCenters select s).First(); // Models.Rooms room = rooms.Where(x => x.Id == roomId).First(); if (center != null) { bool isWeekend = Date.DayOfWeek == DayOfWeek.Sunday || Date.DayOfWeek == DayOfWeek.Saturday; TimeSpan openTime = isWeekend ? center.WeekendOpenTime : center.WeekdaysOpenTime; TimeSpan closeTime = isWeekend ? center.WeekendCloseTime : center.WeekdaysCloseTime; TimeSpan startTime = openTime; TimeSpan interval = new TimeSpan(0, center.TimePerTimePeriod, 0); int i = SessionNo; while (i > 0) { startTime = startTime.Add(interval); i--; } TimeSpan endTime = startTime.Add(interval); endTime = endTime <= closeTime ? endTime : closeTime; StartTime = string.Format("{0:hh\\:mm}", startTime); EndTime = string.Format("{0:hh\\:mm}", endTime); Email = r.AspNetUsers.Email; } } }