protected void MemberDevelopmentDetails() { BusinessLayer.Common.MemberFeesConfig objFeesConfig = new BusinessLayer.Common.MemberFeesConfig(); DataTable dt = objFeesConfig.MemberDevelopmentFeeGetAll(Convert.ToInt32(ddlMember.SelectedValue)); dgvDevelopmentFee.DataSource = dt; dgvDevelopmentFee.DataBind(); }
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"; } }
protected void btnSave_Click(object sender, EventArgs e) { BusinessLayer.Common.MemberFeesConfig objFeesConfig = new BusinessLayer.Common.MemberFeesConfig(); Entity.Common.MemberFeesConfig FeesConfig = new Entity.Common.MemberFeesConfig(); FeesConfig.MemberId = Convert.ToInt32(ddlMember.SelectedValue); string strFeesXml = "<NewDataSet>"; foreach (GridViewRow gvr in dgvFeesHead.Rows) { if (gvr.RowType == DataControlRowType.DataRow) { TextBox txtAmount = (TextBox)gvr.FindControl("txtAmount"); strFeesXml += "<Row"; strFeesXml += " FeesHeadId = \"" + dgvFeesHead.DataKeys[gvr.RowIndex].Value.ToString() + "\""; strFeesXml += " Amount = \"" + (string.IsNullOrEmpty(txtAmount.Text.Trim()) ? "0" : txtAmount.Text.Trim()) + "\""; strFeesXml += " />"; } } strFeesXml += "</NewDataSet>"; FeesConfig.FeesXml = strFeesXml; string strParticularsXml = "<NewDataSet>"; foreach (GridViewRow gvr in dgvDevelopmentFee.Rows) { if (gvr.RowType == DataControlRowType.DataRow) { TextBox txtCapacity = (TextBox)gvr.FindControl("txtCapacity"); TextBox txtFee = (TextBox)gvr.FindControl("txtFee"); TextBox txtNarration = (TextBox)gvr.FindControl("txtNarration"); strParticularsXml += "<Row"; strParticularsXml += " ParticularsId = \"" + dgvDevelopmentFee.DataKeys[gvr.RowIndex].Values[1].ToString() + "\""; strParticularsXml += " Capacity = \"" + (string.IsNullOrEmpty(txtCapacity.Text.Trim()) ? "0" : txtCapacity.Text.Trim()) + "\""; strParticularsXml += " FeeAmount = \"" + (string.IsNullOrEmpty(txtFee.Text.Trim()) ? "0" : txtFee.Text.Trim()) + "\""; strParticularsXml += " Narration = \"" + txtNarration.Text.Trim().Replace("'", "''") + "\""; strParticularsXml += " />"; } } strParticularsXml += "</NewDataSet>"; FeesConfig.ParticularsXml = strParticularsXml; objFeesConfig.Save(FeesConfig); LoadFeesDetails(); Message.IsSuccess = true; Message.Text = "Fees Saved Successfully"; Message.Show = true; }
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; } }
protected void LoadFeesDetails() { MemberDevelopmentDetails(); BusinessLayer.Common.MemberFeesConfig objFeesConfig = new BusinessLayer.Common.MemberFeesConfig(); DataTable dt = objFeesConfig.GetAll(Convert.ToInt32(ddlMember.SelectedValue)); dgvFeesHead.DataSource = dt; dgvFeesHead.DataBind(); if (dt.Rows.Count > 0) { btnSave.Visible = true; } else { btnSave.Visible = false; } }
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"; } }