public HttpResponseMessage GetGrid(UsersGridRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { ItemResponse <UsersGrid> resp = new ItemResponse <UsersGrid>(); resp.Item = _AdminUserService.GetGrid(model); return(Request.CreateResponse(HttpStatusCode.OK, resp)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public UsersGrid GetGrid(UsersGridRequest model) { UsersGrid singleItem = new UsersGrid(); DataProvider.ExecuteCmd("dbo.UserBase_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: Users u = Mapper(reader); if (singleItem.data == null) { singleItem.data = new List <Users>(); } singleItem.data.Add(u); break; default: singleItem = null; break; } }); return(singleItem); }