/// <summary>
/// verifies whether the table is available for booking or not
/// </summary>
/// <param name="tblTableOrder"></param>
/// <returns></returns>
public bool CheckTableAvailability(TblTableOrder tblTableOrder)
{
if (_orderManagementContext.Set <TblTableOrder>().Any(tto => tto.TblRestaurantId == tblTableOrder.TblRestaurantId &&
tto.TblCustomerId == tblTableOrder.TblCustomerId &&
tto.FromDate == tblTableOrder.FromDate))
{
return(false);
}
return(true);
}
/// <summary>
/// Updates the existing booking info
/// </summary>
/// <param name="bookTable"></param>
/// <returns></returns>
public bool UpdateBooking(BookTable bookTable)
{
TblTableOrder tblTableOrder;
if (bookTable != null)
{
tblTableOrder = new TblTableOrder();
tblTableOrder.TblRestaurantId = bookTable.RestaurantId;
tblTableOrder.TblCustomerId = bookTable.CustomerId;
tblTableOrder.FromDate = bookTable.BookingDate;
tblTableOrder.RecordTimeStamp = DateTime.Now;
return(_bookYourTableRepository.BookYourTable(tblTableOrder));
}
return(false);
}
/// <summary>
/// verifies whether the table is available for booking or not
/// </summary>
/// <param name="tblTableOrder"></param>
/// <returns></returns>
public bool CheckTableAvailability(BookTable bookingTable)
{
TblTableOrder tblTableOrder;
if (bookingTable != null)
{
tblTableOrder = new TblTableOrder();
tblTableOrder.TblRestaurantId = bookingTable.RestaurantId;
tblTableOrder.TblCustomerId = bookingTable.CustomerId;
tblTableOrder.FromDate = bookingTable.BookingDate;
return(_bookYourTableRepository.CheckTableAvailability(tblTableOrder));
}
return(false);
}
/// <summary>
/// Updates the booking information
/// </summary>
/// <param name="tblTableOrder"></param>
/// <returns></returns>
public bool UpdateBooking(TblTableOrder tblTableOrder)
{
TblTableOrder tblTableOrderEntity = _orderManagementContext.Set <TblTableOrder>().Where(tto => tto.Id == tblTableOrder.Id).FirstOrDefault();
if (tblTableOrderEntity != null)
{
tblTableOrderEntity = tblTableOrder;
tblTableOrder.UserCreated = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1;
tblTableOrder.UserModified = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1;
tblTableOrderEntity.RecordTimeStamp = DateTime.Now;
_orderManagementContext.SaveChanges();
return(true);
}
return(false);
}
public bool BookYourTable(TblTableOrder tblTableOrder)
{
int?paymentId = null;
if (tblTableOrder != null)
{
tblTableOrder.TblOrderStatusId = 1;
tblTableOrder.TblPaymentTypeId = 4;
tblTableOrder.UserCreated = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1;
tblTableOrder.UserModified = tblTableOrder.TblCustomerId.HasValue ? tblTableOrder.TblCustomerId.Value : 1;
tblTableOrder.ToDate = tblTableOrder.FromDate;
_orderManagementContext.Set <TblTableOrder>().Add(tblTableOrder);
_orderManagementContext.SaveChanges();
return(true);
}
return(false);
}
