public ActionResult LoadPayment(int ledgerId) { List <LocalMarketPayment> paymentList = new List <LocalMarketPayment>(); var partyPayment = partyBalanceService.GetAllInvoice(ledgerId, 2).OrderBy(a => a.VoucherNo); foreach (var item in partyPayment) { LocalMarketPayment payment = new LocalMarketPayment(); var invoice = paymentList.Where(a => a.InvoiceNo == item.InvoiceNo).FirstOrDefault(); if (invoice == null) { payment.InvoiceNo = item.InvoiceNo; payment.PaidAmount = item.Credit; payment.Party = item.LedgerName; payment.PostingDate = item.PostingDate?.ToString("dd-MM-yyyy"); payment.TotalAmount = item.Debit; payment.RestAmount = payment.TotalAmount - payment.PaidAmount; paymentList.Add(payment); } else { invoice.PaidAmount = invoice.PaidAmount + item.Credit; invoice.RestAmount = payment.TotalAmount - invoice.PaidAmount; } } return(Json(paymentList, JsonRequestBehavior.AllowGet)); }
public ActionResult LoadAllLocalPayment(DateTime fromDate, DateTime toDate) { List <LocalMarketPayment> paymentList = new List <LocalMarketPayment>(); var partyPayment = partyBalanceService.GetAll(fromDate, toDate).OrderBy(a => a.InvoiceNo); foreach (var item in partyPayment) { LocalMarketPayment payment = new LocalMarketPayment(); var invoice = paymentList.Where(a => a.InvoiceNo == item.AgainstInvoiceNo).FirstOrDefault(); if (invoice == null) { payment.LedgerId = item.LedgerId; if (string.IsNullOrEmpty(item.InvoiceNo)) { payment.InvoiceNo = ""; } else { payment.InvoiceNo = item.InvoiceNo; } payment.PaidAmount = item.Debit ?? 0; payment.Party = item.AccountLedger.LedgerName; payment.PostingDate = item.PostingDate.Value.ToString("dd-MM-yyyy") ?? DateTime.Now.ToString("dd-MM-yyyy"); payment.TotalAmount = item.Credit ?? 0; payment.RestAmount = payment.TotalAmount - payment.PaidAmount; paymentList.Add(payment); } else { invoice.PaidAmount = invoice.PaidAmount + item.Credit ?? 0; invoice.RestAmount = payment.TotalAmount - invoice.PaidAmount; } } return(Json(paymentList, JsonRequestBehavior.AllowGet)); }