public static void ReadTemplate(DataSet dataSet, string testDataFileName)
{
var folderPath = ReflectionHelper.GetExecutingAssemblyFolder(Assembly.GetExecutingAssembly());
var testDataFullFileName = Path.Combine(folderPath, testDataFileName);
var shortcutTarget = TextFileIoHelper.GetShortcutTarget(testDataFullFileName);
if (!File.Exists(shortcutTarget))
{
Assert.Inconclusive("The test data file {0} does not exist", shortcutTarget);
}
ExcelHelper.ReadTemplateIntoTable(dataSet, shortcutTarget, SupportedSheetNames, true);
}
public static void ReadDictionary(DataSet dataSet, string testDataFileName)
{
const string accounts = "ACCOUNTS";
const string properties = "PROPERTIES";
const string contacts = "CONTACTS";
const string otherSecurities = "OTHER SECURITIES";
var folderPath = ReflectionHelper.GetExecutingAssemblyFolder(Assembly.GetExecutingAssembly());
var testDataFullFileName = Path.Combine(folderPath, testDataFileName);
var shortcutTarget = TextFileIoHelper.GetShortcutTarget(testDataFullFileName);
if (!File.Exists(shortcutTarget))
{
Assert.Inconclusive("The test data file {0} does not exist", shortcutTarget);
}
var supportedSheetNames = new List <string> {
accounts, properties, contacts, otherSecurities
};
ExcelHelper.ReadDictionaryIntoTable(dataSet, shortcutTarget, supportedSheetNames);
}