public ActionResult Create(List <arthaBudget> arthabudget, FormCollection col) { DateTime nepDate; int mn = Convert.ToInt32(col["month"]); int fyId = Convert.ToInt32(col["fyId"]); //var objFiscalYear = db.fisYears.Find(fyId); string year = getYear(fyId, mn); nepDate = Convert.ToDateTime(col["nepDate"]); var objArtha = db.arthaBudgets.FirstOrDefault(m => (m.year == year) && (m.monthIndex == mn)); if (ModelState.IsValid) { foreach (var item in arthabudget) { arthaBudget artha = new arthaBudget(); artha.employeeName = TrimText(item.employeeName); artha.khaSiNa3 = item.khaSiNa3; artha.khaSiNa4 = item.khaSiNa4; artha.nepDate = nepDate; artha.year = year; artha.month = ((month)mn).ToString(); artha.monthIndex = mn; artha.fyId = Convert.ToInt32(col["fyId"]); db.arthaBudgets.Add(artha); } db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ErrorMessage = "Record Not Inserted.Please Try Again"; ViewBag.fyId = new SelectList(db.fisYears, "fyId", "nepFy", fyId); return(View(arthabudget)); }
public ActionResult DeleteConfirmed(int id) { arthaBudget arthabudget = db.arthaBudgets.Find(id); db.arthaBudgets.Remove(arthabudget); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: /ArthaBudget/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } arthaBudget arthabudget = db.arthaBudgets.Find(id); if (arthabudget == null) { return(HttpNotFound()); } return(View(arthabudget)); }
// GET: /ArthaBudget/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } arthaBudget arthabudget = db.arthaBudgets.Find(id); if (arthabudget == null) { return(HttpNotFound()); } // var objListArtha = db.arthaBudgets.Where(m => m.fyId == arthabudget.fyId && m.monthIndex == arthabudget.monthIndex).ToList(); ViewBag.fyId = new SelectList(db.fisYears, "fyId", "nepFy", arthabudget.fyId); return(View(arthabudget)); // return View(objListArtha); }
public ActionResult Edit(arthaBudget arthabudget) { if (ModelState.IsValid) { string year = getYear(arthabudget.fyId, arthabudget.monthIndex); var objArtha = db.arthaBudgets.Find(arthabudget.arthaBudgetId); objArtha.employeeName = TrimText(arthabudget.employeeName); objArtha.khaSiNa3 = arthabudget.khaSiNa3; objArtha.khaSiNa4 = arthabudget.khaSiNa4; objArtha.monthIndex = arthabudget.monthIndex; objArtha.year = year; objArtha.month = ((month)arthabudget.monthIndex).ToString(); objArtha.nepDate = arthabudget.nepDate; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.fyId = new SelectList(db.fisYears, "fyId", "nepFy", arthabudget.fyId); return(View(arthabudget)); }