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