public ReturnStatus SetBooking(SetBooking req)
{
using (var connection = new SqlConnection(_connectionString.HotelManagement))
{
var cmd = new SqlCommand(p_Bookings_Set, connection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@UserID", _requestInfo.UserId);
cmd.Parameters.Add("@RetVal", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@RetMsg", SqlDbType.VarChar, 500).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@BookingID", req.BookingId);
cmd.Parameters.AddWithValue("@GuestID", req.GuestId);
cmd.Parameters.AddWithValue("@PaymentID", req.PaymentId);
cmd.Parameters.AddWithValue("@CheckInDate", req.CheckInDate);
cmd.Parameters.AddWithValue("@CheckOutDate", req.CheckOutDate);
cmd.Parameters.AddWithValue("@BookTypeID", req.BookTypeId);
cmd.Parameters.AddWithValue("@BookRate", req.BookRate);
cmd.Parameters.AddWithValue("@Comment", req.Comment);
cmd.Parameters.AddWithValue("@Cancel", req.Cancel);
cmd.Parameters.AddWithValue("@CanceledDate", req.CanceledDate);
connection.Open();
cmd.ExecuteNonQuery();
return(new ReturnStatus(cmd.Parameters["@RetVal"].Value.ToSafeInt32(), cmd.Parameters["@RetMsg"].Value.ToSafeString()));
}
}
public ReturnStatus SetBooking(SetBooking req)
{
return(null);
}
