

commit c36336e44b2eb100f42742dae67001b4efd62250 (HEAD -> master, origin/master)
Author: Karen Payne <Karen.1.payne@oregon.gov>
Date:   Mon Oct 26 19:45:24 2020 -0700

    Code to remove record in UserDeletingRow event for a DataGridView.

diff --git a/North/Classes/CustomerEntity.cs b/North/Classes/CustomerEntity.cs
index 7c7b783..a064578 100644
--- a/North/Classes/CustomerEntity.cs
+++ b/North/Classes/CustomerEntity.cs
@@ -155,6 +155,11 @@ namespace North.Classes
             }
         }
 
+        public override string ToString()
+        {
+            return CustomerIdentifier.ToString();
+        }
+
         public event PropertyChangedEventHandler PropertyChanged;
         protected virtual void OnPropertyChanged([CallerMemberName] string propertyName = null)
         {
diff --git a/North/Forms/CustomersDataGridViewTestForm.Designer.cs b/North/Forms/CustomersDataGridViewTestForm.Designer.cs
index f57dd1f..e1fd0e5 100644
--- a/North/Forms/CustomersDataGridViewTestForm.Designer.cs
+++ b/North/Forms/CustomersDataGridViewTestForm.Designer.cs
@@ -31,6 +31,8 @@
             this.components = new System.ComponentModel.Container();
             System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(CustomersDataGridViewTestForm));
             this.panel1 = new System.Windows.Forms.Panel();
+            this.label1 = new System.Windows.Forms.Label();
+            this.AddNewCustomerButton = new System.Windows.Forms.Button();
             this.CompanyNameStartsWithTextBox = new System.Windows.Forms.TextBox();
             this.SaveChangesButton = new System.Windows.Forms.Button();
             this.CurrentCustomerDetails = new System.Windows.Forms.Button();
@@ -64,6 +66,8 @@
             // 
             // panel1
             // 
+            this.panel1.Controls.Add(this.label1);
+            this.panel1.Controls.Add(this.AddNewCustomerButton);
             this.panel1.Controls.Add(this.CompanyNameStartsWithTextBox);
             this.panel1.Controls.Add(this.SaveChangesButton);
             this.panel1.Controls.Add(this.CurrentCustomerDetails);
@@ -73,6 +77,25 @@
             this.panel1.Size = new System.Drawing.Size(1060, 56);
             this.panel1.TabIndex = 0;
             // 
+            // label1
+            // 
+            this.label1.AutoSize = true;
+            this.label1.Location = new System.Drawing.Point(456, 24);
+            this.label1.Name = "label1";
+            this.label1.Size = new System.Drawing.Size(35, 13);
+            this.label1.TabIndex = 4;
+            this.label1.Text = "label1";
+            // 
+            // AddNewCustomerButton
+            // 
+            this.AddNewCustomerButton.Location = new System.Drawing.Point(303, 19);
+            this.AddNewCustomerButton.Name = "AddNewCustomerButton";
+            this.AddNewCustomerButton.Size = new System.Drawing.Size(129, 23);
+            this.AddNewCustomerButton.TabIndex = 3;
+            this.AddNewCustomerButton.Text = "Add code";
+            this.AddNewCustomerButton.UseVisualStyleBackColor = true;
+            this.AddNewCustomerButton.Click += new System.EventHandler(this.AddNewCustomerButton_Click);
+            // 
             // CompanyNameStartsWithTextBox
             // 
             this.CompanyNameStartsWithTextBox.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
@@ -279,6 +302,7 @@
             // DeleteCustomerBindingNavigatorButton
             // 
             this.DeleteCustomerBindingNavigatorButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
+            this.DeleteCustomerBindingNavigatorButton.Enabled = false;
             this.DeleteCustomerBindingNavigatorButton.Image = ((System.Drawing.Image)(resources.GetObject("DeleteCustomerBindingNavigatorButton.Image")));
             this.DeleteCustomerBindingNavigatorButton.Name = "DeleteCustomerBindingNavigatorButton";
             this.DeleteCustomerBindingNavigatorButton.RightToLeftAutoMirrorImage = true;
@@ -340,5 +364,7 @@
         private System.Windows.Forms.Button SaveChangesButton;
         private System.Windows.Forms.ToolTip toolTip1;
         private System.Windows.Forms.TextBox CompanyNameStartsWithTextBox;
+        private System.Windows.Forms.Button AddNewCustomerButton;
+        private System.Windows.Forms.Label label1;
     }
 }
\ No newline at end of file
diff --git a/North/Forms/CustomersDataGridViewTestForm.cs b/North/Forms/CustomersDataGridViewTestForm.cs
index 8b9d081..5cc147c 100644
--- a/North/Forms/CustomersDataGridViewTestForm.cs
+++ b/North/Forms/CustomersDataGridViewTestForm.cs
@@ -8,6 +8,7 @@ using System.Text;
 using System.Threading.Tasks;
 using System.Windows.Forms;
 using LanguageExtensions;
+using Microsoft.EntityFrameworkCore;
 using Microsoft.EntityFrameworkCore.ChangeTracking;
 using North.Classes;
 using North.Classes.Components;
