private void LoadAnalyzeNumberToComboBx()
{
this.cmbbxLoadplaintextfromdb.Items.Add("Select Analyze Number To Load Content For Search");
List<int> analyzeno = new List<int>();
ScrapperRecordMain scrm = new ScrapperRecordMain();
analyzeno = scrm.LoaadAnalyzeNumber();
foreach (var filenamesofHTMLn5 in analyzeno)
{
this.cmbbxLoadplaintextfromdb.Items.Add(filenamesofHTMLn5);
}
if (this.cmbbxLoadplaintextfromdb.Items.Count > 0)
this.cmbbxLoadplaintextfromdb.SelectedIndex = 0;
}
private void cmbbxLoadplaintextfromdb_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string pageContent = "Load Search HTML Content";
try
{
ScrapperRecordMain scrm = new ScrapperRecordMain();
int analyzeno = 0;
analyzeno = Convert.ToInt16(cmbbxLoadplaintextfromdb.SelectedItem.ToString());
pageContent = scrm.getThePlainHTMLContentTextFromDB(analyzeno);
if (pageContent == "" || pageContent == null)
{
System.Windows.MessageBox.Show("Empty Data, Please Select Other Analyze Number", "Scraper Demo", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
txtbxSearchHTMLContent.Text = pageContent.Replace("System.Windows.Controls.TextBox:", "");
System.Windows.MessageBox.Show("HTML Content Load For Searching", "Scraper Demo", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch { }
}
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);
}
}