public void testQmagic() { var a = new HTMLParser(@"C:\Users\Akhand\Downloads\DealReport.xls").Process().ToList(); Console.WriteLine("Num of tables extracted : " + a.Count); var data = new DataTable("ICE Data"); MergeTables(a, data); var res = from t1 in data.AsEnumerable() where t1.Field <String>("TableName") == "Cleared Deals" select t1; var res2 = data.Select(@"TableName like '%Cleared Deals%' and RowNum in (2,4,6)"); var res3 = data.Select(@"TableName like '%Cleared Deals%' and RowNum in (2,4,7)"); var res4 = from q1 in res2 join q2 in res3 on q1["RowNum"] equals q2["RowNum"] where q1.Field <String>("Deal ID").Contains("24") && q1.Field <String>("RowNum") == "4" select q1; var res5 = res2.Except(res3); //dataGridView1.DataContext = res2.CopyToDataTable(); string testFile = @"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\Queues.csv"; ReconQueue queuesData = new ReconQueue( testFile); Console.WriteLine("Idhar Hu"); DataView dgv = new DataView(queuesData.QData); //listView.ItemsSource = queuesData.QData.Rows; //listView.ItemsSource = dgv; //listView.it dataGridView1.ItemsSource = dgv; Console.WriteLine("Ab Yahan"); Dictionary <string, ReconQueue> queues = new Dictionary <string, ReconQueue>(); Console.WriteLine("Le yahan bhi aa gaya"); foreach (DataRow r in queuesData.QData.Rows) { queues.Add(r["QueueName"].ToString(), new ReconQueue(r["AttachedFile"].ToString())); Console.WriteLine(r["QueueName"].ToString() + " Queue added"); } ReconQueue comparisons = new ReconQueue( @"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\Comparer3.csv"); foreach (DataRow comp in comparisons.QData.Rows) { queryTrials(comp, queues); } Console.WriteLine("Analysis done"); foreach (KeyValuePair <string, ReconQueue> q in queues) { q.Value.ToCSV(); } Console.WriteLine("Sab ho gaya"); //queryTrials(); }
//Class Methods public void ToCSV() { if (filepath.Length > 0 && QData != null) { Console.WriteLine("Converting to CSV : " + filepath); File.WriteAllLines(filepath, ReconQueue.ToCSV(QData)); Console.WriteLine("Converted to CSV : " + filepath); } }
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"); } }
public ReconQueue(string inFile, string sheetName, string outFile) { if (File.Exists(inFile)) { if (String.Compare(inFile.Substring(inFile.IndexOf('.')), ".csv", true) == 0) { QData = ReconQueue.FromCSV(inFile); } else if (sheetName.Length > 0 && String.Compare(inFile.Substring(inFile.IndexOf('.')), ".xls", true) == 0) { OleDbConnection con = new OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0;data source=" + inFile + ";Extended Properties='Excel 8.0;HDR=Yes;'"); // "Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " // + filepath + "; Extended Properties = Excel 12.0; "); //@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=Yes;'" StringBuilder stbQuery = new StringBuilder(); stbQuery.Append("SELECT * FROM [" + sheetName + "]"); OleDbDataAdapter adp = new OleDbDataAdapter(stbQuery.ToString(), con); DataSet dsXLS = new DataSet(); adp.Fill(dsXLS); QData = dsXLS.Tables[0]; con.Close(); } else { QData = new DataTable(); } } else { QData = new DataTable(); } filepath = outFile; ToCSV(); }
public void initializeExchanges() { //Initialize ICE ReconQueue ICEqueuesData = new ReconQueue( @"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\Queues.csv"); webPagePreview.DownloadHandler = new DownloadHandler(); webPagePreview.Address = @"https://www.theice.com/reports/DealReport.shtml?"; ICEqueues = new Dictionary <string, ReconQueue>(); foreach (DataRow r in ICEqueuesData.QData.Rows) { ICEqueues.Add(r["QueueName"].ToString(), new ReconQueue(r["AttachedFile"].ToString())); Console.WriteLine(r["QueueName"].ToString() + " Queue added"); } QueueSelector.ItemsSource = ICEqueues; QueueSelector.DisplayMemberPath = "Key"; QueueSelector.SelectedValuePath = "Key"; QueueSelector.SelectedItem = ICEqueues["Queues"]; ICEOLQuery = "SELECT (NVL(SUBSTR(a.reference , 0, INSTR(a.reference , '.')-1), a.reference )) AS ICEdealID," + " a.tran_num, a.deal_tracking_num, a.reference, a.trade_date, a.position, price, '' as Contract " + " FROM ceiolfprod.ab_tran a inner join ceiolfprod.header h on a.ins_num = h.ins_num " + " WHERE book IN ( 'ICEGateway','CommStpGateway 1:ICE-OTC' ) AND trade_date= '%TRADEDATE%' " + " AND trade_flag = 1 AND tran_type NOT IN (27, 41) AND tran_status IN (2, 3) AND asset_type = 2"; ICEScheduler = new DispatcherTimer(); ICEScheduler.Tick += new EventHandler(ICEScheduleMethod); ICEScheduler.Interval = new TimeSpan(0, 5, 0); ICEReconTimer = new DispatcherTimer(); ICEReconTimer.Tick += new EventHandler(reconSchedulerMethod); ICEReconTimer.Interval = new TimeSpan(0, 0, 6); ICEOLImporterTimer = new DispatcherTimer(); ICEOLImporterTimer.Tick += new EventHandler(ICEOLImportSchedulerMethod); ICEOLImporterTimer.Interval = new TimeSpan(0, 0, 6); ICEReconStatus.Content = "Not Started"; ICEOLImporterStatus.Content = "Not Started"; ICEDownloaderStatus.Content = "Not Started"; ICESchedulerStatus.Content = "Not Started"; //Initialize CME ReconQueue CMEqueuesData = new ReconQueue( @"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\Queues.csv"); CMEwebPagePreview.DownloadHandler = new DownloadHandler(); CMEwebPagePreview.Address = @"https://login.cmegroup.com/sso/ssologin.action"; CMEqueues = new Dictionary <string, ReconQueue>(); foreach (DataRow r in ICEqueuesData.QData.Rows) { CMEqueues.Add(r["QueueName"].ToString(), new ReconQueue(r["AttachedFile"].ToString())); Console.WriteLine(r["QueueName"].ToString() + " Queue added"); } CMEQueueSelector.ItemsSource = CMEqueues; CMEQueueSelector.DisplayMemberPath = "Key"; CMEQueueSelector.SelectedValuePath = "Key"; CMEQueueSelector.SelectedItem = CMEqueues["Queues"]; }
public void tempGrid2() { /* * Load Exchange Pages * Download the results at certain intervals */ var a = new HTMLParser(@"C:\Users\Akhand\Downloads\DealReport.xls").Process().ToList(); Console.WriteLine("Num of tables extracted : " + a.Count); var data = new DataTable("ICE Data"); MergeTables(a, data); var res = from t1 in data.AsEnumerable() where t1.Field <String>("TableName") == "Cleared Deals" select t1; var res2 = data.Select(@"TableName = 'Cleared Deals'"); webPagePreview.Address = @"https://www.theice.com/reports/DealReport.shtml?"; //DataView dgv = new DataView(res2.CopyToDataTable()); //dataGridView1.ItemsSource = dgv; //dataGridView1.DataContext = res2.CopyToDataTable(); ReconQueue t = new ReconQueue(data, @"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\CollatedData.csv"); ReconQueue queuesData = new ReconQueue( @"C:\Users\Akhand\Documents\Visual Studio 2015\Projects\ExchangeRecon\ExchangeRecon\AppFiles\Queues.csv"); //dataGridView1.ItemsSource = new DataView(queuesData.QData); webPagePreview.DownloadHandler = new DownloadHandler(); //bc.OnBeforeDownload((IBrowser)webPagePreview,DownloadItem) //queuesData.QData.RowChanged += ReconQueue.Equals(); ICEqueues = new Dictionary <string, ReconQueue>(); foreach (DataRow r in queuesData.QData.Rows) { ICEqueues.Add(r["QueueName"].ToString(), new ReconQueue(r["AttachedFile"].ToString())); Console.WriteLine(r["QueueName"].ToString() + " Queue added"); } QueueSelector.ItemsSource = ICEqueues; QueueSelector.DisplayMemberPath = "Key"; QueueSelector.SelectedValuePath = "Key"; QueueSelector.SelectedItem = ICEqueues["Queues"]; //webPagePreview.Address = "www.theice.com"; Debug.WriteLine(webPagePreview.Address); //webPagePreview.DownloadHandler = IDownloadHandler p; /* * 1. GET Data : ICE, CME, OL * 2. Store this data to Queue Objects * 3. Update Queues File * 4. Read and compare Queues */ /* * ReconQueue t = new ReconQueue(); * Console.WriteLine("********************REACHED HERE***********************"); * //t.filepath = @"C:\Users\Akhand\Downloads\DealReport.xlsx"; * //t.sheetname = "Collated"; * t.QData.Rows[2]["Type"] = "Modified"; * Console.WriteLine("********************LAST LAP***********************"); * t.adp.Update(t.dsXLS); * //t.adp.Update(t.QData); * //t.adp.Update() * Console.WriteLine("********************PHEWWW***********************"); */ }