private void completeTask(object sender, RoutedEventArgs e) { var item = (sender as FrameworkElement).DataContext; int index = bucketListView.Items.IndexOf(item); CompleteTaskWindow completeTaskWindow = new CompleteTaskWindow(bucketListTasks[index]); if (completeTaskWindow.ShowDialog() == true) { ListViewItem row = bucketListView.ItemContainerGenerator.ContainerFromIndex(index) as ListViewItem; row.Background = Brushes.LightGreen; Button b = (Button)sender; b.IsEnabled = false; BucketListTask task = bucketListTasks[index]; string query = "UPDATE TASKS " + "SET COST = '" + task.cost.ToString() + "', LOCATION = '" + task.location + "', ISCOMPLETE = 1, DATECOMPLETED = '" + task.dateCompleted + "'" + "WHERE NAME = '" + task.name + "' AND DESCRIPTION = '" + task.description + "' "; dbCon.executeCommand(query); // TODO: Move completed item to end of list signifying it's completion } }
public CompleteTaskWindow(BucketListTask task) { InitializeComponent(); bucketListTask = task; taskNameLabel.Content = bucketListTask.name; }
public ViewTaskWindow(BucketListTask task) { InitializeComponent(); bucketListTask = task; fillTaskInfo(); }
private void fillListFromDB() { bucketListTasks.Clear(); for (int i = 0; i < 2; i++) { string query; if (i == 0) { query = "SELECT * FROM Tasks " + "WHERE isComplete = 0"; } else { query = "SELECT * FROM Tasks " + " WHERE isComplete = 1"; } DataSet ds = dbCon.queryDB(query); foreach (DataTable table in ds.Tables) { foreach (DataRow row in table.Rows) { bool complete = Convert.ToBoolean(row["isComplete"]); double cost = 0; string location = "N/A"; string memoryPath = null; string dateCompleted = "N/A"; if (row["cost"] != System.DBNull.Value) { cost = Convert.ToDouble(row["cost"]); } if (row["location"] != System.DBNull.Value) { location = row["location"].ToString(); } if (row["memoryPath"] != System.DBNull.Value) { memoryPath = row["memoryPath"].ToString(); } if (row["dateCompleted"] != System.DBNull.Value) { dateCompleted = row["dateCompleted"].ToString(); } BucketListTask task = new BucketListTask(row["name"].ToString(), row["difficulty"].ToString(), row["description"].ToString(), cost, location, memoryPath, dateCompleted, complete); bucketListTasks.Add(task); } } } }