public void SaveJv(DtoSaveJv dtoSaveJv)
{
using (var transaction = _db.Database.BeginTransaction())
{
var maxVno = _db.AccVouchers.Max(v => (int?)v.VNo) ?? 0;
++maxVno;
int vSrNo = 0;
foreach (DtoSaveJvDetail detail in dtoSaveJv.JvDetails)
{
++vSrNo;
AccAccount account = _db.AccAccounts.Single(re => re.AccString.Equals(detail.AccString));
AccVoucher voucher = new AccVoucher
{
AccString = detail.AccString,
AccCode = account.AccCode,
BID = 0,
CID = 0,
ChequeNo = "0",
Credit = detail.Credit,
Debit = detail.Debit,
HeadCode = account.HeadCode,
OID = 0,
SubHeadCode = account.SubHeadCode,
SessionId = 0,
VType = dtoSaveJv.VoucherType,
InvType = "Manual-Entry",
InvNo = "0",
VDate = dtoSaveJv.Date,
VDescription = detail.Remarks,
UserCode = 0,
VSrNo = vSrNo,
VNo = maxVno
};
_db.AccVouchers.Add(voucher);
_db.SaveChanges();
}
transaction.Commit();
}
}
public ActionResult JvEntry(DtoSaveJv dtoSaveJv)
{
_voucher.SaveJv(dtoSaveJv);
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
