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