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;
}
}
}
}
