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