private void LoadConsolidatedOutstandingList() { int StateId = Convert.ToInt32(ddlState.SelectedValue.Trim()); int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim()); int BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim()); int CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim()); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); //string MemberName = txtMemberName.Text.Trim(); string MemberName = ""; int BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue); //14/10/19-business type fieldfor search int ReportType = Convert.ToInt32(ddlReportType.SelectedValue.Trim()); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataSet ds = objMemberPayment.GetOutstandingReportConsolidated(StateId, DistrictId, BlockId, CategoryId, ToDate, FromDate, MemberName, "", "", BusinessTypeId, ReportType); dgvMemberOutstanding.DataSource = ds.Tables[0]; dgvMemberOutstanding.DataBind(); Label1.Text = ds.Tables[1].Rows[0]["GrandTotal"].ToString(); if (ds.Tables[0].Rows.Count > 0) { btnDownload.Visible = true; btnSendEmail.Visible = true; Label1.Text = "Grand Total : "; Label2.Text = ds.Tables[1].Rows[0]["GrandTotal"].ToString(); } else { btnDownload.Visible = false; btnSendEmail.Visible = false; Label1.Text = "Grand Total : "; Label2.Text = "0.00"; } }
private void LoadPaymentList() { string PaymentNo = txtPaymentNo.Text.Trim(); string PaymentMode = ddlPaymentMode.SelectedValue; int CashBankLedgerId = Convert.ToInt32(ddlCashBankLedger.SelectedValue); int MemberId = Convert.ToInt32(ddlMember.SelectedValue); DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = objMemberPayment.GetDevelopmentFeesPaymentReport(PaymentNo, CashBankLedgerId, PaymentMode, FromDate, ToDate, MemberId); TotalDevelopmentFee = 0; dt.AsEnumerable().ToList().ForEach(row => { TotalDevelopmentFee += Convert.ToDecimal(row["DevelopmentFeesPaymentAmount"].ToString()); }); dgvPaymentReport.DataSource = dt; dgvPaymentReport.DataBind(); if (dt.Rows.Count > 0) { dgvPaymentReport.FooterRow.Cells[6].Text = TotalDevelopmentFee.ToString("F2"); btnDownload.Visible = true; } else { btnDownload.Visible = false; } }
private void BindUploadList() { //dgvError.DataSource = null; //dgvError.DataBind(); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = objMemberPayment.GetFeesHeadWisePaymentReport("", 0, "All", DateTime.MinValue, DateTime.MinValue, 0, 0); DataView dv = new DataView(dt); dv.RowFilter = "IsExcelUpload = 'True'"; dtList = dv.ToTable(); dgvPaymentReport.DataSource = dtList; dgvPaymentReport.DataBind(); BindFooter(); if (dtList.Rows.Count > 0) { btnDownload.Visible = true; } else { btnDownload.Visible = false; } }
private void LoadMemberOutstandingList() { int MemberId = Convert.ToInt32(Request.QueryString["MemberId"].ToString()); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataSet ds = objMemberPayment.GetDevelopmentFeesOutstandingReport(MemberId, FromDate, ToDate); if (ds.Tables[0].Rows.Count > 0) { StringBuilder sb = new StringBuilder(); sb.Append("To,<br/>"); sb.Append(ds.Tables[0].Rows[0]["MemberName"].ToString().ToUpper() + "<br/>"); sb.Append(ds.Tables[0].Rows[0]["BlockName"].ToString().ToUpper() + ", " + ds.Tables[0].Rows[0]["DistrictName"].ToString().ToUpper() + "<br/>"); sb.Append(ds.Tables[0].Rows[0]["StateName"].ToString().ToUpper() + "<br/>"); sb.Append("Mobile No. " + ds.Tables[0].Rows[0]["MobileNo"].ToString().ToUpper()); lblMemberDetail.Text = Server.HtmlDecode(sb.ToString()); sb = new StringBuilder(); sb.Append("Date: " + DateTime.Now.ToString("dd.MM.yyyy") + "<br/>"); sb.Append("<b>Membership No. </b>" + ds.Tables[0].Rows[0]["MemberCode"].ToString().ToUpper() + "<br/>"); sb.Append("<b>Membership Date </b>" + Convert.ToDateTime(ds.Tables[0].Rows[0]["MembershipDate"]).ToString("dd/MM/yyyy")); lblDate.Text = Server.HtmlDecode(sb.ToString()); } dgvReport.DataSource = ds.Tables[1]; dgvReport.DataBind(); }
private void LoadPaymentDetail(string PaymentNo) { BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dtPayment = objMemberPayment.GetFeesHeadWisePaymentReport(PaymentNo, 0, "All", DateTime.MinValue, DateTime.MinValue, 0, 0); if (dtPayment != null) { lblSLNo.Text = dtPayment.Rows[0]["SrlNo"].ToString(); lblMemberCode.Text = dtPayment.Rows[0]["MemberCode"].ToString(); lblMemberName.Text = dtPayment.Rows[0]["MemberName"].ToString(); lblPO.Text = dtPayment.Rows[0]["PO"].ToString(); lblBlock.Text = dtPayment.Rows[0]["BlockName"].ToString(); lblDistrict.Text = dtPayment.Rows[0]["DistrictName"].ToString(); lblDate.Text = Convert.ToDateTime(dtPayment.Rows[0]["PaymentDate"].ToString()).ToString("dd/MM/yyyy"); lblPAC.Text = ""; lblSum.Text = dtPayment.Rows[0]["RenewalFeesPaymentAmount"].ToString(); lblGST.Text = dtPayment.Rows[0]["RenewalFeesTaxPaymentAmount"].ToString(); lblAdmissionFee.Text = dtPayment.Rows[0]["AdmissionFeesPaymentAmount"].ToString(); lblAdmissionGST.Text = dtPayment.Rows[0]["AdmissionFeesTaxPaymentAmount"].ToString(); lblDevelopmentFee.Text = dtPayment.Rows[0]["DevelopmentPaymentAmount"].ToString(); lblTotal.Text = dtPayment.Rows[0]["PaymentAmount"].ToString(); lblNarration.Text = dtPayment.Rows[0]["Narration"].ToString(); lblChequeNo.Text = dtPayment.Rows[0]["PaymentMode"].ToString(); } }
private void LoadConsolidatedOutstandingList() { int StateId = Convert.ToInt32(ddlState.SelectedValue.Trim()); int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim()); int BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim()); int CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim()); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); //string MemberName = txtMemberName.Text.Trim(); string MemberName = ""; int BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue); //14/10/19-business type fieldfor search int ReportType = Convert.ToInt32(ddlReportType.SelectedValue.Trim()); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataSet ds = objMemberPayment.GetOutstandingReportConsolidatedNew(StateId, DistrictId, BlockId, CategoryId, ToDate, FromDate, MemberName, "", "", BusinessTypeId, ReportType); dgvMemberOutstanding.DataSource = ds.Tables[0]; dgvMemberOutstanding.DataBind(); btnDownload.Visible = true; //btnSendEmail_Click.Visible = false; ////dgvMemberOutstanding.FindControl("lbl_GrandOpeningBalance"); // ((Label)dgvMemberOutstanding.FooterRow.FindControl("lbl_GrandOpeningBalance")).Text = ds.Tables[0].Compute("Sum(TotalOpening)", "").ToString(); ////lbl_GrandTotalBill.Text = ds.Tables[0].Compute("Sum(TotalBill)", "").ToString(); ////lbl_GrandTotalPaid.Text = ds.Tables[0].Compute("Sum(Totalpaid)", "").ToString(); ////lbl_GrandTotalDue.Text = ds.Tables[0].Compute("Sum(TotalDue)", "").ToString(); }
protected void LoadFeeCollectionReport() { int DistrictId = int.Parse(ddlDistrict.SelectedValue); string FromDate1 = (txtFromDate.Text.ToString()); string ToDate1 = (txtToDate.Text.ToString()); DateTime FromDate, ToDate; if (FromDate1 != "" && ToDate1 != "") { FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); } else { FromDate = DateTime.MinValue; ToDate = DateTime.MinValue; } BusinessLayer.Common.MemberPayment ObjFee = new BusinessLayer.Common.MemberPayment(); DataTable dt = ObjFee.GetFeeCollectionBusinessTypeReport(DistrictId, FromDate, ToDate); if (dt.Rows.Count > 0) { dgvFeeCollectionReport.DataSource = dt; dgvFeeCollectionReport.DataBind(); btnExportExcel.Visible = true; } else { btnExportExcel.Visible = false; } //Total Footer Added }
private void LoadConsolidatedOutstandingList() { int StateId = Convert.ToInt32(ddlState.SelectedValue.Trim()); int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim()); int BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim()); int CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim()); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); DateTime FromDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); string MemberName = txtMemberName.Text.Trim(); string MemberCode = txtMemberCode.Text.Trim(); string MobileNo = txtMobileNo.Text.Trim(); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = objMemberPayment.GetExecutiveCommitteeReport(StateId, DistrictId, BlockId, CategoryId, ToDate, FromDate, MemberName, MemberCode, MobileNo); dgvMemberOutstanding.DataSource = dt; dgvMemberOutstanding.DataBind(); if (dt.Rows.Count > 0) { btnDownload.Visible = true; } else { btnDownload.Visible = false; } }
protected void dgvPaymentReport_RowDeleting(object sender, GridViewDeleteEventArgs e) { BusinessLayer.Common.MemberPayment ObjMemberPayment = new BusinessLayer.Common.MemberPayment(); int Id = Convert.ToInt32(dgvPaymentReport.DataKeys[e.RowIndex].Values["PaymentId"].ToString()); ObjMemberPayment.Delete(Id); LoadPaymentList(); }
protected void dgvPaymentReport_RowDeleting(object sender, GridViewDeleteEventArgs e) { BusinessLayer.Common.MemberPayment ObjMemberPayment = new BusinessLayer.Common.MemberPayment(); int Id = Convert.ToInt32(dgvPaymentReport.DataKeys[e.RowIndex].Values["PaymentId"].ToString()); ObjMemberPayment.Delete(Id); BindUploadList(); ShowMessage("Payment detail deleted successfully", true); }
private void LoadPaymentList() { string PaymentNo = txtPaymentNo.Text.Trim(); string PaymentMode = ddlPaymentMode.SelectedValue; int CashBankLedgerId = Convert.ToInt32(ddlCashBankLedger.SelectedValue); int MemberId = Convert.ToInt32(ddlMember.SelectedValue); DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); int BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = objMemberPayment.GetFeesHeadWisePaymentReport(PaymentNo, CashBankLedgerId, PaymentMode, FromDate, ToDate, MemberId, BusinessTypeId); DataView dv = new DataView(dt); if (Session["UserType"].ToString().Equals("Agent")) { dv.RowFilter = "CreatedBy = " + Session["UserId"].ToString() + " AND CreatedByUserType = 'Agent'"; } dt = dv.ToTable(); decimal TotalAdmissionFees = 0, TotalAdmissionFeesTax = 0, TotalRenewalFees = 0, TotalRenewalFeesTax = 0, Total = 0, TotalDevelopmentFee = 0; dt.AsEnumerable().ToList().ForEach(row => { Total += Convert.ToDecimal(row["PaymentAmount"].ToString()); TotalAdmissionFees += Convert.ToDecimal(row["AdmissionFeesPaymentAmount"].ToString()); TotalRenewalFees += Convert.ToDecimal(row["RenewalFeesPaymentAmount"].ToString()); TotalAdmissionFeesTax += Convert.ToDecimal(row["AdmissionFeesTaxPaymentAmount"].ToString()); TotalRenewalFeesTax += Convert.ToDecimal(row["RenewalFeesTaxPaymentAmount"].ToString()); TotalDevelopmentFee += Convert.ToDecimal(row["DevelopmentPaymentAmount"].ToString()); }); dgvPaymentReport.DataSource = dt; dgvPaymentReport.DataBind(); if (dt.Rows.Count > 0) { dgvPaymentReport.FooterRow.Cells[6].Text = TotalAdmissionFees.ToString("F2"); dgvPaymentReport.FooterRow.Cells[7].Text = TotalAdmissionFeesTax.ToString("F2"); dgvPaymentReport.FooterRow.Cells[8].Text = TotalRenewalFees.ToString("F2"); dgvPaymentReport.FooterRow.Cells[9].Text = TotalRenewalFeesTax.ToString("F2"); dgvPaymentReport.FooterRow.Cells[10].Text = TotalDevelopmentFee.ToString("F2"); dgvPaymentReport.FooterRow.Cells[11].Text = Total.ToString("F2"); btnDownload.Visible = true; } else { btnDownload.Visible = false; } }
protected void dgvPaymentReport_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Approve")) { BusinessLayer.Common.MemberPayment ObjMemberPayment = new BusinessLayer.Common.MemberPayment(); ObjMemberPayment.Approve(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session["UserId"].ToString())); LoadPaymentList(); Message.IsSuccess = true; Message.Text = "Payment Approved"; Message.Show = true; } }
protected void btnSearch_Click(object sender, EventArgs e) { int BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim()); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); int i = objMemberPayment.GenerateMemberBill_SpecialCase(BlockId); if (i > 0) { Message.IsSuccess = true; Message.Text = "Bill Generated Successfully"; Message.Show = true; } }
private void LoadMemberOutstandingList() { int MemberId = Convert.ToInt32(ddlMember.SelectedValue); DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataSet ds = objMemberPayment.GetOutstandingReport(MemberId, FromDate, ToDate); if (ds.Tables[0].Rows.Count > 0) { StringBuilder sb = new StringBuilder(); sb.Append("To,<br/>"); sb.Append(ds.Tables[0].Rows[0]["MemberName"].ToString().ToUpper() + "<br/>"); sb.Append(ds.Tables[0].Rows[0]["BlockName"].ToString().ToUpper() + ", " + ds.Tables[0].Rows[0]["DistrictName"].ToString().ToUpper() + "<br/>"); sb.Append(ds.Tables[0].Rows[0]["StateName"].ToString().ToUpper() + "<br/>"); sb.Append("Mobile No. " + ds.Tables[0].Rows[0]["MobileNo"].ToString().ToUpper()); lblMemberDetail.Text = Server.HtmlDecode(sb.ToString()); sb = new StringBuilder(); sb.Append("Date: " + DateTime.Now.ToString("dd.MM.yyyy") + "<br/>"); sb.Append("<b>Membership No. </b>" + ds.Tables[0].Rows[0]["MemberCode"].ToString().ToUpper() + "<br/>"); sb.Append("<b>Membership Date </b>" + Convert.ToDateTime(ds.Tables[0].Rows[0]["MembershipDate"]).ToString("dd/MM/yyyy")); lblDate.Text = Server.HtmlDecode(sb.ToString()); } dgvReport.DataSource = ds.Tables[1]; dgvReport.DataBind(); //dgvMemberOutstanding.DataSource = dt; //dgvMemberOutstanding.DataBind(); //if (dt.Rows.Count > 0) //{ // btnDownload.Visible = true; // } //else //{ //btnDownload.Visible = false; // } }
private void LoadPaymentDetail() { BusinessLayer.Common.MemberPayment ObjMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dtPayment = ObjMemberPayment.GetAllById(PaymentId); txtPaymentNo.Text = dtPayment.Rows[0]["PaymentNo"].ToString(); ddlMember.SelectedValue = dtPayment.Rows[0]["MemberId"].ToString(); ddlMember.Enabled = false; txtMobileNo.Enabled = false; btnSearch.Enabled = false; txtPaymentAmount.Text = dtPayment.Rows[0]["PaymentAmount"].ToString(); ddlPaymentMode.SelectedValue = dtPayment.Rows[0]["PaymentMode"].ToString(); hdnAmount.Value = dtPayment.Rows[0]["PaymentAmount"].ToString(); if (Session["UserType"].ToString().Equals("Member"))//Session["UserType"].ToString().Equals("Agent") || { ddlPaymentMode.Enabled = false; } else { ddlPaymentMode.Enabled = true; } txtPaymentDate.Text = Convert.ToDateTime(dtPayment.Rows[0]["PaymentDate"].ToString()).ToString("dd/MM/yyyy"); txtPaymentDate.Enabled = false; ddlCashBankLedger.SelectedValue = dtPayment.Rows[0]["CashBankLedgerId"].ToString(); if (Session["UserType"].ToString().Equals("Agent") || Session["UserType"].ToString().Equals("Member")) { ddlCashBankLedger.Enabled = false; } else { ddlCashBankLedger.Enabled = true; } LoadLedgerOpeningBalance(); txtNarration.Text = dtPayment.Rows[0]["Narration"].ToString(); Message.Show = false; }
private void LoadMemberOutstandingList() { int FinYrId = Convert.ToInt32(Session["FinYrID"].ToString()); int MemberId = Convert.ToInt32(ddlMember.SelectedValue); if (MemberId != 0) { BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = objMemberPayment.GetOutstanding(MemberId, PaymentId, FinYrId); dgvMemberOutstanding.DataSource = dt; dgvMemberOutstanding.DataBind(); PaymentAmount = 1;//Convert.ToDecimal(dt.Compute("Sum(FeesOutstandingAmount)", string.Empty)) + //Convert.ToDecimal(dt.Compute("Sum(TaxOutstandingAmount)", string.Empty)); } else { dgvMemberOutstanding.DataSource = null; dgvMemberOutstanding.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { int FeesHeadId = Convert.ToInt32(ddlFeesHead.SelectedValue); DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); BusinessLayer.Common.MemberPayment ObjMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = ObjMemberPayment.GetServiceTaxReport(FeesHeadId, FromDate, ToDate); dgvServiceTax.DataSource = dt; dgvServiceTax.DataBind(); if (dt.Rows.Count > 0) { btnExport.Visible = true; } else { btnExport.Visible = false; } }
private void LoadPaymentList() { int AgentId = Convert.ToInt32(ddlAgent.SelectedValue); DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]); DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]); bool?IsApproved = null; if (ddlApprovalStatus.SelectedIndex == 1) { IsApproved = true; } else if (ddlApprovalStatus.SelectedIndex == 2) { IsApproved = false; } BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataTable dt = objMemberPayment.GetAgentWisePaymentReport(AgentId, FromDate, ToDate, IsApproved); decimal TotalPaymentAmount = 0; dt.AsEnumerable().ToList().ForEach(row => { TotalPaymentAmount += Convert.ToDecimal(row["PaymentAmount"].ToString()); }); dgvPaymentReport.DataSource = dt; dgvPaymentReport.DataBind(); if (dt.Rows.Count > 0) { dgvPaymentReport.FooterRow.Cells[6].Text = TotalPaymentAmount.ToString("F2"); btnDownload.Visible = true; } else { btnDownload.Visible = false; } }
private void LoadMemberOutstandingList() { int FinYrId = Convert.ToInt32(Session["FinYrID"].ToString()); int MemberId = Convert.ToInt32(ddlMember.SelectedValue); if (MemberId != 0) { BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); DataView DV = new DataView(objMemberPayment.GetOutstanding(MemberId, PaymentId, FinYrId)); DV.RowFilter = "FeesHeadId IN (1,2)"; DataTable dt = new DataTable(); dt = DV.ToTable(); if (dt != null) { dgvMemberOutstanding.DataSource = dt; dgvMemberOutstanding.DataBind(); } } else { dgvMemberOutstanding.DataSource = null; dgvMemberOutstanding.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { //if (!IsPostBack) //{ //if (Request.Form["encResp"] != null && Request.Form["encResp"].Length > 0) { Response.Write("<script>alert('Payment Cancel '" + Request.Form["encResp"] + ");</script>"); } try { Message.Show = false; if (Request.Form.AllKeys.Contains("encResp")) { if (Request.Form["encResp"] != null && Request.Form["encResp"].Length > 0) { string workingKey = "FF119789EA009958AC9FF44758A5A526";// "272ECCEC820303D21327C07B92A5A367";//"FF119789EA009958AC9FF44758A5A526";//put in the 32bit alpha numeric key in the quotes provided here CCA.Util.CCACrypto ccaCrypto = new CCA.Util.CCACrypto(); string encResponse = ccaCrypto.Decrypt(Request.Form["encResp"], workingKey); NameValueCollection Params = new NameValueCollection(); string[] segments = encResponse.Split('&'); foreach (string seg in segments) { string[] parts = seg.Split('='); if (parts.Length > 0) { string Key = parts[0].Trim(); string Value = parts[1].Trim(); Params.Add(Key, Value); } } #region //string jsMethodName = ""; //for (int i = 0; i < Params.Count; i++) //{ // StringBuilder sb = new StringBuilder(); // jsMethodName+=("<tr><td class='label'>" + Params.Keys[i] + "</td><td>" + Params[i] + "</td></tr>"); // //Response.Write(Params.Keys[i] + " = " + Params[i] + "<br>"); //} //string[] values = null; //foreach (string key in Params.Keys) //{ // values = Params.GetValues(key); // foreach (string value in values) // { // //MessageBox.Show(key + " - " + value); // //if (key.Equals("order_id")) // //{ // // lblOrderId.Text = Params["order_id"]; // //} // Response.Write(key + " = " + value + "<br>"); // } //} #endregion order_id.Text = Params["order_id"]; tracking_id.Text = Params["tracking_id"]; bank_ref_no.Text = Params["bank_ref_no"]; order_status.Text = Params["order_status"]; mer_amount.Text = Params["mer_amount"]; trans_date.Text = Params["trans_date"]; failure_message.Text = Params["failure_message"]; payment_mode.Text = Params["payment_mode"]; billing_name.Text = Params["billing_name"]; //ScriptManager.RegisterClientScriptBlock(this, typeof(string), "ALert", "alert('" + jsMethodName + "')", true); Entity.Common.PaymentGateway payment = new Entity.Common.PaymentGateway(); payment.PaymentId = Convert.ToInt32(Params["merchant_param1"]); payment.MemberId = Convert.ToInt32(Params["merchant_param2"]); payment.MemberType = Params["merchant_param3"]; payment.OrderId = Params["order_id"]; payment.TrackingId = Params["tracking_id"]; payment.BankRefNo = Params["bank_ref_no"]; payment.OrderStatus = Params["order_status"]; payment.PaymentAmount = Convert.ToDecimal(Params["mer_amount"]); payment.FailureMessage = Params["failure_message"]; payment.PaymentMode = Params["payment_mode"]; string transDate = Params["trans_date"]; if (transDate != null && transDate.Length > 0) { string[] tranDate = transDate.Split(' '); string[] tranDate1 = tranDate[0].Split('/'); payment.PaymentDate = Convert.ToDateTime(tranDate1[2] + "-" + tranDate1[1] + "-" + tranDate1[0] + " " + tranDate[1]);// Params["trans_date"]); } else { payment.PaymentDate = DateTime.Now; } payment.Currency = Params["currency"]; payment.CardName = Params["card_name"]; payment.StatusCode = Params["status_code"]; payment.StatusMessage = Params["status_message"]; payment.CardName = Params["card_name"]; payment.CreatedBy = Session["UserId"] != null?Convert.ToInt32(Session["UserId"]) : 0; BusinessLayer.Common.MemberPayment ObjPayment = new BusinessLayer.Common.MemberPayment(); //DataTable DT = ObjPayment.GetAllById(payment.PaymentId); //if (Convert.ToDecimal(DT.Rows[0]["PaymentAmount"]) == payment.PaymentAmount) //{ ObjPayment.PaymentResponseSave(payment); //} //else //{ // order_status.Text = "Transaction Failed"; // failure_message.Text = "Amount is not matched"; //} if (payment.OrderStatus == "Success") { order_status.ForeColor = System.Drawing.Color.Green; Message.IsSuccess = true; Message.Text = "Payment detail saved successfully"; } else { order_status.ForeColor = System.Drawing.Color.Red; failure_message.ForeColor = System.Drawing.Color.Red; Message.IsSuccess = false; Message.Text = "Please try again later!"; } Message.Show = true; } else { Response.Write("<script>alert('Payment Cancel ');</script>"); } } else { Response.Write("<script>alert('Payment Cancel ');</script>"); } } catch (Exception ex) { Message.Text = ex.Message; Message.Show = true; } //} }
protected void btnSave_Click(object sender, EventArgs e) { Message.Show = false; FeesXml = "<NewDataSet>"; foreach (GridViewRow gvr in dgvMemberOutstanding.Rows) { if (gvr.RowType == DataControlRowType.DataRow) { FeesXml += "<Row"; FeesXml += " FeesHeadId = \"" + dgvMemberOutstanding.DataKeys[gvr.RowIndex].Values["FeesHeadId"].ToString() + "\""; FeesXml += " FeesPaymentAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtFeesPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtFeesPaymentAmount")).Text.Trim()) + "\""; FeesXml += " TaxPaymentAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) + "\""; FeesXml += " />"; } } FeesXml += "</NewDataSet>"; BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment(); Entity.Common.MemberPayment payment = new Entity.Common.MemberPayment(); payment.PaymentId = PaymentId; payment.MemberId = Convert.ToInt32(ddlMember.SelectedValue); payment.PaymentMode = ddlPaymentMode.SelectedValue; payment.PaymentDate = Convert.ToDateTime(txtPaymentDate.Text.Split('/')[2] + "-" + txtPaymentDate.Text.Split('/')[1] + "-" + txtPaymentDate.Text.Split('/')[0]); //if (Session["UserType"].ToString().Equals("Member")) { payment.PaymentAmount = PaymentAmount; }//PaymentAmount; } //else //{ payment.PaymentAmount = Convert.ToDecimal(hdnAmount.Value.Trim()); //} payment.Narration = txtNarration.Text.Trim(); payment.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); payment.CreatedByUserType = Session["UserType"].ToString(); payment.CashBankLedgerId = Convert.ToInt32(ddlCashBankLedger.SelectedValue); payment.FeesXml = FeesXml; payment.IsExcelUpload = false; if (Session["UserType"].ToString().Equals("Admin") || Session["UserType"].ToString().Equals("Agent")) { payment.IsApproved = true; payment.ApprovedBy = Convert.ToInt32(Session["UserId"].ToString()); payment.ApprovedDate = DateTime.Now; } else { payment.IsApproved = null; payment.ApprovedBy = null; payment.ApprovedDate = null; } string strPaymentNo = objMemberPayment.Save(payment); PaymentId = 0; txtPaymentNo.Text = strPaymentNo; LoadMemberOutstandingList(); txtPaymentAmount.Text = "0.00"; txtPaymentDate.Enabled = true; txtNarration.Text = ""; LoadLedgerOpeningBalance(); btnPrint.Visible = true; Message.IsSuccess = true; Message.Text = "Payment detail saved successfully"; Message.Show = true; if (Session["UserType"].ToString().Equals("Member") && ddlPaymentMode.SelectedItem.Text.ToUpper().Equals("ONLINE PAYMENT")) { //Response.Redirect(@"https://www.onlinesbi.com/prelogin/icollecthome.htm?corpid=649959"); BusinessLayer.Common.MemberPayment ObjPayment = new BusinessLayer.Common.MemberPayment(); Entity.Common.PaymentGateway paymentGate = new Entity.Common.PaymentGateway(); paymentGate.PaymentId = payment.PaymentId; paymentGate.MemberId = payment.MemberId; paymentGate.MemberType = "Member"; paymentGate.OrderId = GetAutoTransactionId(); paymentGate.PaymentAmount = payment.PaymentAmount; paymentGate.Currency = "INR"; paymentGate.CreatedBy = payment.CreatedBy; ObjPayment.PaymentResponseSave(paymentGate);//&tid=76023071 string ccaRequest = "merchant_id=211354&order_id=" + paymentGate.OrderId + "&amount=" + payment.PaymentAmount + "¤cy=INR&" + "redirect_url=http://accounts.wbpoultryfederation.org/ccavResponseHandler.aspx&cancel_url=http://accounts.wbpoultryfederation.org/MemberDefault.aspx&"; //+ "redirect_url=http://localhost:1044/ccavResponseHandler.aspx&cancel_url=http://localhost:1044/ccavResponseHandler.aspx&"; ccaRequest += "billing_name=" + ddlMember.SelectedItem.Text + "&billing_address=46C, Chowringhee Road, 11th Floor, Room No - C&billing_city=Kolkata&billing_state=West Bengal&billing_zip=700071&billing_country=India&billing_tel=03365229085&[email protected]&" + "delivery_name=" + ddlMember.SelectedItem.Text + "&delivery_address=46C, Chowringhee Road, 11th Floor, Room No - C&delivery_city=Kolkata&delivery_state=West Bengal&delivery_zip=700071&delivery_country=India&delivery_tel=03365229085" + "&merchant_param1=" + payment.PaymentId + "&merchant_param2=" + payment.MemberId + "&merchant_param3=Member"; string strEncRequest = ccaCrypto.Encrypt(ccaRequest, workingKey); Response.Redirect("../ccavRequestHandler.aspx?DATA=" + strEncRequest); } //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "VariableRegisteration", "window.open('renewal-bill.aspx?PaymentNo=" + strPaymentNo + "','','height=600,width=1000')", true); }