private void BtnSave_Click(object sender, EventArgs e)
        {
            // strip dollar signs
            string packageBase = Regex.Replace(txtBasePrice.Text, "\\$", "");
            string packageComm = Regex.Replace(txtCommission.Text, "\\$", "");

            int      packageId          = Convert.ToInt32(txtPackageID.Text);
            string   packageName        = txtPackageName.Text;
            DateTime packageStartDate   = dateStart.Value;
            DateTime packageEndDate     = dateEnd.Value;
            string   packageDescription = txtPackageDesc.Text;
            double   packageBasePrice   = Convert.ToDouble(packageBase);
            double   packageCommission  = Convert.ToDouble(packageComm);

            try
            {
                TravelPackageDB updateTravelPackage = new TravelPackageDB();
                updateTravelPackage.EditTravelPackage(packageId, packageName, packageStartDate, packageEndDate, packageDescription, packageBasePrice, packageCommission);

                this.Close();
                TravelPackageForm refreshFrom = new TravelPackageForm();
                refreshFrom.Refresh();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString());
            }
        }
        // validate changes and save form
        private void BtnSave_Click(object sender, EventArgs e)
        {
            if (Validator.IsNotEmpty(txtPackageName, "Package Name") &&
                Validator.IsLettersAndSpaces(txtPackageName, "Package Name") &&
                Validator.IsValidStartDate(dateStart) &&
                Validator.IsValidEndDate(dateStart, dateEnd) &&
                Validator.IsNotEmpty(txtPackageDesc, "Package description") &&
                Validator.IsNotEmpty(txtBasePrice, "Base price") &&
                Validator.IsCurrency(txtBasePrice, "base price") &&
                Validator.IsNotEmpty(txtCommission, "Commission") &&
                Validator.IsCurrency(txtCommission, "commission"))
            {
                // strip dollar signs
                string packageBase = Regex.Replace(txtBasePrice.Text, "\\$", "");
                string packageComm = Regex.Replace(txtCommission.Text, "\\$", "");

                string   packageName        = txtPackageName.Text;
                DateTime packageStartDate   = dateStart.Value;
                DateTime packageEndDate     = dateEnd.Value;
                string   packageDescription = txtPackageDesc.Text;
                double   packageBasePrice   = Convert.ToDouble(packageBase);
                double   packageCommission  = Convert.ToDouble(packageComm);
                try
                {
                    TravelPackageDB addNewPackage = new TravelPackageDB();
                    addNewPackage.AddTravelPackage(packageName, packageStartDate, packageEndDate, packageDescription, packageBasePrice, packageCommission);

                    this.Close();
                    TravelPackageForm refreshFrom = new TravelPackageForm();
                    refreshFrom.Refresh();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, ex.GetType().ToString());
                }
            }
        }