public void CancelReservation(int reservationId, string user)
{
using (var dbContext = new FlexSeatingContext())
{
var res = dbContext.Reservations.Where(x => x.Id == reservationId).FirstOrDefault();
if (res != null && user == res.UserId)
{
dbContext.Reservations.Remove(res);
}
dbContext.SaveChanges();
}
}
public void ReserveDesk(int deskId, string user, DateTime date)
{
using (var dbContext = new FlexSeatingContext())
{
var num = dbContext.Reservations.Where(x => (x.Date == date && x.UserId == user)).Count();
if (num == 0)
{
var res = new Reservations()
{
DeskId = deskId,
UserId = user,
Date = date
};
dbContext.Reservations.Add(res);
dbContext.SaveChanges();
}
}
}
