public JsonResult GetCategory(DTParameters param)
        {
            CategoryPageStore category = new CategoryPageStore();

            category.PageIndex = param.Start / param.Length + 1;
            category.PageSize  = param.Length;
            if (param.Search.Value == null)
            {
                category.Search = "%%";
            }
            else
            {
                category.Search = "%" + param.Search.Value + "%";
            }
            category.Order = param.SortOrder;
            CategoryPageStore categories = new CategoryModel().GetCategoryByPage(category.Search, category.Order, category.PageIndex, category.PageSize);

            DTResult <CategoryDTO> final = new DTResult <CategoryDTO>()
            {
                draw            = param.Draw,
                data            = categories.Categories.ToList(),
                recordsFiltered = categories.RecordCount,
                recordsTotal    = categories.Categories.Count
            };

            return(Json(final));
        }
Example #2
0
        public CategoryPageStore GetCategoryByPage(string search, string order, int pageIndex, int pageSize)
        {
            CategoryPageStore category = new CategoryPageStore();

            category.PageIndex = pageIndex;
            category.PageSize  = pageSize;
            category.Search    = search;
            category.Order     = order;

            SqlParameter paramPageSearch  = new SqlParameter("@PageSearch", search);
            SqlParameter paramOrderColumn = new SqlParameter("@SortOrder", order);
            SqlParameter paramPageIndex   = new SqlParameter("@PageIndex", pageIndex);
            SqlParameter paramPageSize    = new SqlParameter("@PageSize", pageSize);
            SqlParameter paramRecordCount = new SqlParameter("@RecordCount", category.RecordCount);

            paramRecordCount.Direction = ParameterDirection.Output;
            var listResult = db.Database.SqlQuery <CategoryDTO>("EXEC [dbo].[usp_MaintainCategoryPage] @PageSearch, @SortOrder, @PageIndex, @PageSize, @RecordCount = @RecordCount OUTPUT", paramPageSearch, paramOrderColumn, paramPageIndex, paramPageSize, paramRecordCount).ToList();

            category.RecordCount = (int)paramRecordCount.Value;
            category.Categories  = listResult.Select(e => new CategoryDTO()
            {
                CategoryID    = e.CategoryID,
                CategoryName  = e.CategoryName,
                Description   = e.Description,
                Picture       = e.Picture,
                CategoryImage = e.CategoryImage
            }).ToList();

            return(category);
        }