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