public List <TkmTransaction> FetchAllWithPagination(ref BaseSearchQueryModel searchQuery) { var result = _transactionRepository.Query().Where(b => b.IsActive); searchQuery.TotalData = BaseSearchQueryExpression <TkmTransaction> .DefaultQueryExpression(ref result, searchQuery); return(result.OrderByDescending(e => e.TransactionDate).ThenByDescending(e => e.LastUpdatedDate).ToList()); }
public List <MasterInstitution> FetchAllWithPagination(ref BaseSearchQueryModel searchQuery) { var result = _institutionRepository.Query().Where(i => i.IsActive); searchQuery.TotalData = BaseSearchQueryExpression <MasterInstitution> .DefaultQueryExpression(ref result, searchQuery); return(result.ToList()); }
public List <MasterUom> FetchAllWithPagination(ref BaseSearchQueryModel searchQuery) { var result = _uomRepository.Query().Where(u => u.IsActive); searchQuery.TotalData = BaseSearchQueryExpression <MasterUom> .DefaultQueryExpression(ref result, searchQuery); return(result.ToList()); }
public List <MasterRole> FetchAllWithPagination(ref BaseSearchQueryModel searchQuery) { var institutionId = _securityService.GetCurrentInstitutionId(); var result = _roleRepository.Query().Where(r => r.IsActive && r.InstitutionId == institutionId); searchQuery.TotalData = BaseSearchQueryExpression <MasterRole> .DefaultQueryExpression(ref result, searchQuery); return(result.ToList()); }
public List <MasterBin> FetchAllWithPagination(ref BaseSearchQueryModel searchQuery) { var institutionId = _securityService.GetCurrentInstitutionId(); var result = _binRepository.Query().Where(b => b.IsActive && b.IsActive && b.InstitutionId == institutionId).Include(b => b.ReaderModule); searchQuery.TotalData = BaseSearchQueryExpression <MasterBin> .DefaultQueryExpression(ref result, searchQuery); return(result.ToList()); }
public List <MasterItem> FetchAllWithPagination(ref BaseSearchQueryModel searchQuery) { var institutionId = _securityService.GetCurrentInstitutionId(); var result = _itemRepository.Query() .Include(i => i.Uom) .Include(i => i.Brand) .Where(i => i.IsActive && i.InstitutionId == institutionId); searchQuery.TotalData = BaseSearchQueryExpression <MasterItem> .DefaultQueryExpression(ref result, searchQuery); return(result.ToList()); }
public List <MasterUserInstitutionRole> FetchAllWithPagination(ref BaseSearchQueryModel searchQuery, long userId) { var institutionId = _securityService.GetCurrentInstitutionId(); var user = _userService.FetchOne(userId); if (user == null) { return(null); } var userInstitution = user.Institutions.FirstOrDefault(u => u.InstitutionId == institutionId); var result = _userInstitutionRoleRepository.Query() .Where( u => u.IsActive && u.UserInstitutionId == userInstitution.UserInstitutionId && u.InstitutionId == institutionId); searchQuery.TotalData = BaseSearchQueryExpression <MasterUserInstitutionRole> .DefaultQueryExpression(ref result, searchQuery); return(result.ToList()); }