public void DisplayEmployeeDetails(int EmployeeID)
        {
            //EmployeeDetails myEmployee = new EmployeeDetails(intEmployee_ID, "John", "JOnes", "Janitor", 1, "*****@*****.**", "8001234567", "8009876543", "8007771111");

            try
            {
                myEmployee = EmployeeDB.GetEmployeeDetails(EmployeeID);
            }
            catch (SQLiteException ex)
            {
                Response.Write("<script>alert('Exception: " + ex.Message + "')</script>");
            }

            lblEmployee_ID.Text               = myEmployee.ID.ToString();
            txtEmployee_FName.Text            = myEmployee.FirstName.ToString();
            txtEmployee_LName.Text            = myEmployee.LastName.ToString();
            txtEmployee_JobTitle.Text         = myEmployee.JobTitle.ToString();
            txtEmployeeContact_Email.Text     = myEmployee.ContactEmail.ToString();
            txtEmployeeContact_HomePhone.Text = myEmployee.ContactHomePhone.ToString();
            txtEmployeeContact_CellPhone.Text = myEmployee.ContactCellPhone.ToString();
            txtEmployeeContact_Fax.Text       = myEmployee.ContactFax.ToString();
            txtEmployeeAddress_Line.Text      = myEmployee.Employee_AddressLine.ToString();
            txtEmployeeAddress_Line2.Text     = myEmployee.Employee_AddressLine2.ToString();
            txtEmployeeAddress_City.Text      = myEmployee.Employee_AddressCity.ToString();
            txtEmployeeAddress_Zip.Text       = myEmployee.Employee_AddressZip.ToString();

            ddlState.SelectedValue = myEmployee.Employee_Address_StateID.ToString();
        }
        protected void lnkBtnEditEmployee_Click(object sender, EventArgs e)
        {
            myEmployee = EmployeeDB.GetEmployeeDetails(intEmployee_ID);

            myEmployee.FirstName                = txtEmployee_FName.Text.ToString();
            myEmployee.LastName                 = txtEmployee_LName.Text.ToString();
            myEmployee.JobTitle                 = txtEmployee_JobTitle.Text.ToString();
            myEmployee.ContactEmail             = txtEmployeeContact_Email.Text.ToString();
            myEmployee.ContactHomePhone         = txtEmployeeContact_HomePhone.Text.ToString();
            myEmployee.ContactCellPhone         = txtEmployeeContact_CellPhone.Text.ToString();
            myEmployee.ContactFax               = txtEmployeeContact_Fax.Text.ToString();
            myEmployee.Employee_AddressLine     = txtEmployeeAddress_Line.Text.ToString();
            myEmployee.Employee_AddressLine2    = txtEmployeeAddress_Line2.Text.ToString();
            myEmployee.Employee_AddressCity     = txtEmployeeAddress_City.Text.ToString();
            myEmployee.Employee_Address_StateID = Convert.ToInt32(ddlState.SelectedValue.ToString());
            myEmployee.Employee_AddressZip      = txtEmployeeAddress_Zip.Text.ToString();

            bool NewEntry = false;

            if (ValidateInput.ValidateEmployeeDetails(myEmployee, NewEntry))
            {
                EmployeeDB.UpdateEmployeeDetails(myEmployee);
                DisplayEmployeeDetails(myEmployee.ID);
                lblStatus.Text = "Employee Information Updated";
            }
            else
            {
                lblStatus.Text = "Invalid input, please check entries.";
            }
        }
 protected void lnkBtnDeleteEmployee_Click(object sender, EventArgs e)
 {
     myEmployee = EmployeeDB.GetEmployeeDetails(intEmployee_ID);
     EmployeeDB.DeleteEmployee(myEmployee.ID);
     Response.Redirect("Default.aspx");
 }