private DatatableDTO <ProductDTO> CreateDatatableDTO(List <ProductDTO> products, DataTable datatable)
{
DatatableDTO <ProductDTO> datatableDTO = new DatatableDTO <ProductDTO>()
{
draw = datatable.Draw,
recordsTotal = datatable.RecordsTotal,
recordsFiltered = datatable.RecordFiltered,
data = products
};
return(datatableDTO);
}
public ActionResult GetProducts()
{
List <Product> Products = dgrosStore.Products
.Where(p => p.State == STATE).OrderBy(p => p.ProductId).ToList();
DataTable Datatable = CreateDatatableObjectWithRequestValues(Request);
Datatable.RecordsTotal = Products.Count();
if (!String.IsNullOrEmpty(Datatable.Search))
{
Products = GetProductByParam(Datatable.Search);
}
Datatable.RecordFiltered = Products.Count();
List <ProductDTO> productDTOlist = GetOrderedAndPagedProductDTOList(Products, Datatable);
DatatableDTO <ProductDTO> datatableDTO = CreateDatatableDTO(productDTOlist, Datatable);
return(Json(datatableDTO, JsonRequestBehavior.AllowGet));
}
public ActionResult GetProductByCategory(string category)
{
List <Product> categoryProducts = dgrosStore.Products
.Include(p => p.Category)
.Where(p => p.Category.Name == category)
.Where(p => p.State == STATE)
.ToList();
DataTable Datatable = CreateDatatableObjectWithRequestValues(Request);
Datatable.RecordsTotal = categoryProducts.Count();
if (!String.IsNullOrEmpty(Datatable.Search))
{
categoryProducts = GetProductAndCategoryByParam(category, Datatable.Search);
}
Datatable.RecordFiltered = categoryProducts.Count();
//order,paging
List <ProductDTO> productDTOlist = GetOrderedAndPagedProductDTOList(categoryProducts, Datatable);
DatatableDTO <ProductDTO> datatableDTO = CreateDatatableDTO(productDTOlist, Datatable);
return(Json(datatableDTO, JsonRequestBehavior.AllowGet));
}