protected void LoadMember()
        {
            BusinessLayer.Common.MemberMaster objMember    = new BusinessLayer.Common.MemberMaster();
            Entity.Common.MemberMaster        membermaster = new Entity.Common.MemberMaster();
            if (ddlBlock.SelectedIndex == 0)
            {
                membermaster.BlockId = 0;
            }
            else
            {
                membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
            }

            if (ddlDistrict.SelectedIndex == 0)
            {
                membermaster.DistrictId = 0;
            }
            else
            {
                membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
            }

            if (ddlState.SelectedIndex == 0)
            {
                membermaster.StateId = 0;
            }
            else
            {
                membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
            }

            if (ddlMembershipCategory.SelectedIndex == 0)
            {
                membermaster.CategoryId = 0;
            }
            else
            {
                membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
            }

            if (txtMemberName.Text == string.Empty)
            {
                membermaster.MemberName = string.Empty;
            }
            else
            {
                membermaster.MemberName = txtMemberName.Text.Trim();
            }


            DataTable dt = objMember.GetAll(membermaster);

            if (dt != null)
            {
                dgvMemberMaster.DataSource = dt;
                dgvMemberMaster.DataBind();
            }

            DataTable dtSMS = objMember.SMSSubscription_GetAll(int.Parse(Session["FinYrID"].ToString()));

            if (dtSMS != null)
            {
                foreach (DataRow dr in dtSMS.Rows)
                {
                    foreach (GridViewRow gvr in dgvMemberMaster.Rows)
                    {
                        CheckBox chkSubscribe = (CheckBox)gvr.FindControl("chkSubscribe");

                        if (dr["MemberId"].ToString() == dgvMemberMaster.DataKeys[gvr.RowIndex].Values[0].ToString())
                        {
                            chkSubscribe.Checked = true;
                            chkSubscribe.Enabled = false;

                            if (dr["IsBlocked"].ToString() == "True")
                            {
                                Button btnBlock = (Button)gvr.FindControl("btnBlock");

                                btnBlock.Text = "Unblock";
                                for (int i = 0; i < 10; i++)
                                {
                                    gvr.Cells[i].Style.Add("background-color", "#E5D254");
                                }
                            }
                        }
                    }
                }
            }
        }