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