public ActionResult GridTable(DTParameter model)
{
try
{
var datadetails = _securityfeedsServices.getPaginated(model);
return(Json(new { data = datadetails, model.recordsTotal, model.recordsFiltered }));
//return new JsonDateResult { Data = data, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
catch (Exception ex)
{
throw ex;
}
}
public List <Models.ModelsDTO.SecurityFeedsDTO> getPaginated(DTParameter model)
{
return(_RespositorySecurityFeeds.getPaginated(model));
}
public List <SecurityFeedsDTO> getPaginated(DTParameter model)
{
CultureInfo culture = new CultureInfo("en-GB");
using (var dbContext = new APIdbContext())
{
var data = dbContext.SecurityFeeds.Select(x => new
{
x.SecurityFeedID,
x.ImagePath,
x.ContentTitle,
x.CreatedOn,
x.ContentDescription
}).AsQueryable();
model.recordsTotal = data.Count();
if (!string.IsNullOrEmpty(model.Search.Value))
{
data = data.Where(x => x.SecurityFeedID.ToString().Contains(model.Search.Value) ||
x.ImagePath.Contains(model.Search.Value) ||
x.ContentTitle.Contains(model.Search.Value)
//|| x.CreatedOn.Contains(model.Search.Value)
|| x.ContentDescription.Contains(model.Search.Value)
);
}
if (model.Order.Any())
{
var sortingColumn = model.Order.FirstOrDefault();
var sortingRow = model.Columns.ToArray()[sortingColumn.Column];
switch (sortingRow.Data)
{
case "ImagePath":
if (sortingColumn.Dir.Contains("asc"))
{
data = data.OrderBy(x => x.ImagePath);
}
else
{
data = data.OrderByDescending(x => x.ImagePath);
}
break;
case "ContentTitle":
if (sortingColumn.Dir.Contains("asc"))
{
data = data.OrderBy(x => x.ContentTitle);
}
else
{
data = data.OrderByDescending(x => x.ContentTitle);
}
break;
case "ContentDescription":
if (sortingColumn.Dir.Contains("asc"))
{
data = data.OrderBy(x => x.ContentDescription);
}
else
{
data = data.OrderByDescending(x => x.ContentDescription);
}
break;
default:
data = data.OrderByDescending(x => x.CreatedOn);
break;
}
}
model.recordsFiltered = data.Count();
var result = data
.Skip(model.Start)
.Take(model.Length).ToList();
return(result.Select(x => new SecurityFeedsDTO()
{
SecurityFeedID = x.SecurityFeedID,
ContentTitle = x.ContentTitle,
ContentDescription = x.ContentDescription,
ImagePath = x.ImagePath,
CreatedOn = x.CreatedOn,
DisplayCreatedOn = x.CreatedOn.ToString("dd/MM/yyyy")
}).ToList());
}
}
public List <SecurityFeeds> GetAllSecurityFeeds(DTParameter model)
{
return(_RespositorySecurityFeeds.GetAllSecurityFeeds(model));
}
List <SecurityFeeds> IRepositorySecurityFeeds.GetAllSecurityFeeds(DTParameter model)
{
throw new NotImplementedException();
}
