private void LoadMemberOutstandingList() { int FinYrId = Convert.ToInt32(Session["FinYrID"].ToString()); int MemberId = Convert.ToInt32(ddlMember.SelectedValue); if (MemberId != 0) { BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = objMemberPayment.GetOutstanding(MemberId, PaymentId, FinYrId); dgvMemberOutstanding.DataSource = dt; dgvMemberOutstanding.DataBind(); PaymentAmount = 1;//Convert.ToDecimal(dt.Compute("Sum(FeesOutstandingAmount)", string.Empty)) + //Convert.ToDecimal(dt.Compute("Sum(TaxOutstandingAmount)", string.Empty)); } else { dgvMemberOutstanding.DataSource = null; dgvMemberOutstanding.DataBind(); } }
private void LoadMemberOutstandingList() { int FinYrId = Convert.ToInt32(Session["FinYrID"].ToString()); int MemberId = Convert.ToInt32(ddlMember.SelectedValue); if (MemberId != 0) { BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataView DV = new DataView(objMemberPayment.GetOutstanding(MemberId, PaymentId, FinYrId)); DV.RowFilter = "FeesHeadId IN (1,2)"; DataTable dt = new DataTable(); dt = DV.ToTable(); if (dt != null) { dgvMemberOutstanding.DataSource = dt; dgvMemberOutstanding.DataBind(); } } else { dgvMemberOutstanding.DataSource = null; dgvMemberOutstanding.DataBind(); } }