private void updateSMS(int status, string smsID) { try { //This is my connection string i have assigned the database file address path string MyConnection2 = ConfigurationManager.AppSettings["constring"]; //This is my update query in which i am taking input from the user through windows forms and update the record. string Query = "update sms set smsStatus='" + status + "' where smsID='" + smsID + "';"; //This is MySqlConnection here i have created the object and pass my connection string. MySqlConnection MyConn2 = new MySqlConnection(MyConnection2); MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2); MySqlDataReader MyReader2; MyConn2.Open(); MyReader2 = MyCommand2.ExecuteReader(); while (MyReader2.Read()) { } MyConn2.Close();//Connection closed here } catch (Exception ex) { var err2 = new LogUtility.Error() { ErrorDescription = ex.Message + Environment.NewLine + ex.InnerException, ErrorTime = DateTime.Now, ModulePointer = "Error Sending SMS", StackTrace = ex.StackTrace }; LogUtility.ActivityLogger.WriteErrorLog(err2); } }
public int CountPendingTrans() { int count = 0; try { using (MySqlConnection con = new MySqlConnection()) { //con.ConnectionString = ConfigurationManager.AppSettings["MySQLCon"]; //con.ConnectionString = "Server=172.21.1.35; Database=jaiz_db; Uid=appsoluser; Pwd=@ppSol@Jaiz;"; con.ConnectionString = ConfigurationManager.AppSettings["constring"]; con.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = con; cmd.CommandText = "SELECT Count(*) FROM routing WHERE routeStatus='0'"; count = Convert.ToInt32(cmd.ExecuteScalar()); } } catch (Exception ex) { var err2 = new LogUtility.Error() { ErrorDescription = ex.Message + Environment.NewLine + ex.InnerException, ErrorTime = DateTime.Now, ModulePointer = "Error Counting Transactions", StackTrace = ex.StackTrace }; LogUtility.ActivityLogger.WriteErrorLog(err2); } return(count); }
public void WriteLog(string message, string subject) { var err2 = new LogUtility.Error() { ErrorDescription = message, ErrorTime = DateTime.Now, ModulePointer = subject, //StackTrace = ex.StackTrace }; LogUtility.ActivityLogger.WriteErrorLog(err2); }
protected void Application_Error(object sender, EventArgs e) { // Code that runs when an unhandled error occurs Exception Ex = Server.GetLastError(); Server.ClearError(); // IDP s = new IDP(); var err2 = new LogUtility.Error() { ErrorDescription = "Error Accessing the Application: " + Ex.InnerException.ToString() + " Error Message" + Ex.Message, ErrorTime = DateTime.Now, ModulePointer = "Error", StackTrace = Ex.Message }; LogUtility.ActivityLogger.WriteErrorLog(err2); //s.ErrorLog(Ex.Message); }
public async void PushTransactions() { bool chkConn = false; try { chkConn = chk_con(); if (chkConn) { var client = new HttpClient(); ServicePointManager.Expect100Continue = true; ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; using (MySqlConnection con = new MySqlConnection()) { //con.ConnectionString = ConfigurationManager.AppSettings["MySQLCon"]; //con.ConnectionString = "Server=172.21.1.35; Database=jaiz_db; Uid=appsoluser; Pwd=@ppSol@Jaiz;"; con.ConnectionString = ConfigurationManager.AppSettings["constring"]; con.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = con; cmd.CommandText = "SELECT * FROM routing WHERE routeStatus='0'"; // cmd.Parameters.Add("username", MySqlDbType.VarChar).Value = username; var url = ""; var routeJSON = ""; int transID; MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { //rdr.Read(); while (rdr.Read()) { transID = Convert.ToInt16(rdr["routeID"].ToString()); url = rdr["routeURL"].ToString(); routeJSON = rdr["routeJSON"].ToString(); //update the transactions to prevent double picking updateTrans(2, transID); //var rs = JsonConvert.SerializeObject(t); WriteLog(routeJSON, "Transaction Picked for posting"); var content = new StringContent(routeJSON, Encoding.UTF8, "application/json"); HttpResponseMessage result = null; ServicePointManager.Expect100Continue = true; ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback ( delegate { return(true); } ); result = client.PostAsync(url, content).Result; var r = result.Content.ReadAsStringAsync().Result.Replace("\\", ""); var rr = JsonConvert.DeserializeObject <PostingResult>(r); if (rr.status == "00") { var m = "Status:" + rr.status + " Message:" + rr.message; WriteLog(m, "Transaction Synching Successful"); //updateMessage(1, smsID); updateTrans(1, transID); //Console.WriteLine("Success"); } else { // updateMessage(2, smsID); var m = "Status:" + rr.status + " Message:" + rr.message; WriteLog(m, "Transaction Synching Failed"); updateTrans(0, transID); //Console.WriteLine("Error"); } } } } } else { WriteLog(DateTime.Now + ":No internet connection detected, waiting to try again", "Internet Connection Error"); } } catch (Exception ex) { var err2 = new LogUtility.Error() { ErrorDescription = ex.Message + Environment.NewLine + ex.InnerException, ErrorTime = DateTime.Now, ModulePointer = "Error Sending Transactions", StackTrace = ex.StackTrace }; LogUtility.ActivityLogger.WriteErrorLog(err2); } }
private void SelectTransOnQueue(object sender, ElapsedEventArgs e) { TransSender i = new TransSender(); int count = i.CountPendingTrans(); Thread tr1 = null; Thread tr2 = null; Thread tr3 = null; Thread tr4 = null; Thread tr5 = null; Thread tr6 = null; Thread tr7 = null; Thread tr8 = null; Thread tr9 = null; Thread tr10 = null; if (count > 0) { try { tr1 = new Thread(delegate() { i.PushTransactions(); }); tr1.Start(); //tr2 = new Thread(delegate () { i.PushTransactions(1); }); //tr2.Start(); //tr3 = new Thread(delegate () { i.PushTransactions(2); }); //tr3.Start(); //tr4 = new Thread(delegate () { i.PushTransactions(3); }); //tr4.Start(); //tr5 = new Thread(delegate () { i.PushTransactions(4); }); //tr5.Start(); //tr6 = new Thread(delegate () { i.PushTransactions(5); }); //tr6.Start(); //tr7 = new Thread(delegate () { i.PushTransactions(6); }); //tr7.Start(); //tr8 = new Thread(delegate () { i.PushTransactions(7); }); //tr8.Start(); //tr9 = new Thread(delegate () { i.PushTransactions(8); }); //tr9.Start(); //tr10 = new Thread(delegate () { i.PushTransactions(9); }); //tr10.Start(); } catch (Exception ex) { var err22 = new LogUtility.Error() { ErrorDescription = "Error Code:" + ex.InnerException + " Response Message:" + ex.Message + Environment.NewLine + ex.Message, ErrorTime = DateTime.Now, ModulePointer = "Transaction Synchng Error", StackTrace = ex.InnerException.ToString() }; LogUtility.ActivityLogger.WriteErrorLog(err22); } } }