public IHttpActionResult GetByFilter(FilterMarketingCategories filter) { var repository = new RepositoryMarketingCategories(); if (filter == null) { filter = new FilterMarketingCategories { PageSize = 25, CurrentPage = 1 } } ; var response = repository.GetMarketingCategories(filter, CurrentBusinessId.Value); return(Ok <DataResponse <EntityList <EntityMarketingCategories> > >(response)); }
public DataResponse <EntityList <EntityMarketingCategories> > GetMarketingCategories(FilterMarketingCategories filter, int currentBusineId, int take = 10, int skip = 0) { var response = new DataResponse <EntityList <EntityMarketingCategories> >(); try { if (filter != null) { take = filter.Take; skip = filter.Skip; } base.DBInit(); var query = DBEntity.LookupMarketingCategories.Where(a => a.BusinessId == currentBusineId); if (filter != null) { if (!String.IsNullOrEmpty(filter.KeyWords)) { query = query.Where(a => a.Category.ToLower().Contains(filter.KeyWords)); } } var selectQuery = query.Select(a => new EntityMarketingCategories { Id = a.Id, Category = a.Category, CreatedBy = a.CreatedBy, CreatedOn = a.CreatedOn, UpdatedBy = a.UpdatedBy, UpdatedOn = a.UpdatedOn, BusinessId = a.BusinessId, CreatedByName = a.User.FirstName + " " + a.User.LastName, UpdatedByName = a.User1.FirstName + " " + a.User1.LastName, }).OrderByDescending(a => a.CreatedOn); response = GetList <EntityMarketingCategories>(selectQuery, skip, take); } catch (Exception ex) { ex.Log(); } finally { base.DBClose(); } return(response); }