/// <summary>
        /// Attempts to Update the object and Database when Update button is pressed
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Btn_Update_Click(object sender, EventArgs e)
        {
            string successMessage = "";

            using (var conn = new MySqlConnection(connecterString))
            {
                try
                {
                    //Update information with Information with Textboxes, the user and dates updated
                    if (selectedCustomer != 0)
                    {
                        myCustomer = new Customer(selectedCustomer, conn);
                        // If the Address is changing, create a new address, and link the new address to the customer
                        string textBoxCheckAddress  = Txt_Address1.Text + Txt_Address2.Text + Txt_City.Text;
                        string databaseCheckAddress = myCustomer.addressObject.address + myCustomer.addressObject.address2 + myCustomer.addressObject.cityObject.cityName;
                        int    updatingAddressId    = (int)myCustomer.addressID;

                        //Set the values to the customer Object based on the
                        myCustomer.customerName = Txt_CustName.Text;
                        myCustomer.lastUpdate   = DateTime.Now;
                        myCustomer.lastUpdateBy = loggedInUser;


                        if (textBoxCheckAddress != databaseCheckAddress)
                        {
                            Address updatedAddress = new Address(Txt_Address1.Text, Txt_Address2.Text, Txt_City.Text, Txt_Country.Text, Txt_PostalCode.Text, Txt_PhoneNumber.Text, loggedInUser, conn);
                            myCustomer.addressID = updatedAddress.addressId;
                            updatingAddressId    = myCustomer.addressID;
                        }



                        string myUpdateCustomersQuery = "UPDATE customer c JOIN address a ON c.addressId = a.addressId "
                                                        + "SET c.customerName = '" + Txt_CustName.Text.ToString() + "', c.addressId = "
                                                        + updatingAddressId.ToString() + ", c.lastUpdate = '" + DateTime.Now.ToString("yyyy-MM-dd")
                                                        + "', c.lastUpdateBy = '" + loggedInUser + "', a.phone = '" + Txt_PhoneNumber.Text
                                                        + "', a.lastUpdate = '" + DateTime.Now.ToString("yyyy-MM-dd")
                                                        + "', a.lastUpdateBy = '" + loggedInUser + "' "
                                                        + "WHERE c.customerId = " + myCustomer.customerID.ToString();
                        //DataChanges dt = new DataChanges();
                        DataChanges.ExecuteMySqlCommand(myUpdateCustomersQuery, conn);
                        customerAdded  = true;
                        successMessage = "Customer Information successfully Updated";
                    }
                    else
                    {
                        //int id = int.Parse(Txt_CustId.Text);
                        myCustomer = new Customer(Txt_CustName.Text, Txt_Address1.Text, Txt_Address2.Text, Txt_City.Text, Txt_Country.Text, Txt_PostalCode.Text, Txt_PhoneNumber.Text, loggedInUser, conn);
                        Address myAddress = myCustomer.addressObject;
                        Txt_CustId.Text      = myCustomer.customerID.ToString();
                        Txt_CustName.Text    = myCustomer.customerName;
                        Txt_Address1.Text    = myAddress.address;
                        Txt_Address2.Text    = myAddress.address2;
                        Txt_City.Text        = myAddress.cityObject.cityName;
                        Txt_Country.Text     = myAddress.cityObject.countryObject.country;
                        Txt_PhoneNumber.Text = myAddress.phone;
                        Txt_PostalCode.Text  = myAddress.postalCode;
                        successMessage       = "Customer Successfully Added";
                    }
                    MessageBox.Show(successMessage);

                    //If customer is created, set customerAdded = true to use if creation is cancelled
                    customerAdded = true;
                    Close();
                }
                catch (Exception innerException)
                {
                    MessageBox.Show("Add/Update Failed \n", innerException.ToString());
                }
            }
        }