public HttpResponseMessage GetGrid(HelpGridRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { ItemResponse <HelpGrid> resp = new ItemResponse <HelpGrid>(); resp.Item = _helpService.GetGrid(model); return(Request.CreateResponse(HttpStatusCode.OK, resp)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HelpGrid GetGrid(HelpGridRequest model) { HelpGrid singleItem = new HelpGrid(); DataProvider.ExecuteCmd("dbo.Help_Grid" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@DisplayLength", model.displayLength); paramCollection.AddWithValue("@DisplayStart", model.displayStart); paramCollection.AddWithValue("@SortCol", model.sortCol); paramCollection.AddWithValue("@SortDir", model.sortDir); paramCollection.AddWithValue("@Search", model.search); } , singleRecordMapper : delegate(IDataReader reader, short set) { switch (set) { case 0: singleItem.recordsTotal = reader.GetSafeInt32(0); break; case 1: singleItem.recordsFiltered = reader.GetSafeInt32(0); break; case 2: Help h = Mapper(reader); if (singleItem.data == null) { singleItem.data = new List <Help>(); } singleItem.data.Add(h); break; default: singleItem = null; break; } }); return(singleItem); }