private void InitializeFixture(HttpStatusCode httpClientStatus)
{
var mockHttpClient = MockHttpClient(httpClientStatus);
getMovieCruiser = new GetBookings(mockHttpClient);
getMovieCruiserRequest = new GetBookinggRequest();
}
public List <Booking> GetBookings(GetBookings req)
{
return(null);
}
public ApiResponse <List <Booking> > GetBookings(GetBookings req)
{
var result = null as List <Booking>;
using (var connection = new SqlConnection(_connectionString.HotelManagement))
{
var cmd = new SqlCommand(p_Bookings_Get, 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("@IncludeCanceled", req.IncludeCanceled);
cmd.Parameters.AddWithValue("@CanceledDate", req.CanceledDate);
connection.Open();
using (var dr = cmd.ExecuteReader())
{
result = new List <Booking>();
while (dr.Read())
{
result.Add(new Booking
{
BookingId = dr["BookingID"].ToSafeInt32(),
GuestId = dr["GuestID"].ToSafeInt32(),
PaymentId = dr["PaymentID"].ToSafeInt32(),
CheckInDate = dr["CheckInDate"].ToSafeDateTime(),
CheckOutDate = dr["CheckOutDate"].ToSafeDateTime(),
BookTypeId = dr["BookTypeID"].ToSafeInt32(),
BookRate = dr["BookRate"].ToSafeDecimal(),
Comment = dr["Comment"].ToSafeString(),
Canceled = dr["Canceled"].ToSafeBool(),
CanceledDate = dr["CanceledDate"].ToSafeDateTime(),
CreatedId = dr["CreatedID"].ToSafeInt32(),
CreatedBy = dr["CreatedBy"].ToSafeString(),
CreatedDateTime = dr["CreatedDateTime"].ToSafeDateTime(),
ModifiedId = dr["ModifiedID"].ToSafeInt32(),
ModifiedBy = dr["ModifiedBy"].ToSafeString(),
ModifiedDateTime = dr["ModifiedDateTime"].ToSafeDateTime()
});
}
}
return(new ApiResponse <List <Booking> >
{
Content = result,
Status = new ReturnStatus(cmd.Parameters["@RetVal"].Value.ToSafeInt32(),
cmd.Parameters["@RetMsg"].Value.ToSafeString())
});
}
}
