public void AddPaymentDetail(dtoPaymentDetail t)
{
var paymentDetail = new tbl_paymentDetails()
{
paymentId = t.paymentId,
paymentPrice = t.paymentPrice,
documentId = t.documentId,
dateCreated = DateTime.Now,
createdBy = t.createdBy,
};
DBContext.tbl_paymentDetails.Add(paymentDetail);
DBContext.SaveChanges();
}
public List<dtoPaymentDetail> GetPaymentDetails(dtoPaymentDetail filter)
{
var returnItems = (from i in DBContext.tbl_paymentDetails
join j in DBContext.tbl_document on i.documentId equals j.documentId
where i.paymentId == filter.paymentId
select new dtoPaymentDetail
{
documentId = i.documentId,
documentNo = j.documentNumber,
paymentDetailsId = i.paymentDetailsId,
paymentId = i.paymentId,
paymentPrice = i.paymentPrice,
totalPaid = DBContext.tbl_paymentDetails.Where(d => d.documentId == i.documentId).Sum(e => e.paymentPrice)
}).ToList();
foreach (var item in returnItems)
{
var details = DBContext.tbl_transaction.Where(x => x.documentId == item.documentId).ToList();
item.totalAmount = details.Sum(y => (y.discountA != 0 || y.discountB != 0 || y.discountC != 0) ? ((((y.unitPrice * ((100M - (decimal)y.discountA) * 0.01M)) * ((100M - (decimal)y.discountB) * 0.01M)) * ((100M - (decimal)y.discountC) * 0.01M)) * y.quantity) : (y.unitPrice * y.quantity));
}
return returnItems;
}
