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