static void PullTransactions(int threadId)
{
try
{
Console.WriteLine("this is thread Id " + threadId);
Console.WriteLine("====================== ");
var dt = TranAccess.PullPendingTran(threadId);
foreach (DataRow dr in dt.Rows)
{
var stanVal = "";
var stanDate = new DateTime();
//stanVal = DateTime.Now.ToString("yyMMddHH") + DateTime.Now.ToString("mmss");
stanVal = MyHelperClass.GenerateRandomString(4) + DateTime.Now.ToString("ddHHmmss");
if (String.IsNullOrEmpty(dr["value_date"].ToString()))
{
stanDate = DateTime.Now;
}
else
{
stanDate = Convert.ToDateTime(dr["value_date"].ToString());
}
//MyHelperClass.WriteLog(stanVal + " for " + dr["refId"].ToString() + "== ");
LogFileWrite(stanVal + " for " + dr["refId"].ToString() + "== ", threadId);
var up = TranAccess.UpdateStan(Convert.ToInt64(dr["refId"].ToString()), stanVal, stanDate);
// post to service
var identifier = dr["transaction_type"].ToString();
if (identifier == null || identifier == "")
{
identifier = identifier.Substring(0, 3);
}
var debitAccount = dr["debit_account_number"].ToString();
var creditAccount = dr["credit_account_number"].ToString();
var currency = dr["currency"].ToString();
var transactionAmount = Convert.ToDouble(dr["transaction_amount"].ToString());
var tranParticular2 = dr["transaction_particular2"].ToString();
var transactionRefernce = dr["transaction_reference"].ToString();
var transactionParticular = dr["transaction_particular1"].ToString();
var originalRefNum = dr["original_ref_num"].ToString();
var res = PostTransaction(debitAccount, creditAccount, currency, transactionAmount, stanDate, stanVal, tranParticular2, transactionRefernce, transactionParticular, identifier, threadId, originalRefNum);
var result = res.Split('|');
var fi = TranAccess.UpdateAfterPost(Convert.ToInt64(dr["refId"].ToString()), "Y", result[1].Replace("::", "").TrimStart('7'), result[0], result[1]);
LogFileWrite(result[0] + "==" + result[1] + "==" + result[2] + "==", threadId);
}
}
catch (Exception e)
{
MyHelperClass.WriteLog(e);
LogFileWrite(e.Message, threadId);
}
}
