private void WebserviceTimer_Tick(object sender, EventArgs e) { MenuItem item = (MenuItem)cbSensor.SelectedItem; String webservice = (String)item.Tag; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(webservice); //onglet network F12 qui permet de voir ce qu'on envoie en header request.UserAgent = "Mozilla(Gecko 1.2.13)"; request.Method = "GET"; WebResponse response = request.GetResponse(); Stream receiveStream = response.GetResponseStream(); StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8); Console.WriteLine("Response stream received."); JObject obj = JObject.Parse(readStream.ReadToEnd()); String dataDate = (String)obj["date"]; String humidity = (String)obj["humidity"]; String temperature = (String)obj["temperature"]; String query = "INSERT INTO data(data_date,temperature,humidity,import_date,sensor) " + "VALUES(@data_date, @temperature, @humidity, @import_date, @sensor)"; Dictionary <String, String> parameters = new Dictionary <String, String>() { { "@data_date", dataDate }, { "@temperature", temperature }, { "@humidity", humidity }, { "@import_date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }, { "@sensor", item.Name }, }; try { DBInteractor.QuickExecute(query, parameters); } catch (Exception ex) { MessageBox.Show("ERREUR : Impossible de se connecter à la base de données...\n\r\n\r" + ex.Message + "\n\r" + ex.StackTrace); } //MessageBox.Show("L'insertion de vos données a été effectuée avec succès"); response.Close(); readStream.Close(); synthesis.DisplaySynthesis(); }
public MainForm() { InitializeComponent(); webserviceTimer = new Timer(); webserviceTimer.Interval = 5000; webserviceTimer.Tick += WebserviceTimer_Tick; //Instantiation du formulaire enfant import = new ImportForm(); //Définition en formulaire inclus import.TopLevel = false; //Agrandissement à la taille du panel conteneur import.Dock = DockStyle.Fill; //Ajout du formulaire au panel principal pnlMain.Controls.Add(import); synthesis = new SynthesisForm(); synthesis.TopLevel = false; synthesis.Dock = DockStyle.Fill; pnlMain.Controls.Add(synthesis); data = new DataForm(); data.TopLevel = false; data.Dock = DockStyle.Fill; pnlMain.Controls.Add(data); sensor = new SensorForm(); sensor.TopLevel = false; sensor.Dock = DockStyle.Fill; pnlMain.Controls.Add(sensor); refreshSensorMain(); dtpStart.Value = new DateTime(DateTime.Now.Year, 1, 1); dtpEnd.Value = DateTime.Now.AddDays(1); HideForms(); synthesis.Show(); synthesis.DisplaySynthesis(); synthesis.chTemp_Load(); }