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