private async void timer2_TickAsync(object sender, EventArgs e)
{
button2.PerformClick();
//browser.ViewSource();
String x = await browser.GetSourceAsync();
string task = getBetween(x, textBox1.Text, textBox2.Text);
string defect = getBetween(x, textBox3.Text, textBox4.Text);
richTextBox1.Text = task + " " + defect;
try
{
int newActive = Convert.ToInt32(task);
int newDefect = Convert.ToInt32(defect);
Boolean hasOne = false;
RALLY_NOTIFYER.textnotification = "";
if (newActive > oldActive)
{
//NEGATIVE NEWS TO NOTIFY
RALLY_NOTIFYER.textnotification += Environment.NewLine + "NEW ACTIVE TASK ADDED!";
hasOne = true;
}
else if (newActive < oldActive)
{
//POSITIVE NEWS TO NOTIFY
RALLY_NOTIFYER.textnotification += Environment.NewLine + "AN ACTIVE TASK HAS BEEN CLOSED!";
hasOne = true;
}
if (newDefect > oldDefect)
{
//NEGATIVE NEWS TO NOTIFY
RALLY_NOTIFYER.textnotification += Environment.NewLine + "NEW DEFECT HAS BEEN RAISED!";
hasOne = true;
}
else if (newDefect < oldDefect)
{
//POSITIVE NEWS TO NOTIFY
RALLY_NOTIFYER.textnotification += Environment.NewLine + "A DEFECT HAS BEEN CLOSED!";
hasOne = true;
}
if (hasOne)
{
RALLY_NOTIFYER frm2 = new RALLY_NOTIFYER();
frm2.Show();
}
oldActive = Convert.ToInt32(task);
oldDefect = Convert.ToInt32(defect);
notifyIcon1.Text = "Active: " + task + " Defects:" + defect;
}
catch (Exception ex)
{
richTextBox1.Text = ex.Message;
}
}
public void FillDataGrids()
{
string filename = "export.csv";
if (filename.Trim() != string.Empty)
{
try
{
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
if (dataGridView1.Rows.Count < 1)
{
dt = NewDataTable(filename, ",", false);
dataGridView1.DataSource = dt.DefaultView;
}
else
{
dt2 = NewDataTable(filename, ",", false);
dataGridView2.DataSource = dt2.DefaultView;
//COMPARE
for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j < dataGridView1.ColumnCount - 1; j++)
{
var arg1 = dataGridView1.Rows[i].Cells[j].Value.ToString();
var arg2 = dataGridView2.Rows[i].Cells[j].Value.ToString();
if (!arg1.Equals(arg2, StringComparison.InvariantCultureIgnoreCase))
{
if (dataGridView2.Rows[0].Cells[j].Value.ToString() != "Last Update Date")
{
dataGridView1.Rows[i].Cells[j].Style.BackColor = Color.Red;
dataGridView2.Rows[i].Cells[j].Style.BackColor = Color.Red;
notifStatement += Environment.NewLine + dataGridView2.Rows[i].Cells[0].Value.ToString() + " " + dataGridView2.Rows[i].Cells[1].Value.ToString();
notifStatement += Environment.NewLine + "has changed its " + dataGridView2.Rows[0].Cells[j].Value.ToString();
notifStatement += Environment.NewLine + "from " + dataGridView1.Rows[i].Cells[j].Value.ToString().ToUpper();
notifStatement += " to " + dataGridView2.Rows[i].Cells[j].Value.ToString().ToUpper() + ".";
RALLY_NOTIFYER.textnotification = notifStatement;
RALLY_NOTIFYER frm2 = new RALLY_NOTIFYER();
frm2.Show();
}
}
}
}
//THEN REPLACE dataGridView1.DataSource = dt.DefaultView
dt = NewDataTable(filename, ",", false);
dataGridView1.DataSource = dt.DefaultView;
//THEN CLEAR dataGridView2.DataSource
dataGridView2.DataSource = null;
}
}
catch (Exception ex)
{
}
}
}