public ActionResult GetUnPaidTickets(GridCommand command, string partyId, string locationId = "0") { TempEntityList.Clear(); if (Convert.ToInt32(partyId) > 0) { string dbContextConnectionString = ConfigurationHelper.GetsmARTDBContextConnectionString(); SettlementLibrary settlementLib = new SettlementLibrary(); settlementLib.Initialize(dbContextConnectionString); IEnumerable <Settlement> results = settlementLib.GetUnPaidTickets(new string[] { "Scale", "Scale.Party_ID", "Scale.Purchase_Order", "Scale.Party_Address" }, int.Parse(partyId), int.Parse(locationId)); if (results != null && results.Count() > 0) { PaymentReceiptDetails paymentDetails; int id = 0; foreach (var item in results) { //if (item.Scale != null && item.Scale.Purchase_Order == null) { // item.Scale.Purchase_Order = new PurchaseOrder(); //} id += 1; paymentDetails = new PaymentReceiptDetails() { ID = id, Settlement = item, Balance_Amount = item.Amount - item.Amount_Paid_Till_Date, PaymentReceipt = new PaymentReceipt() }; TempEntityList.Add(paymentDetails); } } } return(Display(command, "0", true)); }
private string GetTotalScaleDueAmount(int partyId, int locationId = 0) { string dbContextConnectionString = ConfigurationHelper.GetsmARTDBContextConnectionString(); SettlementLibrary settlementLib = new SettlementLibrary(); settlementLib.Initialize(dbContextConnectionString); return(settlementLib.GetTotalDueAmount(partyId, locationId).ToString()); }
public ActionResult _MakePayment(Scale data, bool isNew = false) { try { // Start transaction. using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted })) { // Save scale record ActionResult result = base.Save(data); data = ModelFromActionResult <Scale>(result); if (data.Ticket_Settled == false) { // Settlement IEnumerable <ScaleDetails> scaleDetails = new ScaleDetailsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString()).GetAllByParentID(data.ID); Settlement addSettlement = AddSettlement(data, scaleDetails); // Payment Settlement settlement = new SettlementLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString()).GetByID(addSettlement.ID.ToString(), new string[] { "Scale.Party_ID" }); IEnumerable <SettlementDetails> settlementDetails = new SettlementDetailsLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString()).GetAllByParentID(settlement.ID); AddPayment(settlement, settlementDetails); // Cash AddCash(settlement); } // Complete transaction. scope.Complete(); ModelState.Clear(); } return(Display(data.ID.ToString())); } catch (Exception ex) { Response.StatusCode = 500; if (ex.GetBaseException() is smART.Common.DuplicateException) { ModelState.AddModelError("Error", ex.GetBaseException().Message); } else { ModelState.AddModelError("Error", ex.Message); } return(Display(data)); } }