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.BlockId = Session["UserType"].ToString().Equals("Agent") ? Convert.ToInt32(Session["BlockId"]) : 0;
//membermaster.DistrictId = Session["UserType"].ToString().Equals("Agent") ? Convert.ToInt32(Session["DistrictId"]) : 0;
//membermaster.StateId = Session["UserType"].ToString().Equals("Agent") ? Convert.ToInt32(Session["StateId"]) : 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.GetAll(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("--Any Member--", "0"));
if (Session["UserType"].ToString().Equals("Member"))
{
ddlMember.SelectedValue = Session["UserId"].ToString();
ddlMember.Enabled = false;
}
else
{
ddlMember.Enabled = true;
}
}
private void LoadMemberList(int MemberId)
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.MemberId = MemberId;
membermaster.BlockId = 0;
membermaster.DistrictId = 0;
membermaster.StateId = 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.GetAll(membermaster);
if (dt != null && dt.Rows.Count > 0)
{
dt.AsEnumerable().ToList().ForEach(r => r["Name"] = r["Name"].ToString() + " [" + r["MemberCode"].ToString() + "] [" + r["MobileNo"].ToString() + "]");
}
DataView dv = new DataView(dt);
string strRowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
if (txtMobileNo.Text.Trim().Length > 0)
{
strRowFilter = strRowFilter + " And MobileNo = '" + txtMobileNo.Text.Trim() + "'";
}
dv.RowFilter = strRowFilter;
dv.Sort = "MemberName ASC";
ddlMember.DataSource = dv;
ddlMember.DataBind();
ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
}
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.GetAll(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"));
if (Session["UserType"].ToString().Equals("Member"))
{
ddlMember.SelectedValue = Session["UserId"].ToString();
ddlMember.Enabled = false;
}
else if (Session["UserType"].ToString().Equals("Admin") && Request.QueryString["MemberId"] != null && Request.QueryString["MemberId"].Trim().Length > 0)
{
ddlMember.SelectedValue = Request.QueryString["MemberId"].ToString();
ddlMember.Enabled = false;
}
else
{
ddlMember.Enabled = true;
}
}
protected void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
membermaster.MemberName = txtMemberName.Text.Trim();
membermaster.MobileNo = txtMobile.Text.Trim();
membermaster.BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue.Trim());
membermaster.MembershipMonth = Convert.ToInt32(ddlMonth.SelectedValue.Trim());
membermaster.MembershipYear = Convert.ToInt32(ddlYear.SelectedValue.Trim());
DataTable dt = objMember.GetAll(membermaster);
if (dt != null)
{
DataView dv = new DataView(dt);
dv.RowFilter = "IsApproved Is Not Null";
dgvMemberMaster.DataSource = dv;
dgvMemberMaster.DataBind();
lblTotalMemberCount.Text = Server.HtmlDecode("<b>Total Member Count: " + dv.ToTable().Rows.Count.ToString() + "</b>");
}
}
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.GetAll(membermaster);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
}
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.GetAll(membermaster);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
dv.Sort = "MemberName ASC";
ddlMember.DataSource = dv;
ddlMember.DataBind();
ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
}
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.GetAll(membermaster);
if (dt != null)
{
ddlMember.DataSource = dt;
ddlMember.DataTextField = "MemberName";
ddlMember.DataValueField = "MemberId";
ddlMember.DataBind();
}
ddlMember.Items.Insert(0, li);
}
protected void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
membermaster.MemberName = txtMemberName.Text.Trim();
DataTable dt = objMember.GetAll(membermaster);
if (dt != null)
{
DataView dv = new DataView(dt);
dv.RowFilter = "IsApproved Is Null And IsActive Is Null";
dgvMemberMaster.DataSource = dv;
dgvMemberMaster.DataBind();
}
}
protected void LoadMembers()
{
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster member = new Entity.Common.MemberMaster();
member.CategoryId = 0;
member.BlockId = 0;
member.DistrictId = 0;
member.StateId = 0;
member.MemberName = string.Empty;
DataTable dt = objMemberMaster.GetAll(member);
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"));
}
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");
}
}
}
}
}
}
}
