/// <summary> /// Getting the SalesRep units for grid with sorting and filtering /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <SalesRepUnitDto> > GetSalesRepUnits(SearchInputDto input) { var query = from sr in _salesRepUnitRepository.GetAll() select new { SalesRep = sr }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } var resultCount = await query.CountAsync(); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("SalesRep.LastName ASC", input.Sorting)) .PageBy(input) .ToListAsync(); return(new PagedResultOutput <SalesRepUnitDto>(resultCount, results.Select(item => { var dto = item.SalesRep.MapTo <SalesRepUnitDto>(); dto.SalesRepId = item.SalesRep.Id; return dto; }).ToList())); }
private IQueryable <CustomerAndAddressDto> CreateCustomerQuery(SearchInputDto input) { var query = from customer in _customerUnitRepository.GetAll() join addr in _addressRepository.GetAll() on customer.Id equals addr.ObjectId into temp from rt in temp.Where(p => p.IsPrimary == true && p.TypeofObjectId == TypeofObject.CustomerUnit).DefaultIfEmpty() join payterms in _customerPaymentTermRepository.GetAll() on customer.Id equals payterms.Id into paymentperms from pt in paymentperms.DefaultIfEmpty() join salesrep in _salesRepRepository.GetAll() on customer.SalesRepId equals salesrep.Id into salesreps from sr in salesreps.DefaultIfEmpty() select new CustomerAndAddressDto { Customer = customer, Address = rt, PaymentTerms = pt.Description, SalesRepName = sr.LastName }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } return(query); }
/// <summary> /// 根据条件查询数据库,并返回对象集合(用于分页数据显示) /// </summary> /// <param name="search">查询的条件</param> /// <returns>指定对象的集合</returns> public override async Task <PageResult <AppOutputDto> > FindWithPagerAsync(SearchInputDto <APP> search) { bool order = search.Order == "asc" ? false : true; string where = GetDataPrivilege(false); if (!string.IsNullOrEmpty(search.Keywords)) { where += string.Format(" and (AppId like '%{0}%' or RequestUrl like '%{0}%')", search.Keywords); } ; PagerInfo pagerInfo = new PagerInfo { CurrenetPageIndex = search.CurrenetPageIndex, PageSize = search.PageSize }; List <APP> list = await repository.FindWithPagerAsync(where, pagerInfo, search.Sort, order); PageResult <AppOutputDto> pageResult = new PageResult <AppOutputDto> { CurrentPage = pagerInfo.CurrenetPageIndex, Items = list.MapTo <AppOutputDto>(), ItemsPerPage = pagerInfo.PageSize, TotalItems = pagerInfo.RecordCount }; return(pageResult); }
private IQueryable <VendorAndAddressDto> CreateVendorQuery(SearchInputDto input) { var query = from vendor in _vendorUnitRepository.GetAll() join addr in _addresRepository.GetAll() on vendor.Id equals addr.ObjectId into temp from rt in temp.Where(p => p.IsPrimary == true && p.TypeofObjectId == TypeofObject.VendorUnit).DefaultIfEmpty() join payterms in _vendorPaytermRepository.GetAll() on vendor.PaymentTermsId equals payterms.Id into paymentperms from pt in paymentperms.DefaultIfEmpty() select new VendorAndAddressDto { Vendor = vendor, Address = rt, PaymentTerms = pt.Description, // VendorAlias = vendor.VendorAlias }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } query = query.Where(item => item.Vendor.OrganizationUnitId == input.OrganizationUnitId || item.Vendor.OrganizationUnitId == null); return(query); }
/// <summary> /// Sumit Method to get UserUnits /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <UserListDto> > GetUserUnits(SearchInputDto input) { var query = UserManager.Users .Include(u => u.Roles); if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } var userCount = await query.CountAsync(); var users = await query .OrderBy(Helper.GetSort("Name,Surname ASC", input.Sorting)) .PageBy(input) .ToListAsync(); var userListDtos = users.MapTo <List <UserListDto> >(); await FillRoleNames(userListDtos); return(new PagedResultOutput <UserListDto>( userCount, userListDtos )); }
private IQueryable<BankAccountAndAddressDto> CreateCcCompanyQuery(SearchInputDto input) { var values = Enum.GetValues(typeof(TypeOfBankAccount)).Cast<TypeOfBankAccount>().Select(x => x) .ToDictionary(u => u.ToDescription(), u => (int)u).Where(u => u.Value >= 5 && u.Value <= 9) .Select(u => u.Key).ToArray(); var strTypeOfbankAC = string.Join(",", values); var ccCompanyQuery = from bankAccount in _bankAccountUnitRepository.GetAll() join batch in _batchUnitRepository.GetAll() on bankAccount.BatchId equals batch.Id into batch from batchacc in batch.DefaultIfEmpty() select new BankAccountAndAddressDto { BankAccount = bankAccount, BatchDesc = batchacc.Description, }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) ccCompanyQuery = Helper.CreateFilters(ccCompanyQuery, mapSearchFilters); } return ccCompanyQuery.Where(u => strTypeOfbankAC.Contains(u.BankAccount.TypeOfBankAccountId.ToString())); }
public async Task <PagedResultOutput <TenantListDto> > GetTenantUnits(SearchInputDto input) { var query = from tenant in TenantManager.Tenants join org in _organizationRepository.GetAll() on tenant.OrganizationUnitId equals org.Id join connection in _connectionStringRepository.GetAll() on org.ConnectionStringId equals connection.Id select new { tenant, OrganizationName = org.DisplayName, ConnectionName = connection.ConnectionString }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } var tenantCount = await query.CountAsync(); var tenants = await query.OrderBy(Helper.GetSort("tenant.Name ASC", input.Sorting)).PageBy(input).ToListAsync(); return(new PagedResultOutput <TenantListDto>(tenantCount, tenants.Select(item => { var dto = item.tenant.MapTo <TenantListDto>(); dto.OrganizationName = item.OrganizationName; var connectionString = new SqlConnectionStringBuilder(SimpleStringCipher.Instance.Decrypt(item.ConnectionName)); dto.ServerName = connectionString.DataSource; dto.DatabaseName = connectionString.InitialCatalog; return dto; }).ToList())); }
/// <summary> /// Get the Records for Grid with paging and sorting /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <CoaUnitDto> > GetProjectCoaList(SearchInputDto input) { var query = from coa in _coaUnitRepository.GetAll() join linkcoa in _coaUnitRepository.GetAll() on coa.LinkChartOfAccountID equals linkcoa.Id into tempCoa from coaunit in tempCoa.DefaultIfEmpty() where coa.IsCorporate == false select new { Coa = coa, LinkChartOfAccountName = coaunit.Caption }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } query = query.Where(p => p.Coa.IsCorporate == false); var resultCount = await query.CountAsync(); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("Coa.Caption ASC", input.Sorting)) .PageBy(input) .ToListAsync(); return(new PagedResultOutput <CoaUnitDto>(resultCount, results.Select(item => { var dto = item.Coa.MapTo <CoaUnitDto>(); dto.CoaId = item.Coa.Id; return dto; }).ToList())); }
public virtual CommonResult <PageResult <TODto> > FindWithPager(SearchInputDto <T> search) { CommonResult <PageResult <TODto> > result = new CommonResult <PageResult <TODto> >(); result.ResData = iService.FindWithPager(search); result.ErrCode = ErrCode.successCode; return(result); }
private IQueryable <UserViewSettingsUnitDto> CreateUserViewSettingsQuery(SearchInputDto input) { int viewId = 0; IQueryable <UserViewSettingsUnitDto> query = (from settings in _userViewSettingsUnitRepository.GetAll() join gridList in _gridListUnitRepository.GetAll() on settings.ViewId equals gridList.Id into gridsetting from grdsettings in gridsetting.DefaultIfEmpty() select new UserViewSettingsUnitDto { UserViewId = settings.Id, ViewId = settings.ViewId, UserId = settings.UserId, IsDefault = settings.IsDefault, ViewName = settings.ViewName, ViewSettings = settings.ViewSettings, Grid_Name = grdsettings.Name, Grid_Description = grdsettings.Description, IsSystemDefault = false }); if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } foreach (Filters filter in input.Filters) { if (filter.Property == "viewId") { viewId = Convert.ToInt32(filter.SearchTerm); break; } } query = query.Union(from settings in _systemViewSettingsUnitRepository.GetAll() .Where(p => p.ViewId == viewId) join gridList in _gridListUnitRepository.GetAll() on settings.ViewId equals gridList.Id into gridsetting from grdsettings in gridsetting.DefaultIfEmpty() select new UserViewSettingsUnitDto { UserViewId = settings.Id, ViewId = settings.ViewId, UserId = 0, IsDefault = settings.IsDefault, ViewName = settings.ViewName, ViewSettings = settings.ViewSettings, Grid_Name = grdsettings.Name, Grid_Description = grdsettings.Description, IsSystemDefault = true }); return(query); }
/// <summary> /// Get the list of all TaxCredit. /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <ListResultOutput <TaxCreditUnitDto> > GetTaxCreditUnits(SearchInputDto input) { var query = _taxCreditUnitRepository.GetAll(); var items = await query.OrderBy(p => p.Description).ToListAsync(); return(new ListResultOutput <TaxCreditUnitDto>( items.Select(item => { var dto = item.MapTo <TaxCreditUnitDto>(); dto.TaxCreditId = item.Id; return dto; }).ToList())); }
public async Task <ServiceResponse> GetAllVehicles(SearchInputDto searchInput) { Expression <Func <Vehicle, bool> > expression = x => x.IsActive; if (searchInput.Filters != null && searchInput.Filters.Any()) { var dynamicQuery = Helper.QueryMapper(searchInput.Filters, "VehicleSearch.json"); if (!string.IsNullOrEmpty(dynamicQuery)) { Expression <Func <Vehicle, bool> > query = DynamicExpressionParser.ParseLambda <Vehicle, bool>(new ParsingConfig(), false, dynamicQuery); expression = DynamicExpressionParser.ParseLambda <Vehicle, bool>(new ParsingConfig(), false, "@0(it) and @1(it)", expression, query); } } IQueryable <Vehicle> vehicles = _dbContext.Vehicles.Where(expression); var vehiclesForTotalCount = vehicles; int totalCount = await vehiclesForTotalCount.CountAsync(); var searchedVehicles = await vehicles .Skip(searchInput.PageSize *(searchInput.PageNumber - 1)).Take(searchInput.PageSize).ToListAsync(); var mappedVehicles = _mapper.Map <List <VehicleDto> >(searchedVehicles); var pageDetails = new PagedData <Vehicle>().GetPaginationDetails <Vehicle>(searchInput.PageNumber, searchInput.PageSize, totalCount); var tempPageData = new PagedData <VehicleDto>() { Data = mappedVehicles, HasNextPage = pageDetails.HasNextPage, HasPreviousPage = pageDetails.HasPreviousPage, IsFirstPage = pageDetails.IsFirstPage, IsLastPage = pageDetails.IsLastPage, ItemEnd = pageDetails.ItemEnd, ItemStart = pageDetails.ItemStart, PageCount = pageDetails.PageCount, PageIndex = pageDetails.PageIndex, PageSize = pageDetails.PageSize, TotalItemCount = pageDetails.TotalItemCount }; var response = new ServiceResponse { Data = tempPageData, Success = true }; response.Message = response.Success ? "Vehicles list successfully loaded..." : "No vehicle data found.."; return(response); }
private IQueryable <BankAccountAndAddressDto> CreateBankAccountQuery(SearchInputDto input) { var bankAccountUnitQuery = from bankAccount in _bankAccountUnitRepository.GetAll() join address in _addressUnitRepository.GetAll() on bankAccount.Id equals address.ObjectId into bank from addr in bank.Where(p => p.IsPrimary == true && p.TypeofObjectId == TypeofObject.BankAccountUnit).DefaultIfEmpty() join account in _accountUnitRepository.GetAll() on bankAccount.AccountId equals account.Id into acc from pt in acc.DefaultIfEmpty() join job in _jobUnitRepository.GetAll() on bankAccount.JobId equals job.Id into job from jobacc in job.DefaultIfEmpty() join clearingaccount in _accountUnitRepository.GetAll() on bankAccount.ClearingAccountId equals clearingaccount.Id into clearingaccount from clearAcc in clearingaccount.DefaultIfEmpty() join clearingjob in _jobUnitRepository.GetAll() on bankAccount.ClearingJobId equals clearingjob.Id into clearingjob from clearjobacc in clearingjob.DefaultIfEmpty() join vendor in _vendorUnitRepository.GetAll() on bankAccount.VendorId equals vendor.Id into vendor from vendoracc in vendor.DefaultIfEmpty() join typeOfUploadFile in _typeOfUploadFileUnitRepository.GetAll() on bankAccount.TypeOfUploadFileId equals typeOfUploadFile.Id into typeOfUploadFile from typfacc in typeOfUploadFile.DefaultIfEmpty() join typeOfCheckStock in _typeOfCheckStockUnitRepository.GetAll() on bankAccount.TypeOfCheckStockId equals typeOfCheckStock.Id into typeOfCheckStock from typcacc in typeOfCheckStock.DefaultIfEmpty() join batch in _batchUnitRepository.GetAll() on bankAccount.BatchId equals batch.Id into batch from batchacc in batch.DefaultIfEmpty() select new BankAccountAndAddressDto { BankAccount = bankAccount, Address = addr, LedgerAccount = pt.AccountNumber, Job = jobacc.JobNumber, ClearingAccount = clearAcc.AccountNumber, ClearingJob = clearjobacc.JobNumber, Vendor = vendoracc.VendorNumber, TypeOfUploadFile = typfacc.Description, TypeofCheckStock = typcacc.Description, BatchDesc = batchacc.Description, }; var values = Enum.GetValues(typeof(TypeOfBankAccount)).Cast <TypeOfBankAccount>().Select(x => x) .ToDictionary(u => u.ToDescription(), u => (int)u).Where(u => u.Value <= 4) .Select(u => u.Key).ToArray(); var strTypeOfbankAC = string.Join(",", values); if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { bankAccountUnitQuery = Helper.CreateFilters(bankAccountUnitQuery, mapSearchFilters); } } return(bankAccountUnitQuery.Where(u => strTypeOfbankAC.Contains(u.BankAccount.TypeOfBankAccountId.ToString()))); }
public void Add_Valid_Search_Flight__ObjectPassed_ReturnsCreatedResponse() { SearchInputDto searchInput = new SearchInputDto() { DepatureDateTime = Convert.ToDateTime("2018-11-26"), FromDestination = "Johannesburg", ToDestination = "Durban", NoOfPassenger = 50 }; var createdResponse = _service.GetAvailableFlight(searchInput); Assert.IsType <CreatedAtActionResult>(createdResponse); }
public async Task <PagedResultOutput <JobUnitDto> > GetDivisionUnits(SearchInputDto input) { var query = from job in _jobUnitRepository.GetAll() join currency in _typeOfCurrencyUnitRepository.GetAll() on job.TypeOfCurrencyId equals currency.Id into currency from currencyData in currency.DefaultIfEmpty() select new { Job = job, currency = currencyData.Description }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); query = Helper.CreateFilters(query, mapSearchFilters); } query = query.Where(item => item.Job.IsDivision == true); var resultCount = await query.CountAsync(); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("Job.JobNumber ASC", input.Sorting)) .PageBy(input) .ToListAsync(); return(new PagedResultOutput <JobUnitDto>(resultCount, results.Select(item => { var dto = new JobUnitDto { JobId = item.Job.Id, JobNumber = item.Job.JobNumber, Caption = item.Job.Caption, RollupCenterId = item.Job.RollupCenterId, IsCorporateDefault = item.Job.IsCorporateDefault, ChartOfAccountId = item.Job.ChartOfAccountId, RollupAccountId = item.Job.RollupAccountId, TypeOfCurrencyId = item.Job.TypeOfCurrencyId, RollupJobId = item.Job.RollupJobId, TypeOfJobStatusId = item.Job.TypeOfJobStatusId, TypeOfBidSoftwareId = item.Job.TypeOfBidSoftwareId, IsActive = item.Job.IsActive, IsApproved = item.Job.IsApproved, IsICTDivision = item.Job.IsICTDivision, TypeofProjectId = item.Job.TypeofProjectId, TaxRecoveryId = item.Job.TaxRecoveryId }; dto.JobId = item.Job.Id; dto.TypeOfCurrency = item.currency; return dto; }).ToList())); }
public async Task <PagedResultOutput <VendorUnitDto> > GetVendorUnits(SearchInputDto input) { var query = CreateVendorQuery(input); var resultCount = await query.CountAsync(); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("Vendor.LastName ASC", input.Sorting)) .PageBy(input) .ToListAsync(); var vendorListDtos = ConvertToVendorDtos(results); return(new PagedResultOutput <VendorUnitDto>(resultCount, vendorListDtos)); }
/// <summary> /// This method is for retrieve the records for showing in the grid with filters and SortOrder /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <EmployeeUnitDto> > GetEmployeeUnits(SearchInputDto input) { var query = CreateEmployeeQuery(input); var resultCount = await query.CountAsync(); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("Employee.LastName ASC", input.Sorting)) .PageBy(input) .ToListAsync(); var employeeListDtos = ConvertToEmployeeDtos(results); return(new PagedResultOutput <EmployeeUnitDto>(resultCount, employeeListDtos)); }
public void Search_Flight_InvalidObjectPassed_ReturnsBadRequest() { SearchInputDto searchInput = new SearchInputDto() { DepatureDateTime = Convert.ToDateTime(""), FromDestination = "Johannesburg", ToDestination = "Durban", NoOfPassenger = 50 }; _controller.ModelState.AddModelError("DepatureDateTime", "Required"); var badResponse = _controller.GetAvailableflight(searchInput); Assert.IsType <BadRequestObjectResult>(badResponse); }
public async Task <IActionResult> FindPlayers(SearchInputDto input) { var players = this.playerRepository.GetAll() .Where(p => p.FirstName.Contains(input.SearchText, StringComparison.InvariantCultureIgnoreCase) || p.LastName.Contains(input.SearchText, StringComparison.InvariantCultureIgnoreCase)) .Select(p => new PlayerListDto { PlayerId = p.Id, FirstName = p.FirstName, LastNamePrefix = p.LastNamePrefix, LastName = p.LastName }).ToList(); return(this.Ok(new Result <List <PlayerListDto> >(players))); }
/// <summary> /// Sumit Method to get AuditLogs /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <AuditLogListDto> > GetAuditLogUnits(SearchInputDto input) { var query = CreateAuditLogAndUsersQueryUnit(input); var resultCount = await query.CountAsync(); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("AuditLog.ExecutionTime DESC", input.Sorting)) .PageBy(input) .ToListAsync(); var auditLogListDtos = ConvertToAuditLogListDtos(results); return(new PagedResultOutput <AuditLogListDto>(resultCount, auditLogListDtos)); }
public void Add_Valid_Search_Flight_ObjectPassed_ReturnedResponseHasCreatedItem() { SearchInputDto searchInput = new SearchInputDto() { DepatureDateTime = Convert.ToDateTime("2018-11-26"), FromDestination = "Johannesburg", ToDestination = "Durban", NoOfPassenger = 50 }; var createdResponse = _service.GetAvailableFlight(searchInput); var item = createdResponse.ItemResponses as List <ItemResponseDto>; // Assert Assert.IsType <List <ItemResponseDto> >(item); Assert.Single(item); }
/// <summary> /// Get the list of all Batch List /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <PagedResultOutput <BatchUnitDto> > GetBatchUnits(SearchInputDto input) { var batchUnitQuery = _batchUnitRepository.GetAll(); if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { batchUnitQuery = Helper.CreateFilters(batchUnitQuery, mapSearchFilters); } } var resultCount = await batchUnitQuery.CountAsync(); var results = await batchUnitQuery .AsNoTracking() .OrderBy(Helper.GetSort("Description ASC", input.Sorting)) .PageBy(input) .ToListAsync(); var mapEnumResults = (from value in results select new BatchUnitDto { BatchId = value.Id, ControlTotal = value.ControlTotal, DefaultCheckDate = value.DefaultCheckDate, DefaultTransactionDate = value.DefaultTransactionDate, Description = value.Description, IsActive = value.IsActive, IsBatchFinalized = value.IsBatchFinalized, IsDefault = value.IsDefault, IsRetained = value.IsRetained, IsUniversal = value.IsUniversal, PostingDate = value.PostingDate, RecurMonthIncrement = value.RecurMonthIncrement, TypeOfBatchId = value.TypeOfBatchId, TypeOfInactiveStatusId = value.TypeOfInactiveStatusId, TypeOfBatch = value.TypeOfBatchId.ToDisplayName(), TypeOfInactiveStatus = value.TypeOfInactiveStatusId != null ? value.TypeOfInactiveStatusId.ToDisplayName() : "", BatchAmount = GetBatchAmount(value.Id, value.TypeOfBatchId) }).ToList(); return(new PagedResultOutput <BatchUnitDto>(resultCount, mapEnumResults)); }
public async Task <PagedResultOutput <JournalEntryDocumentUnitDto> > GetJournalEntryDocumentUnits( SearchInputDto input) { bool unPosted = false; var query = from journals in _journalEntryDocumentUnitRepository.GetAll() join user in _userUnitRepository.GetAll() on journals.CreatorUserId equals user.Id into users from userunits in users.DefaultIfEmpty() join batch in _batchUnitRepository.GetAll() on journals.BatchId equals batch.Id into batchunit from batchunits in batchunit.DefaultIfEmpty() select new { Journals = journals, BatchName = batchunits.Description, CreatedUser = userunits.Name }; if (!ReferenceEquals(input.Filters, null)) { var mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = query.CreateFilters(mapSearchFilters); } } query = query .Where(u => u.Journals.TypeOfAccountingDocumentId == TypeOfAccountingDocument.GeneralLedger && u.Journals.IsPosted == unPosted); var resultCount = await query.CountAsync(); var results = await query .AsNoTracking() .OrderBy(Helper.GetSort("Journals.DocumentReference ASC", input.Sorting)) .PageBy(input) .ToListAsync(); return(new PagedResultOutput <JournalEntryDocumentUnitDto>(resultCount, results.Select(item => { var dto = item.Journals.MapTo <JournalEntryDocumentUnitDto>(); dto.BatchName = item.BatchName; dto.CreatedUser = item.CreatedUser; dto.JournalType = item.Journals.JournalTypeId.ToDisplayName(); dto.AccountingDocumentId = item.Journals.Id; return dto; }).ToList())); }
public async Task <List <NameValueDto> > GetEmployeeList(SearchInputDto input) { var query = from emp in _employeeUnitRepository.GetAll() select emp; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } var employeeList = await query.Select(u => new NameValueDto { Name = u.LastName, Value = u.Id.ToString() }).ToListAsync(); return(employeeList); }
/// <summary> /// sumit Method to create AuditLogQuerry /// </summary> /// <param name="input"></param> /// <returns></returns> private IQueryable <AuditLogAndUser> CreateAuditLogAndUsersQueryUnit(SearchInputDto input) { var query = from auditLog in _auditLogRepository.GetAll() join user in _userRepository.GetAll() on auditLog.UserId equals user.Id into userJoin from joinedUser in userJoin.DefaultIfEmpty() select new AuditLogAndUser { AuditLog = auditLog, User = joinedUser }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } return(query); }
/// <summary> /// Sumit Method to Get Roles /// </summary> /// <returns></returns> public async Task <ListResultOutput <RoleListDto> > GetAllRoles(SearchInputDto input) { var query = _roleManager.Roles; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } var roles = await query .OrderBy(Helper.GetSort("Name ASC", input.Sorting)) .PageBy(input) .ToListAsync(); return(new ListResultOutput <RoleListDto>(roles.MapTo <List <RoleListDto> >())); }
private IQueryable <EmployeeAndAddressDto> CreateEmployeeQuery(SearchInputDto input) { var query = from emp in _employeeUnitRepository.GetAll() join addr in _addressUnitRepository.GetAll() on emp.Id equals addr.ObjectId into temp from adrs in temp.Where(p => p.IsPrimary == true && p.TypeofObjectId == TypeofObject.EmployeeUnit).DefaultIfEmpty() select new EmployeeAndAddressDto { Employee = emp, Address = adrs }; if (!ReferenceEquals(input.Filters, null)) { SearchTypes mapSearchFilters = Helper.MappingFilters(input.Filters); if (!ReferenceEquals(mapSearchFilters, null)) { query = Helper.CreateFilters(query, mapSearchFilters); } } return(query); }
public ResponseDto GetAvailableFlight(SearchInputDto searchInput) { List <ItemResponseDto> itemResponses = new List <ItemResponseDto>(); ItemResponseDto itemResponseDto = new ItemResponseDto() { AvailableSeat = 20, BookingAvailable = true, FlightName = "SAA Mango", FlightScheduleId = 1 }; itemResponses.Add(itemResponseDto); ResponseDto responseDto = new ResponseDto { ItemResponses = itemResponses, Status = 200, Error = null }; return(responseDto); }
/// <summary> /// 根据条件查询数据库,并返回对象集合(用于分页数据显示) /// 查询条件变换时请重写该方法。 /// </summary> /// <param name="search">查询的条件</param> /// <returns>指定对象的集合</returns> public virtual PageResult <TODto> FindWithPager(SearchInputDto <T> search) { bool order = search.Order == "asc" ? false : true; string where = GetDataPrivilege(); PagerInfo pagerInfo = new PagerInfo { CurrenetPageIndex = search.CurrenetPageIndex, PageSize = search.PageSize }; List <T> list = repository.FindWithPager(where, pagerInfo, search.Sort, order); PageResult <TODto> pageResult = new PageResult <TODto> { CurrentPage = pagerInfo.CurrenetPageIndex, Items = list.MapTo <TODto>(), ItemsPerPage = pagerInfo.PageSize, TotalItems = pagerInfo.RecordCount }; return(pageResult); }
/// <summary> /// 根据条件查询数据库,并返回对象集合(用于分页数据显示) /// </summary> /// <param name="search">查询的条件</param> /// <returns>指定对象的集合</returns> public override async Task <PageResult <RoleOutputDto> > FindWithPagerAsync(SearchInputDto <Role> search) { bool order = search.Order == "asc" ? false : true; string where = GetDataPrivilege(false); if (!string.IsNullOrEmpty(search.Keywords)) { where += string.Format(" and (FullName like '%{0}%' or EnCode like '%{0}%')", search.Keywords); } ; where += " and Category=1"; PagerInfo pagerInfo = new PagerInfo { CurrenetPageIndex = search.CurrenetPageIndex, PageSize = search.PageSize }; List <Role> list = await repository.FindWithPagerAsync(where, pagerInfo, search.Sort, order); List <RoleOutputDto> resultList = list.MapTo <RoleOutputDto>(); List <RoleOutputDto> listResult = new List <RoleOutputDto>(); foreach (RoleOutputDto item in resultList) { if (!string.IsNullOrEmpty(item.OrganizeId)) { item.OrganizeName = _organizeService.Get(item.OrganizeId).FullName; } listResult.Add(item); } PageResult <RoleOutputDto> pageResult = new PageResult <RoleOutputDto> { CurrentPage = pagerInfo.CurrenetPageIndex, Items = listResult.MapTo <RoleOutputDto>(), ItemsPerPage = pagerInfo.PageSize, TotalItems = pagerInfo.RecordCount }; return(pageResult); }