static void Main(string[] args)
{
Collector querieCollector = new Collector(30, @"C:\site\ntec\App_Data\configs.db", @"C:\site\ntec\xml");
List<Dictionary<string, string>> queries = querieCollector.GetQueries();
foreach (Dictionary<string, string> query in queries)
{
RunQuery(
query["conn"],
query["sql"],
query["xml_file"]
);
}
int x;
}
/// <summary>
/// Get data from site database
/// </summary>
private static void LoadntecDbData(int scheduleInterval, DataTable siteConfig)
{
for (int i = 0; i < siteConfig.Rows.Count; i++)
{
string siteName = siteConfig.Rows[i]["title"].ToString();
string dbPath = siteConfig.Rows[i]["db_path"].ToString();
string xmlFolderPath = siteConfig.Rows[i]["default_xml_folder"].ToString();
Collector collector = new Collector(scheduleInterval, dbPath, xmlFolderPath);
List<Dictionary<string, string>> dbQuery = collector.GetQueries();
for (int k = 0; k < dbQuery.Count; k++)
{
dbQuery[k] = AddKeyStatus(dbQuery[k], "status", "");
dbQuery[k] = AddKeyStatus(dbQuery[k], "site_name", siteName);
dbQuery[k] = AddKeyStatus(dbQuery[k], "exec_time", "");
}
if (dbQuery.Count > 0) _queries.AddRange(dbQuery);
}
}
