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