private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
long status = 0;
if (comboBox1.Text == "InProgress")
{
status = 3;
labelStatus.Text = "InProgress";
}
if (comboBox1.Text == "Completed")
{
status = 4;
labelStatus.Text = "Completed";
}
if (comboBox1.Text == "Expired")
{
status = 5;
labelStatus.Text = "Expired";
}
if (comboBox1.Text == "Extended")
{
status = 6;
labelStatus.Text = "Extended";
}
try
{
if (comboBox1.Text == "Extended")
{
DatabaseConnection.getInstance().ExecuteQuery(string.Format("UPDATE Task SET Status='{0}',EndDate='{1}' WHERE Id='{2}'", status, Convert.ToDateTime(dateTimePickerEndDate.Value), Id));
if (labelStatus.Text == "Completed")
{
labelStatus.ForeColor = System.Drawing.Color.Green;
}
if (labelStatus.Text == "Extended")
{
labelStatus.ForeColor = System.Drawing.Color.Orange;
}
if (labelStatus.Text == "Expired")
{
labelStatus.ForeColor = Color.Red;
}
if (labelStatus.Text == "InProgress")
{
labelStatus.ForeColor = Color.Blue;
}
MessageBox.Show("Status Update");
frm.update();
}
else
{
DatabaseConnection.getInstance().ExecuteQuery(string.Format("UPDATE Task SET Status='{0}' WHERE Id='{1}'", status, Id));
if (labelStatus.Text == "Completed")
{
labelStatus.ForeColor = System.Drawing.Color.Green;
}
if (labelStatus.Text == "Extended")
{
labelStatus.ForeColor = System.Drawing.Color.Orange;
}
if (labelStatus.Text == "Expired")
{
labelStatus.ForeColor = Color.Red;
}
if (labelStatus.Text == "InProgress")
{
labelStatus.ForeColor = Color.Blue;
}
MessageBox.Show("Status Update");
frm.update();
}
}catch (Exception exp)
{
MessageBox.Show("Failed to Update Task, Error : " + exp);
}
}
else
{
MessageBox.Show("Status must be selected!");
}
}