public AnonTrackingGrid GetGrid(AnonTrackingGridRequest model)
{
AnonTrackingGrid singleItem = new AnonTrackingGrid();
DataProvider.ExecuteCmd("dbo.AnonTracking_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:
AnonUser singleItem2 = new AnonUser();
int startingIndex = 0; //startingOrdinal
singleItem2.Id = reader.GetSafeInt32(startingIndex++);
singleItem2.Email = reader.GetSafeString(startingIndex++);
singleItem2.VisitCount = reader.GetSafeInt32(startingIndex++);
singleItem2.DateCreated = reader.GetSafeDateTime(startingIndex++);
singleItem2.DateModified = reader.GetSafeDateTime(startingIndex++);
if (singleItem.data == null)
{
singleItem.data = new List <AnonUser>();
}
singleItem.data.Add(singleItem2);
break;
default:
singleItem = null;
break;
}
});
return(singleItem);
}
public HttpResponseMessage GetGrid(AnonTrackingGridRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
try
{
ItemResponse <AnonTrackingGrid> resp = new ItemResponse <AnonTrackingGrid>();
resp.Item = _AnonTrackingService.GetGrid(model);
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
