public ActionResult DeleteConfirmed(int id)
        {
            StudyLeave studyLeave = db.StudyLeave.Find(id);

            db.StudyLeave.Remove(studyLeave);
            db.SaveChanges();

            return(Redirect("/"));
        }
        public ActionResult Edit([Bind(Include = "LeaveID,LeaveStateID,UserID,StartDate,EndDate,RequestDate,Note,StudentNumber,Institution")] StudyLeave studyLeave)
        {
            if (ModelState.IsValid)
            {
                db.Entry(studyLeave).State = EntityState.Modified;
                db.SaveChanges();
            }

            return(Redirect("/"));
        }
        public ActionResult Create([Bind(Include = "LeaveID,LeaveStateID,UserID,StartDate,EndDate,RequestDate,Note,StudentNumber,Institution")] StudyLeave studyLeave)
        {
            if (ModelState.IsValid)
            {
                db.StudyLeave.Add(studyLeave);
                db.SaveChanges();
            }

            return(Redirect("/"));
        }
        // GET: StudyLeaves/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StudyLeave studyLeave = db.StudyLeave.Find(id);

            if (studyLeave == null)
            {
                return(HttpNotFound());
            }
            return(View(studyLeave));
        }
        // GET: StudyLeaves/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StudyLeave studyLeave = db.StudyLeave.Find(id);

            if (studyLeave == null)
            {
                return(HttpNotFound());
            }
            ViewBag.LeaveStateID = new SelectList(db.LeaveState, "LeaveStateID", "Description", studyLeave.LeaveStateID);
            ViewBag.UserID       = new SelectList(db.Users, "Id", "EmployeeCode", studyLeave.UserID);
            return(View(studyLeave));
        }