protected void LoadMemberList() { int StateId = Convert.ToInt32(ddlState.SelectedValue); int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue); int BlockId = Convert.ToInt32(ddlBlock.SelectedValue); int CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue); int BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue); string MemberName = txtMemberName.Text.Trim(); string MobileNo = txtMobile.Text.Trim(); int FinYearId = Convert.ToInt32(Session["FinYrID"]); BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster(); DataTable dt = objMemberMaster.DevelopmentMemberGetAll(StateId, DistrictId, BlockId, CategoryId, MemberName, MobileNo, BusinessTypeId, FromDate, ToDate); if (dt != null) { DataView dv = new DataView(dt); dgvMemberMaster.DataSource = dv; dgvMemberMaster.DataBind(); lblTotalMemberCount.Text = Server.HtmlDecode("<b>Total Member Count: " + dv.ToTable().Rows.Count.ToString() + "</b>"); } if (dt.Rows.Count > 0) { btnDownload.Visible = true; btnPrint.Visible = true; } else { btnDownload.Visible = false; btnPrint.Visible = false; } }
protected void LoadMembers() { BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster(); DataTable dt = objMemberMaster.DevelopmentMemberGetAll(0, 0, 0, 0, "", "", 0, DateTime.MinValue, DateTime.MinValue); DataView dv = new DataView(dt); dv.RowFilter = "IsNull(IsApproved,0)=1 And IsNull(IsActive,0)=1"; if (dt != null) { ddlMember.DataSource = dv.ToTable(); ddlMember.DataTextField = "MemberName"; ddlMember.DataValueField = "MemberId"; ddlMember.DataBind(); } ddlMember.Items.Insert(0, new ListItem("--SELECT MEMBER--", "0")); }