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