public ActionResult UpdatePayment(Payment payment) { using (var transaction = new TransactionScope()) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankPayment_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); var gset = _gsetService.All().LastOrDefault(); payment.BranchCode = Session["BranchCode"].ToString(); payment.FinYear = Session["FinYear"].ToString(); payment.bankAccode = Session["BankAccode"].ToString(); string branchCode = Session["BranchCode"].ToString(); string finYear = Session["FinYear"].ToString(); string bankAccode = Session["BankAccode"].ToString(); var bankOperation = _bankOperationService.All().ToList().LastOrDefault(x => x.BranchCode == branchCode && x.bankAccode == bankAccode && x.TrDate == payment.PayDate); var Payment = _paymentService.All().ToList().Where(x => x.PayCode == payment.PayCode.Trim()).FirstOrDefault(); if (bankOperation != null && Payment != null) { bankOperation.PayTotal = bankOperation.PayTotal + Payment.Amount - payment.Amount; bankOperation.CloseBal = bankOperation.OpenBal + bankOperation.RecTotal - bankOperation.PayTotal; _bankOperationService.Update(bankOperation); _bankOperationService.Save(); Payment = payment; _paymentService.All().ToList().Where(y => y.PayCode == payment.PayCode).ToList().ForEach(x => _paymentService.Delete(x)); _paymentService.Save(); _paymentService.Add(Payment); _paymentService.Save(); // Delete Provision var entryNo = payment.PayCode; LoadDropDown.journalVoucherRemoval("BP", entryNo, payment.VoucherNo, payment.FinYear); //Insert to provision LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Update", payment.PayCode, User.Identity.Name); var sysSet = _sysSetService.All().FirstOrDefault(); if (sysSet.CashRule == "O") { LoadDropDown.BankRecalculate(payment.PayDate, Convert.ToDecimal(payment.Amount), Session["ProjCode"].ToString(), payment.BranchCode, payment.FinYear, payment.bankAccode); } CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode); transaction.Complete(); return(Json(new { CashOPVM, data = 1 }, JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { transaction.Dispose(); return(Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet)); } } }
public ActionResult DelBankOperation(string tag, string transactionNo, string dateTime) { if (tag == "RT") { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("Remittance_Delete")) { return(Json("D", JsonRequestBehavior.AllowGet)); } } if (tag == "BR") { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankReceipt_Delete")) { return(Json("D", JsonRequestBehavior.AllowGet)); } } if (tag == "BP") { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankPayment_Delete")) { return(Json("D", JsonRequestBehavior.AllowGet)); } } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); string branchCode = Session["BranchCode"].ToString(); string bankAccode = Session["BankAccode"].ToString(); switch (tag) { case "RT": { var hoRemit = _hoRemitService.All().ToList().FirstOrDefault(x => x.RemitNo == transactionNo.Trim()); if (hoRemit != null) { using (var transaction = new TransactionScope()) { try { _hoRemitService.Delete(hoRemit); _hoRemitService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "H/O Remittance", "Delete", hoRemit.RemitNo, User.Identity.Name); var entryNo = hoRemit.RemitNo; // var entryNo = Convert.ToInt64(hoRemit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0'); LoadDropDown.journalVoucherRemoval("RT", entryNo, hoRemit.VoucherNo, hoRemit.FinYear); CashOPVM = GetAllRemittances(Convert.ToDateTime(dateTime), branchCode, bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } case "BR": { var bankReceipt = _BankReceiptAppService.All().ToList().FirstOrDefault(x => x.BReceiptNo == transactionNo.Trim()); if (bankReceipt != null) { //bankReceipt.BranchCode = Session["BranchCode"].ToString(); //bankReceipt.FinYear = Session["FinYear"].ToString(); //bankReceipt.bankAccode = Session["BankAccode"].ToString(); //bankReceipt.NewChart = _newChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.purAccode.Trim()); //bankReceipt.bankNewChart = _newChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.bankAccode.Trim()); using (var transaction = new TransactionScope()) { try { _BankReceiptAppService.Delete(bankReceipt); _BankReceiptAppService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Bank Receipt", "Delete", bankReceipt.BReceiptNo, User.Identity.Name); var entryNo = bankReceipt.BReceiptNo; // var entryNo = Convert.ToInt64(bankReceipt.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0'); LoadDropDown.journalVoucherRemoval("BR", entryNo, bankReceipt.VoucherNo, bankReceipt.FinYear); CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } case "BW": { return(Json("2", JsonRequestBehavior.AllowGet)); } case "BP": { var payment = _paymentService.All().ToList().FirstOrDefault(x => x.PayCode == transactionNo.Trim()); if (payment != null) { using (var transaction = new TransactionScope()) { try { _paymentService.Delete(payment); _paymentService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Expene", "Delete", payment.PayCode, User.Identity.Name); var entryNo = payment.PayCode; // var entryNo = Convert.ToInt64(payment.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0'); LoadDropDown.journalVoucherRemoval("BP", entryNo, payment.VoucherNo, payment.FinYear); CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } case "BD": { return(Json("2", JsonRequestBehavior.AllowGet)); } default: { return(Json(0, JsonRequestBehavior.AllowGet)); } } }