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