private Dictionary <string, string> GetEdtFieldValues(StandardMapping mappingUnderTest)
{
if (mappingUnderTest.IsEmailField())
{
return(GetEmailFieldValues(_idxDocumentIds, mappingUnderTest.EdtName));
}
if (mappingUnderTest.EdtType == "MultiValueList")
{
var allFieldValues = EdtDocumentRepository.GetMultiValueFieldValues(_idxDocumentIds, _idxToEdtConversionService.MappedEdtDatabaseColumn);
var combinedValues = allFieldValues.GroupBy(x => x.DocNumber)
.Select(group => new
{
DocNumber = group.Key,
Values = group.Select(x => x.FieldValue).OrderBy(x => x)
});
var dictionaryValues = combinedValues.ToDictionary(x => (string)x.DocNumber, x => string.Join(";", x.Values));
return(dictionaryValues);
}
else
{
return((_idxToEdtConversionService.MappedEdtDatabaseColumnType == ColumnType.Date) ? EdtDocumentRepository.GetDocumentDateField(_idxDocumentIds, _idxToEdtConversionService.MappedEdtDatabaseColumn)
: EdtDocumentRepository.GetDocumentField(_idxDocumentIds, _idxToEdtConversionService.MappedEdtDatabaseColumn));
}
}
public IdxToEdtConversionService(StandardMapping standardMapping)
{
_standardMapping = standardMapping;
if (!_standardMapping.IsEmailField())
{
_edtColumnDetails = GetEdtColumnDetailsFromDisplayName(standardMapping.EdtName);
}
}
private string GetIdxFieldValue(Framework.Models.IdxLoadFile.Document idxDocument, StandardMapping mappingUnderTest)
{
if (mappingUnderTest.EdtType != "MultiValueList" && !mappingUnderTest.IsEmailField())
{
return(idxDocument.AllFields.FirstOrDefault(x => x.Key.Equals(mappingUnderTest.IdxName))?.Value);
}
var allFieldValues = idxDocument.AllFields.Where(x => x.Key.Equals(mappingUnderTest.IdxName))
.Select(x => x.Value)
.OrderBy(x => x);
return(string.Join(";", allFieldValues));
}