private void ICEScheduleSteps()
{
ICESchedulerStatus.Content = "Running";
if (ICEDownloaderSwitch.Value == 1)
{
downLoadStarter();
ICEReconTimer.Interval = new TimeSpan(0, 1, 0);
}
if (olImporterSwitch.Value == 1)
{
ICEOLImporterTimer.Start();
ICEReconTimer.Interval = new TimeSpan(0, 1, 0);
}
//Running it irrespective of switch coz we need to merge the ICE Files and update the queues. Switch check is in the scheduler method
ICEReconTimer.Start();
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(System.DateTime.UtcNow, TimeZoneInfo.Local);
ICESchedulerStatus.Content = "Last executed at " + now.ToString("dd-mmm-yy hh:mm:ss");
}
private void downLoadStarter()
{
//Console.Out;
//string src = IBrowser.GetSourceAsync(webPagePreview);
//webPagePreview.ViewSource();
//webPagePreview.GetMainFrame().ViewSource();
if (ReconSwitch.Value == 1)
{
ICEReconTimer.Start();
}
ICEDownloaderStatus.Content = "Running";
string cmd = @"document.getElementById('companyId').selectedIndex=0; ";
cmd += @"var a = document.getElementsByTagName('a'); ";
cmd += @"var c; for(i=0;i<a.length;i++) if(a[i].href=='https://www.theice.com/reports/DealReport.shtml?excel=') c=a[i]; c.click(); ";
//cmd += @"alert(a[3].href);";
//cmd += @"document.getElementById('companyId').selectedIndex=1; c.click()";
//cmd += @"var a = document.getElementsByTagName('a'); ";
//cmd += "for(i=0;i<a.length;i++) if(a[i].href==\"https://www.theice.com/reports/DealReport.shtml?excel=\") a[i].click(); ";
cmd = @"var a = document.getElementsByTagName('a'); var c; for (i = 0; i < a.length; i++) if (a[i].href == 'https://www.theice.com/reports/DealReport.shtml?excel=') c = a[i];";
cmd += @"document.getElementById('companyId').selectedIndex = 0; c.click(); setTimeout(function(){ document.getElementById('companyId').selectedIndex = 1; c.click(); },15000);";
IFrame frame = webPagePreview.GetMainFrame();
frame.ExecuteJavaScriptAsync(cmd);
frame.ExecuteJavaScriptAsync("document.getElementById('companyId').selectedIndex = 1;");
//frame.ExecuteJavaScriptAsync("alert('ExecuteJavaScript works!');");
//frame->GetURL(), 0);
/*
* var a = document.getElementsByTagName('a'); var c; for(i=0;i<a.length;i++) if(a[i].href=='https://www.theice.com/reports/DealReport.shtml?excel=') c=a[i]; setInterval(function(){
* document.getElementById('companyId').selectedIndex=0; c.click(); console.log("0 Done"); setTimeout(function(){document.getElementById('companyId').selectedIndex=1; c.click();},5000);
* }, 600000);
*/
Debug.WriteLine("..........." + webPagePreview.Content.ToString());
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(System.DateTime.UtcNow, TimeZoneInfo.Local);
ICEDownloaderStatus.Content = "Last executed at " + now.ToString("dd-mmm-yy hh:mm:ss");
//Console.WriteLine("..........." + webPagePreview.Content.ToString());
}
private void reconSchedulerMethod(object sender, EventArgs e)
{
if (ICEDownloaderSwitch.Value == 1)
{
var a = new HTMLParser(@"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\Download Data\ICE_CBNA.xls").Process().ToList();
var b = new HTMLParser(@"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\Download Data\ICE_CGML.xls").Process().ToList();
foreach (DataTable t in b)
{
a.Add(t);
}
Console.WriteLine("Num of tables extracted : " + a.Count);
var data = new DataTable("ICE Data");
MergeTables(a, data);
AddPKtoICE(data);
ICEqueues["ICE Raw Collated"].QData = data;
ICEqueues["ICE Raw Collated"].ToCSV();
}
Console.WriteLine("Chal gaya hu");
ICEReconTimer.Stop();
if (ReconSwitch.Value == 1)
{
ICEReconStatus.Content = "Running";
// Add the Recon Method
ReconQueue comparisons = ICEqueues["Comparisons"];
foreach (DataRow comp in comparisons.QData.Rows)
{
queryTrials(comp, ICEqueues);
}
Console.WriteLine("Analysis done");
foreach (KeyValuePair <string, ReconQueue> q in ICEqueues)
{
q.Value.ToCSV();
}
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(System.DateTime.UtcNow, TimeZoneInfo.Local);
ICEReconStatus.Content = "Last executed at " + now.ToString("dd-mmm-yy hh:mm:ss");
}
}
