public object SaveWaitedlistBooking(BookingTableInputDTO bookingTableInput)
{
bool res = _hostessBL.SaveWaitedlistBooking(bookingTableInput);
try
{
return(Json(new JsonResponseResult {
_ErrorCode = TruflConstants._ErrorCodeSuccess, _Data = res, _StatusCode = TruflConstants._StatusCodeOK, _StatusMessage = TruflConstants._StatusMessageSuccess
}));
}
catch (Exception ex)
{
return(Json(new JsonResponseResult {
_ErrorCode = TruflConstants._ErrorCodeFailed, _Data = ex.ToString(), _StatusCode = TruflConstants._StatusCodeFailed, _StatusMessage = TruflConstants._StatusMessageFailed
}));
}
}
/// <summary>
/// This method 'SaveWaitedlistBooking' will save all the waited list users
/// </summary>
/// <param name=" data"></param>
/// <returns>Returns 1 if Success, 0 for failure</returns>
public bool SaveWaitedlistBooking(BookingTableInputDTO bookingTableInput)
{
try
{
var dtClient = new DataTable();
dtClient.Columns.Add("BookingID", typeof(Int64));
dtClient.Columns.Add("TruflUserID", typeof(Int64));
dtClient.Columns.Add("RestaurantID", typeof(Int64));
dtClient.Columns.Add("PartySize", typeof(Int64));
dtClient.Columns.Add("OfferType", typeof(Int64));
dtClient.Columns.Add("OfferAmount", typeof(Int64));
dtClient.Columns.Add("BookingStatus", typeof(Int64));
dtClient.Columns.Add("Points", typeof(Int64));
dtClient.Columns.Add("TruflUserCardDataID", typeof(Int64));
dtClient.Columns.Add("TruflTCID", typeof(Int64));
dtClient.Columns.Add("ModifiedDate", typeof(DateTime));
dtClient.Columns.Add("ModifiedBy", typeof(Int64));
dtClient.Columns.Add("Quoted", typeof(DateTime));
dtClient.Columns.Add("PaymentStatus", typeof(string));
dtClient.Columns.Add("TableNumbers", typeof(string));
dtClient.Rows.Add(bookingTableInput.BookingID,
bookingTableInput.TruflUserID,
bookingTableInput.RestaurantID,
bookingTableInput.PartySize,
bookingTableInput.OfferType,
bookingTableInput.OfferAmount,
bookingTableInput.BookingStatus,
bookingTableInput.Points,
bookingTableInput.TruflUserCardDataID,
bookingTableInput.TruflTCID,
bookingTableInput.ModifiedDate,
bookingTableInput.ModifiedBy,
bookingTableInput.Quoted,
bookingTableInput.PaymentStatus,
bookingTableInput.TableNumbers
);
string connectionString = ConfigurationManager.AppSettings["TraflConnection"];
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("spSaveBooking", con))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter tvpParam = cmd.Parameters.AddWithValue("@BookingTY", dtClient);
tvpParam.SqlDbType = SqlDbType.Structured;
SqlParameter tvparam1 = cmd.Parameters.AddWithValue("@LoggedInUser", bookingTableInput.LoggedInUser);
tvparam1.SqlDbType = SqlDbType.Int;
SqlParameter pvNewId = new SqlParameter();
pvNewId.ParameterName = "@RetVal";
pvNewId.DbType = DbType.Int32;
pvNewId.Direction = ParameterDirection.Output;
cmd.Parameters.Add(pvNewId);
int status = cmd.ExecuteNonQuery();
if (status == 0)
{
return(false);
}
else
{
return(true);
}
}
}
}
catch (Exception ex)
{
ExceptionLogger.WriteToErrorLogFile(ex);
return(false);
}
}
public bool SaveWaitedlistBooking(BookingTableInputDTO bookingTableInput)
{
return(_hostessDL.SaveWaitedlistBooking(bookingTableInput));
}
