public SuggestionPaggingListVM GetList(bool showIsDeleted = false, string searchText = "", string sortOrder = "", int pageNumber = 1, int pageItemCount = 10, Guid?categoryId = null) { if (!searchText.IsNullOrEmpty()) { searchText = searchText.Trim().ToUpper(); } SuggestionPaggingListVM result = new SuggestionPaggingListVM(); result.Records = GetAllAsync(a => a.Title.ToUpper().Contains(searchText) || a.Description.ToUpper().Contains(searchText), true, sortOrder, pageNumber, pageItemCount, categoryId).Result; #region Next Page Check var query = Repository.Query(showIsDeleted).AsNoTracking().AsQueryable(); if (!searchText.IsNullOrEmpty()) { query = query.Where(a => a.Title.ToUpper().Contains(searchText) || a.Description.ToUpper().Contains(searchText)).AsQueryable(); } result.Pagging = new PaggingVM(); result.Pagging.IsNextPageExist = query.Skip((pageNumber * pageItemCount)).Take(1).Count() == 1; #endregion var users = _con.Set <User>().AsNoTracking().Select(s => new { s.Id, s.UserName }).ToList(); foreach (var item in result.Records) { item.CreateByName = users.Any(a => a.Id == item.CreateById) ? users.Where(a => a.Id == item.CreateById).Select(s => s.UserName).FirstOrDefault() : ""; } return(result); }
public virtual async Task <T> GetByIDAysnc(Guid id) { try { return(await con.Set <T>().FirstOrDefaultAsync(p => p.Id == id && !p.IsDeleted)); } catch (Exception ex) { _logger.LogError("Repository.GetByID", ex); return(null); } }
public CategoryPaggingListVM GetList(bool showIsDeleted = false, int pageNumber = 1, int pageItemCount = 10) { CategoryPaggingListVM result = new CategoryPaggingListVM(); result.Records = GetAllAsync(null, true, pageNumber, pageItemCount).Result; #region Next Page Check var query = Repository.Query(showIsDeleted).AsNoTracking().AsQueryable(); result.Pagging = new PaggingVM(); result.Pagging.IsNextPageExist = query.Skip((pageNumber * pageItemCount)).Take(1).Count() == 1; #endregion var users = _con.Set <User>().AsNoTracking().Select(s => new { s.Id, s.UserName }).ToList(); foreach (var item in result.Records) { item.CreateByName = users.Any(a => a.Id == item.CreateById) ? users.Where(a => a.Id == item.CreateById).Select(s => s.UserName).FirstOrDefault() : ""; } return(result); }
public UserPaggingListVM GetList(string searchText = "", int pageNumber = 1, int pageItemCount = 10) { if (!searchText.IsNullOrEmpty()) { searchText = searchText.Trim().ToUpper(); } UserPaggingListVM result = new UserPaggingListVM(); var query = _con.Set <User>().Where(a => searchText.IsNullOrEmpty() || a.UserName.Contains(searchText)).AsNoTracking().OrderBy(a => a.UserName).AsQueryable(); if (pageNumber > 1) { query = query.Skip((pageNumber - 1) * pageItemCount); } result.Records = (from u in query select new UserVM() { Id = u.Id, PictureUrl = u.PictureUrl, Name = u.UserName, SuggetionCount = (from s in _con.Set <Suggestion>().AsNoTracking() where s.CreateBy == u.Id select s).Count(), CommentCount = (from s in _con.Set <SuggestionComment>().AsNoTracking() where s.CreateBy == u.Id select s).Count(), ReactionCount = (from s in _con.Set <SuggestionReaction>().AsNoTracking() where s.CreateBy == u.Id select s).Count() }).Take(pageItemCount).ToList(); #region Next Page Check query = _con.Set <User>().AsNoTracking().AsQueryable(); if (!searchText.IsNullOrEmpty()) { query = query.Where(a => a.UserName.ToUpper().Contains(searchText)).AsQueryable(); } result.Pagging = new PaggingVM(); result.Pagging.IsNextPageExist = query.Skip((pageNumber * pageItemCount)).Take(1).Count() == 1; #endregion return(result); }