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