private void button2_Click(object sender, EventArgs e)
{
validate val = new validate();
val.ShowDialog();
if (val.upflag == "1")
{
try
{
using (SQLiteConnection conn = new SQLiteConnection(DBConn.LoadConnectionString()))
{
string qry = @"delete from todo where code = @code";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(qry, conn);
cmd.Parameters.AddWithValue("@code", this.label2.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Task Deleted!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show("Oops, Wrong Password");
return;
}
loadTask();
}
private void clearDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
{
validate val = new validate();
val.ShowDialog();
if (val.upflag == "1")
{
try
{
using (SQLiteConnection conn = new SQLiteConnection(DBConn.LoadConnectionString()))
{
string qry = @"DELETE FROM todo;
DELETE FROM sqlite_sequence WHERE name = 'todo';";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(qry, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("DATABASE CLEARED!");
loadTask();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show("Oops, Wrong Password");
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
string strPending = "update todo set done_flag = 'Done' where code = @code";
string strDone = "update todo set done_flag = 'Pending' where code = @code";
string messPending = "Task Marked as Done!";
string messDone = "Task Marked as Pending!";
string qry = null;
string mess = null;
if (comboBox1.Text == "Pending")
{
qry = strPending;
mess = messPending;
}
else if (comboBox1.Text == "Done")
{
validate val = new validate();
val.ShowDialog();
if (val.upflag == "1")
{
qry = strDone;
mess = messDone;
}
else
{
MessageBox.Show("Oops, Wrong Password");
return;
}
}
else
{
return;
}
try
{
using (SQLiteConnection conn = new SQLiteConnection(DBConn.LoadConnectionString()))
{
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(qry, conn);
cmd.Parameters.AddWithValue("@code", label2.Text);
cmd.ExecuteNonQuery();
MessageBox.Show(mess);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
label2.Text = "*";
loadTask();
}
}
private void button3_Click(object sender, EventArgs e)
{
validate val = new validate();
val.ShowDialog();
if (val.upflag == "1")
{
alterTask a = new alterTask(this);
a.ShowDialog();
}
else
{
MessageBox.Show("Oops, Wrong Password");
return;
}
loadTask();
}