public ActionResult DeleteConfirmed(int id)
{
BG_OTDivision bg_otdivision = db.BG_OTDivision.Find(id);
db.BG_OTDivision.Remove(bg_otdivision);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "PBDivID,DivID,FinYear,TotalBudget,PaidBudget,RemainingBudget")] BG_OTDivision bg_otdivision)
{
if (ModelState.IsValid)
{
db.Entry(bg_otdivision).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DivID = new SelectList(db.HR_Department, "DeptID", "DepartmentName", bg_otdivision.DivID);
ViewBag.FinYear = new SelectList(db.PR_FinYear, "PFinYearID", "FinYearName", bg_otdivision.FinYear);
return(View(bg_otdivision));
}
// GET: /Attendance/OTDiv/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BG_OTDivision bg_otdivision = db.BG_OTDivision.Find(id);
if (bg_otdivision == null)
{
return(HttpNotFound());
}
return(View(bg_otdivision));
}
// GET: /Attendance/OTDiv/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BG_OTDivision bg_otdivision = db.BG_OTDivision.Find(id);
if (bg_otdivision == null)
{
return(HttpNotFound());
}
ViewBag.DivID = new SelectList(db.HR_Department, "DeptID", "DepartmentName", bg_otdivision.DivID);
ViewBag.FinYear = new SelectList(db.PR_FinYear, "PFinYearID", "FinYearName", bg_otdivision.FinYear);
return(View(bg_otdivision));
}
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));
}
public ActionResult Create([Bind(Include = "PCID,BOTDivID,FinYearID,Amount,Remarks")] BG_OTCredit bg_otcredit)
{
if (ModelState.IsValid)
{
if (db.BG_OTDivision.Where(aa => aa.DivID == bg_otcredit.BOTDivID && aa.FinYear == bg_otcredit.FinYearID).Count() > 0)
{
BG_OTDivision bg = new BG_OTDivision();
bg = db.BG_OTDivision.First(aa => aa.DivID == bg_otcredit.BOTDivID && aa.FinYear == bg_otcredit.FinYearID);
bg.RemainingBudget = bg.RemainingBudget + bg_otcredit.Amount;
db.SaveChanges();
}
db.BG_OTCredit.Add(bg_otcredit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BOTDivID = new SelectList(db.BG_OTDivision, "PBDivID", "PBDivID", bg_otcredit.BOTDivID);
ViewBag.FinYearID = new SelectList(db.PR_FinYear, "PFinYearID", "FinYearName", bg_otcredit.FinYearID);
return(View(bg_otcredit));
}
public ActionResult Edit([Bind(Include = "PCID,BOTDivID,FinYearID,Amount,Remarks")] BG_OTCredit bg_otcredit)
{
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");
//ViewBag.BOTDivID = new SelectList(db.BG_OTDivision, "PBDivID", "PBDivID", bg_otcredit.BOTDivID);
//ViewBag.FinYearID = new SelectList(db.PR_FinYear, "PFinYearID", "FinYearName", bg_otcredit.FinYearID);
if (ModelState.IsValid)
{
if (db.BG_OTDivision.Where(aa => aa.DivID == bg_otcredit.BOTDivID && aa.FinYear == bg_otcredit.FinYearID).Count() > 0)
{
BG_OTDivision bg = new BG_OTDivision();
bg = db.BG_OTDivision.First(aa => aa.DivID == bg_otcredit.BOTDivID && aa.FinYear == bg_otcredit.FinYearID);
bg.RemainingBudget = bg.RemainingBudget + bg_otcredit.Amount;
db.SaveChanges();
}
db.Entry(bg_otcredit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bg_otcredit));
}
