/// <summary>Returns all defined Excel Definitions from Unittest DB Context</summary>
public void GetTestDefinitions()
{
using (var context = new ExcelUnitTestDataContext())
{
_excelDefinitions = context.ExcelDefinition.Include(u => u.ColumnMappings).Where(a => a.IsActive).ToList();
Log.Info(string.Format("Found {0} Definition(s)", _excelDefinitions.Count));
}
}
/// <summary>Returns all defined Excel Definitions from Unittest DB Context</summary>
public void SaveTestImport(ExcelDefinition definition)
{
using (var context = new ExcelUnitTestDataContext())
{
ExcelImport import = new ExcelImport();
import.ImportTimestamp = DateTime.Now;
import.RowsImported = rowCount;
import.RowsWithErrors = errorRowCount;
import.ResultStatus = "VALID";
if (errorRowCount > 0)
{
import.ResultStatus = "ERROR";
}
definition.Imports.Add(import);
context.Entry(definition).State = EntityState.Modified;
context.SaveChanges();
context.Entry(import).State = EntityState.Added;
context.SaveChanges();
}
}
