protected void Page_Load(object sender, EventArgs e)
        {
            if (Page.IsPostBack)
            {
                return;
            }

            if (Request.Params["Id"] == null)
            {
                this.employeesGrid.DataSource = this.GetEmployees();

                Page.DataBind();
            }
            else
            {
                var context = new NORTHWNDEntities();
                using (context)
                {
                    this.employeesGrid.DataSource = this.GetEmployees();

                    int id = int.Parse(Request.Params["Id"]);
                    var employee = context.Employees.FirstOrDefault(em => em.EmployeeID == id);

                    this.FormViewEmployee.DataSource = new List<Employee> { employee };
                    Page.DataBind();

                }
            }

            
        }
        public ICollection<Employee> GetEmployees()
        {
            var context = new NORTHWNDEntities();
            using (context)
            {
                var employees = context.Employees.ToList();

                return employees;
            }
        }
        public IList<EmployeeModel> GetEmployees()
        {
            var context = new NORTHWNDEntities();
            using (context)
            {
                var employees =
                    (from employee in context.Employees
                     select new EmployeeModel()
                     {
                         FullName = employee.FirstName + " " + employee.LastName,
                         Id = employee.EmployeeID
                     }).ToList();

                return employees;

            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.Params["Id"] == null)
            {
                Response.Redirect("Employees.aspx");
            }
            else
            {
                var context = new NORTHWNDEntities();
                using (context)
                {
                    int id = int.Parse(Request.Params["Id"]);

                    var employee = context.Employees.FirstOrDefault(em => em.EmployeeID == id);
                    this.EmployeeDetails.DataSource = new List<Employee>() { employee };
                    Page.DataBind();
                }
            }
        }