@@ -24,6 +25,7 @@ namespace North.Forms
         private SortableBindingList<CustomerEntity> _customerView;
         private SortableBindingList<CustomerEntity> _customerViewFilter;
         private readonly BindingSource _customerBindingSource = new BindingSource();
+
         private bool _filtered = false;
 
         public CustomersDataGridViewTestForm()
@@ -53,6 +55,7 @@ namespace North.Forms
             {
                 try
                 {
+
                     var filter = CompanyNameStartsWithTextBox.Text.Trim();
                     _customerViewFilter = new SortableBindingList<CustomerEntity>(_customerView.Where(customerEntity =>
                         customerEntity.CompanyName.ToLower().StartsWith(filter)).ToList());
@@ -99,8 +102,75 @@ namespace North.Forms
 
             CustomersDataGridView.CellValueChanged += CustomersDataGridView_CellValueChanged;
             CustomersDataGridView.UserDeletingRow += CustomersDataGridView_UserDeletingRow;
+
+            
             _customerView.ListChanged += _customerView_ListChanged;
+            _customerView.AddingNew += _customerView_AddingNew;
+
+            DeleteCustomerBindingNavigatorButton.Enabled = true;
+
+            CustomersDataGridView.RowPrePaint += CustomersDataGridView_RowPrePaint;
+            
+
+        }
+        /// <summary>
+        /// - Set default values (hard coded) for new row.
+        /// - The code in this form was never meant to allow
+        ///   adding via the DataGridView, this is to show in part what to do.
+        ///
+        ///   What needs to change? for one, the DataGridViewComboBoxes would
+        ///   need "Select" selection and code to validate that selection is
+        ///   not selected when leaving the row.
+        /// </summary>
+        /// <param name="sender"></param>
+        /// <param name="e"></param>
+        private void _customerView_AddingNew(object sender, AddingNewEventArgs e)
+        {
+            e.NewObject = new CustomerEntity() {ContactIdentifier = 91, CountryIdentifier = 9, ContactTypeIdentifier = 11};
+        }
+        /// <summary>
+        /// Get newly added Customer (CustomerEntity)
+        /// </summary>
+        /// <param name="sender"></param>
+        /// <param name="e"></param>
+        private void CustomersDataGridView_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)
+        {
+            if (CustomersDataGridView.Rows[e.RowIndex].DataBoundItem != null)
+            {
+                label1.Text = ((CustomerEntity) CustomersDataGridView.Rows[e.RowIndex].DataBoundItem).CompanyName;
+            }
+        }
+        /// <summary>
+        /// For validating stuff, currently not production ready.
+        /// </summary>
+        /// <param name="sender"></param>
+        /// <param name="e"></param>
+        private void AddNewCustomerButton_Click(object sender, EventArgs e)
+        {
+            
+            /*
+             * NOTE: WIP
+             */
+
+            CustomerEntity customerEntity = _customerView.FirstOrDefault(x => x.CustomerIdentifier == 0);
+            customerEntity.ContactIdentifier = 52;
+            customerEntity.CountryIdentifier = 9;
 
+            Customers customers = new Customers
+            {
+                CompanyName = customerEntity.CompanyName,
+                CountryIdentifier = customerEntity.CountryIdentifier,
+                ContactId = 52,
+                ContactTypeIdentifier = 5
+            };
+
+
+            CustomersTestOperations.Context.Attach(customers).State = EntityState.Added;
+            if (CustomersTestOperations.Context.SaveChanges() != 1)
+            {
+                // alert user and/or write to log file.
+            }
+            
         }
 
         private bool _hasValidationErrors;
@@ -120,7 +190,7 @@ namespace North.Forms
                 // Get current customer in current DataGridView row
                 //
                 CustomerEntity currentCustomer = _customerView.CurrentCustomer(_customerBindingSource.Position);
-
+                Console.WriteLine($" -> {e.ListChangedType.ToString()}");
                 //
                 // Assert if there are changes to the current row in the DataGridView
                 //
@@ -303,17 +373,31 @@ namespace North.Forms
         {
             if (_customerView.Count <= 0) return;
 
-            CustomerEntity customer = _customerView.CurrentCustomer(_customerBindingSource.Position);
+            var customer = _customerView.CurrentCustomer(_customerBindingSource.Position);
 
             if (Question($"Remove {customer.CompanyName}"))
             {
-                MessageBox.Show(@"Removal goes here");
+
+                var customerToRemove = CustomersTestOperations.Context.Customers.Find(customer.CustomerIdentifier);
+                CustomersTestOperations.Context.Customers.Remove(customerToRemove);
+                try
+                {
+                    CustomersTestOperations.Context.SaveChanges();
+                }
+                catch (Exception ex)
+                {
+                    /*
+                     * Common reason is no cascade rule to related table(s)
+                     */
+                    MessageBox.Show($"Failed to remove customer\n{ex.Message}");
+                }
+
             }
             else
             {
                 e.Cancel = true;
-                MessageBox.Show(@"Removal aborted");
             }
         }
+
     }
 }