/// <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); }