public ActionResult Create([Bind(Include = "LeaveId,EmployeeId,FirstName,LastName,LeaveDate,LeaveReason")] EmployeeAbsenceViewModel employeeAbsenceViewModel)

        {
            if (ModelState.IsValid)
            {
                var data = db.SP_ApplyLeave(employeeAbsenceViewModel.EmployeeId, employeeAbsenceViewModel.FirstName, employeeAbsenceViewModel.LastName, employeeAbsenceViewModel.LeaveDate, employeeAbsenceViewModel.LeaveReason);
                db.SaveChanges();
            }
            return(RedirectToAction("Index"));
        }
        // GET: AbsenceLists/Create
        public ActionResult Create(int id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Employee emp = db.Employees.Find(id);
            EmployeeAbsenceViewModel employeeAbsenceViewModel = new EmployeeAbsenceViewModel()
            {
                EmployeeId = id,
                FirstName  = emp.FirstName,
                LastName   = emp.LastName
            };


            if (employeeAbsenceViewModel == null)
            {
                return(HttpNotFound());
            }
            return(View(employeeAbsenceViewModel));
        }