public async Task <IActionResult> PutRoomAmenity(int id, RoomAmenity roomAmenity) { if (id != roomAmenity.RoomID) { return(BadRequest()); } _context.Entry(roomAmenity).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RoomAmenityExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Edit(int id, [Bind("AmenityID,RoomID")] RoomAmenity roomAmenity) { if (id != roomAmenity.AmenityID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(roomAmenity); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RoomAmenityExists(roomAmenity.AmenityID, roomAmenity.RoomID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["AmenityID"] = new SelectList(_context.Amenities, "ID", "Name", roomAmenity.AmenityID); ViewData["RoomID"] = new SelectList(_context.Rooms, "ID", "Name", roomAmenity.RoomID); return(View(roomAmenity)); }
public async void CanSaveRoomAmenityInDB() { DbContextOptions <HotelDbContext> options = new DbContextOptionsBuilder <HotelDbContext>().UseInMemoryDatabase("DbSaveRoomAmenity").Options; using (HotelDbContext context = new HotelDbContext(options)) { Room room = new Room(); room.Name = "Cove"; room.Layout = Layout.OneBedroom; context.Rooms.Add(room); Amenity amenity = new Amenity(); amenity.Name = "Mini Bar"; context.Amenities.Add(amenity); // Arrange RoomAmenity roomAmenity = new RoomAmenity(); roomAmenity.Room = room; roomAmenity.Amenity = amenity; context.RoomAmenities.Add(roomAmenity); context.SaveChanges(); // Act var roomAmenityGet = await context.RoomAmenities.FirstOrDefaultAsync(); // Assert Assert.Equal(amenity, roomAmenityGet.Amenity); } }
public async void CanDeleteRoomAmenityInDB() { DbContextOptions <HotelDbContext> options = new DbContextOptionsBuilder <HotelDbContext>().UseInMemoryDatabase("DbDeleteRoomAmenity").Options; using (HotelDbContext context = new HotelDbContext(options)) { Room room = new Room(); room.Name = "Cove"; room.Layout = Layout.Studio; context.Rooms.Add(room); Amenity amenity = new Amenity(); amenity.Name = "Mini Bar"; context.Amenities.Add(amenity); // Arrange RoomAmenity roomAmenity = new RoomAmenity(); roomAmenity.Room = room; roomAmenity.Amenity = amenity; context.RoomAmenities.Add(roomAmenity); context.SaveChanges(); // Act context.RoomAmenities.Remove(roomAmenity); context.SaveChanges(); var nameOfRoomAmenity = await context.RoomAmenities.FirstOrDefaultAsync(); // Assert Assert.False(context.RoomAmenities.Any()); } }
// POST: RoomAmenities/Create // To protect from overposting attacks, please enable the specific properties you want to bind to, for // more details see https://go.microsoft.com/fwlink/?LinkId=317598. public JsonResult CreateRoomAmenities(RoomAmenity roomAmenity) { try { if (ModelState.IsValid) { int totalExistRows = db.RoomAmenities.Where(x => x.RoomAmenitiesName.ToUpper().Equals(roomAmenity.RoomAmenitiesName.ToUpper())).Count(); if (totalExistRows > 0) { return(Json(new { StatusCode = HttpStatusCode.Found, StatusMessage = "Room Amenity already present" }, JsonRequestBehavior.AllowGet)); } roomAmenity.CreatedBy = (Session["User"] as SessionEntity).UserID; roomAmenity.CreatedDate = DateTime.Now; db.RoomAmenities.Add(roomAmenity); db.SaveChanges(); return(Json(new { StatusCode = HttpStatusCode.Created, StatusMessage = "Room Amenity Saved Successfully" }, JsonRequestBehavior.AllowGet)); } ViewBag.CreatedBy = new SelectList(db.Users, "UserID", "FirstName", roomAmenity.CreatedBy); ViewBag.RoomTypeID = new SelectList(db.RoomTypes, "RoomTypeID", "RoomTypeName", roomAmenity.RoomTypeID); ViewBag.UpdatedBy = new SelectList(db.Users, "UserID", "FirstName", roomAmenity.UpdatedBy); } catch (Exception e) { return(Json(new { StatusCode = HttpStatusCode.MethodNotAllowed, StatusMessage = e.Message }, JsonRequestBehavior.AllowGet)); } return(Json(new { StatusCode = HttpStatusCode.MethodNotAllowed, StatusMessage = "Please enter required fields" }, JsonRequestBehavior.AllowGet)); }
public async void CreateRoomAmenityDB() { DbContextOptions <AsyncInnDbContext> options = new DbContextOptionsBuilder <AsyncInnDbContext>() .UseInMemoryDatabase("CreateRoomAmenity") .Options; using (AsyncInnDbContext context = new AsyncInnDbContext(options)) { // create room, create amenity, create //room amenity Amenity a = new Amenity(); a.Name = "Air Conditioning"; Room r = new Room(); r.Name = "Mii amo"; context.Add(a); context.Add(r); context.SaveChanges(); var amenity = context.Amenity.FirstOrDefaultAsync(x => x.Name == a.Name); var room = context.Rooms.FirstOrDefaultAsync(x => x.Name == r.Name); RoomAmenity ra = new RoomAmenity(); ra.AmenitiesID = amenity.Id; ra.RoomID = room.Id; context.RoomAmenity.Add(ra); context.SaveChanges(); var roomamenity = await context.RoomAmenity.FirstOrDefaultAsync(x => x.AmenitiesID == ra.AmenitiesID); //assert db entry Assert.Equal(roomamenity.RoomID, ra.RoomID); } }
public async Task RemoveAmentityFromRoom(int roomId, int amenityId) { RoomAmenity roomAmenity = await _context.RoomAmenities.Where(x => x.AmenityId == amenityId).FirstOrDefaultAsync(); _context.Entry(roomAmenity).State = EntityState.Deleted; await _context.SaveChangesAsync(); }
public ActionResult DeleteConfirmed(int id) { RoomAmenity roomAmenity = db.RoomAmenity.Find(id); db.RoomAmenity.Remove(roomAmenity); db.SaveChanges(); return(RedirectToAction("Index")); }
public void CanGetAndSetAmenity() { RoomAmenity ra = new RoomAmenity(); Amenity amenity = new Amenity(); amenity.Name = "Ice Box"; ra.Amenity = amenity; Assert.Equal(amenity, ra.Amenity); }
// GET: RoomAmenities/Details/5 public ActionResult Details(int?id) { RoomAmenity roomAmenity = db.RoomAmenities.Find(id); if (roomAmenity == null) { return(Json(new { StatusCode = HttpStatusCode.NoContent, StatusMessage = "Room Amenities not found" }, JsonRequestBehavior.AllowGet)); } return(PartialView(roomAmenity)); }
/// <summary> /// Removes a given amenity from a specific room. /// </summary> /// <param name="roomId">Unique id for room</param> /// <param name="amenityId">Unique id for amenity to be removed</param> /// <returns>Task of completion</returns> public async Task RemoveAmenityFromRoom(int roomId, int amenityId) { RoomAmenity result = await _context.RoomAmenities.FindAsync(roomId, amenityId); if (result != null) { _context.Entry(result).State = EntityState.Deleted; await _context.SaveChangesAsync(); } }
public async Task AddAmenityAsync(long amenityId, long roomId) { var roomAmenity = new RoomAmenity { AmenityId = amenityId, RoomId = roomId }; _context.RoomAmenities.Add(roomAmenity); await _context.SaveChangesAsync(); }
public async Task AddAmenityToRoom(int roomId, int amenityId) { var roomAmenity = new RoomAmenity { AmenityId = amenityId, RoomId = roomId, }; _context.RoomAmenities.Add(roomAmenity); await _context.SaveChangesAsync(); }
public async Task <IActionResult> Create([Bind("AmenitiesID,RoomID")] RoomAmenity roomAmenity) { if (ModelState.IsValid) { _context.Add(roomAmenity); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(roomAmenity)); }
public async Task AddAmenityToRoom(int roomId, int amenityId) { RoomAmenity roomAmenity = new RoomAmenity() { RoomId = roomId, AmenityId = amenityId }; _context.Entry(roomAmenity).State = EntityState.Added; await _context.SaveChangesAsync(); }
public async Task AddAmenityAsync(int roomId, int amenityId) { var amenity = new RoomAmenity { RoomId = roomId, AmenityId = amenityId }; _context.RoomAmenities.Add(amenity); await _context.SaveChangesAsync(); }
public async Task AddAmenityToRoom(int roomID, int amenityID) { var roomAmenity = new RoomAmenity { AmenityID = amenityID, RoomID = roomID }; _context.RoomAmenity.Add(roomAmenity); await _context.SaveChangesAsync(); }
public ActionResult Edit([Bind(Include = "amenityID,reservationID,serviceID,date")] RoomAmenity roomAmenity) { if (ModelState.IsValid) { db.Entry(roomAmenity).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.reservationID = new SelectList(db.Reservation, "reservationID", "reservationID", roomAmenity.reservationID); ViewBag.serviceID = new SelectList(db.Service, "serviceID", "name", roomAmenity.serviceID); return(View(roomAmenity)); }
public async Task <IActionResult> Create([Bind("AmenityID,RoomID")] RoomAmenity roomAmenity) { if (ModelState.IsValid) { _context.Add(roomAmenity); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["AmenityID"] = new SelectList(_context.Amenities, "ID", "Name", roomAmenity.AmenityID); ViewData["RoomID"] = new SelectList(_context.Rooms, "ID", "Name", roomAmenity.RoomID); return(View(roomAmenity)); }
// GET: RoomAmenities/Edit/5 public ActionResult Edit(int?id) { RoomAmenity roomAmenity = db.RoomAmenities.Find(id); if (roomAmenity == null) { return(Json(new { StatusCode = HttpStatusCode.NoContent, StatusMessage = "Room Amenity not found" }, JsonRequestBehavior.AllowGet)); } ViewBag.CreatedBy = new SelectList(db.Users, "UserID", "FirstName", roomAmenity.CreatedBy); ViewBag.RoomTypeID = new SelectList(db.RoomTypes, "RoomTypeID", "RoomTypeName", roomAmenity.RoomTypeID); ViewBag.UpdatedBy = new SelectList(db.Users, "UserID", "FirstName", roomAmenity.UpdatedBy); return(PartialView(roomAmenity)); }
// POST: RoomAmenities/Delete/5 public JsonResult DeleteConfirmed(int id) { try { RoomAmenity roomAmenity = db.RoomAmenities.Find(id); db.RoomAmenities.Remove(roomAmenity); db.SaveChanges(); return(Json(new { StatusCode = HttpStatusCode.Created, StatusMessage = "Room Amenity Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { StatusCode = HttpStatusCode.MethodNotAllowed, StatusMessage = e.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create([Bind(Include = "amenityID,reservationID,serviceID")] RoomAmenity roomAmenity) { if (ModelState.IsValid) { roomAmenity.date = DateTime.Now; db.RoomAmenity.Add(roomAmenity); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.reservationID = new SelectList(db.Reservation, "reservationID", "reservationID", roomAmenity.reservationID); ViewBag.serviceID = new SelectList(db.Service, "serviceID", "name", roomAmenity.serviceID); return(View(roomAmenity)); }
// GET: RoomAmenities/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RoomAmenity roomAmenity = db.RoomAmenity.Find(id); if (roomAmenity == null) { return(HttpNotFound()); } return(View(roomAmenity)); }
// GET: RoomAmenities/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RoomAmenity roomAmenity = db.RoomAmenity.Find(id); if (roomAmenity == null) { return(HttpNotFound()); } ViewBag.reservationID = new SelectList(db.Reservation, "reservationID", "reservationID", roomAmenity.reservationID); ViewBag.serviceID = new SelectList(db.Service, "serviceID", "name", roomAmenity.serviceID); return(View(roomAmenity)); }
public async Task <RoomDto> AddAmenityToRoom(int roomId, int amenityId) { RoomAmenity roomAmenity = new RoomAmenity() { RoomId = roomId, AmenityId = amenityId }; _context.Entry(roomAmenity).State = EntityState.Added; await _context.SaveChangesAsync(); var dto = await GetRoom(roomId); return(dto); }
public async Task <ActionResult <RoomAmenity> > PostRoomAmenity(RoomAmenity roomAmenity) { _context.RoomAmenity.Add(roomAmenity); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (RoomAmenityExists(roomAmenity.RoomID)) { return(Conflict()); } else { throw; } } return(CreatedAtAction("GetRoomAmenity", new { id = roomAmenity.RoomID }, roomAmenity)); }
public void AddAmenityToRoom(int amenityId, int roomId) { var roomAmenity = new RoomAmenity { AmenityId = amenityId, RoomId = roomId }; using (var dbContextTransaction = db.Database.BeginTransaction()) { try { db.RoomAmenities.Add(roomAmenity); db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } }
// POST: RoomAmenities/Edit/5 // To protect from overposting attacks, please enable the specific properties you want to bind to, for // more details see https://go.microsoft.com/fwlink/?LinkId=317598. public JsonResult UpdateRoomAmenities(RoomAmenity roomAmenity) { try { if (ModelState.IsValid) { db.Entry(roomAmenity).State = EntityState.Modified; roomAmenity.UpdatedBy = (Session["User"] as SessionEntity).UserID; roomAmenity.UpdatedDate = DateTime.Now; db.SaveChanges(); return(Json(new { StatusCode = HttpStatusCode.Created, StatusMessage = "Room Amenity Updated Successfully" }, JsonRequestBehavior.AllowGet)); } ViewBag.CreatedBy = new SelectList(db.Users, "UserID", "FirstName", roomAmenity.CreatedBy); ViewBag.RoomTypeID = new SelectList(db.RoomTypes, "RoomTypeID", "RoomTypeName", roomAmenity.RoomTypeID); ViewBag.UpdatedBy = new SelectList(db.Users, "UserID", "FirstName", roomAmenity.UpdatedBy); } catch (Exception e) { return(Json(new { StatusCode = HttpStatusCode.MethodNotAllowed, StatusMessage = e.Message }, JsonRequestBehavior.AllowGet)); } return(Json(new { StatusCode = HttpStatusCode.MethodNotAllowed, StatusMessage = "Please enter required fields" }, JsonRequestBehavior.AllowGet)); }
public async void CanUpdateRoomAmenityInDB() { DbContextOptions <HotelDbContext> options = new DbContextOptionsBuilder <HotelDbContext>().UseInMemoryDatabase("DbUpdateRoomAmenity").Options; using (HotelDbContext context = new HotelDbContext(options)) { Room room = new Room(); room.Name = "Cove"; room.Layout = Layout.OneBedroom; context.Rooms.Add(room); Amenity amenityOne = new Amenity(); amenityOne.Name = "Mini Bar"; context.Amenities.Add(amenityOne); Amenity amenityTwo = new Amenity(); amenityTwo.Name = "Cigars"; context.Amenities.Add(amenityTwo); // Arrange RoomAmenity roomAmenity = new RoomAmenity(); roomAmenity.Room = room; roomAmenity.Amenity = amenityOne; // Act roomAmenity.Amenity = amenityTwo; context.RoomAmenities.Update(roomAmenity); context.SaveChanges(); var nameOfRoomAmenity = await context.RoomAmenities.FirstOrDefaultAsync(); // Assert Assert.Equal(amenityTwo, nameOfRoomAmenity.Amenity); } }