private void Button_Click_1(object sender, RoutedEventArgs e)
{
String project_name = this.projectNameField.Text;
//MessageBox.Show(project_name);
itemWindow itemWin = new itemWindow();
itemWin.ProjectNameValue = project_name;
itemWin.ShowDialog();
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
SQLiteConnection conn = new SQLiteConnection(dbConnectionString);
try
{
if (this.typeBox.Text == "task")
{
MessageBoxResult result = MessageBox.Show("Are you sure you want to Delete this Task?", "Delete Confirmation", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
conn.Open();
string query = "delete from tasks where task_name = '" + this.nameBox.Text + "' and proj_id = (select project_id from projects where project_name = '" + this.projNameBox.Text + "')";
SQLiteCommand createCommand = new SQLiteCommand(query, conn);
createCommand.ExecuteNonQuery();
MessageBox.Show("Item has been deleted!");
conn.Close();
this.Close();
string projectName = this.projNameBox.Text;
itemWindow update = new itemWindow();
update.ProjectNameValue = projectName;
update.ShowDialog();
this.Close();
}
}
else if (this.typeBox.Text == "subtask")
{
MessageBoxResult result = MessageBox.Show("Are you sure you want to Delete this subtask?", "Delete Confirmation", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
conn.Open();
string query = "delete from subtasks where subtask_name = '" + this.nameBox.Text + "';";
SQLiteCommand createCommand = new SQLiteCommand(query, conn);
createCommand.ExecuteNonQuery();
MessageBox.Show("Item has been deleted!");
conn.Close();
this.Close();
string projectName = this.projNameBox.Text;
itemWindow update = new itemWindow();
update.ProjectNameValue = projectName;
update.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show("test");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
