public AnnotationIdentifier[] FindSeriesAnnotations(string seriesInstanceUID)
{
using (DbConnection dbConnection = _databaseProvider.CreateConnection())
{
DbCommand dbCommand = dbConnection.CreateCommand();
dbCommand.CommandText = @"SELECT [AnnId], [SeriesInstanceUID], [UserData] FROM dbo.Annotations WHERE [SeriesInstanceUID] = @seriesInstanceUID";
DbParameter seriesInstanceUIDParam = dbCommand.CreateParameter();
seriesInstanceUIDParam.ParameterName = "@seriesInstanceUID";
seriesInstanceUIDParam.DbType = DbType.String;
seriesInstanceUIDParam.Value = seriesInstanceUID;
dbCommand.Parameters.Add(seriesInstanceUIDParam);
dbConnection.Open( );
using (DbDataReader reader = dbCommand.ExecuteReader( ))
{
List <AnnotationIdentifier> annIds = new List <AnnotationIdentifier> ( );
while (reader.Read( ))
{
AnnotationIdentifier annId = new AnnotationIdentifier( );
annId.AnnotationID = reader.GetValue(0).ToString( );
annId.SeriesInstanceUID = reader.GetString(1);
annId.UserData = reader.GetString(2);
annIds.Add(annId);
}
return(annIds.ToArray( ));
}
}
}
public AnnotationIdentifier SaveAnnotations(string authenticationCookie, string seriesInstanceUID, string annotationData, string userData)
{
ServiceUtils.Authorize(authenticationCookie, PermissionsTable.Instance.CanStoreAnnotations);
string identifier = AddinsFactory.CreateAnnotationsAddin().SaveAnnotations(seriesInstanceUID, annotationData, userData);
if (!string.IsNullOrEmpty(identifier))
{
AnnotationIdentifier annID = new AnnotationIdentifier( );
annID.UserData = userData;
annID.SeriesInstanceUID = seriesInstanceUID;
annID.AnnotationID = identifier;
return(annID);
}
else
{
return(null);
}
}
