public ActionResult DeleteConfirmed(int id) { BG_OTDebit bg_otdebit = db.BG_OTDebit.Find(id); db.BG_OTDebit.Remove(bg_otdebit); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: /Attendance/OTDebit/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BG_OTDebit bg_otdebit = db.BG_OTDebit.Find(id); if (bg_otdebit == null) { return(HttpNotFound()); } return(View(bg_otdebit)); }
// GET: /Attendance/OTDebit/Edit/5 public ActionResult Edit(int?id) { ViewBag.BOTDivID = new SelectList(db.HR_Department.OrderBy(aa => aa.DepartmentName).ToList(), "DeptID", "DepartmentName"); ViewBag.FinYearID = new SelectList(db.PR_FinYear.OrderBy(aa => aa.FinYearName).ToList(), "PFinYearID", "FinYearName"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BG_OTDebit bg_otdebit = db.BG_OTDebit.Find(id); if (bg_otdebit == null) { return(HttpNotFound()); } //ViewBag.BOTDivID = new SelectList(db.BG_OTDivision, "PBDivID", "PBDivID", bg_otdebit.BOTDivID); //ViewBag.FinYearID = new SelectList(db.PR_FinYear, "PFinYearID", "FinYearName", bg_otdebit.FinYearID); return(View(bg_otdebit)); }
public ActionResult Create([Bind(Include = "PDID,BOTDivID,FinYearID,Amount,Remarks")] BG_OTDebit bg_otdebit) { if (ModelState.IsValid) { if (db.BG_OTDivision.Where(aa => aa.DivID == bg_otdebit.BOTDivID && aa.FinYear == bg_otdebit.FinYearID).Count() > 0) { BG_OTDivision bg = new BG_OTDivision(); bg = db.BG_OTDivision.First(aa => aa.DivID == bg_otdebit.BOTDivID && aa.FinYear == bg_otdebit.FinYearID); bg.RemainingBudget = bg.RemainingBudget - bg_otdebit.Amount; db.SaveChanges(); } db.BG_OTDebit.Add(bg_otdebit); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BOTDivID = new SelectList(db.HR_Department.OrderBy(aa => aa.DepartmentName).ToList(), "DeptID", "DepartmentName"); ViewBag.FinYearID = new SelectList(db.PR_FinYear.OrderBy(aa => aa.FinYearName).ToList(), "PFinYearID", "FinYearName"); return(View(bg_otdebit)); }