public ActionResult DeleteDetailConfirm(int id) { Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; CashVoucherDetail cashvoucherdetail = db.CashVoucherDetails.Find(id); try { var cashVoucherdetailallocation = db.CashVoucherDetailAllocations.Where(b => b.CashVoucherDetailID == id).ToList(); foreach (CashVoucherDetailAllocation b in cashVoucherdetailallocation) { db.CashVoucherDetailAllocations.Remove(b); db.SaveChanges(); } db.CashVoucherDetails.Remove(cashvoucherdetail); db.SaveChanges(); } catch { } try { decimal totalamt = db.CashVoucherDetails.Where(u => u.CashVoucherID == cashvoucherdetail.CashVoucherID).Sum(u => (decimal)u.Amount); CashVoucher cashvoucher = db.CashVouchers.Find(cashvoucherdetail.CashVoucherID); cashvoucher.TotalAmount = decimal.Round(Convert.ToDecimal(totalamt.ToString("#.##")), 2, MidpointRounding.AwayFromZero); db.Entry(cashvoucher).State = EntityState.Modified; db.SaveChanges(); Session["err"] = ""; Session["msg"] = "Deleted Successfully"; } catch { } return(RedirectToAction("Edit", new { id = cashvoucherdetail.CashVoucherID })); }
public ActionResult Create() { CashVoucher cashvoucher = new CashVoucher(); cashvoucher.VoucherNo = "CRV-"; cashvoucher.VoucherTypeID = 1; cashvoucher.EmployeeID = int.Parse(Session["UserID"].ToString()); cashvoucher.AccountHeadID = 1; cashvoucher.VoucherDate = DateTime.Now; cashvoucher.ReferenceNo = ""; cashvoucher.ReferenceDate = DateTime.Now; cashvoucher.Narration = ""; cashvoucher.TotalAmount = 0.00M; cashvoucher.Flag = false; db.CashVouchers.Add(cashvoucher); db.SaveChanges(); cashvoucher.VoucherNo = "CRV-" + cashvoucher.CashVoucherID.ToString("D" + 6); db.Entry(cashvoucher).State = EntityState.Modified; db.SaveChanges(); CashVoucherDetail cashvoucherdetail = new CashVoucherDetail(); cashvoucherdetail.CashVoucherID = cashvoucher.CashVoucherID; cashvoucherdetail.AccountHeadID = 1; cashvoucherdetail.Amount = 0.00M; cashvoucherdetail.Remarks = ""; db.CashVoucherDetails.Add(cashvoucherdetail); db.SaveChanges(); Session["Create"] = "1"; return(RedirectToAction("Edit", new { id = cashvoucher.CashVoucherID })); }
public ActionResult Edit(int?id) { var cashvoucher = db.CashVouchers.Where(b => b.CashVoucherID == id).ToList(); var cashvoucherdetail = db.CashVoucherDetails.Where(b => b.CashVoucherID == id).ToList(); if (cashvoucherdetail.Count == 0) { CashVoucherDetail cashvoucherdetail1 = new CashVoucherDetail(); cashvoucherdetail1.CashVoucherID = int.Parse(id.ToString()); cashvoucherdetail1.AccountHeadID = 1; cashvoucherdetail1.Amount = 0.00M; cashvoucherdetail1.Remarks = ""; db.CashVoucherDetails.Add(cashvoucherdetail1); db.SaveChanges(); cashvoucherdetail = db.CashVoucherDetails.Where(b => b.CashVoucherID == id).ToList(); } CashVoucherCashVoucherDetailCashVoucherDetailAllocationModel multiModel = new CashVoucherCashVoucherDetailCashVoucherDetailAllocationModel(); multiModel.CashVouchers = cashvoucher; multiModel.CashVoucherDetails = cashvoucherdetail; foreach (CashVoucher bv in cashvoucher) { ViewBag.AccountHeadID = new SelectList(db.AccountHeads.Include(a => a.CurrentAccountGroup).Where(a => a.CurrentAccountGroup.Name.ToLower() == "cash").OrderBy(a => a.Name), "AccountHeadID", "Name", bv.AccountHeadID); ViewBag.AccountHeads = db.AccountHeads.Include(a => a.CurrentAccountGroup).Where(a => a.CurrentAccountGroup.Name.ToLower() == "cash").OrderBy(a => a.Name); ViewBag.EmployeeID = new SelectList(db.Employees.Where(e => e.EmployeeID > 1), "EmployeeID", "Name", bv.EmployeeID); ViewBag.VoucherTypeID = new SelectList(db.VoucherTypes, "VoucherTypeID", "Name", bv.VoucherTypeID); } ViewBag.Message = Session["msg"]; ViewBag.Error = Session["err"]; Session["err"] = ""; Session["msg"] = ""; HttpSessionStateBase session = HttpContext.Session; if (session["Create"] != null) { ViewBag.PageType = "Create"; } else { ViewBag.PageType = "Edit"; } Session["Create"] = null; return(View(multiModel)); }
public ActionResult Edit(List <tempCashVoucherDetail> cashVoucherDetailList, List <tempCashVoucher> cashVoucherList, string create) { Session["err"] = "Error, Please Check Input Fields"; Session["msg"] = ""; int cashvoucherid = 0; foreach (tempCashVoucherDetail t in cashVoucherDetailList.ToList()) { cashvoucherid = t.cashvoucherid; if (Convert.ToDecimal(t.amount.Replace(",", "")) > 0) { try { CashVoucherDetail cashvoucherdetail = db.CashVoucherDetails.Find(t.cashvoucherdetailid); if (cashvoucherdetail == null) { CashVoucherDetail cashvoucherdetail1 = new CashVoucherDetail(); cashvoucherdetail1.CashVoucherID = t.cashvoucherid; cashvoucherdetail1.AccountHeadID = t.accountheadid; cashvoucherdetail1.Amount = decimal.Round(Convert.ToDecimal(t.amount.Replace(",", "")), 2, MidpointRounding.AwayFromZero); cashvoucherdetail1.Remarks = t.remarks; db.CashVoucherDetails.Add(cashvoucherdetail1); db.SaveChanges(); } else { cashvoucherdetail.CashVoucherID = t.cashvoucherid; cashvoucherdetail.AccountHeadID = t.accountheadid; cashvoucherdetail.Amount = decimal.Round(Convert.ToDecimal(t.amount.Replace(",", "")), 2, MidpointRounding.AwayFromZero); cashvoucherdetail.Remarks = t.remarks; db.Entry(cashvoucherdetail).State = EntityState.Modified; db.SaveChanges(); } cashvoucherid = t.cashvoucherid; } catch { } } } try { var cashvoucherdetailfinal = db.CashVoucherDetails.Where(b => b.CashVoucherID == cashvoucherid).OrderBy(b => b.CashVoucherDetailID).Skip(1).ToList(); foreach (CashVoucherDetail cvd in cashvoucherdetailfinal) { if (cvd.Amount == 0) { db.CashVoucherDetails.Remove(cvd); db.SaveChanges(); } } } catch {} if (create == "1") { try { CashVoucherDetail cashvoucherdetail1 = new CashVoucherDetail(); cashvoucherdetail1.CashVoucherID = cashvoucherid; cashvoucherdetail1.AccountHeadID = 1; cashvoucherdetail1.Amount = 0.00M; cashvoucherdetail1.Remarks = ""; db.CashVoucherDetails.Add(cashvoucherdetail1); db.SaveChanges(); } catch { } } decimal totalamt = 0; try { totalamt = db.CashVoucherDetails.Where(u => u.CashVoucherID == cashvoucherid).Sum(u => (decimal)u.Amount); } catch { } try { foreach (tempCashVoucher bv in cashVoucherList.ToList()) { CashVoucher cashvoucherfinal = db.CashVouchers.Find(bv.cashvoucherid); if (bv.vouchertypeid == 1) { cashvoucherfinal.VoucherNo = "CRV-" + cashvoucherid.ToString("D" + 6); } else { cashvoucherfinal.VoucherNo = "CPV-" + cashvoucherid.ToString("D" + 6); } cashvoucherfinal.VoucherTypeID = bv.vouchertypeid; cashvoucherfinal.EmployeeID = bv.employeeid; cashvoucherfinal.AccountHeadID = bv.accountheadid; cashvoucherfinal.VoucherDate = bv.voucherdate; cashvoucherfinal.ReferenceNo = bv.referenceno; cashvoucherfinal.ReferenceDate = bv.referencedate; cashvoucherfinal.Narration = bv.narration; cashvoucherfinal.TotalAmount = decimal.Round(Convert.ToDecimal(totalamt.ToString("#.##")), 2, MidpointRounding.AwayFromZero); db.Entry(cashvoucherfinal).State = EntityState.Modified; db.SaveChanges(); if (create == "0" && cashvoucherfinal.TotalAmount > 0) { cashvoucherfinal.Flag = true; db.Entry(cashvoucherfinal).State = EntityState.Modified; db.SaveChanges(); var accountjournals = db.AccountJournals.Where(a => a.VoucherNo == cashvoucherfinal.VoucherNo).ToList(); foreach (AccountJournal accountjournal1 in accountjournals) { var accountjournaldetails = db.AccountJournalDetails.Where(a => a.AccountJournalID == accountjournal1.AccountJournalID).ToList(); foreach (AccountJournalDetail accountjournaldetail1 in accountjournaldetails) { db.AccountJournalDetails.Remove(accountjournaldetail1); } db.SaveChanges(); db.AccountJournals.Remove(accountjournal1); } db.SaveChanges(); AccountJournal accountjournal = new AccountJournal(); accountjournal.VoucherNo = cashvoucherfinal.VoucherNo; accountjournal.VoucherType = cashvoucherfinal.VoucherNo.Substring(0, 2); accountjournal.TransactionDate = cashvoucherfinal.VoucherDate; accountjournal.BranchID = int.Parse(Session["BranchID"].ToString()); accountjournal.FinancialYearID = int.Parse(Session["FinancialYearID"].ToString()); accountjournal.UserID = Session["UserID"].ToString(); accountjournal.Remarks = "Cash Voucher"; db.AccountJournals.Add(accountjournal); db.SaveChanges(); var cashvoucherdetail = db.CashVoucherDetails.Where(d => d.CashVoucherID == cashvoucherfinal.CashVoucherID).ToList(); int voucheracc = 0; foreach (CashVoucherDetail d in cashvoucherdetail) { AccountJournalDetail accountjournaldetail = new AccountJournalDetail(); if (voucheracc == 0) { voucheracc = cashvoucherfinal.AccountHeadID; accountjournaldetail.AccountJournalID = accountjournal.AccountJournalID; accountjournaldetail.AccountHeadID = cashvoucherfinal.AccountHeadID; accountjournaldetail.AnalysisHeadID = 0; if (cashvoucherfinal.VoucherTypeID == 1) { accountjournaldetail.Amount = cashvoucherfinal.TotalAmount * -1; accountjournaldetail.Remarks = "Cash Voucher Receipt"; } else { accountjournaldetail.Amount = cashvoucherfinal.TotalAmount; accountjournaldetail.Remarks = "Cash Voucher Payment"; } db.AccountJournalDetails.Add(accountjournaldetail); db.SaveChanges(); } accountjournaldetail = new AccountJournalDetail(); accountjournaldetail.AccountJournalID = accountjournal.AccountJournalID; accountjournaldetail.AccountHeadID = d.AccountHeadID; accountjournaldetail.AnalysisHeadID = 0; if (cashvoucherfinal.VoucherTypeID == 1) { accountjournaldetail.Amount = d.Amount; accountjournaldetail.Remarks = "Cash Voucher Receipt"; } else { accountjournaldetail.Amount = d.Amount * -1; accountjournaldetail.Remarks = "Cash Voucher Payment"; } db.AccountJournalDetails.Add(accountjournaldetail); db.SaveChanges(); } } Session["msg"] = "Modified Successfully"; Session["err"] = ""; } } catch {} return(Json(Session["err"], JsonRequestBehavior.AllowGet)); }