public string _GetTotalDueAmount(string id) { int intPartyId = Convert.ToInt32(id); string dbContextConnectionString = ConfigurationHelper.GetsmARTDBContextConnectionString(); InvoiceLibrary lib = new InvoiceLibrary(); lib.Initialize(dbContextConnectionString); return(lib.GetTotalDueAmount(intPartyId).ToString()); }
public ActionResult GetUnPaidInvoices(GridCommand command, string partyId) { int totalRows = 0; TempEntityList.Clear(); if (Convert.ToInt32(partyId) > 0) { string dbContextConnectionString = ConfigurationHelper.GetsmARTDBContextConnectionString(); InvoiceLibrary lib = new InvoiceLibrary(); lib.Initialize(dbContextConnectionString); IEnumerable <Invoice> results = lib.GetUnPaidInvoicesWithPaging(out totalRows, command.Page, command.PageSize == 0 ? 20 : command.PageSize, "", "Asc", new string[] { "Booking.Sales_Order_No.Party", "Sales_Order_No.Party" }, null, int.Parse(partyId) ); if (results != null && results.Count() > 0) { PaymentReceiptDetails paymentDetails; int id = 0; foreach (var item in results) { id += 1; if (item.Booking == null) { item.Booking = new Booking(); } paymentDetails = new PaymentReceiptDetails() { ID = id, Invoice = item, Balance_Amount = item.Net_Amt - item.Amount_Paid_Till_Date, PaymentReceipt = new PaymentReceipt() }; TempEntityList.Add(paymentDetails); } } } IEnumerable <PaymentReceiptDetails> resultList = TempEntityList; return(View(new GridModel { Data = resultList, Total = totalRows })); }