private void BindEmployeeRole()
        {
            DropDownListStoreCustomMemberEmployeeRole.ClearSelection();
            string[] roleList = Roles.GetAllRoles();

            foreach (string role in roleList)
            {
                DropDownListStoreCustomMemberEmployeeRole.Items.Add(new ListItem(role, role));
            }
            ListItem listItem = new ListItem("", "0");

            DropDownListStoreCustomMemberEmployeeRole.Items.Add(listItem);

            //List<EmployeeRole> employeeRole = EmployeeRole.GetEmployeeRoleListByEmployeeId(this.employeeId);

            //foreach (EmployeeRole employeeRoleItem in employeeRole)
            //{
            //    DropDownListEmployeeRole.Items.Remove(DropDownListEmployeeRole.Items.FindByValue(employeeRoleItem.Description));
            //}

            //if (DropDownListStoreCustomMemberEmployeeRole.Items.FindByValue("Representative") != null)
            //{
            //    DropDownListStoreCustomMemberEmployeeRole.Items.FindByValue("Representative").Selected = true;
            //}
            //else
            //{
            //    DropDownListStoreCustomMemberEmployeeRole.Items.FindByValue("0").Selected = true;
            //}
            DropDownListStoreCustomMemberEmployeeRole.Items.Remove("Administrator");
        }
        protected void GridViewStoreCustomMember_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                switch (e.CommandName.ToLower())
                {
                case "removestorecustommember":
                {
                    StoreCustomMember.DeleteStoreCustomMemberByStoreCustomMemberId(Convert.ToInt32(e.CommandArgument));
                    BindStoreCustomMember();
                    break;
                }

                case "editstorecustommember":
                {
                    StoreCustomMember storeCustomMember = StoreCustomMember.GetStoreCustomMemberByStoreCustomMemberId(Convert.ToInt32(e.CommandArgument));

                    ViewState["StoreCustomMemberId"]          = storeCustomMember.StoreCustomMemberId;
                    TextBoxStoreCustomMemberEmployeeName.Text = storeCustomMember.EmployeeName;
                    //BindEmployeeRole();
                    DropDownListStoreCustomMemberEmployeeRole.ClearSelection();
                    DropDownListStoreCustomMemberEmployeeRole.Items.FindByText(storeCustomMember.RoleName).Selected = true;
                    TextBoxStoreCustomMemberEmail.Text         = storeCustomMember.Email;
                    TextBoxStoreCustomMemberContactNumber.Text = storeCustomMember.ContactNumber;
                    TextBoxStoreCustomBirthday.Text            = storeCustomMember.Birthday.ToString("yyyy/MM/dd");

                    break;
                }
                }
            }
            catch (System.Data.SqlClient.SqlException sqlEx)
            {
                LabelError.Text = "";
                for (int i = 0; i < sqlEx.Errors.Count; i++)
                {
                    LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
                }
                PanelError.Visible = true;
            }
        }