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