protected void LoadMember()
        {
            ddlMember.Items.Clear();
            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());
            }

            membermaster.MemberName = string.Empty;

            DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster);

            if (dt != null)
            {
                ddlMember.DataSource     = dt;
                ddlMember.DataTextField  = "MemberName";
                ddlMember.DataValueField = "MemberId";
                ddlMember.DataBind();
            }

            ddlMember.Items.Insert(0, li);
        }
        private void LoadMemberList()
        {
            BusinessLayer.Common.MemberMaster objMember    = new BusinessLayer.Common.MemberMaster();
            Entity.Common.MemberMaster        membermaster = new Entity.Common.MemberMaster();

            membermaster.BlockId    = 0;
            membermaster.DistrictId = 0;
            membermaster.StateId    = 0;
            membermaster.CategoryId = 0;
            membermaster.MemberName = string.Empty;

            DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster);
            DataView  dv = new DataView(dt);

            //dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";

            ddlMember.DataSource = dv;
            ddlMember.DataBind();
            ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
        }
Esempio n. 3
0
        protected void LoadMember()
        {
            BusinessLayer.Common.MemberMaster objMember    = new BusinessLayer.Common.MemberMaster();
            Entity.Common.MemberMaster        membermaster = new Entity.Common.MemberMaster();

            membermaster.BlockId    = 0;
            membermaster.DistrictId = 0;
            membermaster.StateId    = 0;
            membermaster.CategoryId = 0;
            membermaster.MemberName = string.Empty;

            DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster);

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

            //ddlMember.Items.Insert(0, li);
        }