public async Task <FilterPiDetailCompleteDto> GetPiPayList(FilterPiDetailCompleteDto filterPiDetailDto)
{
var asQueryable = piDetailRepository
.GetEntities()
.AsQueryable();
#region Filter - From To Sale Date
if (!string.IsNullOrWhiteSpace(filterPiDetailDto.FromDateSale) && !string.IsNullOrWhiteSpace(filterPiDetailDto.ToDateSale))
{
var from = Convert.ToDateTime(filterPiDetailDto.FromDateSale);
var to = Convert.ToDateTime(filterPiDetailDto.ToDateSale);
asQueryable = asQueryable.Where(x => x.DepositDate >= from && x.DepositDate < to);
//currencyAsQueryable = currencyAsQueryable.Where(x => x.SaleDate < DateTime.Today);
}
#endregion
asQueryable = asQueryable.OrderByDescending(x => x.DepositDate);
var count = (int)Math.Ceiling(asQueryable.Count() / (double)filterPiDetailDto.TakeEntity);
var pager = Pager.Builder(count, filterPiDetailDto.PageId, filterPiDetailDto.TakeEntity);
var list = asQueryable.Paging(pager).ToList();
filterPiDetailDto.PiDetailDtos = new List <PiDetailCompleteDto>();
foreach (var item in list)
{
var broker = await _brokerRepository.GetEntityById(item.BrokerId);
var pi = await piRepository.GetEntityById(item.PeroformaInvoiceId);
var customer = pi.CommodityCustomerId != null ? await customerRepository.GetEntityById((long)pi.CommodityCustomerId) : null;
var customerName = customer == null ? null : customer.Name;
filterPiDetailDto.PiDetailDtos.Add(new PiDetailCompleteDto()
{
BrokerId = item.BrokerId,
PiId = item.PeroformaInvoiceId,
DepositDate = item.DepositDate,
DepositPrice = item.DepositPrice,
Id = item.Id,
IsSold = item.IsSold,
BrokerName = broker.Name + "(" + broker.Title + ")",
PiCode = pi.PiCode,
TotalPrice = pi.TotalPrice,
CustomerName = customerName
});
}
if (filterPiDetailDto.SearchText != null || !(string.IsNullOrWhiteSpace(filterPiDetailDto.SearchText)))
{
filterPiDetailDto.PiDetailDtos = filterPiDetailDto.PiDetailDtos.Where(x => x.PiCode.Contains(filterPiDetailDto.SearchText.Trim()) ||
x.BrokerName.Contains(filterPiDetailDto.SearchText.Trim()) ||
x.DepositPrice.ToString().Contains(filterPiDetailDto.SearchText.Trim()) ||
x.TotalPrice.ToString().Contains(filterPiDetailDto.SearchText))
//|| x.CustomerName.Contains(filterPiDetailDto.SearchText.Trim())
.ToList();
}
return(filterPiDetailDto.SetPiDetails(filterPiDetailDto.PiDetailDtos).SetPaging(pager));
}
public async Task <PiDto> GetPiById(long id)
{
var pi = await piRepository.GetEntityById(id);
if (pi == null)
{
return(null);
}
return(new PiDto()
{
Id = pi.Id,
PiCode = pi.PiCode.Trim(),
PiDate = pi.PiDate,
BasePrice = pi.BasePrice,
TotalPrice = pi.TotalPrice,
Description = pi.Description.Trim(),
CustomerId = pi.CommodityCustomerId != null ?(long)pi.CommodityCustomerId : 0
});
}
public async Task <FilterCurrSalePiDto> GetListExDecSalesByPiDetailId(FilterCurrSalePiDto filterDto)
{
var piDetailIdList = _piDetailRepository
.GetEntities()
.Where(x => x.PeroformaInvoiceId == filterDto.Id)
.Select(x => x.Id);
var asQueryable = _currPiDetailRepository
.GetEntities()
.Include(X => X.CurrencySale)
.Where(x => piDetailIdList.Contains((long)x.PeroformaInvoiceDetailId))
.AsQueryable();
//var listOfRoleId = user.Roles.Select(r => r.RoleId);
//var roles = db.Roles.Where(r => listOfRoleId.Contains(r.RoleId));
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 peroformaInvoice = await _piRepository.GetEntityById(filterDto.Id);
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 = peroformaInvoice.PiCode,
SellPriceCurrency = item.CurrencySale.SalePricePerUnit,
SellPriceCommodity = peroformaInvoice.BasePrice
});
}
return(filterDto.SetCurrencySaleExDec(filterDto.CurrencySaleDetailPi).SetPaging(pager));
}
