public ValidationMsg Save(ExpBankVoucher model, int userId, string pageUrl) { var transactionOption = new TransactionOptions { Timeout = new TimeSpan(0, 0, 99999) }; var vMsg = new ValidationMsg(); using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption)) { try { _dalBankVoucher = new DalBankVoucher(); BVID = _dalBankVoucher.Save(model, userId, pageUrl); //GetpurchaseID(purchaseID); if (BVID > 0) { transactionScope.Complete(); vMsg.Type = Enums.MessageType.Success; vMsg.Msg = "Saved successfully."; //vMsg.ReturnId = _dalChemicalForeignPurchaseOrder.GetOrderNo(OrderID); } else { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to save."; } } catch (Exception e) { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to save."; } } return(vMsg); }
public ActionResult BankVoucher(ExpBankVoucher model) { if (model.BVID == 0) { var msg = objBLL.Save(model, Convert.ToInt32(Session["UserID"]), "BankVoucher/BankVoucher"); var BVID = objBLL.GetBVID(); //var TransactionNo = objDalBankVoucher.GetTransactionNo(TransactionID); var VouchertemList = objDalBankVoucher.GetVouchertemList(BVID); return(Json(new { Msg = msg, BVID = BVID, VouchertemList = VouchertemList }, JsonRequestBehavior.AllowGet)); } else { var msg = objBLL.Update(model, Convert.ToInt32(Session["UserID"])); var VouchertemList = objDalBankVoucher.GetVouchertemList(model.BVID); return(Json(new { Msg = msg, VouchertemList = VouchertemList }, JsonRequestBehavior.AllowGet)); } }
public ValidationMsg Update(ExpBankVoucher model, int userId) { var transactionOption = new TransactionOptions { Timeout = new TimeSpan(0, 0, 9999) }; var vMsg = new ValidationMsg(); using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption)) { try { _dalBankVoucher = new DalBankVoucher(); var UpdateStatus = _dalBankVoucher.Update(model, userId); if (UpdateStatus > 0) { transactionScope.Complete(); vMsg.Type = Enums.MessageType.Update; vMsg.Msg = "Updated successfully."; } else { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to Update."; } } catch (Exception) { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to Update."; } } return(vMsg); }
public int Update(ExpBankVoucher model, int userId) { try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { #region Transaction_Informaiton_Update var objVoucher = (from p in _context.EXP_BankVoucher where p.BVID == model.BVID select p).FirstOrDefault(); objVoucher.RefBVNo = model.RefBVNo; objVoucher.BVDate = DalCommon.SetDate(model.BVDate); objVoucher.BVType = model.BVType; objVoucher.BankID = model.BankID; objVoucher.BranchID = model.BranchID; objVoucher.ACName = model.ACName; objVoucher.ACNo = model.ACNo; objVoucher.CIID = model.CIID; #endregion #region Update voucher Items if (model.EXPBankVoucherDtl != null) { foreach (var item in model.EXPBankVoucherDtl) { var checkVoucherItem = (from i in _context.EXP_BankVoucherDtl where i.BVDTLID == item.BVDTLID select i).Any(); #region New_Item_Insertion if (!checkVoucherItem) { EXP_BankVoucherDtl objItem = new EXP_BankVoucherDtl(); objItem.BVID = model.BVID; objItem.TransSL = item.TransSL; objItem.Narration = item.Narration; objItem.TransHead = item.TransHead; objItem.BVCRAmt = item.BVCRAmt; objItem.BVDRAmt = item.BVDRAmt; if (item.CurrencyName != null) { objItem.Currency = DalCommon.GetCurrencyID(item.CurrencyName); } if (item.ExchangeCurrencyName != null) { objItem.ExchangeCurrency = DalCommon.GetCurrencyID(item.ExchangeCurrencyName); } objItem.ExchangeRate = item.ExchangeRate; objItem.ExchangeAmount = item.ExchangeAmount; objItem.CIID = item.CIID; objItem.SetOn = DateTime.Now; objItem.SetBy = userId; _context.EXP_BankVoucherDtl.Add(objItem); } #endregion #region Existing_Item_Update else { var objItem = (from i in _context.EXP_BankVoucherDtl where i.BVDTLID == item.BVDTLID select i).FirstOrDefault(); objItem.BVID = model.BVID; objItem.TransSL = item.TransSL; objItem.Narration = item.Narration; objItem.TransHead = item.TransHead; objItem.BVCRAmt = item.BVCRAmt; objItem.BVDRAmt = item.BVDRAmt; if (item.CurrencyName != null) { objItem.Currency = DalCommon.GetCurrencyID(item.CurrencyName); } if (item.ExchangeCurrencyName != null) { objItem.ExchangeCurrency = DalCommon.GetCurrencyID(item.ExchangeCurrencyName); } objItem.ExchangeRate = item.ExchangeRate; objItem.ExchangeAmount = item.ExchangeAmount; objItem.CIID = item.CIID; objItem.ModifiedOn = DateTime.Now; objItem.ModifiedBy = userId; } #endregion } } #endregion _context.SaveChanges(); } transaction.Complete(); } return(1); } catch (Exception e) { return(0); } }
public long Save(ExpBankVoucher model, int userId, string pageUrl) { long CurrentBVID = 0; using (TransactionScope transaction = new TransactionScope()) { try { using (_context) { var AutoBVNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl); //Random r = new Random(); //var AutoBVNo = r.Next(); if (AutoBVNo != null) { #region New_Voucher_Insert EXP_BankVoucher objVoucher = new EXP_BankVoucher(); objVoucher.BVNo = AutoBVNo.ToString(); objVoucher.RefBVNo = model.RefBVNo; objVoucher.BVDate = DalCommon.SetDate(model.BVDate); objVoucher.BVType = model.BVType; objVoucher.BankID = model.BankID; objVoucher.BranchID = model.BranchID; objVoucher.ACName = model.ACName; objVoucher.ACNo = model.ACNo; objVoucher.Remarks = model.Remarks; objVoucher.RecordStatus = "NCF"; objVoucher.SetBy = userId; objVoucher.SetOn = DateTime.Now; _context.EXP_BankVoucher.Add(objVoucher); _context.SaveChanges(); CurrentBVID = objVoucher.BVID; #endregion } #region Item Insert if (model.EXPBankVoucherDtl != null) { foreach (var item in model.EXPBankVoucherDtl) { EXP_BankVoucherDtl objItem = new EXP_BankVoucherDtl(); objItem.BVID = CurrentBVID; objItem.TransSL = item.TransSL; objItem.Narration = item.Narration; objItem.TransHead = item.TransHead; objItem.BVCRAmt = item.BVCRAmt; objItem.BVDRAmt = item.BVDRAmt; if (item.CurrencyName != null) { objItem.Currency = DalCommon.GetCurrencyID(item.CurrencyName); } if (item.ExchangeCurrencyName != null) { objItem.ExchangeCurrency = DalCommon.GetCurrencyID(item.ExchangeCurrencyName); } objItem.ExchangeRate = item.ExchangeRate; objItem.ExchangeAmount = item.ExchangeAmount; objItem.CIID = item.CIID; objItem.SetOn = DateTime.Now; objItem.SetBy = userId; _context.EXP_BankVoucherDtl.Add(objItem); //_context.SaveChanges(); } } #endregion _context.SaveChanges(); } transaction.Complete(); } catch (Exception e) { CurrentBVID = 0; return(CurrentBVID); } } return(CurrentBVID); }