protected void LoadReceipt(string VoucherNo) { BusinessLayer.Common.SemFeesGeneration objBill = new BusinessLayer.Common.SemFeesGeneration(); DataView DV = new DataView(objBill.SMSFeeReceipt(VoucherNo)); DataTable dt = new DataTable(); dt = DV.ToTable(); if (dt.Rows.Count > 0) { gvCshBnk.DataSource = dt; gvCshBnk.DataBind(); lblSLNo.Text = VoucherNo.ToString().Split('/').Last(); lblDate.Text = Convert.ToDateTime(dt.Rows[0]["VoucherDate"]).ToString("dd/MM/yyyy"); lblMemberName.Text = dt.Rows[0]["CBVNarration"].ToString(); gvCshBnk.FooterRow.Cells[2].Text = dt.Rows[0]["TotalAmount"].ToString(); } }
protected void btnSearch_Click(object sender, EventArgs e) { OpBal = 0; BillAmt = 0; BillTax = 0; PaidAmt = 0; PaidTax = 0; DueAmt = 0; TaxDueAmt = 0; TotalBill = 0; TotalPaid = 0; TotalDue = 0; BusinessLayer.Common.SemFeesGeneration ObjSemFees = new BusinessLayer.Common.SemFeesGeneration(); Entity.Common.SemFeesGeneration SemFees = new Entity.Common.SemFeesGeneration(); if (txtFromDate.Text == "") { SemFees.FromDate = null; } else { SemFees.FromDate = Convert.ToDateTime(txtFromDate.Text); } if (txtToDate.Text == "") { SemFees.ToDate = null; } else { SemFees.ToDate = Convert.ToDateTime(txtToDate.Text); } SemFees.MembershipCategoryId = int.Parse(ddlMembershipCategory.SelectedValue.Trim()); SemFees.BlockId = int.Parse(ddlBlock.SelectedValue.Trim()); SemFees.DistrictId = int.Parse(ddlDistrict.SelectedValue.Trim()); SemFees.StateId = int.Parse(ddlState.SelectedValue.Trim()); SemFees.Month = ""; // (ddlSubscriptionMonth.SelectedIndex == 0) ? string.Empty : ddlSubscriptionMonth.SelectedValue.Trim(); SemFees.Year = 0; // (ddlSubscriptionYear.SelectedIndex == 0) ? 0 : int.Parse(ddlSubscriptionYear.SelectedValue.Trim()); SemFees.FeesHeadId = int.Parse(ddlFeesHead.SelectedValue.Trim()); DataTable dt = ObjSemFees.GetConsolidated_StudentOutstandingReport(SemFees); if (dt != null) { dgvBill.DataSource = dt; dgvBill.DataBind(); } if (dt.Rows.Count > 0) { btnDownload.Visible = true; ((Literal)dgvBill.FooterRow.FindControl("ltrTotOpBalAmt")).Text = "<b>" + OpBal.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotBillAmt")).Text = "<b>" + BillAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxBillAmt")).Text = "<b>" + BillTax.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotPaidAmt")).Text = "<b>" + PaidAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxPaidAmt")).Text = "<b>" + PaidTax.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotDueAmt")).Text = "<b>" + DueAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxDueAmt")).Text = "<b>" + TaxDueAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotalBill")).Text = "<b>" + TotalBill.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotalPaid")).Text = "<b>" + TotalPaid.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotalDue")).Text = "<b>" + TotalDue.ToString("#0.00") + "</b>"; } else { btnDownload.Visible = false; } }