public async Task <ActionResult> Edit(int id, CreateBookedRoomViewModel model)
{
try
{
TimeTable timeTable = model.timeTable;
// TODO: Add update logic here
string sql = $@"
UPDATE TimeTable
SET BookTime = '{timeTable.BookTime}'
WHERE Id = {id}";
using (IDbConnection conn = Connection)
{
int rowsAffected = await conn.ExecuteAsync(sql);
if (rowsAffected > 0)
{
return(RedirectToAction(nameof(Index)));
}
return(BadRequest());
}
}
catch
{
return(View());
}
}
public async Task <ActionResult> Create(CreateBookedRoomViewModel model)
{
string sql = $@"INSERT INTO TimeTable
(BookTime)
VALUES
(
'{model.timeTable.BookTime}'
);";
using (IDbConnection conn = Connection)
{
var newId = await conn.ExecuteAsync(sql);
return(RedirectToAction(nameof(Index)));
}
}
// GET: Rooms/Details/5
public async Task <ActionResult> Details(int id)
{
string roomsql = $@"
SELECT
r.RoomId,
r.Name
FROM Rooms r
WHERE r.RoomId = {id}
";
using (IDbConnection conn = Connection)
{
Room room = await conn.QueryFirstAsync <Room>(roomsql);
CreateBookedRoomViewModel model = new CreateBookedRoomViewModel(_config, room);
return(View(model));
}
}