protected void Add_Emp(object sender, EventArgs e)
        {
            string SSN = ((Label)EmployeeTable.FooterRow.Cells[1].FindControl("Label1")).Text;

            ProjRef.Employee temp_emp = new ProjRef.Employee
            {
                SSN        = int.Parse(SSN),
                Name       = ((TextBox)EmployeeTable.FooterRow.Cells[2].FindControl("TextBox2")).Text,
                Salary     = decimal.Parse(((TextBox)EmployeeTable.FooterRow.Cells[3].FindControl("TextBox4")).Text),
                Phone      = ((TextBox)EmployeeTable.FooterRow.Cells[4].FindControl("TextBox3")).Text,
                Department = int.Parse(((DropDownList)EmployeeTable.FooterRow.Cells[5].FindControl("DropDownList1")).SelectedValue)
            };
            client.AddEmployee(temp_emp);
            EmployeeTable.DataSource = client.GetAllEmployees();
            EmployeeTable.DataBind();
        }
        protected void EmployeeTable_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string SSN = ((Label)EmployeeTable.Rows[e.RowIndex].Cells[1].FindControl("Label1")).Text;

            ProjRef.Employee temp_emp = new ProjRef.Employee
            {
                SSN        = int.Parse(SSN),
                Name       = ((TextBox)EmployeeTable.Rows[e.RowIndex].Cells[2].FindControl("TextBox2")).Text,
                Salary     = decimal.Parse(((TextBox)EmployeeTable.Rows[e.RowIndex].Cells[3].FindControl("TextBox4")).Text),
                Phone      = ((TextBox)EmployeeTable.Rows[e.RowIndex].Cells[4].FindControl("TextBox3")).Text,
                Department = int.Parse(((DropDownList)EmployeeTable.Rows[e.RowIndex].Cells[5].FindControl("DropDownList1")).SelectedValue)
            };
            client.UpdateEmployee(temp_emp, SSN);
            EmployeeTable.EditIndex  = -1;
            EmployeeTable.DataSource = client.GetAllEmployees();
            EmployeeTable.DataBind();
        }