public void InsertNewTestRun(DBTestRun pTestRun) { try { using (NpgsqlConnection pDBConnection = new NpgsqlConnection(__sConnectionString)) { pDBConnection.Open(); string sInsert = string.Format("INSERT INTO {0} ({1}, {2}, {3},{4}) VALUES (@sSensorMatNum,@pDate,@fMeasuredmV,@bSucceeded)", DBNames.TestRunTable.TableName, DBNames.TestRunTable.Columns.sensor_matnum, DBNames.TestRunTable.Columns.date, DBNames.TestRunTable.Columns.measured_mv, DBNames.TestRunTable.Columns.succeeded); // Insert some data using (NpgsqlCommand cmd = new NpgsqlCommand(sInsert, pDBConnection)) { cmd.Parameters.AddWithValue("sSensorMatNum", pTestRun.SensorMaterialNumber); cmd.Parameters.AddWithValue("pDate", pTestRun.EpochStart); cmd.Parameters.AddWithValue("fMeasuredmV", pTestRun.MeasuredValuemV); cmd.Parameters.AddWithValue("bSucceeded", pTestRun.Succeeded); cmd.ExecuteNonQuery(); } } } catch (Exception e) { //todo: Add logging } }
public void UpdateTestRun(DBTestRun pUpdateRun) { throw new NotImplementedException(); }