public TransformationSet TransformationSet_Read(string name, string userName)
{
TransformationSet result = _DemiContext.TransformationSets.
Where(t => t.UserName == userName && t.Name == name).FirstOrDefault();
return(result);
}
private void UpdateExistingSet(TransformationSet set, List <TransformationViewModel> transformations, IExcelService destFile)
{
IEnumerable <TransformationViewModel> existingTranformations = Transformations_Read(set.Id).ToList();
foreach (string columnName in destFile.ColumnNames.Values)
{
if (!existingTranformations.Where(t => t.TargetColumn.Contains(columnName)).Any())
{
transformations.Add(new TransformationViewModel {
TransformationSetId = set.Id, TransformationRule = "", TargetColumn = columnName
});
}
}
if (transformations.Count > 0)
{
Transformations_Create(transformations);
}
//TODO: I think this is wrong. We should not remove transformations, just
//because a column is not found in this table
foreach (TransformationViewModel trans in existingTranformations)
{
if (!destFile.ColumnNames.Where(t => t.Value.Contains(trans.TargetColumn)).Any())
{
Transformations_Destroy(trans);
}
}
}
private TransformationSet CreateNewSet(string userName, string setName, List <TransformationViewModel> transformations, IExcelService destFile)
{
TransformationSet result = new TransformationSet();
{
result.Name = setName;
result.UserName = userName;
}
TransformationSet_Create(result);
foreach (string columnName in destFile.ColumnNames.Values)
{
TransformationViewModel model = new TransformationViewModel
{
TransformationSetId = result.Id,
TransformationRule = "",
TargetColumn = columnName
};
transformations.Add(model);
}
Transformations_Create(transformations);
return(result);
}
private void DeleteTransformationSet(string setName)
{
TransformationSet set = _DemiContext.TransformationSets.
Where(s => s.Name == setName).
FirstOrDefault();
if (set != null)
{
_DemiContext.TransformationSets.Remove(set);
_DemiContext.SaveChanges();
}
}
public void CreateOrUpdateTransformationsWithGrussData()
{
const string DEST_FILE = TEST_FILE_FOLDER + @"11_CreateOrUpdateTransformationsWithGrussData_Destination.xlsx";
const string SET_NAME = "UnitTest_CreateOrUpdateTransformationsWithGrussData";
const int EXPECTED_COUNT = 205;
_TransformationService.CreateTransformationSet(USER_NAME, SET_NAME, DEST_FILE);
TransformationSet newSet = _DemiContext.TransformationSets.Where(ts => ts.Name == SET_NAME).FirstOrDefault();
Assert.IsNotNull(newSet, "New set ({0}) not created", SET_NAME);
IList <Transformation> transformations = _DemiContext.Transformations.Where(t => t.TransformationSetId == newSet.Id).ToList();
Assert.AreEqual(EXPECTED_COUNT, transformations.Count);
}
private void DeleteTransformation(string setName, string targetColumn)
{
TransformationSet set = _DemiContext.TransformationSets.
Where(s => s.Name == setName).
FirstOrDefault();
if (set != null)
{
Transformation transformation = _DemiContext.Transformations.
Where(t => t.TargetColumn == targetColumn).
FirstOrDefault();
if (transformation != null)
{
_DemiContext.Transformations.Remove(transformation);
_DemiContext.SaveChanges();
}
}
}
public void UpdateTransformationSetAddTwoFields()
{
const string DEST_FILE = TEST_FILE_FOLDER + @"02_UpdateTransformationSetAddTwoFields_Destination.xlsx";
const string SET_NAME = "UnitTest_UpdateTransformationSetAddTwoFields";
const int SET_ID = 29;
const int EXPECTED_START_COUNT = 4;
const int EXPECTED_END_COUNT = 6;
TransformationSet set = _DemiContext.TransformationSets.Where(ts => ts.Name == SET_NAME).FirstOrDefault();
Assert.AreEqual(EXPECTED_START_COUNT, set.Transformations.Count);
_TransformationService.CreateTransformationSet(USER_NAME, SET_NAME, DEST_FILE);
_DemiContext = new DEMIContext();
set = _DemiContext.TransformationSets.Where(ts => ts.Name == SET_NAME).FirstOrDefault();
Assert.AreEqual(EXPECTED_END_COUNT, set.Transformations.Count);
Assert.IsTrue(set.Id == SET_ID);
}
public void CreateTransformationSet()
{
const string DEST_FILE = TEST_FILE_FOLDER + @"03_CreateTransformationSet_Destination.xlsx";
const string SET_NAME = "UnitTest_CreateTransformationSet";
const int EXPECTED_COUNT = 10;
if (_DemiContext.TransformationSets.Any(ts => ts.Name == SET_NAME))
{
Assert.Inconclusive("Delete set ({0}) before running this test", SET_NAME);
}
else
{
_TransformationService.CreateTransformationSet(USER_NAME, SET_NAME, DEST_FILE);
TransformationSet newSet = _DemiContext.TransformationSets.Where(ts => ts.Name == SET_NAME).FirstOrDefault();
Assert.IsNotNull(newSet, "New set ({0}) not created", SET_NAME);
IList <Transformation> transformations = _DemiContext.Transformations.Where(t => t.TransformationSetId == newSet.Id).ToList();
Assert.AreEqual(EXPECTED_COUNT, transformations.Count);
}
}
public void TransformationSet_Create(TransformationSet transformationSet)
{
transformationSet.CreateDateTime = DateTime.Now;
_DemiContext.TransformationSets.Add(transformationSet);
_DemiContext.SaveChanges();
}
