public void uploadCalibration(CalibrationValuesDTO calibrationValuesDto)
{
var currentTime = DateTime.Now;
//_command = new SqlCommand("INSERT INTO dbo.calibrationDB(Mmhg10,Mmhg50,Mmhg100,CurrentDate) VALUES ('" + calibrationValuesDto.getSingleValue(0) + "', '" + calibrationValuesDto.getSingleValue(1) + "', '" + calibrationValuesDto.getSingleValue(2) + "', '" + calibrationValuesDto.Slope + "', '"+ calibrationValuesDto.Intercept+ ", '" + currentTime + "')", conn);
_command = new SqlCommand(
"INSERT INTO dbo.calibrationDB(Mmhg10,Mmhg50,Mmhg100,Slope,Intercept, CurrentDate) VALUES (@Mmhg10, @Mmhg50, @Mmhg100, @Slope, @Intercept, @Date)",
conn);
_command.Parameters.AddWithValue("@Mmhg10", calibrationValuesDto.getValues()[0]);
_command.Parameters.AddWithValue("@Mmhg50", calibrationValuesDto.getValues()[1]);
_command.Parameters.AddWithValue("@Mmhg100", calibrationValuesDto.getValues()[2]);
_command.Parameters.AddWithValue("@Slope", calibrationValuesDto.Slope);
_command.Parameters.AddWithValue("@Intercept", calibrationValuesDto.Intercept);
_command.Parameters.AddWithValue("@Date", currentTime);
try
{
conn.Open();
_sqlDataReader = _command.ExecuteReader();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public CalibrationValuesDTO getCalibrationValues()
{
var calibrationValues = new CalibrationValuesDTO();
_command = new SqlCommand("SELECT TOP 1 * FROM dbo.calibrationDB ORDER BY CurrentDate DESC", conn);
try
{
conn.Open();
_sqlDataReader =
_command.ExecuteReader(); // nu indeholder _sqlDataReader-objektet resultatet af forespørgslen
while (_sqlDataReader.Read())
{
calibrationValues.Intercept = Convert.ToDouble(_sqlDataReader.GetString(4));
calibrationValues.Slope = Convert.ToDouble(_sqlDataReader.GetString(5));
calibrationValues.ID = _sqlDataReader.GetInt32(0);
calibrationValues.Intercept = Convert.ToDouble(_sqlDataReader.GetString(5));
calibrationValues.Slope = Convert.ToDouble(_sqlDataReader.GetString(4));
}
conn.Close();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(calibrationValues);
}
public ConvertClass(iDataAccessLogic dataAccessLogic)
{
_dataAccessLogic = dataAccessLogic;
_calibrationDTO = _dataAccessLogic.getValues();
slope = _calibrationDTO.Slope;
intercept = _calibrationDTO.Intercept;
}
public Calibration(double zp)
{
_iDataAccessLogic = new CtrlDataAccessLogic();
_calibrationValuesDto = new CalibrationValuesDTO();
_zp = zp;
}
public void uploadCalibation(CalibrationValuesDTO calibrationValuesDto)
{
_databaseConnection = new DatabaseConnection();
_databaseConnection.uploadCalibration(calibrationValuesDto);
}
