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