private void LoadRenewalFeeList()
{
MemberId = Convert.ToInt32(ddlMember.SelectedValue);
FinYrId = Convert.ToInt32(Session["FinYrID"]);
FromMonth = Convert.ToInt32(ddlFromMonth.SelectedValue);
ToMonth = Convert.ToInt32(ddlToMonth.SelectedValue);
BusinessLayer.Common.MemberFeesConfig objMember = new BusinessLayer.Common.MemberFeesConfig();
DataSet ds = objMember.MemberRenewalFeeGetAll(MemberId, FinYrId, FromMonth, ToMonth, 0);
DataTable dt = ds.Tables[1];
if (dt.Rows.Count > 0)
{
dgvMemberRenewalFee.DataSource = dt;
dgvMemberRenewalFee.DataBind();
btnDownload.Visible = true;
btnDownload_WithOutOpening.Visible = true;
}
else
{
btnDownload.Visible = false;
}
}
protected void LoadBillDetails()
{
BusinessLayer.Common.MemberFeesConfig objMember = new BusinessLayer.Common.MemberFeesConfig();
DataSet ds = objMember.MemberRenewalFeeGetAll(MemberId, FinYrId, FromMonth, ToMonth, WithOutOpening);
DataTable dt = ds.Tables[0]; //Member Details
DataTable dtBill = ds.Tables[1]; // Bill Details Month Wise
lblOpeningBalance.Text = ds.Tables[2].Rows[0]["OpeningBalance"].ToString();
//lblOpeningTax.Text = ds.Tables[1].Rows[0]["OpeningBalanceTax"].ToString();
decimal OpeningTotal = decimal.Parse(ds.Tables[2].Rows[0]["OpeningBalance"].ToString());
DataTable dtPaid = ds.Tables[3];
//** 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();
lblGSTNo.Text = dt.Rows[0]["GSTNo"] == DBNull.Value ? "" : dt.Rows[0]["GSTNo"].ToString().ToUpper();
if (dtBill.Rows.Count > 0)
{
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");
decimal Rate1 = (dtBill.Rows[0]["FinalAmount"] == DBNull.Value) ? 0 : Convert.ToDecimal(dtBill.Rows[0]["FinalAmount"]);
string MonthlyRate = "";
decimal total = 0;
for (int k = 0; k < dtBill.Rows.Count; k++)
{
lblMonth.Text += dtBill.Rows[k]["MonthName"].ToString().ToUpper() + ", " + dtBill.Rows[k]["YearNo"] + "</br></br>";
decimal Rate2 = (dtBill.Rows[k]["FinalAmount"] == DBNull.Value) ? 0 : Convert.ToDecimal(dtBill.Rows[k]["FinalAmount"]);
if ((Rate2 != Rate1) || (k == 0))
{
if (k != 0)
{
MonthlyRate += "Monthly Subscription / Renewal fees @ Rs " + Rate2 + "</br></br>";
}
else
{
MonthlyRate += (Rate2 == 0 ? "0.00" : Rate2.ToString()) + "</br></br>";
}
Rate1 = Rate2;
}
else
{
MonthlyRate += "</br></br>";
}
lblFinalAmount.Text += ((dtBill.Rows[k]["FinalAmount"] == DBNull.Value) ? "0.00" : dtBill.Rows[k]["FinalAmount"]) + "</br></br>";
total += (dtBill.Rows[k]["FinalAmount"] == DBNull.Value) ? 0 : Convert.ToDecimal(dtBill.Rows[k]["FinalAmount"]);
}
decimal TotalAmount = (OpeningTotal + total);
//if (dtPaid != null && dtPaid.Rows.Count > 0) from here
//{
// MonthlyRate += "Membership Renewal 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"]);
// }
//}
lblMonthlyRate.Text += MonthlyRate; //till here ,removed as per the request by hironmoy
//decimal TotalTax = ((TotalAmount * 18) / 100);
//lblServiceTax.Text = TotalTax == 0 ? "0.00" : TotalTax.ToString(".00");
//lblTotalAmount.Text = (TotalAmount + TotalTax) == 0 ? "0.00" : (TotalAmount + TotalTax).ToString(".00");
//lblTotalInWords.Text = ConvertNumbertoWords(Convert.ToInt32(TotalAmount + TotalTax)) + " ONLY";
lblTotalAmount.Text = TotalAmount == 0 ? "0.00" : TotalAmount.ToString(".00");
lblTotalInWords.Text = ConvertNumbertoWords(Convert.ToInt32(TotalAmount)) + " ONLY";
}
}