private void btn_AddAllTasks_Click(object sender, RoutedEventArgs e)
        {
            FillAvailableTasks();
                     string s_ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data " +
                     "Source=|DataDirectory|\\CloseoutApp.accdb";
                     using (OleDbConnection AccessConn = new OleDbConnection(s_ConnString))
                     {
                         using (OleDbCommand AccessCmd = AccessConn.CreateCommand())
                         {
                             foreach (TaskForMilestone t in GlobalVars.AvailableTasksForMilestone)
                             {

                                 AccessCmd.CommandText = "INSERT INTO Tasks (TaskID, ContractID, MilestoneID) " +
                                         "VALUES (@TID, @CID, @MID);";
                                 AccessCmd.Parameters.Clear();
                                 AccessCmd.Parameters.Add("TID", OleDbType.Integer).Value = t.TaskID;
                                 AccessCmd.Parameters.Add("CID", OleDbType.Integer).Value = GlobalVars.SelectedContract;
                                 AccessCmd.Parameters.Add("MID", OleDbType.Integer).Value = GlobalVars.SelectedMilestone;

                                 try
                                 {
                                     AccessConn.Open();
                                     AccessCmd.ExecuteNonQuery();
                                     AccessConn.Close();
                                 }
                                 catch (Exception except)
                                 {
                                     MessageBox.Show("Database error: " + except.Message,
                                     "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                                 }
                             }
                         }
                     }
                     // Update the Global list of tasks for the selected milestone for that contract.
                     ContractStatus cts = new ContractStatus();
                     cts.UpdateTasksForMilestoneList(GlobalVars.SelectedMilestone);

                     // Head back to the contract status screen.
                     NavigationService nav = NavigationService.GetNavigationService(this);
                     nav.Navigate(new System.Uri("ContractStatus.xaml", UriKind.RelativeOrAbsolute));
        }
        private void btn_Save_Click(object sender, RoutedEventArgs e)
        {
            /* btn_Save_Click
             * If the New Task button was clicked and there is an available
             * task selected in the ComboBox...
             * 1. Sets up the parameterized SQL command.
             * 2. Adds the TaskID, ContractID, and MilestoneID parameters to the query.
             * 3. Attempts the query, popping a message box if successful or if an error was thrown.
             * 4. Updates the global list of tasks for that milestone.
             * 5. Automatically returns to the contract status screen.
             *
             * If there was no task selected, throws an error.
             * If New Task wasn't clicked, they shouldn't be able to click save anyway.
             *
             * */

            if (NewTask == true)
            {
                if (cb_TasksPicker.SelectedIndex != -1)
                {
                    string s_ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data " +
                     "Source=|DataDirectory|\\CloseoutApp.accdb";

                    using (OleDbConnection AccessConn = new OleDbConnection(s_ConnString))
                    {
                        using (OleDbCommand AccessCmd = AccessConn.CreateCommand())
                        {
                            string command = "INSERT INTO Tasks (TaskID, ContractID, MilestoneID) " +
                                "VALUES (@TID, @CID, @MID);";

                            AccessCmd.CommandText = command;

                            AccessCmd.Parameters.Add("TID", OleDbType.Integer).Value = GlobalVars.AvailableTasksForMilestone[cb_TasksPicker.SelectedIndex].TaskID;
                            AccessCmd.Parameters.Add("CID", OleDbType.Integer).Value = GlobalVars.SelectedContract;
                            AccessCmd.Parameters.Add("MID", OleDbType.Integer).Value = GlobalVars.SelectedMilestone;

                            AccessConn.Open();

                            try
                            {
                                if (AccessCmd.ExecuteNonQuery() > 0)
                                {
                                    MessageBox.Show("Task successfully added.", "Added",
                                        MessageBoxButton.OK, MessageBoxImage.Information);
                                }
                                AccessCmd.Parameters.Clear();
                            }
                            catch (Exception dbex)
                            {
                                MessageBox.Show("Error when adding task:\n" + dbex.Message +
                                    "\nPlease take a screenshot and\nreport this to Ashton.",
                                    "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                            }
                            AccessConn.Close();
                        }
                    }

                    // Update the Global list of tasks for the selected milestone for that contract.
                    ContractStatus cts = new ContractStatus();
                    cts.UpdateTasksForMilestoneList(GlobalVars.SelectedMilestone);

                    // Head back to the contract status screen.
                    NavigationService nav = NavigationService.GetNavigationService(this);
                    nav.Navigate(new System.Uri("ContractStatus.xaml", UriKind.RelativeOrAbsolute));
                }
                else
                {
                    MessageBox.Show("No task selected. No tasks may be available to input\nfor this milestone.",
                        "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
            else
            {
                // Do nothing. Shouldn't be able to click save if false anyway.
            }
        }