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