public HttpResponseMessage GetActiveOpenHousesBySearchCriteria(OpenHouseDatesSearchRequest model)
{
HttpStatusCode statusCode = HttpStatusCode.OK;
BaseResponse response = null;
// check initial request model
if (!ModelState.IsValid)
{
return(ErrorList(ModelState.Values));
}
try
{
response = new ItemsResponse <OpenHouseBase>();
((ItemsResponse <OpenHouseBase>)response).Items = _openHouseService.GetActiveOpenHousesBySearch(model);
statusCode = HttpStatusCode.OK;
}
catch (Exception ex)
{
// general error
statusCode = HttpStatusCode.ExpectationFailed;
response = new ErrorResponse(ex.Message);
}
return(Request.CreateResponse(statusCode, response));
}
public List <OpenHouseBase> GetActiveOpenHousesBySearch(OpenHouseDatesSearchRequest model)
{
List <OpenHouseBase> openHouseList = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.OpenHouses_SelectAllActiveBySearch"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@StartDate", model.StartDate);
if (model.EndDate.HasValue && (model.EndDate > model.StartDate))
{
paramCollection.AddWithValue("@EndDate", model.EndDate);
}
else
{
paramCollection.AddWithValue("@EndDate", null);
}
paramCollection.AddWithValue("@ListingKeyNumeric", model.ListingKeyNumeric);
paramCollection.AddWithValue("@MlsListingId", model.MlsListingId);
paramCollection.AddWithValue("@PostalCode", model.PostalCode);
paramCollection.AddWithValue("@CityName", model.CityName);
paramCollection.AddWithValue("@MaxRows", model.MaxRows);
}, map : delegate(IDataReader reader, short set)
{
OpenHouseBase openHouse = MapOpenHouseReader(reader);
if (openHouseList == null)
{
openHouseList = new List <OpenHouseBase>();
}
openHouseList.Add(openHouse);
}
);
return(openHouseList);
}
