public bool AddDataToTable(IWorkerModel wm, int dataSet, ISqlDataAccess SDA) { if (dataSet == 1) { SDA.SaveData1(wm, "Default", "DataSet1"); return(true); } if (dataSet == 2) { SDA.SaveData1(wm, "Default", "DataSet2"); return(true); } if (dataSet == 3) { SDA.SaveData1(wm, "Default", "DataSet3"); return(true); } if (dataSet == 4) { SDA.SaveData1(wm, "Default", "DataSet4"); return(true); } return(false); }
public bool SaveData1(IWorkerModel workerModel, string connectionString, string DataSet) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString(connectionString))) { cnn.Execute("insert into " + DataSet + " (Value, Code, TimeStamp) values (@Value, @Code, @TimeStamp)", workerModel); } return(true); }