public void UploadAnalyzedECGs(AnalyzedECGModel analyzedEcg)
{
connection = new SqlConnection(@"Data Source=st-i4dab.uni.au.dk;Initial Catalog=" + db + ";Integrated Security=False;User ID=" + db + ";Password="******";Connect Timeout=15;Encrypt=False;TrustServerCertificate=False");
connection.Open();
string insertStringParam = @"INSERT INTO dbo.AnalyzedECG (AECGID, ECGID, CPR, Illness, Date, BLOBstValues, Samplerate, MonitorID, IsRead) VALUES (@AECGID, @ECGID, @CPR, @BLOBValues, @Illness, @Date, @BLOBstValues, @Samplerate, @MonitorID, @IsRead)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, connection))
{
cmd.CommandText = insertStringParam;
cmd.Parameters.AddWithValue("@AECGID", analyzedEcg.AECGID);
cmd.Parameters.AddWithValue("@ECGID", analyzedEcg.ECGID);
cmd.Parameters.AddWithValue("@CPR", analyzedEcg.CPR);
cmd.Parameters.AddWithValue("@Illness", analyzedEcg.Illnes);
cmd.Parameters.AddWithValue("@Date", analyzedEcg.Date);
cmd.Parameters.AddWithValue("@Samplerate", analyzedEcg.SampleRate);
cmd.Parameters.AddWithValue("@IsRead", analyzedEcg.IsRead);
cmd.Parameters.AddWithValue("@MonitorID", analyzedEcg.MonitorID);
cmd.Parameters.AddWithValue("@BLOBstValues", analyzedEcg.STValues.SelectMany(value => BitConverter.GetBytes(value).ToArray()));
reader = cmd.ExecuteReader();
double id = (double)cmd.ExecuteScalar();
reader.Read();
}
connection.Close();
}
public AnalyzedECGModel GetAnalyzedECG(int aECGID)
{
AnalyzedECGModel result = new AnalyzedECGModel();
foreach (AnalyzedECGModel aECG in aECGList)
{
if (aECG.ECGID == aECGID)
{
result = aECG;
}
}
//Sætter også isRead = true
//Sker når der vælges en ECG på listen
return(result);
}
public void UpdateIsRead(AnalyzedECGModel aECGID)
{
throw new NotImplementedException();
}
public void UploadAnalyzedECGs(AnalyzedECGModel analyzedEcg)
{
throw new NotImplementedException();
}
