public XObjs.InterSwitchPostFields getISWtransactionByTransactionID(string txnref) { XObjs.InterSwitchPostFields x = new XObjs.InterSwitchPostFields(); SqlConnection connection = new SqlConnection(this.ConnectXpay()); SqlCommand command = new SqlCommand("SELECT * FROM InterSwitchPostFields WHERE txn_ref='" + txnref + "' ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { x.xid = reader["xid"].ToString(); x.product_id = reader["product_id"].ToString(); x.amount = reader["amount"].ToString(); x.isw_conv_fee = reader["isw_conv_fee"].ToString(); x.currency = reader["currency"].ToString(); x.site_redirect_url = reader["site_redirect_url"].ToString(); x.txn_ref = reader["txn_ref"].ToString(); x.hash = reader["hash"].ToString(); x.mackey = reader["mackey"].ToString(); x.pay_item_id = reader["pay_item_id"].ToString(); x.site_name = reader["site_name"].ToString(); x.cust_id = reader["cust_id"].ToString(); x.cust_id_desc = reader["cust_id_desc"].ToString(); x.cust_name = reader["cust_name"].ToString(); x.resp_desc = reader["resp_desc"].ToString(); x.pay_item_name = reader["pay_item_name"].ToString(); x.local_date_time = reader["local_date_time"].ToString(); x.TransactionDate = reader["TransactionDate"].ToString(); x.MerchantReference = reader["MerchantReference"].ToString(); x.trans_status = reader["trans_status"].ToString(); x.pay_ref = reader["pay_ref"].ToString(); x.ret_ref = reader["ret_ref"].ToString(); x.xreg_date = reader["xreg_date"].ToString(); x.xvisible = reader["xvisible"].ToString(); x.xsync = reader["xsync"].ToString(); } reader.Close(); return x; }
protected void btnSearch_Click(object sender, EventArgs e) { this.xsearch = this.txt_status.Text.Trim(); string txnref; if (this.xsearch.Contains("-")) { txnref = this.xsearch.Trim().Split(new char[] { '-' })[0]; } else { txnref = this.xsearch; } this.c_twall = this.ret.getTwalletByTransIDAdminID(txnref, this.adminID, this.agentType); this.c_app = this.ret.getApplicantByID(this.c_twall.applicantID); if (this.c_twall.xid != null) { if (this.c_twall.xgt == "xpay_bk") { this.xgt_type = "Bank"; } else { if (this.c_twall.xgt == "xpay_isw") { this.xgt_type = "Inter switch"; } else { this.xgt_type = "None"; } } if (this.c_twall.xpay_status == "1") { this.payment_status = "Paid"; } else { if (this.c_twall.xpay_status == "2") { this.payment_status = "Pending"; } else { this.payment_status = "Failed"; } } this.Session["c_twall"] = this.c_twall; this.lt_fdets = this.ret.getFee_detailsByTwalletID(this.c_twall.xid); if (this.lt_fdets.Count > 0) { this.Session["lt_fdets"] = this.lt_fdets; } this.lt_hwall = this.ret.getHwalletByTransID(txnref); this.isw_fields = this.ret.getISWtransactionByTransactionID(txnref); this.isw_fields.TransactionDate = this.isw_fields.TransactionDate.Substring(0, 11).Trim(); int num = 1; int num2 = 0; foreach (XObjs.Hwallet current in this.lt_hwall) { XObjs.PaymentReciept paymentReciept = new XObjs.PaymentReciept(); XObjs.Fee_list fee_list = new XObjs.Fee_list(); fee_list = this.ret.getFee_listByID(this.ret.getFee_detailsByID(current.fee_detailsID).fee_listID); paymentReciept.sn = num.ToString(); paymentReciept.item_code = fee_list.item_code; paymentReciept.item_desc = fee_list.xdesc; int num3 = Convert.ToInt32(fee_list.init_amt) + Convert.ToInt32(fee_list.tech_amt); paymentReciept.amount = string.Format("{0:n}", num3); paymentReciept.transID = string.Concat(new string[] { current.transID, "-", current.fee_detailsID, "-", current.xid }); num2 += Convert.ToInt32(num3); this.lt_pr.Add(paymentReciept); num++; } this.total_amt = string.Format("{0:n}", (double)num2 + Math.Round(Convert.ToDouble(this.isw_fields.isw_conv_fee), 2)); this.show_receipt = 1; this.show_search = 0; return; } this.show_receipt = 0; this.show_search = 1; }
protected void gvTm_RowCommand(object sender, GridViewCommandEventArgs e) { if ((Session["tm_cnt"] != null) && (Session["tm_cnt"].ToString() != "")) { tm_cnt = Convert.ToInt32(Session["tm_cnt"]); } if ((Session["lt_ri"] != null) && (Session["lt_ri"].ToString() != "")) { lt_ri = (List<XObjs.ReportItem>)Session["lt_ri"]; } gvTm.DataSource = lt_ri; gvTm.DataBind(); if (e.CommandName == "TmPayClick") { GridViewRow namingContainer = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int rowIndex = namingContainer.RowIndex; string txnref = e.CommandArgument.ToString(); xispf = ret.getISWtransactionByTransactionID(txnref); if ((xispf.xid != null) && (xispf.xid != null)) { Session["xispf"] = xispf; base.Response.Redirect("../xis/pd/tx/re_payment_details.aspx"); } } if (e.CommandName == "TmReqClick") { string str2 = DateTime.Now.ToString("dd-MMM-yy HH:MM:ss"); GridViewRow row2 = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int num2 = row2.RowIndex; string str3 = e.CommandArgument.ToString(); int num = 0; isw_fields = ret.getISWtransactionByTransactionID(str3); string inputString = isw_fields.product_id + isw_fields.txn_ref + isw_fields.mackey; string headerValue = hash_value.GetGetSHA512String(inputString); isr = tx.myRedirect(check_trans_page + "?productid=" + isw_fields.product_id + "&transactionreference=" + isw_fields.txn_ref + "&amount=" + isw_fields.amount, "Hash", headerValue); if ((((isr.ResponseCode != "") && (isr.ResponseCode != null)) && ((isr.PaymentReference != "") && (isr.PaymentReference != null))) && ((isr.ResponseDescription != "") && (isr.ResponseDescription != null))) { if (isw_fields.txn_ref == null) { isw_fields.txn_ref = ""; } if (isw_fields.pay_ref == null) { isw_fields.pay_ref = ""; } if (isw_fields.ret_ref == null) { isw_fields.ret_ref = ""; } if (isr.ResponseCode == null) { isr.ResponseCode = ""; } if (isr.TransactionDate == null) { isr.TransactionDate = ""; } if (isr.MerchantReference == null) { isr.MerchantReference = ""; } if (isr.ResponseDescription == null) { isr.ResponseDescription = ""; } xstring.AppendLine("Sent Amount: " + isw_fields.amount + "\r\n Product ID: " + isw_fields.product_id + "\r\n Hash: " + headerValue + "\r\n Amount: " + isr.Amount + "\r\n CardNumber: " + isr.CardNumber + "\r\n MerchantReference: " + isr.MerchantReference + "\r\n PaymentReference: " + isr.PaymentReference + "\r\n RetrievalReferenceNumber: " + isr.RetrievalReferenceNumber + "\r\n LeadBankCbnCode: " + isr.LeadBankCbnCode + "\r\n TransactionDate: " + isr.TransactionDate + "\r\n ResponseCode: " + isr.ResponseCode + "\r\n ResponseDescription: " + isr.ResponseDescription + "\r\n Json Page: " + check_trans_page); if (isw_fields.txn_ref != "") { docpath = base.Server.MapPath("~/") + "LiveInterLogs/Ag/" + isw_fields.txn_ref + ".txt"; num = x.WriteToFile(xstring.ToString(), docpath); } else { docpath = base.Server.MapPath("~/") + "LiveInterLogs/Ag/xxx.txt"; num = x.WriteToFile(xstring.ToString(), docpath); } if ((isr.ResponseCode == "") || (isr.ResponseCode == null)) { xpay_status = "2"; } else if (isr.ResponseCode == "00") { xpay_status = "1"; } else { xpay_status = "3"; } num = reg.updateInterSwitchRecords(isw_fields.txn_ref, isw_fields.pay_ref, isw_fields.ret_ref, isr.ResponseCode, isr.TransactionDate, isr.MerchantReference, isr.ResponseDescription); reg.updateTwalletPaymentStatus(isw_fields.txn_ref, xpay_status); reg.updateInterSwitchPostFieldsDate(isw_fields.txn_ref, str2); base.Response.Redirect("./xreport_payments.aspx"); if (num == 0) { } } else { base.Response.Redirect("./xreport_payments.aspx"); } } if (e.CommandName == "TmDeleteClick") { GridViewRow row3 = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int num3 = row3.RowIndex; string transID = e.CommandArgument.ToString(); reg.updateInterSwitchVisibleStatus(transID, "0"); base.Response.Redirect("./xreport_payments.aspx"); } if (e.CommandName == "TmDetailsClick") { GridViewRow row4 = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int num4 = row4.RowIndex; string str7 = e.CommandArgument.ToString(); lt_twall = ret.getTwalletByMemberID(adminID, str7, Session["agentType"].ToString()); //if (lt_twall.Count > 0) { } if (lt_twall.Count > 0) { isw_fields = ret.getISWtransactionByTransactionID(lt_twall[0].transID); isw_fields.TransactionDate = isw_fields.TransactionDate.Substring(0, 11).Trim(); c_app = ret.getApplicantByID(lt_twall[0].applicantID); string str8 = lt_twall[0].xpay_status; lt_fdets = ret.getFee_detailsByTwalletID(lt_twall[0].xid); Session["transID"] = str7; Session["memberID"] = adminID; show_inv = 1; switch (str8) { case "0": str8 = "PAYMENT UNCOMPLETED!!!"; return; case "1": str8 = "PAYMENT SUCCESSFUL!!!"; return; case "2": str8 = "PAYMENT PENDING!!!"; return; case "3": str8 = "PAYMENT UNSUCCESSFUL!!!"; break; } } } }
protected void gvTm_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "TmPayClick") { GridViewRow namingContainer = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int rowIndex = namingContainer.RowIndex; string txnref = e.CommandArgument.ToString(); int num = 0; this.isw_fields = this.ret.getISWtransactionByTransactionID(txnref); this.isr = this.tx.myRedirect(this.check_trans_page + "?productid=" + this.isw_fields.product_id + "&transactionreference=" + this.isw_fields.txn_ref + "&amount=" + this.isw_fields.amount, "Hash", this.isw_fields.hash); num = this.reg.updateInterSwitchRecords(this.isw_fields.txn_ref, this.isw_fields.pay_ref, this.isw_fields.ret_ref, this.isr.ResponseCode, this.isr.TransactionDate, this.isr.MerchantReference, this.isr.ResponseDescription); if (!(this.isr.ResponseCode == "") && (this.isr.ResponseCode != null)) { bool flag1 = this.isr.ResponseCode == "00"; } string str2 = DateTime.Now.ToString("dd-MMM-yy HH:MM:ss"); this.reg.updateInterSwitchPostFieldsDate(this.isw_fields.txn_ref, str2); base.Response.Redirect("./v_bask_tmp.aspx"); } if (e.CommandName == "TmDeleteClick") { GridViewRow row2 = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int num2 = row2.RowIndex; string transID = e.CommandArgument.ToString(); this.reg.updateInterSwitchVisibleStatus(transID, "0"); base.Response.Redirect("./v_bask_tmp.aspx"); } if (e.CommandName == "TmDetailsClick") { GridViewRow row3 = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int num3 = row3.RowIndex; string str4 = e.CommandArgument.ToString(); this.lt_twall = this.ret.getTwalletByMemberID(this.adminID, str4, this.Session["agentType"].ToString()); if (this.lt_twall.Count > 0) { string str5 = this.lt_twall[0].xpay_status; this.lt_fdets = this.ret.getFee_detailsByTwalletID(this.lt_twall[0].xid); this.Session["transID"] = str4; this.Session["memberID"] = this.adminID; this.show_inv = 1; switch (str5) { case "0": str5 = "PAYMENT UNCOMPLETED!!!"; return; case "1": str5 = "PAYMENT SUCCESSFUL!!!"; return; case "2": str5 = "PAYMENT PENDING!!!"; return; case "3": str5 = "PAYMENT UNSUCCESSFUL!!!"; break; } } } }