public static DataTable resProc(resProcModel obj)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GSWS_APSEEDS_CORP_RESP_PROC";
cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = obj.type;
cmd.Parameters.Add("P_TRANSACTION_ID", OracleDbType.Varchar2).Value = obj.txnId;
cmd.Parameters.Add("P_DEPT_TRANS_ID", OracleDbType.Varchar2).Value = obj.orderId;
cmd.Parameters.Add("P_DEPT_ID", OracleDbType.Varchar2).Value = obj.deptId;
cmd.Parameters.Add("P_STATUS_CODE", OracleDbType.Varchar2).Value = obj.statusCode;
cmd.Parameters.Add("P_REMARKS", OracleDbType.Varchar2).Value = obj.remarks;
cmd.Parameters.Add("P_SERVICE_ID", OracleDbType.Varchar2).Value = obj.serviceId;
cmd.Parameters.Add("P_AMOUNT", OracleDbType.Varchar2).Value = obj.userCharge;
cmd.Parameters.Add("P_SERVICE_CHARGE", OracleDbType.Varchar2).Value = obj.serviceCharge;
cmd.Parameters.Add("P_TOTAL_AMOUNT", OracleDbType.Varchar2).Value = obj.totalAmount;
cmd.Parameters.Add("P_IS_PAYMENT_SUCCESS", OracleDbType.Varchar2).Value = obj.isPaymentSuccess;
cmd.Parameters.Add("P_IS_PAYMENT_REVERSAL", OracleDbType.Varchar2).Value = obj.isPaymentReversal;
cmd.Parameters.Add("P_IS_PAY_REV_SUCCESS", OracleDbType.Varchar2).Value = obj.isPaymentRevSuccess;
cmd.Parameters.Add("P_IS_TXNID_CANCEL_SUCCESS", OracleDbType.Varchar2).Value = obj.isTxnCancelSuccess;
cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
return(dtstatus);
}
catch (Exception ex)
{
throw ex;
}
}
public static dynamic OrderDetails(seedPaymentModel obj)
{
dynamic objdata = new ExpandoObject();
try
{
var input = new
{
vscode = "11190157",
otpid = obj.orderId
};
var mualinput = new
{
deptId = "1101",
deptName = "Agriculture",
serviceName = "ReceivePayment",
serviceType = "REST",
method = "POST",
simulatorFlag = "false",
application = "GWS",
username = "******",
data = input
};
string input_data = JsonConvert.SerializeObject(mualinput);
string url = ConfigurationManager.AppSettings["AgricultureApiBaseAddress"].ToString() + "Agriculture/v1/api/v1/agriculture";
//string url = "https://eseed.ap.gov.in/eseed/RestFul/VSServices/ReceivePayment";
string response = POST_RequestAsync(url, input_data);
orderDetailesRespModel rootobj = JsonConvert.DeserializeObject <orderDetailesRespModel>(response);
if (rootobj.response.status == "1" || rootobj.response.status == "2")
{
resProcModel objres = new resProcModel();
objres.type = "5";
objres.txnId = obj.orderId;
objdata.status = true;
objdata.result = rootobj.response;
objdata.DataList = resProc(objres);
objdata.Pflag = rootobj.response.status;
}
else
{
objdata.status = false;
objdata.result = rootobj.response.msg;
}
}
catch (Exception ex)
{
objdata.status = false;
objdata.result = ex.Message.ToString();
}
return(objdata);
}
public static dynamic recieptData(recieptModel obj)
{
dynamic objdata = new ExpandoObject();
try
{
string serialized_data = rbkPaymentsHelper.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 = rbkPaymentsHelper.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 = rbkPaymentsHelper.resProc(objRes);
if (dt1 != null && dt1.Rows.Count > 0)
{
obj.secId = "11190157";
var input = new
{
vscode = obj.secId,
otpid = objResp.APPLICATIONNO,
transactionid = objResp.GSWSREFNO,
receiptid = "123",
amounttobepaid = (float.Parse(objResp.serviceAmt, CultureInfo.InvariantCulture.NumberFormat) + float.Parse(objResp.userCharges, CultureInfo.InvariantCulture.NumberFormat)).ToString(),
paystatus = "1"
};
var mualinput = new
{
deptId = "1101",
deptName = "Agriculture",
serviceName = "updatePaymentStatus",
serviceType = "REST",
method = "POST",
simulatorFlag = "false",
application = "GWS",
username = "******",
data = input
};
string input_data = JsonConvert.SerializeObject(mualinput);
// string url = "https://eseed.ap.gov.in/eseed/RestFul/VSServices/updatePaymentStatus";
string url = ConfigurationManager.AppSettings["AgricultureApiBaseAddress"].ToString() + "Agriculture/v1/api/v1/agriculture";
string response = POST_RequestAsync(url, input_data);
orderDetailesRespModel rootobj = JsonConvert.DeserializeObject <orderDetailesRespModel>(response);
if (rootobj.response.status == "1")
{
var input1 = new
{
vscode = "11190157",
otpid = objResp.APPLICATIONNO
};
var mualinput1 = new
{
deptId = "1101",
deptName = "Agriculture",
serviceName = "ReceivePayment",
serviceType = "REST",
method = "POST",
simulatorFlag = "false",
application = "GWS",
username = "******",
data = input1
};
input_data = JsonConvert.SerializeObject(mualinput1);
// url = "https://eseed.ap.gov.in/eseed/RestFul/VSServices/ReceivePayment";
response = POST_RequestAsync(url, input_data);
orderDetailesRespModel rootobj1 = JsonConvert.DeserializeObject <orderDetailesRespModel>(response);
if (rootobj1.response.status == "2")
{
//call wallet table and resp table and txn cancel servie otpid = objResp.APPLICATIONNO
objdata.status = true;
objdata.seedDetails = rootobj1.response;
objdata.walletDetails = objResp;
objdata.orderDetails = dt1;
}
else
{
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
else
{
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
else
{
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
else
{
objdata.status = false;
objdata.result = "Failed Make Payment Please try again !!!";
}
}
catch (Exception ex1)
{
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 makePayment(walletProcModel obj)
{
dynamic objdata = new ExpandoObject();
try
{
var input = new
{
vscode = obj.GSWSCODE,
otpid = obj.APPLICATIONNO,
transactionid = obj.GSWSREFNO,
receiptid = "123",
amounttobepaid = (float.Parse(obj.serviceCharge, CultureInfo.InvariantCulture.NumberFormat) + float.Parse("0", CultureInfo.InvariantCulture.NumberFormat)).ToString(),
paystatus = "1"
};
var mualinput = new
{
deptId = "1101",
deptName = "Agriculture",
serviceName = "updatePaymentStatus",
serviceType = "REST",
method = "POST",
simulatorFlag = "false",
application = "GWS",
username = "******",
data = input
};
string input_data = JsonConvert.SerializeObject(mualinput);
// string url = "https://eseed.ap.gov.in/eseed/RestFul/VSServices/updatePaymentStatus";
string url = ConfigurationManager.AppSettings["AgricultureApiBaseAddress"].ToString() + "Agriculture/v1/api/v1/agriculture";
string response = POST_RequestAsync(url, input_data);
string mappath1 = HttpContext.Current.Server.MapPath("SeedsPaymentUpdationLogs");
Task WriteTask1 = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath1, response));
orderDetailesRespModel rootobj = JsonConvert.DeserializeObject <orderDetailesRespModel>(response);
resProcModel objRes = new resProcModel();
objRes.type = "6";
objRes.txnId = obj.GSWSREFNO;
objRes.orderId = obj.APPLICATIONNO;
if (rootobj.response.status == "1")
{
objRes.isPaymentSuccess = "1";
}
//else
//{
// objRes.isPaymentSuccess = "0";
//}
DataTable dt = resProc(objRes);
if (dt != null && dt.Rows.Count > 0 && dt.Rows[0]["STATUS"].ToString() == "1" && rootobj.response.status == "1")
{
objdata.status = true;
objdata.result = dt;
}
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 paymentOrderDetails(seedPaymentModel obj)
{
dynamic objdata = new ExpandoObject();
try
{
obj.encrypted_data = obj.encrypted_data.Replace(" ", "+");
string decrypted_text = EncryptDecryptAlgoritham.DecryptStringAES(obj.encrypted_data, "3fee5395f01bee349feed65629bd442a", obj.iv);
var input = new
{
vscode = "11190157",
otpid = obj.orderId
};
var mualinput = new
{
deptId = "1234",
deptName = "Agriculture",
serviceName = "ReceivePayment",
serviceType = "REST",
method = "POST",
simulatorFlag = "false",
application = "GWS",
username = "******",
data = input
};
string input_data = JsonConvert.SerializeObject(mualinput);
decModel decData = JsonConvert.DeserializeObject <decModel>(decrypted_text);
// decData.PS_TXN_ID = DateTime.Now.ToString("yyyymmddhhmmssfff");
string url = ConfigurationManager.AppSettings["AgricultureApiBaseAddress"].ToString() + "Agriculture/v1/api/v1/agriculture";
// string url = "https://eseed.ap.gov.in/eseed/RestFul/VSServices/ReceivePayment";
string response = POST_RequestAsync(url, input_data);
orderDetailesRespModel rootobj = JsonConvert.DeserializeObject <orderDetailesRespModel>(response);
if (rootobj.response.status == "1" || rootobj.response.status == "2")
{
resProcModel objRes = new resProcModel();
objRes.type = "1";
objRes.txnId = decData.PS_TXN_ID;
objRes.orderId = obj.orderId;
objRes.deptId = "11";
objRes.statusCode = rootobj.response.status.ToString();
objRes.remarks = rootobj.response.msg;
objRes.serviceId = "1101025";
objRes.userCharge = rootobj.response.amountTobePaid.ToString();
objRes.serviceCharge = "0";
objRes.totalAmount = (float.Parse(objRes.userCharge, CultureInfo.InvariantCulture.NumberFormat) + float.Parse(objRes.serviceCharge, CultureInfo.InvariantCulture.NumberFormat)).ToString();
DataTable dt = resProc(objRes);
if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1")
{
rootobj.response.gswsTxnId = decData.PS_TXN_ID;
objdata.status = true;
objdata.result = rootobj.response;
}
else if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "2")
{
objdata.status = false;
objdata.result = "These transaction id is already used please login and try again !!!";
}
else
{
objdata.status = false;
objdata.result = "Failed to Fetch Record";
}
}
else
{
objdata.status = false;
objdata.result = rootobj.response.msg;
}
}
catch (Exception ex)
{
objdata.status = false;
objdata.result = ex.Message.ToString();
}
return(objdata);
}
