/// <summary>
/// Loads the data elements.
/// </summary>
/// <param name="recordId">The record identifier.</param>
/// <returns>List<DataElement>.</returns>
private List <DataElement> LoadDataElements(long recordId)
{
var retVal = new List <DataElement>();
try
{
// Load all the data for building up the data elements collection
var ds = dataProvider.LoadDetailData(recordId);
var lastDatenElementId = 0;
foreach (var row in ds.DetailData.OrderBy(d => d.DATEN_ELMNT_ID))
{
if (lastDatenElementId != (int)row.DATEN_ELMNT_ID)
{
var element = new DataElement
{
// All the attributes
ElementId = ((int)row.DATEN_ELMNT_ID).ToString(),
ElementName = row.XML_CD,
EadCode = row.EAD_CD,
ElementType = MapperHelper.MapDataElementType((ScopeArchivDatenElementTyp)(int)row.DATEN_ELMNT_TYP_ID),
IncludeInFullTextIndex = (int)row.VOLL_TXT_SRCHBL_IND != 0,
Visibility = (int)row.ZGRF_BRTG_STUFE_ID == 2 ? DataElementVisibility.@public : DataElementVisibility.@internal
};
// Get the actual value(s) for the data element
element.ElementValue = GetValues(ds, (int)row.DATEN_ELMNT_ID, element.ElementType);
retVal.Add(element);
lastDatenElementId = (int)row.DATEN_ELMNT_ID;
}
}
}
catch (Exception ex)
{
Log.Error(ex, "Failed to load detail elements for record {RecordId}", recordId);
throw;
}
return(retVal);
}
public static void FillDataElementElementValue(DataElementElementType elementType, DetailDataDataSet.DetailDataRow row,
DataElementElementValue value,
LanguageSettings languageSettings)
{
try
{
value.Sequence = row.IsELMNT_SQNZ_NRNull() ? 1 : (int)row.ELMNT_SQNZ_NR;
switch (elementType)
{
case DataElementElementType.text:
value.TextValues.Add(GetDefaultLanguageMemoText(row, languageSettings.DefaultLanguage));
break;
case DataElementElementType.memo:
// Memo text is appended to existing text and sequence is always 1
value.Sequence = 1;
var existing = value.TextValues.FirstOrDefault();
if (existing == null)
{
existing = new DataElementElementValueTextValue
{
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
};
value.TextValues.Add(existing);
}
existing.Value += row.MEMO_TXT;
break;
case DataElementElementType.selection:
value.TextValues.Add(GetDefaultLanguageMemoText(row, languageSettings.DefaultLanguage));
break;
case DataElementElementType.date:
value.TextValues = GetDateTranslations(row.BGN_DT_STND, languageSettings);
value.DateRange = new DateRange
{
From = row.BGN_DT_STND,
To = row.END_DT_STND,
FromApproxIndicator = row.BGN_CIRCA_IND != 0,
ToApproxIndicator = row.BGN_CIRCA_IND != 0,
FromDate = row.BGN_DT,
ToDate = row.END_DT,
DateOperator = MapperHelper.MapDateOperator((ScopeArchivDateOperator)row.DT_OPRTR_ID)
};
// Special logic for search dates.
var searchDates = GetSearchDate(row.BGN_DT_STND, row.BGN_DT, row.BGN_CIRCA_IND != 0, row.BGN_DT_STND, row.END_DT,
row.BGN_CIRCA_IND != 0);
value.DateRange.SearchFromDate = searchDates.FromDate;
value.DateRange.SearchToDate = searchDates.ToDate;
break;
case DataElementElementType.datePrecise:
value.TextValues = GetDateTranslations(row.BGN_DT_STND, languageSettings);
value.DateValue = row.BGN_DT;
break;
case DataElementElementType.dateRange:
value.TextValues = GetDateRangeTranslations((ScopeArchivDateOperator)row.DT_OPRTR_ID, row.BGN_DT_STND, row.END_DT_STND,
row.BGN_CIRCA_IND != 0, row.END_CIRCA_IND != 0,
languageSettings);
value.DateRange = new DateRange
{
From = row.BGN_DT_STND,
To = row.END_DT_STND,
FromApproxIndicator = row.BGN_CIRCA_IND != 0,
ToApproxIndicator = row.END_CIRCA_IND != 0,
FromDate = row.BGN_DT,
ToDate = row.END_DT,
DateOperator = MapperHelper.MapDateOperator((ScopeArchivDateOperator)row.DT_OPRTR_ID)
};
// Special logic for search dates.
searchDates = GetSearchDate(row.BGN_DT_STND, row.BGN_DT, row.BGN_CIRCA_IND != 0, row.END_DT_TXT, row.END_DT,
row.END_CIRCA_IND != 0);
value.DateRange.SearchFromDate = searchDates.FromDate;
value.DateRange.SearchToDate = searchDates.ToDate;
break;
case DataElementElementType.integer:
value.IntValue = (int)row.INT_ZAHL;
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.INT_ZAHL.ToString("N0", languageSettings.DefaultLanguage),
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
foreach (var language in languageSettings.SupportedLanguages)
{
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.INT_ZAHL.ToString("N0", language),
Lang = language.TwoLetterISOLanguageName
});
}
break;
case DataElementElementType.@float:
value.FloatValue = new DataElementElementValueFloatValue
{
Value = (float)row.FLOAT_ZAHL,
DecimalPositions = (int)row.DZML_STLN_ANZ
};
var frmtString = "N" + row.DZML_STLN_ANZ;
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.FLOAT_ZAHL.ToString(frmtString, languageSettings.DefaultLanguage),
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
foreach (var language in languageSettings.SupportedLanguages)
{
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.FLOAT_ZAHL.ToString(frmtString, language),
Lang = language.TwoLetterISOLanguageName
});
}
break;
case DataElementElementType.boolean:
var rm = new ResourceManager(typeof(Resources));
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = (int)row.INT_ZAHL == 0
? rm.GetString("BooleanNo", languageSettings.DefaultLanguage)
: rm.GetString("BooleanYes", languageSettings.DefaultLanguage),
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
foreach (var language in languageSettings.SupportedLanguages)
{
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = (int)row.INT_ZAHL == 0 ? rm.GetString("BooleanNo", language) : rm.GetString("BooleanYes", language),
Lang = language.TwoLetterISOLanguageName
});
}
value.BooleanValue = row.INT_ZAHL != 0;
break;
case DataElementElementType.time:
value.TimeValue = row.ZT;
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.ZT.ToString("T", languageSettings.DefaultLanguage),
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
foreach (var language in languageSettings.SupportedLanguages)
{
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.ZT.ToString("T", language),
Lang = language.TwoLetterISOLanguageName
});
}
break;
case DataElementElementType.timespan:
var seconds = (int)row.INT_ZAHL;
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = TimeSpan.FromSeconds(seconds).ToString("g", languageSettings.DefaultLanguage),
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
foreach (var language in languageSettings.SupportedLanguages)
{
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = TimeSpan.FromSeconds(seconds).ToString("g", language),
Lang = language.TwoLetterISOLanguageName
});
}
value.DurationInSeconds = seconds;
break;
case DataElementElementType.hyperlink:
var linkParts = row.MEMO_TXT.Split(new[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
if (linkParts.Length > 1)
{
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = linkParts[0],
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
value.Link = new DataElementElementValueLink
{
Href = linkParts[1].ToUpper().StartsWith("HTTP://") ? linkParts[1] :
linkParts[1].ToUpper().StartsWith("HTTPS://") ? linkParts[1] : "http://" + linkParts[1],
Value = linkParts[0]
};
}
else
{
var link = row.MEMO_TXT;
link = link.ToUpper().StartsWith("HTTP://") ? link :
link.ToUpper().StartsWith("HTTPS://") ? link : "http://" + linkParts[0];
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.MEMO_TXT,
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
value.Link = new DataElementElementValueLink
{
Href = link,
Value = row.MEMO_TXT
};
}
break;
case DataElementElementType.header:
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.TITEL,
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
break;
case DataElementElementType.entityLink:
value.TextValues.Add(GetDefaultLanguageMemoText(row, languageSettings.DefaultLanguage));
value.EntityLink = new DataElementElementValueEntityLink
{
EntityRecordId = row.VRKNP_GSFT_OBJ_ID.ToString("F0"),
EntityType = Enum.GetName(typeof(ScopeArchivGeschaeftsObjektKlasse), (int)row.VRKNP_GSFT_OBJ_KLS_ID),
Value = row.MEMO_TXT
};
break;
case DataElementElementType.accrual:
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.INT_ZAHL + " - " + row.MEMO_TXT,
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
break;
case DataElementElementType.fileLink:
value.TextValues.Add(GetDefaultLanguageMemoText(row, languageSettings.DefaultLanguage));
break;
case DataElementElementType.mailLink:
var mailLink = row.MEMO_TXT;
mailLink = mailLink.ToUpper().StartsWith("MAILTO:") ? mailLink : "mailto:" + mailLink;
value.TextValues.Add(GetDefaultLanguageMemoText(row, languageSettings.DefaultLanguage));
value.Link = new DataElementElementValueLink
{
Href = mailLink,
Value = row.MEMO_TXT
};
break;
case DataElementElementType.image:
case DataElementElementType.media:
value.TextValues.Add(new DataElementElementValueTextValue
{
Value = row.MEMO_TXT.Substring(row.MEMO_TXT.LastIndexOf("\\", StringComparison.Ordinal) + 1),
Lang = languageSettings.DefaultLanguage.TwoLetterISOLanguageName,
IsDefaultLang = true
});
value.BlobValueBase64 = GetBlobValue(row.BNR_DATEN);
break;
default:
throw new ArgumentOutOfRangeException(nameof(elementType), elementType, null);
}
}
catch (Exception ex)
{
// Simply log the error and then return the value as is.
// This simply means that the archive record might miss one data value
Log.Error(ex, "Failed to fill the data element value for {@Row} of element type {@ElementType}", row, elementType);
}
}
