public static DataTable walletProc(walletProcModel obj)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GSWS_RBK_REQ_RES_INS_PROC";
cmd.Parameters.Add("ptype", OracleDbType.Varchar2).Value = obj.type;
cmd.Parameters.Add("pAPPLICANT_NAME", OracleDbType.Varchar2).Value = obj.CONSUMERNAME;
cmd.Parameters.Add("prbk_name", OracleDbType.Varchar2).Value = obj.rbkName;
cmd.Parameters.Add("phub_name", OracleDbType.Varchar2).Value = obj.hubName;
cmd.Parameters.Add("puser_charges", OracleDbType.Varchar2).Value = obj.userCharges;
cmd.Parameters.Add("pservice_charges", OracleDbType.Varchar2).Value = obj.serviceAmt;
cmd.Parameters.Add("ptotal_amount", OracleDbType.Varchar2).Value = obj.totalAmount;
cmd.Parameters.Add("pdept_txn_id", OracleDbType.Varchar2).Value = obj.APPLICATIONNO;
cmd.Parameters.Add("pgsws_txn_id", OracleDbType.Varchar2).Value = obj.GSWSREFNO;
cmd.Parameters.Add("pwallet_txn_id", OracleDbType.Varchar2).Value = obj.walletTxnId;
cmd.Parameters.Add("pis_payment_status", OracleDbType.Varchar2).Value = obj.paymentStatus;
cmd.Parameters.Add("pis_txn_reversal", OracleDbType.Varchar2).Value = obj.txnReversal;
cmd.Parameters.Add("pis_txn_reversal_succ", OracleDbType.Varchar2).Value = obj.txnReversalSuccess;
cmd.Parameters.Add("pis_dept_txn_canciled", OracleDbType.Varchar2).Value = obj.deptTxnCancelled;
cmd.Parameters.Add("pgsws_code", OracleDbType.Varchar2).Value = obj.GSWSCODE;
cmd.Parameters.Add("ptxn_initiate_date ", OracleDbType.TimeStamp).Value = DateTime.Now;
cmd.Parameters.Add("ptxn_response_date ", OracleDbType.TimeStamp).Value = DateTime.Now;
cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
return(dtstatus);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult makePayment(dynamic data)
{
string serialized_data = token_gen.Authorize_aesdecrpty(data);
string mappath2 = HttpContext.Current.Server.MapPath("MakePaymentLogs");
Task WriteTask2 = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath2, serialized_data));
walletProcModel rootobj = JsonConvert.DeserializeObject <walletProcModel>(serialized_data);
return(Ok(rbkPaymentsHelper.PaymentDone_Update(rootobj)));
}
public static dynamic makePayment(walletProcModel obj)
{
dynamic objdata = new ExpandoObject();
try
{
urlRedirectionModel objPaymentModel = new urlRedirectionModel();
objPaymentModel.GSWSCODE = obj.GSWSCODE;
objPaymentModel.OPERATORID = obj.OPERATORID;
objPaymentModel.DEPTCODE = "11";
objPaymentModel.SERVICECODE = "1104";
objPaymentModel.APPLICATIONNO = obj.APPLICATIONNO;
objPaymentModel.CONSUMERNAME = obj.CONSUMERNAME;
objPaymentModel.GSWSREFNO = obj.GSWSREFNO;
objPaymentModel.PAYMODE = "C";
objPaymentModel.userCharges = "0";
objPaymentModel.serviceAmt = obj.serviceAmt;
objPaymentModel.CallBackURI = "http://uat.gramawardsachivalayam.ap.gov.in/GSWSUAT/#!/rbkPaymentResp"; // "http://localhost:3831/#!/rbkPaymentResp";
string serialized_string = JsonConvert.SerializeObject(objPaymentModel);
string url = "http://43.241.39.112/STG/WalletPayment/PaymentConfirm?walletOne=" + encryptString(serialized_string);
obj.type = "1";
obj.userCharges = "0";
obj.totalAmount = (float.Parse(obj.serviceAmt, CultureInfo.InvariantCulture.NumberFormat) + float.Parse(obj.userCharges, CultureInfo.InvariantCulture.NumberFormat)).ToString();
DataTable dt = walletProc(obj);
if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1")
{
objdata.status = true;
objdata.result = url;
}
else
{
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
catch (Exception ex)
{
objdata.status = false;
objdata.result = ex.Message.ToString();
}
return(objdata);
}
public static bool GSWSWalletTxnCancel(string orderId, string txnId, string type, string isPaymentReversal = null, string isPaymentRevSuccess = null, string isTxnRevSeccess = null)
{
try
{
walletProcModel walletObj = new walletProcModel();
walletObj.type = type;
walletObj.APPLICATIONNO = orderId;
walletObj.GSWSREFNO = txnId;
walletObj.txnReversal = isPaymentReversal;
walletObj.txnReversalSuccess = isPaymentRevSuccess;
walletObj.deptTxnCancelled = isTxnRevSeccess;
DataTable dt = walletProc(walletObj);
if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1")
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
}
public static dynamic recieptData(recieptModel obj)
{
dynamic objdata = new ExpandoObject();
try
{
string serialized_data = decryptString(obj.encryptedString);
walletRespModel objResp = JsonConvert.DeserializeObject <walletRespModel>(serialized_data);
if (objResp.ERRORCODE == "101")
{
try
{
walletProcModel walletObj = new walletProcModel();
walletObj.type = "2";
walletObj.walletTxnId = objResp.WALLETREFNO;
walletObj.paymentStatus = "1";
walletObj.APPLICATIONNO = objResp.APPLICATIONNO;
walletObj.GSWSREFNO = objResp.GSWSREFNO;
DataTable dt = walletProc(walletObj);
if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1")
{
resProcModel objRes = new resProcModel();
objRes.type = "5";
objRes.txnId = objResp.GSWSREFNO;
DataTable dt1 = resProc(objRes);
if (dt1 != null && dt1.Rows.Count > 0)
{
var input = new
{
id = objResp.APPLICATIONNO,
transactionId = objResp.GSWSREFNO
};
string input_data = JsonConvert.SerializeObject(input);
string url = "https://hub.nukkadshops.com/v1/gew/updateTransaction";
string response = POST_RequestAsync(url, input_data);
rbkPayRespModel rootobj = JsonConvert.DeserializeObject <rbkPayRespModel>(response);
if (rootobj.status == 200)
{
var Innerinput = new
{
id = objResp.APPLICATIONNO
};
input_data = JsonConvert.SerializeObject(Innerinput);
url = "https://hub.nukkadshops.com/v1/gew/orderDetails";
response = POST_RequestAsync(url, input_data);
orderDerailsRespModel rootobj1 = JsonConvert.DeserializeObject <orderDerailsRespModel>(response);
if (rootobj1.Status == 200)
{
//call wallet table and resp table and txn cancel servie
objdata.status = true;
objdata.rbkDetails = rootobj1.Data;
objdata.walletDetails = objResp;
objdata.orderDetails = dt1;
}
else
{
//Auto Reconcile Module
walletAutoReconcile(objResp.APPLICATIONNO, objResp.GSWSREFNO);
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
else
{
//Auto Reconcile Module
walletAutoReconcile(objResp.APPLICATIONNO, objResp.GSWSREFNO);
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
else
{
//Auto Reconcile Module
walletAutoReconcile(objResp.APPLICATIONNO, objResp.GSWSREFNO);
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
else
{
//Auto Reconcile Module
walletAutoReconcile(objResp.APPLICATIONNO, objResp.GSWSREFNO);
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
catch (Exception ex1)
{
//Auto Reconcile Module
walletAutoReconcile(objResp.APPLICATIONNO, objResp.GSWSREFNO);
objdata.status = false;
objdata.result = ex1.Message.ToString();
}
}
else
{
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
catch (Exception ex)
{
objdata.status = false;
objdata.result = ex.Message.ToString();
}
return(objdata);
}
public static dynamic PaymentDone_Update(walletProcModel obj1)
{
dynamic objdata = new ExpandoObject();
try
{
var input = new
{
id = obj1.APPLICATIONNO,
transactionId = obj1.GSWSREFNO
};
string input_data = JsonConvert.SerializeObject(input);
string url = "https://hub.rbk.apagros.ap.gov.in/v1/gew/updateTransaction"; //"https://hub.nukkadshops.com/v1/gew/updateTransaction";
string response = POST_RequestAsync(url, input_data);
string mappath1 = HttpContext.Current.Server.MapPath("RBKPaymentUpdationLogs");
Task WriteTask1 = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath1, response));
rbkPayRespModel rootobj = JsonConvert.DeserializeObject <rbkPayRespModel>(response);
if (rootobj.status == 200)
{
resProcModel objRes = new resProcModel();
objRes.type = "9"; //update
objRes.txnId = obj1.GSWSREFNO;
objRes.orderId = obj1.APPLICATIONNO;
objRes.isPaymentSuccess = "1";
DataTable dt1 = resProc(objRes);
if (dt1 != null && dt1.Rows.Count > 0 && dt1.Rows[0]["STATUS"].ToString() == "1")
{
var Innerinput = new
{
id = obj1.APPLICATIONNO
};
input_data = JsonConvert.SerializeObject(Innerinput);
url = "https://hub.rbk.apagros.ap.gov.in/v1/gew/orderDetails";
response = POST_RequestAsync(url, input_data);
orderDerailsRespModel rootobj1 = JsonConvert.DeserializeObject <orderDerailsRespModel>(response);
if (rootobj1.Status == 200)
{
//call wallet table and resp table and txn cancel servie
objdata.status = true;
objdata.rbkDetails = rootobj1.Data;
objdata.walletDetails = obj1;
objdata.orderDetails = dt1;
}
else
{
//Auto Reconcile Module
walletAutoReconcile(obj1.APPLICATIONNO, obj1.GSWSREFNO);
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
else
{
//Auto Reconcile Module
walletAutoReconcile(obj1.APPLICATIONNO, obj1.GSWSREFNO);
objdata.status = false;
objdata.result = rootobj.message.ToString();
}
}
else
{
resProcModel objRes = new resProcModel();
objRes.type = "9"; //update
objRes.txnId = obj1.GSWSREFNO;
objRes.orderId = obj1.APPLICATIONNO;
objRes.isPaymentSuccess = "2";
//DataTable dt1 = resProc(objRes);
//Auto Reconcile Module
walletAutoReconcile(obj1.APPLICATIONNO, obj1.GSWSREFNO);
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
catch (Exception ex)
{
string mappath2 = HttpContext.Current.Server.MapPath("MakePaymentExceptionLogs");
Task WriteTask2 = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath2, "Error from Paymentdone Update:" + ex.Message.ToString() + JsonConvert.SerializeObject(obj1)));
objdata.status = false;
objdata.result = ex.Message.ToString();
}
return(objdata);
}
