protected void LoadBillDetails() { BusinessLayer.Common.MemberFeesConfig objMemberBill = new BusinessLayer.Common.MemberFeesConfig(); DataSet ds = objMemberBill.MemberDevelopmentFeeAllMonthGetAll(MemberId, FinYrId, FromMonth, ToMonth, WithOutOpening); DataTable dt = ds.Tables[0]; //Member Details DataTable dtBill = ds.Tables[1]; //Bill Details decimal OpeningBalance = decimal.Parse(ds.Tables[2].Rows[0]["OpeningBalance"].ToString()); lblOpeningBalance.Text = OpeningBalance.ToString(); DataTable dtPaid = ds.Tables[3]; //Paid or Not // ** Populate Member Details lblMemberName.Text = (dt.Rows[0]["MemberName"] == DBNull.Value ? "" : dt.Rows[0]["MemberName"].ToString()); lblAddress.Text = (dt.Rows[0]["VillageOrStreet"] == DBNull.Value ? "" : dt.Rows[0]["VillageOrStreet"].ToString().ToUpper()) + "</br>" + (dt.Rows[0]["DistrictName"] == DBNull.Value ? "" : dt.Rows[0]["DistrictName"].ToString().ToUpper()) + ", " + (dt.Rows[0]["PIN"] == DBNull.Value ? "" : dt.Rows[0]["PIN"].ToString().ToUpper()); lblMemberCode.Text = dt.Rows[0]["MemberCode"] == DBNull.Value ? "" : dt.Rows[0]["MemberCode"].ToString().ToUpper(); if (dtBill != null) { int count = dtBill.Rows.Count; lblBillNo.Text = ((dtBill.Rows[0]["BillNo"] == DBNull.Value) ? "" : dtBill.Rows[0]["BillNo"].ToString().ToUpper()) + " - " + ((dtBill.Rows[count - 1]["BillNo"] == DBNull.Value) ? "" : dtBill.Rows[count - 1]["BillNo"].ToString().ToUpper()); lblBillDate.Text = DateTime.Parse(dtBill.Rows[0]["MonthlyRenewalDate"].ToString()).ToString("dd/MM/yyyy") + " - " + DateTime.Parse(dtBill.Rows[count - 1]["MonthlyRenewalDate"].ToString()).ToString("dd/MM/yyyy"); //lblGSTNo.Text = dt.Rows[0]["GSTNo"] == DBNull.Value ? "" : dt.Rows[0]["GSTNo"].ToString().ToUpper(); string MonthlyRate = ""; //MonthlyRate=dt.Rows[0]["FinalAmount"].ToString().ToUpper(); decimal total = 0; for (int k = 0; k < dtBill.Rows.Count; k++) { lblMonth.Text += dtBill.Rows[k]["MonthName"].ToString().ToUpper() + ", " + dtBill.Rows[k]["YearNo"].ToString().ToUpper() + "</br></br>"; lblFinalAmount.Text += ((dtBill.Rows[k]["FinalAmount"] == DBNull.Value) ? "0.00" : dtBill.Rows[k]["FinalAmount"].ToString().ToUpper()) + "</br></br>"; total += (dtBill.Rows[k]["FinalAmount"] == DBNull.Value) ? 0 : Convert.ToDecimal(dtBill.Rows[k]["FinalAmount"]); MonthlyRate += "</br></br>"; } decimal TotalAmount = (OpeningBalance + total); //if (dtPaid != null && dtPaid.Rows.Count > 0) //from here //{ // MonthlyRate += "Development Fees Paid"; // for (int c = 0; c < dtPaid.Rows.Count; c++) // { // lblMonth.Text += "On " + DateTime.Parse(dtPaid.Rows[c]["PaymentDate"].ToString()).ToString("dd/MM/yyyy") + " (" + dtPaid.Rows[c]["PaymentNo"] + ")</br></br>"; // lblFinalAmount.Text += dtPaid.Rows[c]["PaymentAmount"].ToString() + "</br></br>"; // TotalAmount -= (dtPaid.Rows[c]["PaymentAmount"] == DBNull.Value) ? 0 : Convert.ToDecimal(dtPaid.Rows[c]["PaymentAmount"]); // } //} //till here ,closed as per the request of Hironmoy lblMonthlyRate.Text += MonthlyRate; lblTotal.Text = TotalAmount == 0 ? "0.00" : TotalAmount.ToString(".00"); lblTotalInWords.Text = ConvertNumbertoWords(Convert.ToInt32(TotalAmount)) + " ONLY"; } }
private void LoadDevelopmentFeeList() { BusinessLayer.Common.MemberFeesConfig objMember = new BusinessLayer.Common.MemberFeesConfig(); DataSet ds = objMember.MemberDevelopmentFeeAllMonthGetAll(MemberId, FinYrId, FromMonth, ToMonth, 0); DataTable dt = ds.Tables[1]; if (dt.Rows.Count > 0) { dgvMemberDevelopmentFee.DataSource = dt; dgvMemberDevelopmentFee.DataBind(); btnDownload.Visible = true; btnDownload_WithOutOpening.Visible = true; } else { btnDownload.Visible = false; } }