public void insertDatatoMainRecords(mainRecords mainRecord) { SqlCommand cmd = new SqlCommand("insert into ScraperRecordMain(AWNO,webURL,web1URL,web2URL,scrapDateTime,AnalyzeNo) values(" + mainRecord.awNo + ",'" + mainRecord.webURL + "','" + mainRecord.web1URL + "','" + mainRecord.web2URL + "','" + mainRecord.scrapDT.Date.ToString("yyyy-MM-dd HH:mm:ss") + "'," + mainRecord.AnalyzeNo + ")", sqlConnection.connScrapDb); cmd.CommandType = CommandType.Text; try { sqlConnection.connScrapDb.Open(); cmd.ExecuteNonQuery(); sqlConnection.connScrapDb.Close(); } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message.ToString()); } }
public void insertDatatoScraperPageTextData(mainRecords mainRecord) { SqlCommand cmd = new SqlCommand("insert into ScraperPageTextData(AWNO,webURL,web1URL,web2URL,isURLsimilar,scrapDateTime,pageContentText,SearchContentText,SearchDateTime,AnalyzeNo) values(" + mainRecord.awNo + ",'" + mainRecord.webURL + "','" + mainRecord.web1URL + "','" + mainRecord.web2URL + "','" + mainRecord.isURLsimilar + "','" + mainRecord.scrapDT.Date.ToString("yyyy-MM-dd HH:mm:ss") + "','" + mainRecord.pageContentText.ToString().Replace("'", "") + "','" + mainRecord.searchContentText + "','" + mainRecord.searchCtxtDT.ToString("yyyy-MM-dd HH:mm:ss") + "'," + mainRecord.AnalyzeNo + ")", sqlConnection.connScrapDb); cmd.CommandType = CommandType.Text; try { sqlConnection.connScrapDb.Open(); cmd.ExecuteNonQuery(); sqlConnection.connScrapDb.Close(); } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message.ToString()); } }
private void BtnLoadHTMLContentToDB_Click(object sender, RoutedEventArgs e) { mainRecords records = new mainRecords(); sqlConnection sqlconn = new sqlConnection(); ScrapperRecordMain scrpMainRecord = new ScrapperRecordMain(); if (RecordData.firstanalyzeFlg) { records.awNo = sqlconn.getAWNO(); records.webURL = RecordData.mainRecords.webURL; records.web1URL = "n/a"; records.web2URL = "n/a"; records.scrapDT = DateTime.UtcNow; records.AnalyzeNo = sqlconn.getAnalyzeNo(); records.isURLsimilar = "false"; if (this.txtbxShowhtmlcontent.Text == null) { records.pageContentText = ""; } else { records.pageContentText = this.txtbxShowhtmlcontent.ToString(); } records.searchContentText = ""; records.searchCtxtDT = DateTime.UtcNow; scrpMainRecord.insertDatatoMainRecords(records); scrpMainRecord.insertDatatoScraperPageTextData(records); RecordData.firstanalyzeFlg = false; System.Windows.MessageBox.Show("HTML Content Loaded To Database Sucessfully At : " + DateTime.UtcNow.ToString(), "Scraper Demo", MessageBoxButton.OK, MessageBoxImage.Information); return; } else if (RecordData.secondanalyzeFlg) { records.awNo = sqlconn.getAWNO(); records.webURL = RecordData.mainRecords.webURL; records.web1URL = RecordData.mainRecords.web1URL; records.web2URL = RecordData.mainRecords.web2URL; records.scrapDT = DateTime.UtcNow; records.AnalyzeNo = sqlconn.getAnalyzeNo(); if (records.web1URL == records.web2URL) { records.isURLsimilar = "true"; } else { records.isURLsimilar = "false"; } if (this.txtbxShowhtmlcontent.Text == null) { records.pageContentText = ""; } else { records.pageContentText = this.txtbxShowhtmlcontent.ToString(); } records.searchContentText = ""; records.searchCtxtDT = DateTime.UtcNow; scrpMainRecord.insertDatatoMainRecords(records); scrpMainRecord.insertDatatoScraperPageTextData(records); RecordData.secondanalyzeFlg = false; System.Windows.MessageBox.Show("HTML Content Loaded To Database Sucessfully At : " + DateTime.UtcNow.ToString() , "Scraper Demo", MessageBoxButton.OK, MessageBoxImage.Information); return; } else { RecordData.firstanalyzeFlg = false; RecordData.secondanalyzeFlg = false; System.Windows.MessageBox.Show("Please analyze first, then load","Scraper Demo",MessageBoxButton.OK,MessageBoxImage.Information); } }