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);
}
}
}
}
