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"); } } } } } } }