public List <Opportunity> Search(OpportunitySearchRequest model, out int totalRows)
{
List <Opportunity> list = null;
int r = 0;
DataProvider.ExecuteCmd(GetConnection, "dbo.Opportunity_Search"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@SearchString", model.SearchString);
paramCollection.AddWithValue("@CurrentPage", model.CurrentPage);
paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage);
paramCollection.AddWithValue("@BeginDate", model.BeginDate);
paramCollection.AddWithValue("@EndDate", model.EndDate);
paramCollection.AddWithValue("@SortByColumn", model.SortByColumn);
paramCollection.AddWithValue("@Descending", model.Descending);
}
, map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
Opportunity o = MapOpportunity(reader, out r);
if (list == null)
{
list = new List <Opportunity>();
}
list.Add(o);
break;
}
});
totalRows = r;
return(list);
}
public HttpResponseMessage Search([FromUri] OpportunitySearchRequest model)
{
int rows = 0;
List <Opportunity> opportunity = _opportunity.Search(model, out rows);
SearchResponse <Opportunity>
response = new SearchResponse <Opportunity>();
response.Items = opportunity;
response.ResultCount = rows;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
