public ActionResult Vat6P6Rpt(string errMsg) { if (Session["UserID"] != null) { var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; ViewBag.Message = errMsg; ViewBag.FinYear = LoadDropDown.LoadAllFinYears(_FYDDService); return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult GetCrNoteByCrNoteNo(string CrNoteNo) { HttpResponseMessage response = GlobalVariabls.VatApiClient.GetAsync("VM_CrNote/GetVM_CrNote?CrNoteNo=" + CrNoteNo.ToString()).Result; VM_CrNote VM_CrNote = response.Content.ReadAsAsync <VM_CrNote>().Result; string returnValue = ""; if (Convert.ToBoolean(Session["MaintVAT"]) == true) { string respse = LoadDropDown.CallApi(ConfigurationManager.AppSettings["VATApiUrl"] + "/api/VAT/" + "GetVM_6P7?TransNo=" + CrNoteNo.ToString(), Session["token"].ToString()); JavaScriptSerializer js = new JavaScriptSerializer(); returnValue = js.Deserialize <string>(respse); } return(Json(new { VM_CrNote = VM_CrNote, returnValue = returnValue }, JsonRequestBehavior.AllowGet)); }
// GET: VM_CrNote public ActionResult VM_CrNote() { if (Session["UserID"] != null) { ViewBag.Reason = LoadDropDown.LoadCrNoteReason(); ViewBag.NoteList = GetCrNote(); ViewBag.CrNoteNo = GetNewCrNote(); var sysSet = _sysSetService.All().ToList().FirstOrDefault(); ViewBag.MaintVAT = sysSet.MaintVAT; Session["MaintVAT"] = sysSet.MaintVAT; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult Create(string errMsg) { if (Session["UserID"] != null) { ViewBag.SubCode = GenerateSubsidiaryCode(); ViewBag.Items = GetSubInfo(); ViewBag.SubType = new SelectList(_subsidiaryTypeAppService.All().ToList(), "TypeCode", "SubType"); ViewBag.CountryCode = LoadDropDown.LoadCountryDDL(); ViewBag.SubGrp = LoadDropDown.LoadSubGrpDDL(); ViewBag.errMsg = errMsg; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult GetAllDataForOpenBalance(string Proj, string BrCode) { try { List <OpenBal> OBInfoList = new List <OpenBal>(); OBInfoList = _pR_OpenBalanceService.All().Where(s => s.ProjCode == Proj && s.BranchCode == BrCode).ToList(); // Convert the object member "Acccode" to its name from newChart table var defAc = LoadDropDown.GetDefAc(); foreach (var item in OBInfoList) { item.AccName = _NewChartAppService.All().Where(x => x.Accode == item.Accode).Select(s => s.AcName).FirstOrDefault(); string isAsset = item.Accode.Substring(0, 1); if (isAsset == defAc.AssAc) { item.YrCrBal = 0; item.YrDrBal = item.OpenBalance; } else { item.YrDrBal = 0; item.YrCrBal = item.OpenBalance * (-1); } } Session["mydata"] = OBInfoList; if (OBInfoList != null) { return(Json(new { data = OBInfoList }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { data = new EmptyResult() }, JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetCustomerWiseSaleSummaryRpt(CustWiseSaleRptSearchVModel saleRpt) { if (saleRpt.LocCode == null) { saleRpt.LocCode = ""; } if (saleRpt.RptType == 1) { string finYear = Session["FinYear"].ToString(); string JsonResponse = LoadDropDown.CallApi(ConfigurationManager.AppSettings["ApiUrl"] + "/api/" + "CustomerWiseSaleRpt?finYear=" + finYear + "&locCode=" + saleRpt.LocCode.ToString() + "&fdate=" + saleRpt.fDate.ToString("MM/dd/yyyy") + "&tdate=" + saleRpt.toDate.ToString("MM/dd/yyyy"), Session["token"].ToString()); JavaScriptSerializer js = new JavaScriptSerializer(); IEnumerable <CustWiseSummSaleRpt> itemList = js.Deserialize <IEnumerable <CustWiseSummSaleRpt> >(JsonResponse); if (saleRpt.LocCode != null && saleRpt.LocCode != "0" && saleRpt.LocCode != "") { ViewBag.Location = _locationService.All().FirstOrDefault(x => x.LocCode == saleRpt.LocCode.Trim()).LocName.ToString(); } else { ViewBag.Location = "All"; } ViewBag.fDate = saleRpt.fDate.ToString("dd-MMM-yyyy"); ViewBag.tDate = saleRpt.toDate.ToString("dd-MMM-yyyy"); if (saleRpt.LocCode != null && saleRpt.LocCode != "") { Session["LocCode"] = saleRpt.LocCode; } Session["RptType"] = saleRpt.RptType; //ViewBag.LocCode = new SelectList(_locationService.All().ToList(), "LocCode", "LocName"); if (itemList.ToList().Count == 0) { string errMsg = "There is no data in this combination. Please try again !!!"; return(RedirectToAction("CustomerWiseSaleRptSearch", "RptSalesPurchase", new { errMsg })); } return(View(itemList)); } else { return(View()); } }
// GET: ProductionRpt public ActionResult ProductionRpt(string errMsg) { if (Session["UserID"] != null) { ViewBag.ItemType = new SelectList(_itemTypeService.All().ToList(), "ItemTypeCode", "ItemTypeName"); ViewBag.ItemCode = LoadDropDown.LoadItemByItemType("", _CommonVmService); ViewBag.BranchCode = new SelectList(_branchService.All().ToList(), "BranchCode", "BranchName"); var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; ViewBag.Message = errMsg; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult Vat9P1_SF_Ka_2_Rpt(string errMsg) { if (Session["UserID"] != null) { var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; ViewBag.Message = errMsg; ViewBag.FinYear = LoadDropDown.LoadAllFinYears(_FYDDService); ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); ViewBag.projCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName"); return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult Search(string errMsg) { if (Session["UserID"] != null) { ViewBag.LedgerTypeCode = new SelectList(_SumRptTypeService.All().ToList(), "ReportTypeCode", "ReportTypeName"); ViewBag.BranchCode = PermittedBranch();//new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); ViewBag.BookType = LoadDropDown.LoadBookType(); var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; ViewBag.Message = errMsg; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult Search(string errMsg) { if (Session["UserID"] != null) { ViewBag.LedgerTypeCode = new SelectList(_LedgerTypeService.All().ToList(), "LedgerTypeCode", "LedgerTypeName"); ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); //GardenSelection(); ViewBag.AccountCode = LoadDropDown.LoadAccount("", _ItemService, _SubsidiaryService, _NewChartService); var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; //var sysSet = _sysSetService.All().ToList().FirstOrDefault(); ViewBag.Message = errMsg; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult RateChart(string errMsg) { if (Session["UserID"] != null) { ViewBag.CustGroup = LoadDropDown.LoadSubGrpDDL(); ViewBag.CustCode = LoadDropDown.LoadSubsidiary(_ISubsidiaryInfoService); ViewBag.ItemCode = LoadDropDown.LoadItem(_IItemInfoAppService); ViewBag.CustType = new SelectList(ISubsidiaryTypeService.All().ToList(), "TypeCode", "SubType"); var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; ViewBag.Message = errMsg; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult ItemWiseSalesStatementRpt(string errMsg) { if (Session["UserID"] != null) { ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); ViewBag.LocCode = new SelectList(_locationService.All().ToList(), "LocCode", "LocName"); ViewBag.ItemCode = LoadDropDown.LoadItems(_ItemService); var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; ViewBag.Message = errMsg; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
// GET: JobWiseRecPay public ActionResult JobWiseRecPay(string errMsg) { if (Session["UserID"] != null) { ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName"); ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); //ViewBag.FYDD = new SelectList(_FYDDService.All().ToList(), "FinYear", "FinYear"); ViewBag.JobNo = LoadDropDown.LoadJobInfo(); var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString()); ViewBag.FyddFDate = Fydd.FYDF; ViewBag.FyddTDate = Fydd.FYDT; ViewBag.Message = errMsg; return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult GetOpenBalForEdit(int OpenBalId) { try { OpenBal GLOB = new OpenBal(); var defAc = LoadDropDown.GetDefAc(); var Obal = _pR_OpenBalanceService.All().ToList().FirstOrDefault(x => x.Id == OpenBalId); string isAsset = Obal.Accode.Substring(0, 1); if (Obal != null) { GLOB.Id = Obal.Id; GLOB.ProjCode = Obal.ProjCode; GLOB.BranchCode = Obal.BranchCode; GLOB.Accode = Obal.Accode; if (isAsset == defAc.AssAc) { GLOB.OpenBalance = Obal.OpenBalance; } else if (isAsset == defAc.LiaAc) { GLOB.OpenBalance = Obal.OpenBalance * (-1); } } var serializerSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects }; string json = JsonConvert.SerializeObject(GLOB, Formatting.Indented, serializerSettings); if (GLOB != null && GLOB.Id > 0) { return(Json(json, JsonRequestBehavior.AllowGet)); } else { return(Json(new EmptyResult(), JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetMoneyReceiptPdf(string ReceiptNo) { MoneyReceiptVM MRVM = new MoneyReceiptVM(); var crPfd = _chequeReceiptService.All().FirstOrDefault(x => x.ChqReceiptNo == ReceiptNo); if (crPfd != null) { var todayDate = DateTime.Now; var TingCount = _chequeReceiptService.All().FirstOrDefault(x => x.ChqReceiptNo == ReceiptNo); TingCount.MRTing = TingCount.MRTing + 1; TingCount.MRTingTime = todayDate.AddHours(todayDate.Hour).AddMinutes(todayDate.Minute).AddSeconds(todayDate.Second).AddMilliseconds(todayDate.Millisecond); MRVM.MRNo = crPfd.ChqReceiptNo; MRVM.CustCode = crPfd.SubCode.Trim(); MRVM.ChequeDate = (DateTime)crPfd.ChqDate; MRVM.CustName = (from s in _subsidiaryService.All().ToList() where s.SubCode == crPfd.SubCode.Trim() select s.SubName).FirstOrDefault(); MRVM.Address = (from se in _SubsidiaryExtService.All().ToList() where se.SubCode.Trim() == crPfd.SubCode.Trim() select se.SubAddress).FirstOrDefault(); MRVM.InWord = InWord.ConvertToWords(crPfd.Amount.ToString()); MRVM.AcType = LoadDropDown.GetMrAgainst(crPfd.MRAgainst); MRVM.MRDate = crPfd.ChqReceiptDate; MRVM.Amount = crPfd.Amount; MRVM.PayMode = "ChequeReceipt"; MRVM.ChequeNo = crPfd.ChqNo; MRVM.BankName = _bankInfoService.All().FirstOrDefault(s => s.BankCode == crPfd.BankCode).BankName;; MRVM.Branch = crPfd.BranchName; _chequeReceiptService.Update(TingCount); _chequeReceiptService.Save(); return(new Rotativa.ViewAsPdf("~/Views/CashReceipt/MoneyReceiptPdf.cshtml", MRVM) { PageSize = Rotativa.Options.Size.A4 }); } else { string errMsg = "NF"; return(RedirectToAction("ChequeReceipts", "ChequeReceipts", new { errMsg })); } }
// GET: CustAdjustment public ActionResult CustAdjustment() { if (Session["UserID"] != null) { DateTime datetime = DateTime.Now; ViewBag.GLProvition = Counter("JB"); ViewBag.GLEntries = CountEntries("JB", datetime); var sysSet = _sysSetService.All().ToList().FirstOrDefault(); ViewBag.MaintJob = sysSet.MaintJob; ViewBag.CustCode = new SelectList(_subsidiaryInfoService.All().ToList().Where(x => x.SubType == "1").OrderBy(x => x.SubName), "SubCode", "SubName"); ViewBag.InvNo = LoadDropDown.LoadEmpDlList(); ViewBag.AdjReason = LoadDropDown.LoadAdjReason(); ViewBag.ApprBy = new SelectList(_EmployeeService.All().ToList(), "Id", "UserName"); ViewBag.JobNo = LoadDropDown.LoadJobInfo(); var VchrConv = _vchrSetService.All().ToList().FirstOrDefault().VchrConv; Session["VchrConv"] = VchrConv; ViewBag.AdjNo = LoadDropDown.GenerateAdjustmentNo(_custAdjustmentService, "", Session["BranchCode"].ToString(), "", Session["VchrConv"].ToString()); return(View()); } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult UpdateDepositToBank(Deposit deposit, DateTime dateTime) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankDeposit_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>(); if (ModelState.IsValid) { deposit.BranchCode = Session["BranchCode"].ToString(); var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault(); if (GCa == null) { var gset = _gsetService.All().LastOrDefault(); GCa = gset.GCa; } deposit.FinYear = Session["FinYear"].ToString(); deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim()); CashOperation cashOperation = new CashOperation(); var isClosed = _CashOperationService.All().LastOrDefault(x => x.BranchCode == deposit.BranchCode && Convert.ToDateTime(x.TrDate.ToShortDateString()) <= Convert.ToDateTime(dateTime.ToShortDateString())); if (isClosed.IsClosed == false) { using (var transaction = new TransactionScope()) { try { _DepositToBankService.Update(deposit); _DepositToBankService.Save(); //delete to provision var entryNo = deposit.DepositNo; //var entryNo = Convert.ToInt64(deposit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0'); LoadDropDown.journalVoucherRemoval("BD", entryNo, deposit.VoucherNo, deposit.FinYear); //insert to provision LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Update", deposit.DepositNo, Session["UserName"].ToString()); var sysSet = _sysSetService.All().FirstOrDefault(); if (sysSet.CashRule == "O") { LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate); } CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else { return(Json("2", JsonRequestBehavior.AllowGet)); } } return(Json("0", JsonRequestBehavior.AllowGet)); }
public ActionResult GetVchrNoByVchrType(string VchrType) { return(Json(LoadDropDown.LoadVchrNoByVchrType(VchrType, _vchrMainService), JsonRequestBehavior.AllowGet)); }
public ActionResult SavePayment(Payment payment) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankPayment_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); var gset = _gsetService.All().LastOrDefault(); try { var IfExit = _paymentService.All().Where(x => x.PayCode == payment.PayCode).FirstOrDefault(); if (IfExit == null) { payment.BranchCode = Session["BranchCode"].ToString(); payment.FinYear = Session["FinYear"].ToString(); payment.bankAccode = Session["BankAccode"].ToString(); var openBal = GetOpenBal(payment.PayDate); var rcecBal = GetAllRemittances(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount); var payTotal = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount); var closBal = openBal + rcecBal - payTotal; BankOperation bankOperation = new BankOperation(payment.PayDate, openBal, 0.0, payment.Amount, closBal, payment.BranchCode, payment.FinYear, false, payment.bankAccode); // BankOperation bankOperation = new BankOperation(payment.PayDate, 0.0, 0.0, 0.0, 0.0, payment.BranchCode, payment.FinYear, false, payment.bankAccode); var isAlreadySaved = _bankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == payment.PayDate.ToString("MM-dd-yyyy") && x.BranchCode == payment.BranchCode && x.bankAccode == payment.bankAccode); if (isAlreadySaved == null) { using (var transaction = new TransactionScope()) { try { _bankOperationService.Add(bankOperation); _bankOperationService.Save(); _paymentService.Add(payment); _paymentService.Save(); //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", "Save", payment.PayCode, User.Identity.Name); CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } else { var payTotals = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount); isAlreadySaved.PayTotal = payTotals + payment.Amount; isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal; using (var transaction = new TransactionScope()) { try { _bankOperationService.Update(isAlreadySaved); _bankOperationService.Save(); _paymentService.Add(payment); _paymentService.Save(); //Insert to provision LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString()); 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); } TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Save", payment.PayCode, User.Identity.Name); CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else { return(Json("1", JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
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 UpdateCashMR(MoneyReceiptVM MrVM) { using (var transaction = new TransactionScope()) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("MoneyReceiptCash_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } var VchrExist = _pVchrmainService.All().FirstOrDefault(s => s.VchrNo == MrVM.VchrNo); if (VchrExist == null) { return(Json("3", JsonRequestBehavior.AllowGet)); } var MR = _moneyReceiptService.All().Where(x => x.MRSL == MrVM.MRSL && x.MRNo == MrVM.MRNo && MrVM.Posted == false).FirstOrDefault(); var CR = _CashReceiptService.All().Where(s => s.RefNo == MrVM.MRSL).FirstOrDefault(); var CRSD = _CashReceiptSubDetailsAppService.All().Where(s => s.CashReceiptNo == CR.ReceiptNo).FirstOrDefault(); if (MR != null && CR != null && CRSD != null) { //var cabkop = _defACService.All().ToList().FirstOrDefault().CashAc; var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault(); if (GCa == null) { var gset = _gsetService.All().LastOrDefault(); GCa = gset.GCa; } //For MR MR.MRSL = MrVM.MRSL; MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode; MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode; MR.MRNo = MrVM.MRNo; MR.MRDate = MrVM.MRDate; MR.MRAgainst = MrVM.MRAgainst; MR.VchrNo = MrVM.VchrNo; MR.Posted = MrVM.Posted; MR.AdjWithBill = MrVM.AdjWithBill; MR.MRAmount = MrVM.Amount; MR.Accode = MrVM.Accode; MR.CustCode = MrVM.CustCode; MR.FinYear = Session["FinYear"].ToString(); MR.JobNo = MrVM.JobNo; MR.Remarks = MrVM.Remarks; MR.Ca_Bk = GCa; CR.ReceiptDate = (DateTime)MrVM.MRDate; CR.purAccode = MrVM.MRAgainst;// "1.2.004"; CR.RefNo = MrVM.MRSL; CR.Amount = (Double)MrVM.Amount; CR.Remarks = MrVM.Remarks; CR.VoucherNo = MrVM.VchrNo; CRSD.SubCode = MrVM.CustCode; CRSD.Accode = MrVM.MRAgainst; CRSD.Amount = (Double)MrVM.Amount; _moneyReceiptService.Update(MR); _CashReceiptService.Update(CR); _CashReceiptSubDetailsAppService.Update(CRSD); _CashReceiptService.Save(); _CashReceiptSubDetailsAppService.Save(); _moneyReceiptService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Cash MR", "Update", MR.MRSL, Session["UserName"].ToString()); LoadDropDown.journalVoucherRemoval("CR", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString()); LoadDropDown.journalVoucherSave("CR", "I", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), GCa, Session["UserName"].ToString()); transaction.Complete(); return(Json("1", JsonRequestBehavior.AllowGet)); } else { transaction.Dispose(); return(Json("3", JsonRequestBehavior.AllowGet)); } } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }
// GET: Language public ActionResult Language() { ViewBag.LangName = LoadDropDown.LoadLanguage(); return(View()); }
public ActionResult SaveCashMR(MoneyReceiptVM MrVM, List <MoneyReceiptExt> AdjBills) { using (var transaction = new TransactionScope()) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("MoneyReceiptCash_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } //----Edit Nasir---// //var cabkop = ""; //var sysSet = _sysSetService.All().FirstOrDefault(); //if (sysSet.ActualBasis == true) //{ //var cabkop = _defACService.All().ToList().FirstOrDefault().CashAc; //} //else //{ // cabkop = _defACService.All().ToList().FirstOrDefault().CashAc; //} //--- ---// string CRNo = ""; var IfExit = _moneyReceiptService.All().Where(x => x.MRNo == MrVM.MRNo).FirstOrDefault(); if (IfExit == null) { //var todayDate = DateTime.Now; CashReceipt CR = new CashReceipt(); CashReceiptSubDetails CRSD = new CashReceiptSubDetails(); MoneyReceipt MR = new MoneyReceipt(); MR.MRSL = MrVM.MRSL; MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode; MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode; MR.MRNo = MrVM.MRNo; MR.MRDate = MrVM.MRDate; //.AddHours(todayDate.Hour).AddMinutes(todayDate.Minute).AddSeconds(todayDate.Second).AddMilliseconds(todayDate.Millisecond); MR.MRAgainst = MrVM.MRAgainst; MR.VchrNo = MrVM.VchrNo; MR.PayMode = "Ca"; MR.Posted = MrVM.Posted; MR.AdjWithBill = MrVM.AdjWithBill; MR.MRAmount = MrVM.Amount; // Accode ???? MR.Accode = MrVM.MRAgainst; // "1.2.001"; MR.CustCode = MrVM.CustCode; MR.FinYear = Session["FinYear"].ToString(); MR.Remarks = MrVM.Remarks; MR.JobNo = MrVM.JobNo; //MR.Ca_Bk = cabkop; // CR.ReceiptNo = _CashReceiptController.GenerateReceiptNo(MR.BranchCode).Substring(6, 0);//MrVM.MRNo; CR.ReceiptNo = _CashReceiptController.GenerateReceiptNo(MR.BranchCode); // CR.ReceiptNo = MrVM.MRNo; CRNo = CR.ReceiptNo; CR.ReceiptDate = (DateTime)MrVM.MRDate; CR.purAccode = MrVM.MRAgainst;// "1.2.004"; CR.RefNo = MrVM.MRSL; CR.Amount = (Double)MrVM.Amount; CR.Advance = false; CR.Remarks = MrVM.Remarks; CR.GLPost = false; CR.BranchCode = MrVM.BranchCode; CR.VoucherNo = MrVM.VchrNo; CR.BranchCode = MR.BranchCode; CR.FinYear = Session["FinYear"].ToString(); CRSD.SubCode = MrVM.CustCode; CRSD.Accode = MrVM.MRAgainst; CRSD.Amount = (Double)MrVM.Amount; CRSD.CashReceiptNo = CRNo; //CR.purAccode = cabkop; // "1.2.004"; _moneyReceiptService.Add(MR); _CashReceiptService.Add(CR); _CashReceiptSubDetailsAppService.Add(CRSD); _CashReceiptService.Save(); _moneyReceiptService.Save(); _CashReceiptSubDetailsAppService.Save(); //List<MoneyReceiptExt> MRExtList = new List<MoneyReceiptExt>(); if (AdjBills != null) { decimal TotAmt = MrVM.Amount; foreach (var bill in AdjBills) { MoneyReceiptExt MRExt = new MoneyReceiptExt(); var saleMain = _salesMainService.All().Where(s => s.SaleNo == bill.SaleNo).FirstOrDefault(); MRExt.MRId = _moneyReceiptService.All().OrderBy(s => s.MRId).LastOrDefault().MRId; MRExt.SaleNo = bill.SaleNo; MRExt.InstallNo = _moneyReceiptExtService.All().OrderBy(s => s.InstallNo).Where(x => x.SaleNo == bill.SaleNo).Select(s => s.InstallNo).LastOrDefault(); MRExt.InstallNo = MRExt.InstallNo + 1; MRExt.InstallDate = DateTime.Now; if (TotAmt >= bill.Amount) { MRExt.Amount = bill.Amount; TotAmt = TotAmt - bill.Amount; saleMain.ReceiptNo = MrVM.MRNo; saleMain.ReceiptAmt = bill.Amount; saleMain.IsPaid = true; _salesMainService.Update(saleMain); _salesMainService.Save(); _moneyReceiptExtService.Add(MRExt); _moneyReceiptExtService.Save(); } else { if (bill.IsPaid_mre) { saleMain.IsPaid = true; MRExt.Amount = TotAmt; //TotAmt = TotAmt - bill.Amount; } else { saleMain.IsPaid = false; MRExt.Amount = TotAmt; // MRExt.Amount = bill.Amount; //TotAmt = TotAmt - bill.Amount; } saleMain.ReceiptNo = MrVM.MRNo; saleMain.ReceiptAmt = TotAmt; _moneyReceiptExtService.Add(MRExt); _moneyReceiptExtService.Save(); string sql = string.Format("select sm.ReceiptAmt,sm.SaleNo, sm.SaleDate, (sm.NetAmount - isnull(sum(mre.Amount),0)) as Billamount from SalesMain sm left join MoneyReceiptExt mre on mre.SaleNo = sm.SaleNo where sm.CustCode = " + MrVM.CustCode + " and sm.IsPaid = 'false' group by sm.ReceiptAmt, mre.SaleNo, sm.NetAmount, sm.SaleNo, sm.SaleDate, mre.Amount order by sm.SaleNo"); IEnumerable <billShow> BillLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList(); } foreach (var Salebill in BillLst) { if (Salebill.BillAmount == 0) { saleMain.ReceiptNo = MrVM.MRNo; saleMain.ReceiptAmt = ((Salebill.ReceiptAmt == null) ? 0 : Salebill.ReceiptAmt) + TotAmt; saleMain.IsPaid = true; _salesMainService.Update(saleMain); _salesMainService.Save(); } } } } //end of foreach } // New Add By Nasir var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault(); if (GCa == null) { var gset = _gsetService.All().LastOrDefault(); GCa = gset.GCa; } //------------------ TransactionLogService.SaveTransactionLog(_transactionLogService, "Cash MR", "Save", MR.MRSL, Session["UserName"].ToString()); LoadDropDown.journalVoucherSave("CR", "I", CRNo, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), GCa, Session["UserName"].ToString()); transaction.Complete(); return(Json("1", JsonRequestBehavior.AllowGet)); } else { transaction.Dispose(); return(Json("3", JsonRequestBehavior.AllowGet)); } } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }
public ActionResult GetAdjBills(string CustCode, string MRAgainst, decimal Amount, string isEdit) { var Bills = default(dynamic); string sql = ""; string MrAg = LoadDropDown.GetMrAgainstType(MRAgainst); if (MrAg == null) { MrAg = MRAgainst; //temporary Ashik } if (MrAg == "Sales") { if (isEdit == "1") { Bills = (from mr in _moneyReceiptService.All().ToList() join mre in _moneyReceiptExtService.All().ToList() on mr.MRId equals mre.MRId where mr.CustCode == CustCode select new { SaleNo = mre.SaleNo, SaleDate = mr.MRDate, BillAmount = mre.Amount, IsPaid = true }).ToList(); } else if (isEdit == "ChqEdit") { sql = string.Format("select sm.IsPaid, sm.NetAmount as Billamount, sm.SaleNo, sm.SaleDate , (sm.NetAmount - isnull(sum(cre.BillAmount),0)) as Billamt from SalesMain sm left join ChequeReceiptExt cre on cre.BillNo = sm.SaleNo where sm.CustCode = " + CustCode + " group by sm.IsPaid, cre.BillNo, sm.NetAmount, sm.SaleNo, sm.SaleDate order by sm.SaleNo "); //sql = string.Format("select sm.IsPaid, sm.NetAmount as Billamount, sm.SaleNo, sm.SaleDate , (sm.NetAmount - isnull(sum(cre.BillAmount),0)) as Billamt from SalesMain sm left join ChequeReceiptExt cre on cre.BillNo = sm.SaleNo where sm.CustCode = " + CustCode + " and sm.Ispaid = 'true' and Billamt = 0 group by sm.IsPaid, cre.BillNo, sm.NetAmount, sm.SaleNo, sm.SaleDate, cre.BillAmount order by sm.SaleNo "); IEnumerable <billShow> BillLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList(); Bills = BillLst; } } else { //decimal MrExtAmt = 0; //Bills = (from sm in _salesMainService.All().ToList() // join mre in _moneyReceiptExtService.All().ToList() on sm.SaleNo equals mre.SaleNo into SmMre // from leftJ in SmMre.DefaultIfEmpty() // where sm.CustCode == CustCode && sm.IsPaid == false // //group leftJ by leftJ.SaleNo into G // select new // { // SaleNo = sm.SaleNo, // SaleDate = sm.SaleDate, // BillAmount = sm.NetAmount - (MrExtAmt = (leftJ == null) ? 0 : leftJ.Amount) // }).GroupBy(x => x.SaleNo).ToList(); sql = string.Format("select sm.SaleNo, sm.SaleDate, (sm.NetAmount - (select isnull(sum(mre.Amount),0) as Billamount from MoneyReceiptExt mre where SaleNo = sm.SaleNo)) as Billamount from SalesMain sm where sm.CustCode = " + CustCode + " and sm.IsPaid = 'false' group by sm.NetAmount, sm.SaleNo, sm.SaleDate order by sm.SaleNo "); IEnumerable <billShow> BillLst; using (AcclineERPContext dbContext = new AcclineERPContext()) { BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList(); Bills = BillLst; } } } //else if (true) //{ //} return(Json(new { data = Bills }, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveBankReceipt(BankReceipt bankReceipt) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankReceipt_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); var gset = _gsetService.All().LastOrDefault(); try { var IfExit = _BankReceiptAppService.All().Where(x => x.BReceiptNo == bankReceipt.BReceiptNo).FirstOrDefault(); if (IfExit == null) { if (!string.IsNullOrEmpty(bankReceipt.purAccode) && bankReceipt.purAccode.Trim() != "Select Purpose") { bankReceipt.BranchCode = Session["BranchCode"].ToString(); bankReceipt.bankAccode = Session["BankAccode"].ToString(); bankReceipt.FinYear = Session["FinYear"].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()); var openBal = GetOpenBal(bankReceipt.BReceiptDate); var rcecBal = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode).Sum(x => x.Amount); var payTotal = GetAllPayment(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode).Sum(x => x.Amount); var closBal = openBal + rcecBal - payTotal; BankOperation bankOperation = new BankOperation(bankReceipt.BReceiptDate, openBal, bankReceipt.Amount, 0.0, closBal, bankReceipt.BranchCode, bankReceipt.FinYear, false, bankReceipt.bankAccode); //cashReceipt.Customer = _CustomerService.All().ToList().FirstOrDefault(x => x.CustCode == cashReceipt.CustCode); //BankOperation bankOperation = new BankOperation(bankReceipt.BReceiptDate, 0.0, 0.0, 0.0, 0.0, bankReceipt.BranchCode, bankReceipt.FinYear, false, bankReceipt.bankAccode); var isAlreadySaved = _BankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == bankReceipt.BReceiptDate.ToString("MM-dd-yyyy") && x.BranchCode == bankReceipt.BranchCode && x.bankAccode == bankReceipt.bankAccode); if (isAlreadySaved == null) { using (var transaction = new TransactionScope()) { try { _BankOperationService.Add(bankOperation); _BankOperationService.Save(); _BankReceiptAppService.Add(bankReceipt); _BankReceiptAppService.Save(); //insert to provision LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "BankReceipt", "Save", bankReceipt.BReceiptNo, User.Identity.Name); CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } else { var rcecBals = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode).Sum(x => x.Amount); isAlreadySaved.RecTotal = rcecBals + bankReceipt.Amount; isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal; using (var transaction = new TransactionScope()) { try { _BankOperationService.Update(isAlreadySaved); _BankReceiptAppService.Save(); _BankReceiptAppService.Add(bankReceipt); _BankReceiptAppService.Save(); var sysSet = _sysSetService.All().FirstOrDefault(); if (sysSet.CashRule == "O") { LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString()); } //insert to provision LoadDropDown.BankRecalculate(bankReceipt.BReceiptDate, Convert.ToDecimal(bankReceipt.Amount), Session["ProjCode"].ToString(), bankReceipt.BranchCode, bankReceipt.FinYear, bankReceipt.bankAccode); TransactionLogService.SaveTransactionLog(_transactionLogService, "BankReceipt", "Save", bankReceipt.BReceiptNo, User.Identity.Name); CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } else { return(Json("1", JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetInvMrNoByVchrType(string VchrType, string CustCode) { return(Json(LoadDropDown.GetInvMrNoByVchrType(VchrType, CustCode, _SalesMainService, _moneyReceiptService, _FYDDAppService), JsonRequestBehavior.AllowGet)); }
public ActionResult SaveDepositToBank(Deposit deposit) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankDeposit_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>(); try { var IfExit = _DepositToBankService.All().Where(x => x.DepositNo == deposit.DepositNo).FirstOrDefault(); if (IfExit == null) { if (!string.IsNullOrEmpty(deposit.bankAccode) && deposit.bankAccode.Trim() != "Select Bank A/C") { deposit.BranchCode = Session["BranchCode"].ToString(); var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault(); if (GCa == null) { var gset = _gsetService.All().LastOrDefault(); GCa = gset.GCa; } deposit.FinYear = Session["FinYear"].ToString(); deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim()); //cashReceipt.Customer = _CustomerService.All().ToList().FirstOrDefault(x => x.CustCode == cashReceipt.CustCode); CashOperation cashOperation = new CashOperation(deposit.DepositDate, 0.0, 0.0, 0.0, 0.0, "", DateTime.Now, false, deposit.FinYear, false, deposit.BranchCode); var isAlreadyClosed = _CashOperationService.All().ToList().FirstOrDefault(x => x.BranchCode == deposit.BranchCode && x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy")); var openBal = GetOpenBal(deposit.DepositDate, deposit.bankAccode); var rcecBal = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount); var payTotal = GetAllPayment(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount); var closBal = openBal + rcecBal - payTotal; BankOperation bankOperation = new BankOperation(deposit.DepositDate, openBal, deposit.Amount, 0.0, closBal, deposit.BranchCode, deposit.FinYear, false, deposit.bankAccode); var sysSet = _sysSetService.All().FirstOrDefault(); var isAlreadySaved = _BankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy") && x.BranchCode == deposit.BranchCode && x.bankAccode == deposit.bankAccode); if (isAlreadyClosed == null || isAlreadySaved == null) { using (var transaction = new TransactionScope()) { try { _CashOperationService.Add(cashOperation); _CashOperationService.Save(); _BankOperationService.Add(bankOperation); _BankOperationService.Save(); _DepositToBankService.Add(deposit); _DepositToBankService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString()); LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString()); CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else if (isAlreadyClosed != null && sysSet.CashRule == "O" ? true : isAlreadyClosed.IsClosed == false) { var rcecBals = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount); isAlreadySaved.RecTotal = rcecBals + deposit.Amount; isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal; using (var transaction = new TransactionScope()) { try { _BankOperationService.Update(isAlreadySaved); _BankReceiptAppService.Save(); _DepositToBankService.Add(deposit); _DepositToBankService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString()); LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString()); if (sysSet.CashRule == "O") { LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate); } CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else { return(Json("2", JsonRequestBehavior.AllowGet)); } } else { return(Json("1", JsonRequestBehavior.AllowGet)); } } else { return(Json("3", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetRecvNo(string branchCode, string ProjCode) { return(Json(LoadDropDown.GenerateRecvSlNo(_moneyReceiptService, branchCode, Session["BranchCode"].ToString(), ProjCode, Session["VchrConv"].ToString()), JsonRequestBehavior.AllowGet)); }
public ActionResult GenerateAdjustmentNo() { return(Json(LoadDropDown.GenerateAdjustmentNo(_custAdjustmentService, "", Session["BranchCode"].ToString(), "", Session["VchrConv"].ToString()), JsonRequestBehavior.AllowGet)); }
public ActionResult SaveOpenBalance(OpenBal OpnBal) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("GL_OpenBal_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } string eCode = ""; var defAc = LoadDropDown.GetDefAc(); // Checking and operation Data for save database string isAsset = OpnBal.Accode.Substring(0, 1); if (isAsset == defAc.AssAc) { OpnBal.OpenBalance = OpnBal.OpenBalance; } else if (isAsset == defAc.LiaAc) { OpnBal.OpenBalance = OpnBal.OpenBalance * (-1); } using (var transaction = new TransactionScope()) { try { // query for check existing data and then if null go to transaction var objOpnBal = _pR_OpenBalanceService.All().ToList() .Where(x => x.Accode == OpnBal.Accode && x.BranchCode == OpnBal.BranchCode && x.ProjCode == OpnBal.ProjCode).ToList(); if (objOpnBal.Count == 0) { //// should not here , in setOpnBal OpnBal.FinYear = Session["FinYear"].ToString(); _pR_OpenBalanceService.Add(OpnBal); _pR_OpenBalanceService.Save(); var OpenBalanceID = 1; // not defined TransactionLogService.SaveTransactionLog(_transactionLogService, "SaveOpnBal", "Save", OpenBalanceID.ToString(), Session["UserName"].ToString()); eCode = "1"; } else { eCode = "2"; } transaction.Complete(); return(Json(eCode, JsonRequestBehavior.AllowGet)); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }