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); }