public ChargeShipmentResult ListChargeShipment(ChargeShipmentCriteria criteria)
{
if (string.IsNullOrEmpty(criteria.CurrencyLocal))
{
criteria.CurrencyLocal = AccountingConstants.CURRENCY_LOCAL;
}
var data = acctSOAService.GetListChargeShipment(criteria);
return(data);
}
public ChargeShipmentResult GetListChargeShipment(ChargeShipmentCriteria criteria)
{
var chargeShipmentList = GetSpcChargeShipment(criteria).ToList();
var dataMap = mapper.Map <List <spc_GetListChargeShipmentMaster>, List <ChargeShipmentModel> >(chargeShipmentList);
var result = new ChargeShipmentResult
{
ChargeShipments = dataMap,
TotalShipment = chargeShipmentList.Where(x => x.HBL != null).GroupBy(x => x.HBL).Count(),
TotalCharge = chargeShipmentList.Count(),
AmountDebitLocal = chargeShipmentList.Sum(x => x.AmountDebitLocal),
AmountCreditLocal = chargeShipmentList.Sum(x => x.AmountCreditLocal),
AmountDebitUSD = chargeShipmentList.Sum(x => x.AmountDebitUSD),
AmountCreditUSD = chargeShipmentList.Sum(x => x.AmountCreditUSD),
};
return(result);
}
private List <spc_GetListChargeShipmentMaster> GetSpcChargeShipment(ChargeShipmentCriteria criteria)
{
DbParameter[] parameters =
{
SqlParam.GetParameter("currencyLocal", criteria.CurrencyLocal),
SqlParam.GetParameter("customerID", criteria.CustomerID),
SqlParam.GetParameter("dateType", criteria.DateType),
SqlParam.GetParameter("fromDate", criteria.FromDate),
SqlParam.GetParameter("toDate", criteria.ToDate),
SqlParam.GetParameter("type", criteria.Type),
SqlParam.GetParameter("isOBH", criteria.IsOBH),
SqlParam.GetParameter("strCreators", criteria.StrCreators),
SqlParam.GetParameter("strCharges", criteria.StrCharges),
SqlParam.GetParameter("commodityGroupID", criteria.CommodityGroupID),
SqlParam.GetParameter("strServices", criteria.StrServices)
};
return(((eFMSDataContext)DataContext.DC).ExecuteProcedure <spc_GetListChargeShipmentMaster>(parameters));
}
public ChargeShipmentResult ListChargeShipment(ChargeShipmentCriteria criteria)
{
var data = csShipmentSurchargeService.GetListChargeShipment(criteria);
return(data);
}
