public JsonResult GetEmployees()
 {
     try
     {
         DataAccess.EmployeeDA employeeDAO = new DataAccess.EmployeeDA();
         List <Employee>       employees   = employeeDAO.getEmployees();
         return(Json(employees, JsonRequestBehavior.AllowGet));
     }
     catch
     {
         throw;
     }
 }
        public ActionResult DeleteEmployee(int id)
        {
            try
            {
                DataAccess.EmployeeDA employeeDAO = new DataAccess.EmployeeDA();
                employeeDAO.DeleteEmployee(id);

                //Update the data in the Employee table
                List <Employee> employees = employeeDAO.getEmployees();
                return(Json(employees));
            }
            catch
            {
                throw;
            }
        }
        public ActionResult GetEmployee(string id)
        {
            int employeeID;

            try
            {
                employeeID = int.Parse(id);
                DataAccess.EmployeeDA employeeDAO = new DataAccess.EmployeeDA();
                Employee employee = employeeDAO.getEmployeeDetails(employeeID);
                return(Json(employee, JsonRequestBehavior.AllowGet));
            }
            catch
            {
                throw;
            }
        }
 public ActionResult UpdateEmployee(Employee employee)
 {
     DataAccess.EmployeeDA employeeDAO = new DataAccess.EmployeeDA();
     employeeDAO.UpdateEmployee(employee);
     return(Json(new { }));
 }