public ViewResult Detail(int id)
        {
            var             model   = new HomePageViewModel();
            SQLEmployeeData sqlData = new SQLEmployeeData(_context);

            Employee employee = sqlData.Get(id);

            return(View(employee));
        }
        public IActionResult Index()
        {
            var model = new HomePageViewModel();

            SQLEmployeeData sqlData = new SQLEmployeeData(_context);

            model.Employees = sqlData.GetAll();

            return(View(model));
        }
        public IActionResult Edit(int id, EmployeeEditViewModel input)
        {
            SQLEmployeeData sqlData  = new SQLEmployeeData(_context);
            var             employee = sqlData.Get(id);

            if (employee != null && ModelState.IsValid)
            {
                employee.Name = input.Name;
                _context.SaveChanges();
            }
            return(View(employee));
        }
        public IActionResult Create(EmployeeEditViewModel model)
        {
            if (ModelState.IsValid)
            {
                var employee = new Employee();
                employee.Name = model.Name;

                SQLEmployeeData sqlData = new SQLEmployeeData(_context);
                sqlData.Add(employee);
                return(RedirectToAction("Detail", new { id = employee.ID }));
            }
            return(View());
        }
        public IActionResult Edit(int id)
        {
            var             model   = new HomePageViewModel();
            SQLEmployeeData sqlData = new SQLEmployeeData(_context);

            Employee employee = sqlData.Get(id);

            if (employee == null)
            {
                return(RedirectToAction("Index"));
            }

            return(View(employee));
        }