コード例 #1
0
        private void ButtonAdd_Click(object sender, RoutedEventArgs e)
        {
            if (ButtonAdd.Content.ToString() == "Add")
            {
                ButtonAdd.Content             = "Confirm";
                TextBoxDescription.Background = Brushes.White;
                TextBoxCategoryId.Background  = Brushes.White;
                TextBoxDescription.IsReadOnly = false;
                TextBoxCategoryId.IsReadOnly  = false;

                // Clear out boxes
                TextBoxId.Text          = "";
                TextBoxDescription.Text = "";
                TextBoxCategoryId.Text  = "";
            }

            else
            {
                ButtonAdd.Content             = "Add";
                ButtonEdit.IsEnabled          = false;
                TextBoxDescription.IsReadOnly = true;
                TextBoxCategoryId.IsReadOnly  = true;
                var brush = new BrushConverter();
                TextBoxDescription.Background = (Brush)brush.ConvertFrom("#B3A4C5");
                TextBoxCategoryId.Background  = (Brush)brush.ConvertFrom("#B3A4C5");

                int.TryParse(TextBoxCategoryId.Text, out int categoryId);

                var addTask = new Task()
                {
                    Description = TextBoxDescription.Text,
                    CategoryID  = categoryId
                };

                using (var db = new NewTasksDBEntities())
                {
                    // Add to database
                    db.Tasks.Add(addTask);
                    db.SaveChanges();

                    // Update list box
                    ListBoxTasks.ItemsSource = null;      // Reset list box
                    taskItems = db.Tasks.ToList();        // Get fresh list
                    ListBoxTasks.ItemsSource = taskItems; // Relink
                }
            }
        }
コード例 #2
0
        private void ButtonEdit_Click(object sender, RoutedEventArgs e)
        {
            if (ButtonEdit.Content.ToString() == "Edit")
            {
                TextBoxDescription.IsReadOnly = false;
                TextBoxCategoryId.IsReadOnly  = false;
                ButtonEdit.Content            = "Save";
                TextBoxDescription.Background = Brushes.White;
                TextBoxCategoryId.Background  = Brushes.White;
            }

            else
            {
                using (var db = new NewTasksDBEntities())
                {
                    var taskToEdit = db.Tasks.Find(task.TaskID);

                    // Update description and categoryID
                    taskToEdit.Description = TextBoxDescription.Text;

                    // Convert category id to int from text box (string)
                    // Tryparse is safe to do conversion : null if fails
                    int.TryParse(TextBoxCategoryId.Text, out int categoryId);
                    taskToEdit.CategoryID = categoryId;

                    // Update records to database
                    db.SaveChanges();

                    // Update list box
                    ListBoxTasks.ItemsSource = null;      // Reset list box
                    taskItems = db.Tasks.ToList();        // Get fresh list
                    ListBoxTasks.ItemsSource = taskItems; // Relink
                }
                ButtonEdit.Content            = "Edit";
                ButtonEdit.IsEnabled          = false;
                TextBoxDescription.IsReadOnly = true;
                TextBoxCategoryId.IsReadOnly  = true;
                var brush = new BrushConverter();
                TextBoxDescription.Background = (Brush)brush.ConvertFrom("#B3A4C5");
                TextBoxCategoryId.Background  = (Brush)brush.ConvertFrom("#B3A4C5");
            }
        }
コード例 #3
0
        private void ButtonDelete_Click(object sender, RoutedEventArgs e)
        {
            if (ButtonDelete.Content.ToString() == "Delete")
            {
                ButtonDelete.Content          = "Sure?";
                TextBoxId.Background          = Brushes.PaleVioletRed;
                TextBoxDescription.Background = Brushes.PaleVioletRed;
                TextBoxCategoryId.Background  = Brushes.PaleVioletRed;
            }

            else
            {
                using (var db = new NewTasksDBEntities())
                {
                    var taskToDelete = db.Tasks.Find(task.TaskID);
                    db.Tasks.Remove(taskToDelete);

                    // Update records to database
                    db.SaveChanges();

                    // Update list box
                    ListBoxTasks.ItemsSource = null;      // Reset list box
                    taskItems = db.Tasks.ToList();        // Get fresh list
                    ListBoxTasks.ItemsSource = taskItems; // Relink
                }

                ButtonDelete.Content   = "Delete";
                ButtonDelete.IsEnabled = false;

                // Clear out boxes
                TextBoxId.Text          = "";
                TextBoxDescription.Text = "";
                TextBoxCategoryId.Text  = "";

                var brush = new BrushConverter();
                TextBoxId.Background          = (Brush)brush.ConvertFrom("#B3A4C5");
                TextBoxDescription.Background = (Brush)brush.ConvertFrom("#B3A4C5");
                TextBoxCategoryId.Background  = (Brush)brush.ConvertFrom("#B3A4C5");
            }
        }