public async Task <IActionResult> Edit(int id, [Bind("ActorID,ActorFullName,ActorNotes")] BookingsRooms bookings)
{
if (id != bookings.BookingsRoomsID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(bookings);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BookingsRoomsExists(bookings.BookingsRoomsID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(bookings));
}
public async Task <IActionResult> Create([Bind("ActorID,ActorFullName,ActorNotes")] BookingsRooms bookings)
{
if (ModelState.IsValid)
{
_context.Add(bookings);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(bookings));
}
public async Task <bool> AddBookingRoom(BookingsRooms bookingsRooms)
{
using (var c = new SqlConnection(_connectionString))
{
try
{
await c.ExecuteAsync("INSERT INTO BOOKINGSROOMS (BOOKINGSID, ROOMSID) VALUES (@id, @roomsid)",
new
{
bookingsRooms.BOOKINGSID, bookingsRooms.ROOMSID
});
return(true);
}
catch (System.Exception)
{
return(false);
}
}
}
public async Task <IActionResult> Add([FromBody] BookingsRooms bookingsRooms)
{
return(Ok(await _bookingRoomService.AddBookingRoom(bookingsRooms)));
}
public async Task <bool> AddBookingRoom(BookingsRooms bookingRooms)
{
return(await _bookingRoomRepository.AddBookingRoom(bookingRooms));
}
