/// <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(); } }