protected void dgvAssignRep_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Assign")
            {
                //assign representative
                GridViewRow selectedRow      = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
                int         selectedIndex    = selectedRow.RowIndex;
                Button      buttonAssign     = (Button)dgvAssignRep.Rows[selectedIndex].FindControl("btnAssign");
                string      buttonAssignText = buttonAssign.Text;
                string      newRepName       = dgvAssignRep.Rows[selectedIndex].Cells[0].Text;

                if (buttonAssignText == "Assign")
                {
                    try
                    {
                        string oldRepName = (string)Session["CurrentRep"];
                        lblRepName.Text      = newRepName;
                        lblRepSubtitle1.Text = " is the current Department Representative.";
                        BusinessLogic_Sam.assignNewRepresentative(oldRepName, newRepName, departmentCode);
                        Session["CurrentRep"] = newRepName;
                        Response.Redirect("AssignRepresentative.aspx");
                    }
                    catch (Exception exp)
                    {
                        Response.Write(exp.ToString());
                    }
                }
                else
                {
                    lblRepName.Text      = newRepName;
                    lblRepSubtitle1.Text = " is the current Department Representative. ";
                    lblRepSubtitle2.Text = "Please reselect new employee for assignment.";
                }
            }
        }