public async Task <PiDetailDto> GetPiDetailById(long id) { var piDetail = await piDetailRepository.GetEntityById(id); if (piDetail == null) { return(null); } return(new PiDetailDto() { Id = piDetail.Id, DepositPrice = piDetail.DepositPrice, DepositDate = piDetail.DepositDate, BrokerId = piDetail.BrokerId, PiId = piDetail.PeroformaInvoiceId, IsSold = piDetail.IsSold }); }
public async Task <FilterCurrSalePiDto> GetListPiSalesByCurrencyId(FilterCurrSalePiDto filterDto) { var asQueryable = _currPiDetailRepository .GetEntities() .Include(X => X.CurrencySale) .Where(x => x.CurrencySaleId == filterDto.Id) .AsQueryable(); if (filterDto.SearchText != null || !(string.IsNullOrEmpty(filterDto.SearchText))) { asQueryable = asQueryable.Include(x => x.PeroformaInvoiceDetails) .Include(c => c.PeroformaInvoiceDetails.PeroformaInvoice) .Where(d => d.PeroformaInvoiceDetails.PeroformaInvoice.PiCode.Contains(filterDto.SearchText.Trim())); } var count = (int)Math.Ceiling(asQueryable.Count() / (double)filterDto.TakeEntity); var pager = Pager.Builder(count, filterDto.PageId, filterDto.TakeEntity); var list = await asQueryable.Paging(pager).ToListAsync(); filterDto.CurrencySaleDetailPi = new List <CurrencySaleDetailPiDto>(); foreach (var item in list) { var currencySaleItem = await _currencySaleRepository.GetCurrencyByIdIncludesCustomerAndBroker(item.CurrencySaleId); var piDetail = await _piDetailRepository.GetEntityById(item.PeroformaInvoiceDetailId ?? 1); var pi = await _piRepository.GetEntityById(piDetail.PeroformaInvoiceId); filterDto.CurrencySaleDetailPi.Add(new CurrencySaleDetailPiDto() { Id = item.Id, BrokerName = currencySaleItem.Broker.Name + " (" + currencySaleItem.Broker.Title + ") ", CurrSaleDate = currencySaleItem.SaleDate, CustomerName = currencySaleItem.Customer.Name, Price = item.Price, ProfitLossAmount = item.ProfitLossAmount, PiCode = pi.PiCode, PiDetailPrice = piDetail.DepositPrice, SellPriceCurrency = item.CurrencySale.SalePricePerUnit, SellPriceCommodity = pi.BasePrice }); } return(filterDto.SetCurrencySaleExDec(filterDto.CurrencySaleDetailPi).SetPaging(pager)); }