private void MessageReceived(MqttApplicationMessageReceivedEventArgs e) { this.Invoke(new MethodInvoker(() => { lstNotifier.Items.Add("Topic : " + e.ApplicationMessage.Topic + " Payload : " + Encoding.UTF8.GetString(e.ApplicationMessage.Payload)); int i = e.ApplicationMessage.Topic.IndexOf("/") + 1; string _Topic = e.ApplicationMessage.Topic.Substring(i); string _Payload = Encoding.UTF8.GetString(e.ApplicationMessage.Payload); using (var dbContext = new hydroPhonicsDBEntities()) { dbContext.sensors.Add(new sensor { SensorType = _Topic, SensorData = _Payload, DateCreated = DateTime.Now.ToString() }); dbContext.SaveChanges(); } })); }
private void Form1_Load(object sender, EventArgs e) { try { using (var dbContext = new hydroPhonicsDBEntities()) { if (dbContext.Database.Exists()) { lstNotifier.Items.Add("Status : Connected at " + DateTime.Now); // await ConnectAsync(); //await StartMQTT(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "DB Connection"); } }