public string WriteDataPayload([FromBody] SimplePayload payload)
{
string apiRequestStartTime = "";
apiRequestStartTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fffffff");
try
{
string strDockerName = System.Environment.MachineName;
string dtApiResponseTime = string.Empty;
try
{
DBUtility.WriteData(payload.transactionId, "Hello-World", strDockerName, payload.clientRequestTime, apiRequestStartTime);
}
catch (Exception)
{
throw;
}
return("Insert Successfull");
}
catch (Exception)
{
throw;
}
}
static void Main(string[] args)
{
SimplePayload payload = new SimplePayload("1");
Request request = new Request(payload);
CyClient.Client socketClient = new Client();
socketClient.Start(request);
}
public string TransferFundTwoTable([FromBody] SimplePayload payload)
{
try {
DBUtility.TransferFundInsert(payload.transactionId, "AddTransaction_Split");
return("Insert Successfull");
}
catch (Exception ex) {
return(ex.Message);
}
}
public string OneInsertWithSpTran([FromBody] SimplePayload payload)
{
try {
DBUtility.OneInsertSpTran(payload.transactionId, payload.clientRequestTime, "SP_OneInsertWithSpTran");
return("Direct Pay Successfull");
}
catch (Exception ex) {
throw ex;
}
}
public string OneInsertDynamicSqlWithLogTran([FromBody] SimplePayload payload)
{
try
{
DBUtility.OneInsertDynamicSqlWithLog(payload.transactionId, "", "", 1, "", "", 2, 1, DateTime.Now, payload.clientRequestTime, "OneInsertDynamicSqlTran", _logger);
return("Direct Pay Successfull");
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult TwoGetOneInsertSpTran([FromBody] SimplePayload payload)
{
try {
string sendervid = "*****@*****.**", receiverVid = "*****@*****.**";
decimal amount = 2;
DBUtility.TwoGetOneInsertSpTran(sendervid, receiverVid, amount, payload.transactionId, payload.clientRequestTime, "SP_TwoGetOneInsertSpTran");
return(new JsonResult(new { StatusCode = HttpStatusCode.OK, Message = "Direct Pay Successfull" }));
}
catch (Exception ex) {
return(new JsonResult(new { StatusCode = HttpStatusCode.BadRequest, Message = ex.Message }));
}
}
public string OneInsertDynamicSqlTran([FromBody] SimplePayload payload)
{
try
{
DBUtility.OneInsertDynamicSqlNoLog(payload.transactionId, "arnab", "accountno", 1, "receiver", "accountno",
2, 1, DateTime.Now, payload.clientRequestTime, "OneInsertDynamicSqlTran");
return("Direct Pay Successfull");
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult TwoGetOneInsertDynamicSqlConstantDecryptTran([FromBody] SimplePayload payload)
{
XmlDocument doc = new XmlDocument();
try
{
doc.LoadXml(Constants.XMLData);
RSA idtpPrivate = RSA.Create();
RSA idtpPublic = RSA.Create();
RSA sampleBankPrivate = RSA.Create();
RSA sampleBankPublic = RSA.Create();
sampleBankPrivate.FromXmlString(IDTPCryptography.bankPrivateKey);
idtpPublic.FromXmlString(IDTPCryptography.idtpPublicKey);
IDTPCryptography cryptography = new IDTPCryptography();
doc = cryptography.DecryptAndValidateSignature(doc, sampleBankPrivate, idtpPublic);
string sendervid = "", receiverVid = "", idtppin = "";
sendervid = doc.GetElementsByTagName("DbtrAcct").Item(0).InnerText;
receiverVid = doc.GetElementsByTagName("CdtrAcct").Item(0).InnerText;
idtppin = doc.GetElementsByTagName("IDTP_PIN").Item(0).InnerText;
string amountstr = "";
amountstr = doc.GetElementsByTagName("IntrBkSttlmAmt").Item(0).InnerText;
if (!idtppin.Equals("123456"))
{
throw new Exception("Invalid Pin");
}
decimal amount = 0;
decimal.TryParse(amountstr, out amount);
var senderInfo = DBUtility.GetUser(sendervid);
var receiverInfo = DBUtility.GetUser(receiverVid);
DBUtility.OneInsertDynamicSqlNoLog(payload.transactionId, sendervid, senderInfo.AccountNo, senderInfo.BankId,
receiverVid, receiverInfo.AccountNo, receiverInfo.BankId, amount, DateTime.Now, payload.clientRequestTime, "TwoGetOneInsertDynamicSqlXmlDecryptTran");
return(new JsonResult(new { StatusCode = HttpStatusCode.OK, Message = "Direct Pay Successfull" }));
}
catch (Exception ex)
{
return(new JsonResult(new { StatusCode = HttpStatusCode.BadRequest, Message = ex.Message }));
}
}
public IActionResult TwoGetOneInsertDynamicSqlTran([FromBody] SimplePayload payload)
{
try
{
string sendervid = "*****@*****.**", receiverVid = "*****@*****.**";
decimal amount = 2;
var senderInfo = DBUtility.GetUser(sendervid);
var receiverInfo = DBUtility.GetUser(receiverVid);
DBUtility.OneInsertDynamicSqlNoLog(payload.transactionId, sendervid, senderInfo.AccountNo, senderInfo.BankId,
receiverVid, receiverInfo.AccountNo, receiverInfo.BankId, amount, DateTime.Now, payload.clientRequestTime, "TwoGetOneInsertDynamicSqlTran");
return(new JsonResult(new { StatusCode = HttpStatusCode.OK, Message = "Direct Pay Successfull" }));
}
catch (Exception ex)
{
return(new JsonResult(new { StatusCode = HttpStatusCode.BadRequest, Message = ex.Message }));
}
}
public string WriteDataPayloadCassandra([FromBody] SimplePayload payload)
{
string apiRequestStartTime = "";
apiRequestStartTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fffffff");
try
{
string strDockerName = System.Environment.MachineName;
string dtApiResponseTime = string.Empty;
string createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fffffff");
var cluster = Cluster.Builder()
.AddContactPoints("192.168.1.13") //159.89.207.171
.WithPort(9042)
.Build();
// Connect to the nodes using a keyspace
var session = cluster.Connect("idtp");
// Execute a query on a connection synchronously
//session.Execute("INSERT INTO customer (name, email, phone) VALUES('maruf', '*****@*****.**', '01877188432')");
string sql = "INSERT INTO LoadBalancer (TransactionId, Message, DockerName, ClientRequestTime, ApiRequestStartTime, CreateTime)" +
"VALUES('" + payload.transactionId + "', '" + "Hello-World-Cassandra" + "', '" + strDockerName +
"', '" + payload.clientRequestTime +
"', '" + apiRequestStartTime +
"', '" + createTime +
"');";
session.Execute(sql);
//var rs = session.Execute("select * from customer");
//// Iterate through the RowSet
//Console.WriteLine("Reading data from Cassandra");
//foreach (var row in rs)
//{
// var value = row.GetValue<string>("name");
// Console.WriteLine(row.GetValue<string>(0) + "|" + row.GetValue<string>(1) + "|" + row.GetValue<string>(2));
// // Do something with the value
//}
return("Insert Successfull");
}
catch (Exception ex)
{
return(ex.Message);
}
}
