public static void Import(string serverIP, string database, string siteFilter, string networkListName)
{
string fn = @"C:\temp\mcf.xml";
Performance perf = new Performance();
var pnMcf = new McfDataSet();
if (File.Exists(fn) && File.GetLastWriteTime(fn).Date != DateTime.Now.Date)
{ // read existing file.
Logger.WriteLine("Reading existing XML");
pnMcf.ReadXml(fn);
}
else
{
Logger.WriteLine("Reading csv files from MCF");
pnMcf = McfUtility.GetDataSetFromCsvFiles(Globals.LocalConfigurationDataPath);
pnMcf.WriteXml(fn);
}
DumpInfo(pnMcf);
Application.DoEvents();
Logger.WriteLine(serverIP);
var cs = PostgreSQL.CreateADConnectionString(serverIP, database, "decodes");
PostgreSQL svr = new PostgreSQL(cs);
var decodes = DecodesUtility.GetDataSet(svr);
McfDecodesConverter c = new McfDecodesConverter(svr, pnMcf, decodes);
c.importMcf(siteFilter.Split(','), networkListName);
UpdateSequences(svr);
}
public static void Import(string serverIP, string database, string password, string networkListName,
string[] siteList, string mrdbPath)
{
string fn = @"C:\temp\mcf.xml";
Performance perf = new Performance();
var pnMcf = new McfDataSet();
if (File.Exists(fn) && File.GetLastWriteTime(fn).Date == DateTime.Now.Date)
{ // read existing file.
Logger.WriteLine("Reading existing XML");
pnMcf.ReadXml(fn);
}
else
{
Logger.WriteLine("Reading csv files from MCF");
pnMcf = McfUtility.GetDataSetFromCsvFiles(mrdbPath);
pnMcf.WriteXml(fn);
}
DumpInfo(pnMcf);
Application.DoEvents();
Logger.WriteLine(serverIP);
var svr = PostgreSQL.GetPostgresServer(database, serverIP, "decodes", password) as PostgreSQL;
DecodesUtility.UpdateSequences(svr);
DecodesUtility.GenerateDataSet(@"c:\temp\decodes.xsd", svr);
var decodes = DecodesUtility.GetDataSet(svr);
McfDecodesConverter c = new McfDecodesConverter(svr, pnMcf, decodes, siteList);
c.importMcf(networkListName);
}
