public IActionResult UpdateBooking(int Id, bool?isDelete)
{
ViewData["PackageTypes"] = DBUtl.GetList(@"SELECT ID as value, Description as text from SRPackageType ORDER BY Description");
ViewData["Slots"] = DBUtl.GetList(@"SELECT Id as value, Description as text FROM SRSlot ORDER BY Description");
string userId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
List <SRBooking> lstBooking = DBUtl.GetList <SRBooking>(@"SELECT * FROM SRBooking WHERE Id = {0} AND BookedBy={1}", Id, userId);
SRBooking model = null;
if (lstBooking.Count > 0)
{
if (isDelete.HasValue == false || isDelete == false)
{
ViewData["PostTo"] = "UpdateBooking";
ViewData["ButtonText"] = "Update";
}
else
{
ViewData["PostTo"] = "DeleteBooking";
ViewData["ButtonText"] = "Delete";
}
model = lstBooking[0];
return(View("Booking", model));
}
else
{
TempData["Msg"] = $"Booking {Id} not found!";
return(RedirectToAction("Index"));
}
}
public IActionResult CreateBooking(SRBooking newBk)
{
if (ModelState.IsValid)
{
// TODO Task 2c: Modify the ExecSQL so that BookedBy field is updated with current logged-user id.
// TODO Task 2d: Verification: Navigate to SingRoom/CreateBooking to verify that new records created can be displayed in the index view
string userID = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
if (DBUtl.ExecSQL(@"INSERT INTO SRBooking
(Name, SlotId, PackageTypeId, BookingDate, Hours,
AOSnack, AODrink, BookedBy)
VALUES ('{0}',{1},{2},'{3}',{4},'{5}','{6}',{7})",
newBk.Name, newBk.SlotId, newBk.PackageTypeId,
$"{newBk.BookingDate:dd MMMM yyyy}", newBk.Hours,
newBk.AOSnack, newBk.AODrink, userID) == 1)
{
TempData["Msg"] = "New booking added.";
}
else
{
TempData["Msg"] = DBUtl.DB_Message;
}
return(RedirectToAction("Index"));
}
else
{
TempData["Msg"] = "Invalid information entered!";
return(RedirectToAction("Index"));
}
}
public IActionResult DeleteBooking(SRBooking uBook)
{
string userId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
if (DBUtl.ExecSQL(@"DELETE FROM SRBooking WHERE Id ={0} AND BookedBy={1}", uBook.Id, userId) == 1)
{
TempData["Msg"] = $"Booking{uBook.Id} deleted";
}
else
{
TempData["Msg"] = DBUtl.DB_Message;
}
return(RedirectToAction("Index"));
}
public IActionResult CreateBooking(SRBooking newSRBooking)
{
// TODO Task 3d Use ModelState.IsValid to guard against invalid input. Pass the message "Invalid information entered" to Index action when ModelState.IsValid is false
if (ModelState.IsValid)
{
if (DBUtl.ExecSQL(@"INSERT INTO SRBooking (Name, SlotId, PackageTypeId, BookingDate, Hours, AOSnack, AODrink)
VALUES ('{0}', {1}, {2}, '{3}', {4}, '{5}', '{6}')",
newSRBooking.Name, newSRBooking.SlotId, newSRBooking.PackageTypeId, $"{newSRBooking.BookingDate:yyyy-MM-dd}", newSRBooking.Hours, newSRBooking.AOSnack, newSRBooking.AODrink) == 1)
{
TempData["Msg"] = "New booking added.";
}
else
{
TempData["Msg"] = "Failed to add new booking.";
}
return(RedirectToAction("Index"));
}
else
{
TempData["Msg"] = "Invalid information entered";
return(RedirectToAction("Index"));
}
}
public IActionResult UpdateBooking(SRBooking uBook)
{
if (ModelState.IsValid)
{
string userId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
if (DBUtl.ExecSQL(@"UPDATE SRBooking
SET Name='{0}', SlotId={1}, PackageTypeId={2},BookingDate='{3}',Hours={4},AOSnack='{5}',AODrink='{6}' WHERE Id = {7} AND BookedBy={8}",
uBook.Name, uBook.SlotId, uBook.PackageTypeId, $"{uBook.BookingDate:dd MMMM yyyy}", uBook.Hours, uBook.AOSnack, uBook.AODrink, uBook.Id, userId) == 1)
{
TempData["Msg"] = $"Booking{uBook.Id} updated";
}
else
{
TempData["Msg"] = DBUtl.DB_Message;
}
return(RedirectToAction("Index"));
}
else
{
TempData["Msg"] = "Invalid information entered!";
return(RedirectToAction("Index"));
}
}
public IActionResult UpdateBooking(SRBooking newSRBooking)
{
string userid = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
if (ModelState.IsValid)
{
if (DBUtl.ExecSQL(@"INSERT INTO SRBooking (Name, SlotId, PackageTypeId, BookingDate, Hours, AOSnack, AODrink,BookedBy)
VALUES ('{0}', {1}, {2}, '{3}', {4}, '{5}', '{6}',{7})",
newSRBooking.Name, newSRBooking.SlotId, newSRBooking.PackageTypeId, $"{newSRBooking.BookingDate:dd MMMM yyyy}", newSRBooking.Hours, newSRBooking.AOSnack, newSRBooking.AODrink, userid) == 1)
{
TempData["Msg"] = "New booking added.";
}
else
{
TempData["Msg"] = DBUtl.DB_Message;
}
return(RedirectToAction("Index"));
}
else
{
TempData["Msg"] = "Invalid information entered!";
return(RedirectToAction("Index"));
}
}
