/// <summary>
///
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public DatatablesView <ProductModel> GetProductsByPaging(DataTablesPaging request)
{
int total = 0;
var pagingItems = ProductRepository.GetItemsByPaging(request, out total);
var items = new List <ProductModel>();
foreach (var pagingItem in pagingItems)
{
var item = pagingItem.ToModel();
items.Add(item);
}
return(new DatatablesView <ProductModel>(request.Draw, total, pagingItems.Count, items));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <ProductPO> GetItemsByPaging(DataTablesPaging paging, out int total)
{
var filterParameters = new Dictionary <string, string>();
foreach (var filterItem in paging.CustomFilterParameters)
{
if (!string.IsNullOrWhiteSpace(filterItem.Value))
{
filterParameters.Add(filterItem.Name, filterItem.Value);
}
}
using (var context = new SchoolContext())
{
var items = context.Products.Filter(filterParameters);
total = items.Count();
var datas = items.OrderBy(p => p.Id).Skip(paging.Start * paging.Length).Take(paging.Length).ToList();
return(datas);
}
}
public JsonResult ProductImagesByPaging(DataTablesPaging request)
{
var view = new ProductImageService().GetProductImagesByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
public JsonResult SchoolsByPaging(DataTablesPaging request)
{
var view = new SchoolService().GetSchoolsByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
public JsonResult CountrysByPaging(DataTablesPaging request)
{
var view = new CountryService().GetCountrysByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
public JsonResult MerchantCustomCategorysByPaging(DataTablesPaging request)
{
var view = new MerchantCustomCategoryService().GetMerchantCustomCategorysByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public DatatablesView <MerchantCustomCategoryModel> GetMerchantCustomCategorysByPaging(DataTablesPaging request)
{
int total = 0;
var pagingItems = MerchantCustomCategoryRepository.GetItemsByPaging(request, out total);
var items = new List <MerchantCustomCategoryModel>();
foreach (var pagingItem in pagingItems)
{
var item = pagingItem.ToModel();
items.Add(item);
}
return(new DatatablesView <MerchantCustomCategoryModel>(request.Draw, total, pagingItems.Count, items));
}
public JsonResult PromotionLaddersByPaging(DataTablesPaging request)
{
var view = new PromotionLadderService().GetPromotionLaddersByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
public JsonResult DistrictsByPaging(DataTablesPaging request)
{
var view = new DistrictService().GetDistrictsByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
public JsonResult UserTasksByPaging(DataTablesPaging request)
{
var view = new UserTaskService().GetUserTasksByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
public JsonResult OrderDetailsByPaging(DataTablesPaging request)
{
var view = new OrderDetailService().GetOrderDetailsByPaging(request);
return(Json(view, JsonRequestBehavior.AllowGet));
}
