public JsonResult GetCampaignLog(PagingOptions options, Int64 CampID, int userId)
{
var start = options.Start;
var length = options.Length;
int pageSize = length;
int skip = start;
int recordsTotal = 0;
var firstCampaign = "";
List <Log> camplog = null;
if (CampID > 0)
{
camplog = optimizeData.GetCampaignLogData(CampID, userId, out firstCampaign);
var v = from a in camplog select a;
recordsTotal = v.Count();
camplog = v.Skip(skip).Take(pageSize).ToList();
}
return(Json(new { recordsTotal = recordsTotal, data = camplog, FirstCampaign = firstCampaign }));
}
public JsonResult GetCampaignLog(PagingOptions options, Int64 CampID)
{
//paging parameter
var start = options.Start;
var length = options.Length;
//sorting parameter
//var sortColumn = options.ColumnName;
//var sortColumnDir = options.Direction ? "ascending" : "descending";
//filter parameter
//var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
int pageSize = length;
int skip = start;
int recordsTotal = 0;
var firstCmap = "";
var camplog = optimizeData.GetCampaignLogData(CampID, SessionData.UserID, out firstCmap);
//Database query
var v = from a in camplog select a;
//if (!string.IsNullOrEmpty(searchValue))
//{
// v = v.Where(a =>
// a.CampaignName.Contains(searchValue)
// );
//}
//sort
//if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
//{
// //for make sort simpler we will add Syste.Linq.Dynamic reference
// v = v.OrderBy(sortColumn + " " + sortColumnDir);
//}
recordsTotal = v.Count();
camplog = v.Skip(skip).Take(pageSize).ToList();
return(Json(new { recordsTotal = recordsTotal, data = camplog }));
}
