public static void importdb(List <string> args)
{
var unityPathArg = args.Where(y => y.StartsWith("-BaseUnityFolder:")).SingleOrDefault();
if (unityPathArg != null)
{
MetaStateSettings._BaseUnityFolder = unityPathArg.Replace("-BaseUnityFolder:", string.Empty);
}
string excelFileName = Path.GetFullPath(args.First(), Directory.GetCurrentDirectory());
string databaseFileName = Path.GetFullPath(MetaStateSettings._BaseUnityFolder + @"\" + MetaStateSettings._DatabaseFileName, Directory.GetCurrentDirectory());
if (!File.Exists(databaseFileName))
{
Console.WriteLine("Error, could not locate file: " + databaseFileName);
}
else
{
DataLayer.Instance.Init(databaseFileName, true);
}
if (File.Exists(excelFileName))
{
ExcelReader reader = new ExcelReader();
DataSet dataSet = null;
try
{
dataSet = reader.ReadExcelFile(excelFileName);
ThreadPool.QueueUserWorkItem(arg => DataImport.ImportData(dataSet, resetEvent));
resetEvent.WaitOne();
}
catch (Exception e)
{
Console.WriteLine("Error while parsing Excel file.");
Console.WriteLine(e.Message);
Console.WriteLine(e.StackTrace);
}
}
else
{
Console.WriteLine("Error, could not locate file: " + excelFileName);
}
}
