// Add PlugRTData to DataBase-PlugRTData Table public static bool AddPlugRTData(PlugRTData plugrtdata, string dbPath) { try { SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbPath + ";"); conn.Open(); SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = @"INSERT INTO PlugRTData(PlugID, UpTime, V, I, P, Q1, S, S1, PF, PF1, SN, N, THDI, ECounter, PCounter, Freq, RelayState, TransmitInternal, DateTime) VALUES(@_PlugID, @_UpTime, @_V, @_I, @_P, @_Q1, @_S, @_S1, @_PF, @_PF1, @_SN, @_N, @_THDI, @_ECounter, @_PCounter, @_Freq, @_RelayState, @_TransmitInternal, @_DateTime)"; cmd.Parameters.Add(new SQLiteParameter("_PlugID", plugrtdata.PlugID)); cmd.Parameters.Add(new SQLiteParameter("_UpTime", plugrtdata.UpTime)); cmd.Parameters.Add(new SQLiteParameter("_V", plugrtdata.V)); cmd.Parameters.Add(new SQLiteParameter("_I", plugrtdata.I)); cmd.Parameters.Add(new SQLiteParameter("_P", plugrtdata.P)); cmd.Parameters.Add(new SQLiteParameter("_Q1", plugrtdata.Q1)); cmd.Parameters.Add(new SQLiteParameter("_S", plugrtdata.S)); cmd.Parameters.Add(new SQLiteParameter("_S1", plugrtdata.S1)); cmd.Parameters.Add(new SQLiteParameter("_PF", plugrtdata.PF)); cmd.Parameters.Add(new SQLiteParameter("_PF1", plugrtdata.PF1)); cmd.Parameters.Add(new SQLiteParameter("_SN", plugrtdata.SN)); cmd.Parameters.Add(new SQLiteParameter("_N", plugrtdata.N)); cmd.Parameters.Add(new SQLiteParameter("_THDI", plugrtdata.THDI)); cmd.Parameters.Add(new SQLiteParameter("_ECounter", plugrtdata.ECounter)); cmd.Parameters.Add(new SQLiteParameter("_PCounter", plugrtdata.PCounter)); cmd.Parameters.Add(new SQLiteParameter("_Freq", plugrtdata.Freq)); cmd.Parameters.Add(new SQLiteParameter("_RelayState", plugrtdata.RelayState)); cmd.Parameters.Add(new SQLiteParameter("_TransmitInternal", plugrtdata.TransmitInterval)); cmd.Parameters.Add(new SQLiteParameter("_DateTime", plugrtdata.AddDateTime)); int i = cmd.ExecuteNonQuery(); return(i == 1); } catch (SQLiteException se) { MessageBox.Show(se.Message + " \n\n" + se.Source + "\n\n" + se.StackTrace + "\n\n" + se.Data); return(false); } catch (ArgumentException ae) { MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace + "\n\n" + ae.Data); return(false); } catch (Exception ex) { //Do any logging operation here if necessary MessageBox.Show(ex.Message + "\n\n" + ex.Source + "\n\n" + ex.StackTrace + "\n\n" + ex.Data); return(false); } }
private void SimulateDataTimer_Tick(object sender, EventArgs e) { Random _rand = new Random(DateTime.Now.Millisecond); PlugRTData plugrtdata = new PlugRTData(); uptime += 2; plugrtdata.PlugID = 3813057585; plugrtdata.UpTime = uptime; plugrtdata.V = _rand.Next(210, 230); plugrtdata.I = _rand.Next(0, 10); plugrtdata.P = _rand.Next(0, 2300); plugrtdata.Q1 = _rand.Next(0, 100); plugrtdata.S = _rand.Next(0, 2400); plugrtdata.S1 = _rand.Next(0, 2350); plugrtdata.PF = _rand.Next(0, 1); plugrtdata.PF1 = _rand.Next(0, 1); plugrtdata.SN = _rand.Next(0, 100); plugrtdata.N = _rand.Next(0, 100); plugrtdata.THDI = _rand.Next(0, 100); plugrtdata.ECounter = _rand.Next(0, 10); plugrtdata.PCounter = _rand.Next(0, 10); plugrtdata.Freq = 50; plugrtdata.RelayState = true; plugrtdata.TransmitInterval = 2; plugrtdata.AddDateTime = DateTime.Now; try { SmartPlugDAL.AddPlugRTData(plugrtdata, SqliteDBPath); } catch { } }