private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e)
{
PropertyFinder finder = new PropertyFinder();
finder.InformationDownloadEvent += new InformationDownloadHandler(finder_InformationDownloadEvent);
icon.BalloonTipText = "STARTED";
icon.ShowBalloonTip(5 * 60 * 1000);
string ConsoleText = null;
if (String.IsNullOrEmpty(textBox1.Text) == false)
{
//// D:\\Week185_SampleFile_Z5.xlsx
OledbHandler Excelhandler = new OledbHandler(textBox1.Text, null);
ConsoleText = Excelhandler.ReadExcelFileSingle(textBox1.Text.Trim(), "No Addresses Found$", "POSTCODE");
}
SetRichboxText(ConsoleText);
SetRichboxText("\n\n\n");
SetLabelText("Start time=" + DateTime.Now);
// ConsoleText = finder.FindMultipleProperties();
SetRichboxText(ConsoleText);
SetRichboxText("\n\n\n");
SetLabelText("Read PAF FILE");
// this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
handler = new OledbHandler(textBox14.Text, "Table");
Property p = new Property();
p = handler.GetRecordByID(textBox13.Text);
if (p != null)
{
richTextBox1.Text += p.FullAddress + " , " + p.SuccessURL + "\n";
}
richTextBox1.Text += handler.OLEDBLog;
}