private static void ChangeProperty <T>(Feature feature, ImportRow importRow, FeatureChangeSet changeSet, Expression <Func <Feature, T> > dest,
Func <ImportRow, T> src, bool addToChangeSet = true)
{
var currentValue = dest.Compile()(feature);
var targetValue = src(importRow);
if (Equals(currentValue, targetValue))
{
return;
}
var mex = dest.Body as MemberExpression;
if (mex?.Member == null)
{
throw new ArgumentException(nameof(dest));
}
mex.Member.SetMemberValue(feature, targetValue);
if (!addToChangeSet)
{
return;
}
changeSet.Changes.Add(new FeatureChange
{
Id = Guid.NewGuid(),
FeatureChangeSet = changeSet,
Property = mex.Member.Name,
OldValue = currentValue?.ToString(),
NewValue = targetValue?.ToString()
});
}
public async Task ImportAsync(UploadFileInfo info, Stream content)
{
var dbImport = _dbContext.ImportFiles.FirstOrDefault(x => x.DataDate == info.DownloadTime);
if (dbImport != null)
{
return;
}
var dbTags = await _dbContext.Tags.ToListAsync();
var features = await _dbContext.Features
.Include(c => c.FeatureTags)
.ThenInclude(c => c.Tag)
.ToDictionaryAsync(c => c.No);
var importFile = new ImportFile
{
Id = Guid.NewGuid(),
DataDate = info.DownloadTime,
FileName = info.FileName,
};
await _dbContext.ImportFiles.AddAsync(importFile);
var entries = await LoadImportRowsAsync(content);
var featuresAdded = 0;
var featuresModified = 0;
foreach (var importRow in entries)
{
var isNew = false;
if (!features.TryGetValue(importRow.FeatureID, out var feature))
{
feature = new Feature
{
Id = Guid.NewGuid(),
AddedToRoadmap = importRow.AddedToRoadmap,
FeatureTags = new List <FeatureTag>()
};
features[importRow.FeatureID] = feature;
await _dbContext.Features.AddAsync(feature);
featuresAdded++;
isNew = true;
}
var changeSet = new FeatureChangeSet
{
Id = Guid.NewGuid(),
Feature = feature,
ImportFile = importFile,
Type = isNew ? FeatureChangeSetType.Added : FeatureChangeSetType.Modified,
Date = info.DownloadTime,
Changes = new List <FeatureChange>()
};
ChangeProperty(feature, importRow, changeSet, f => f.Description, s => s.Description);
ChangeProperty(feature, importRow, changeSet, f => f.Details, s => s.Details);
ChangeProperty(feature, importRow, changeSet, f => f.Status, s => s.Status);
ChangeProperty(feature, importRow, changeSet, f => f.EditType, s => s.EditType, false);
ChangeProperty(feature, importRow, changeSet, f => f.Release, s => s.Release);
ChangeProperty(feature, importRow, changeSet, f => f.LastModified, s => s.LastModified, false);
ChangeProperty(feature, importRow, changeSet, f => f.AddedToRoadmap, s => s.AddedToRoadmap);
ChangeProperty(feature, importRow, changeSet, f => f.MoreInfo, s => s.MoreInfo);
ChangeProperty(feature, importRow, changeSet, f => f.No, s => s.FeatureID);
ChangeTagList(feature, dbTags, changeSet, importRow.TagsPlatform, TagCategory.Platform);
ChangeTagList(feature, dbTags, changeSet, importRow.TagsProducts, TagCategory.Product);
ChangeTagList(feature, dbTags, changeSet, importRow.TagsCloudInstance, TagCategory.CloudInstance);
ChangeTagList(feature, dbTags, changeSet, importRow.TagsReleasePeriod, TagCategory.ReleasePeriod);
if (isNew || changeSet.Changes.Any())
{
feature.CalculateValueHash();
if (isNew)
{
changeSet.Changes.Clear();
}
await _dbContext.FeatureChangeSets.AddAsync(changeSet);
if (!isNew)
{
featuresModified++;
}
}
}
await _dbContext.SaveChangesAsync();
Console.WriteLine($"{info.DownloadTime.Date.ToShortDateString()} - added: {featuresAdded}, modified: {featuresModified}");
}
private void ChangeTagList(Feature feature, List <Tag> tags, FeatureChangeSet changeSet, List <string> targetTagList, TagCategory category)
{
var activeTagList = feature.FeatureTags.Where(x => x.Tag.Category == category).ToList();
var orphanedList = activeTagList.ToList();
var categoryTags = tags.Where(x => x.Category == category).ToList();
foreach (var targetTagName in targetTagList)
{
var availableTag = activeTagList.FirstOrDefault(x => targetTagName.Equals(x.Tag.Name, StringComparison.InvariantCultureIgnoreCase));
if (availableTag != null)
{
orphanedList.Remove(availableTag);
continue;
}
var dbTag = categoryTags.FirstOrDefault(x => x.Name.Equals(targetTagName, StringComparison.CurrentCultureIgnoreCase));
if (dbTag == null)
{
dbTag = new Tag
{
Id = Guid.NewGuid(),
Category = category,
Name = targetTagName,
};
tags.Add(dbTag);
}
var featureTag = new FeatureTag
{
Feature = feature,
Tag = dbTag
};
feature.FeatureTags.Add(featureTag);
activeTagList.Add(featureTag);
changeSet.Changes.Add(new FeatureChange
{
Id = Guid.NewGuid(),
FeatureChangeSet = changeSet,
Property = $"Tag-{category}",
OldValue = "add",
NewValue = targetTagName
});
}
foreach (var featureTag in orphanedList)
{
feature.FeatureTags.Remove(featureTag);
changeSet.Changes.Add(new FeatureChange
{
Id = Guid.NewGuid(),
FeatureChangeSet = changeSet,
Property = $"Tag-{category}",
OldValue = "remove",
NewValue = featureTag.Tag.Name
});
}
}