public DataTable UpdateUserCashDetails(TPSLResponse obj) { try { DALSchedule objSch = new DALSchedule(); DataTable dt = objSch.UpdateUserCashDetails(obj); return(dt); } catch (Exception) { throw; } }
public DataTable UpdateUserCashDetails(TPSLResponse obj) { DBParams[] dbParams = new DBParams[27]; dbParams[0] = new DBParams("@MERCHANTID", obj.MERCHANTID, ParamType.String, ParamDirection.Input); dbParams[1] = new DBParams("@CustomerID", obj.CustomerID, ParamType.String, ParamDirection.Input); dbParams[2] = new DBParams("@TxnreferenceNo", obj.TxnreferenceNo, ParamType.String, ParamDirection.Input); dbParams[3] = new DBParams("@BankReferenceNo", obj.BankReferenceNo, ParamType.String, ParamDirection.Input); dbParams[4] = new DBParams("@TxnAmount", obj.TxnAmount, ParamType.String, ParamDirection.Input); dbParams[5] = new DBParams("@BankID", obj.BankID, ParamType.String, ParamDirection.Input); dbParams[6] = new DBParams("@BankMERCHANTID", obj.BankMERCHANTID, ParamType.String, ParamDirection.Input); dbParams[7] = new DBParams("@TxnType", obj.TxnType, ParamType.String, ParamDirection.Input); dbParams[8] = new DBParams("@CurrencyName", obj.CurrencyName, ParamType.String, ParamDirection.Input); dbParams[9] = new DBParams("@ItemCode", obj.ItemCode, ParamType.String, ParamDirection.Input); dbParams[10] = new DBParams("@SecurityType", obj.SecurityType, ParamType.String, ParamDirection.Input); dbParams[11] = new DBParams("@SecurityID", obj.SecurityID, ParamType.String, ParamDirection.Input); dbParams[12] = new DBParams("@SecurityPassword", obj.SecurityPassword, ParamType.String, ParamDirection.Input); dbParams[13] = new DBParams("@TxnDate", obj.TxnDate, ParamType.String, ParamDirection.Input); dbParams[14] = new DBParams("@AuthStatus", obj.AuthStatus, ParamType.String, ParamDirection.Input); dbParams[15] = new DBParams("@SettlementType", obj.SettlementType, ParamType.String, ParamDirection.Input); dbParams[16] = new DBParams("@AdditionalInfo1", obj.AdditionalInfo1, ParamType.String, ParamDirection.Input); dbParams[17] = new DBParams("@AdditionalInfo2", obj.AdditionalInfo2, ParamType.String, ParamDirection.Input); dbParams[18] = new DBParams("@AdditionalInfo3", obj.AdditionalInfo3, ParamType.String, ParamDirection.Input); dbParams[19] = new DBParams("@AdditionalInfo4", obj.AdditionalInfo4, ParamType.String, ParamDirection.Input); dbParams[20] = new DBParams("@AdditionalInfo5", obj.AdditionalInfo5, ParamType.String, ParamDirection.Input); dbParams[21] = new DBParams("@AdditionalInfo6", obj.AdditionalInfo6, ParamType.String, ParamDirection.Input); dbParams[22] = new DBParams("@AdditionalInfo7", obj.AdditionalInfo7, ParamType.String, ParamDirection.Input); dbParams[23] = new DBParams("@ErrorStatus", obj.ErrorStatus, ParamType.String, ParamDirection.Input); dbParams[24] = new DBParams("@ErrorDescription", obj.ErrorDescription, ParamType.String, ParamDirection.Input); dbParams[25] = new DBParams("@CheckSum", obj.CheckSum, ParamType.String, ParamDirection.Input); dbParams[26] = new DBParams("@Status", obj.Status, ParamType.String, ParamDirection.Input); DataTable dt = DALHandler.GetDataTable(Constants.UpdateUserCashDetails, dbParams); return(dt); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { COM.CheckSumResponseBean objCheckSumResponseBean = new COM.CheckSumResponseBean(); TPSLUtil1 objTPSLUtil1 = new TPSLUtil1(); //Response.Write("Originally Generated String===========>" + Convert.ToString(Session["myString"]) + "End String===========>"); //String strResponseMsg = "01|9892381157|16462992|NA|5.00|10|NA|NA|INR|NA|NA|NA|NA|19-04-2011 12:31:40|0399|NA|12345|100000001|NA|NA|NA|NA|NA|NA|NA|777629931425";//Request["msg"] == null ? "" : Request["msg"].Trim(); if (System.Configuration.ConfigurationManager.AppSettings["TestMode"].ToString() == "1") { strResponseMsg = "L2983|" + Request.QueryString["msg"].ToString().Trim() + "|90203896|1212225152|1|300|32858463|NA|INR|NA|NA|NA|NA|13-12-2013 10:51:56|0300|NA|L2983|1|NA|NA|NA|NA|NA|NA|NA|125848191442"; } else { strResponseMsg = Request["msg"] == null ? "" : Request["msg"].Trim(); } //if(Request["msg"]!=null) // Response.Write(" Request[msg]===========>" + Request["msg"].ToString()); //else // Response.Write(" Response string is null"); if (strResponseMsg == "" || strResponseMsg == string.Empty || strResponseMsg == null) { Response.Write("strResponseMsg===========>TPSL Response" + strResponseMsg); } else { String[] token = strResponseMsg.Split('|'); BLSchedule objSch = new BLSchedule(); if (token.Length == 26) { objCheckSumResponseBean.MSG = strResponseMsg; objCheckSumResponseBean.PropertyPath = HttpContext.Current.Server.MapPath("~/Property/MerchantDetails_sharedhosting.property"); string strCheckSumValue = objTPSLUtil1.transactionResponseMessage(objCheckSumResponseBean); ViewState["ResponseCheckSum"] = token[25].ToString(); ViewState["Authstatus"] = token[14].ToString(); ViewState["ResponseCheckSum"] = strCheckSumValue;//written for testing if (!strCheckSumValue.Equals("")) { if (!ViewState["ResponseCheckSum"].ToString().Equals(strCheckSumValue)) { Status = "F"; } else { if (ViewState["Authstatus"].ToString() == "0300") { Status = "Y"; } else { Status = "N"; } } } else { Status = "F"; } TPSLResponse objTpsl = new TPSLResponse(); objTpsl.MERCHANTID = token[0].ToString(); objTpsl.CustomerID = token[1].ToString(); objTpsl.TxnreferenceNo = token[2].ToString(); objTpsl.BankReferenceNo = token[3].ToString(); objTpsl.TxnAmount = token[4].ToString(); objTpsl.BankID = token[5].ToString(); objTpsl.BankMERCHANTID = token[6].ToString(); objTpsl.TxnType = token[7].ToString(); objTpsl.CurrencyName = token[8].ToString(); objTpsl.ItemCode = token[9].ToString(); objTpsl.SecurityType = token[10].ToString(); objTpsl.SecurityID = token[11].ToString(); objTpsl.SecurityPassword = token[12].ToString(); objTpsl.TxnDate = token[13].ToString(); objTpsl.AuthStatus = token[14].ToString(); objTpsl.SettlementType = token[15].ToString(); objTpsl.AdditionalInfo1 = token[16].ToString(); objTpsl.AdditionalInfo2 = token[17].ToString(); objTpsl.AdditionalInfo3 = token[18].ToString(); objTpsl.AdditionalInfo4 = token[19].ToString(); objTpsl.AdditionalInfo5 = token[20].ToString(); objTpsl.AdditionalInfo6 = token[21].ToString(); objTpsl.AdditionalInfo7 = token[22].ToString(); objTpsl.ErrorStatus = token[23].ToString(); objTpsl.ErrorDescription = token[24].ToString(); objTpsl.CheckSum = token[25].ToString(); objTpsl.Status = Status; ViewState["tranid"] = objTpsl.CustomerID.ToString(); DataTable dt = objSch.UpdateUserCashDetails(objTpsl); if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0][0].ToString() == "Success") { lblMsg.Text = "Great!!! Your bookings have been done.Please take a printout of your booking receipt."; tbl_details.Visible = true; btnPrint.Visible = true; bindDetails(objTpsl.CustomerID.ToString()); } else { lblMsg.Text = "Oops!!!, your bookings have not been done, if your payment has been deducted please call on +919435173561 else try again."; btnPrint.Visible = false; tbl_details.Visible = false; } } } else if (token.Length == 1) { ViewState["tranid"] = token[0].ToString(); Response.Write("strResponseMsg===========>Token 1 block" + strResponseMsg); Response.Write(" ViewState[tranid] " + ViewState["tranid"].ToString()); DataTable dt = objSch.PaymentUpdateBMETWallet(token[0].ToString()); if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0]["Status"].ToString() == "Success") { lblMsg.Text = "Great!!! Dear <b>" + dt.Rows[0]["FranName"].ToString() + "</b>, Your bookings have been done.<br><br> <b> Your BMETWallet Balance was Rs." + dt.Rows[0]["PreBMETWalletBal"].ToString() + "<br>Transaction Amt. Rs." + dt.Rows[0]["txnAmt"].ToString() + "<br>Available BMETWallet Balance Rs." + dt.Rows[0]["ActualBMETWalletBal"].ToString() + " </b><br><br>Please take printout of your booking receipt. BuyMyETicket wishes a very happy journey."; btnPrint.Visible = true; bindDetails(ViewState["tranid"].ToString()); } else { lblMsg.Text = "Oops!!! Franchisee your bookings have not been done, if your payment has been deducted please call on 9435173561 else try again."; btnPrint.Visible = false; tbl_details.Visible = false; } } } else { Response.Write("Inside ELSE of Response***********"); return; } } } }