private void EditMember_button_Click(object sender, RoutedEventArgs e)
        {
            if (Surname_EditDel_combo.Items.Count == 0)
            {
                MessageBox.Show("Please enter a customer to search for");
            }
            else
            {
                string mFirstName = Forename_EditDel_txt.Text.ToString();
                if (mFirstName.Length == 0)
                {
                    MessageBox.Show("Please enter a forename");
                }
                else
                {
                    string stringToBeChecked = ValidationClass.HasNumbersInStringChecker(mFirstName);
                    if (stringToBeChecked != null)
                    {
                        MessageBox.Show("Forename cannot contain numbers");
                    }
                    else
                    {
                        string mLastName = Surname2_EditDel_txt.Text.ToString();
                        if (mLastName.Length == 0)
                        {
                            MessageBox.Show("Please enter a Surname");
                        }
                        else
                        {
                            stringToBeChecked = ValidationClass.HasNumbersInStringChecker(mLastName);
                            if (stringToBeChecked != null)
                            {
                                MessageBox.Show("Surname cannot contain numbers");
                            }
                            else
                            {
                                string mEmail = Email_EditDel_txt.Text.ToString();
                                if (mEmail.Length == 0)
                                {
                                    MessageBox.Show("Please enter an Email");
                                }
                                else
                                {
                                    if (CustomerClass.checkIfEmailExits(mEmail) == true)
                                    {
                                        MessageBox.Show("This email already exists - Please enter another email");
                                    }
                                    else
                                    {
                                        int chosenCustomerID = int.Parse(this.Surname_EditDel_combo.SelectedValue.ToString());
                                        dataSet = CustomerClass.getCustomerById(chosenCustomerID);
                                        string membershipExpiryDate = dataSet.Tables[0].Rows[0]["Membership_Expiry_Date"].ToString();

                                        CustomerClass.editCustomerDetails(chosenCustomerID, mFirstName, mLastName, mEmail, membershipExpiryDate);
                                        MessageBox.Show("Customer edited");
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
        //---------------------------------------------- Add Member Tab ------------------------------------------------------//
        private void CreateMember_button_Click(object sender, RoutedEventArgs e)
        {
            string mFirstName = Forename_AddMember_txt.Text.ToString();

            if (mFirstName.Length == 0)
            {
                MessageBox.Show("Please enter a Forename");
            }
            else
            {
                string stringToBeChecked = ValidationClass.HasNumbersInStringChecker(mFirstName);
                if (stringToBeChecked != null)
                {
                    MessageBox.Show("Forename cannot contain numbers");
                }
                else
                {
                    string mLastName = Surname_AddMember_txt.Text.ToString();
                    if (mLastName.Length == 0)
                    {
                        MessageBox.Show("Please enter a Surname");
                    }
                    else
                    {
                        stringToBeChecked = ValidationClass.HasNumbersInStringChecker(mLastName);
                        if (stringToBeChecked != null)
                        {
                            MessageBox.Show("Surname cannot contain numbers");
                        }
                        else
                        {
                            string mEmail = Email_AddMember_txt.Text.ToString();
                            if (mEmail.Length == 0)
                            {
                                MessageBox.Show("Please enter an Email");
                            }
                            else
                            {
                                if (CustomerClass.checkIfEmailExits(mEmail) == true)
                                {
                                    MessageBox.Show("This email already exists - Please enter another email");
                                }
                                else
                                {
                                    if (GoldMember_checkbox.IsChecked == true)
                                    {
                                        var    currentTime           = ShowingsClass.formatDateTimeToSqlLiteDateString(DateTime.Now.AddMonths(12));
                                        string mMembershipExpiryDate = currentTime.ToString();

                                        CustomerClass.newCustomer(mFirstName, mLastName, mEmail, mMembershipExpiryDate);
                                        MessageBox.Show("Customer added");
                                    }
                                    else
                                    {
                                        CustomerClass.newCustomer(mFirstName, mLastName, mEmail, null);
                                        MessageBox.Show("Customer added");
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }