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(); }