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