public IHttpActionResult GetParent(long? parentId)
 {
     CategorySE se = new CategorySE();
     se.ParentId = parentId;
     var categories = categoryService.Search(se);
     var t = categories.ToList();
     IEnumerable<ComboItem> items = categories.Select(x => new ComboItem
     {
         Value = SqlFunctions.StringConvert((double)x.Id).Trim(),
         Text = x.Title
     }).ToList();
     return Ok(items);
 }
        public IHttpActionResult GetParent(long?parentId)
        {
            CategorySE se = new CategorySE();

            se.ParentId = parentId;
            var categories = categoryService.Search(se);
            var t          = categories.ToList();
            IEnumerable <ComboItem> items = categories.Select(x => new ComboItem
            {
                Value = SqlFunctions.StringConvert((double)x.Id).Trim(),
                Text  = x.Title
            }).ToList();

            return(Ok(items));
        }
        public IQueryable <Category> Search(CategorySE se, bool isNoTracking = true, bool withoutDeleted = true)
        {
            var q = base.Search(se, isNoTracking, withoutDeleted);

            if (!String.IsNullOrEmpty(se.Title))
            {
                q = q.Where(x => x.Title.Contains(se.Title));
            }
            if (se.ParentId != 0)
            {
                q = q.Where(x => x.ParentId == se.ParentId);
            }


            return(q);
        }
        public IHttpActionResult Search(CategorySE se)
        {
            var page = new Page {
                PageSize = se.PageSize, PageNumber = se.PageNumber
            };
            var categories = categoryService.Search(se);
            int totalCount = categories.Count();

            categories = categories.OrderByPropertyName(se.SortField, se.SortOrder);
            categories = categories.GetPage <Category>(page);


            IEnumerable <CategoryViewModel> categoryViewModels = new List <CategoryViewModel>();

            Mapper.Map(categories, categoryViewModels);
            PagedCollectionViewModel <CategoryViewModel> viewModel = new PagedCollectionViewModel <CategoryViewModel> {
                Data = categoryViewModels, TotalCount = totalCount
            };

            return(Ok(viewModel));
        }
        public IHttpActionResult Search(CategorySE se)
        {
            var page = new Page { PageSize = se.PageSize, PageNumber = se.PageNumber};
            var categories = categoryService.Search(se);
            int totalCount = categories.Count();
            categories = categories.OrderByPropertyName(se.SortField, se.SortOrder);
            categories = categories.GetPage<Category>(page);

            IEnumerable<CategoryViewModel> categoryViewModels = new List<CategoryViewModel>();
            Mapper.Map(categories, categoryViewModels);
            PagedCollectionViewModel<CategoryViewModel> viewModel = new PagedCollectionViewModel<CategoryViewModel> { Data = categoryViewModels, TotalCount = totalCount };

            return Ok(viewModel);
        }