// GET: BookedRooms/Edit/5
// Semi-Custom Edit GET
public async Task <IActionResult> Edit(int?id)
{
string roomsql = $@"
SELECT
br.BookedRoomId,
br.RoomId,
br.TimeTableId,
br.UserId,
br.BookDate
FROM BookedRooms br
WHERE br.BookedRoomId = {id}
";
if (id == null)
{
return(NotFound());
}
using (IDbConnection conn = Connection)
{
BookedRoom bookedRoom = await conn.QueryFirstAsync <BookedRoom>(roomsql);
EditBookedRoomViewModel model = new EditBookedRoomViewModel(_config, bookedRoom);
return(View(model));
}
}
public async Task <IActionResult> Edit(int id, EditBookedRoomViewModel viewModel)
{
ModelState.Remove("bookedRoom.User");
ModelState.Remove("bookedRoom.UserId");
ModelState.Remove("bookedRoom.BookDate");
ModelState.Remove("timeTable.BookTime");
ModelState.Remove("UserId");
ModelState.Remove("BookDate");
if (ModelState.IsValid)
{
var user = await GetCurrentUserAsync();
BookedRoom reassignedBookedRoom = await _context.BookedRooms
.FirstOrDefaultAsync(m => m.BookedRoomId == id);
reassignedBookedRoom.TimeTableId = viewModel.timeTable.TimeTableId;
reassignedBookedRoom.BookedRoomId = id;
reassignedBookedRoom.UserId = user.Id;
_context.Update(reassignedBookedRoom);
await _context.SaveChangesAsync();
}
return(RedirectToAction(nameof(Index)));
}
