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