private void BtnDelete_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("Delete " + lblPackageName.Text + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (result == DialogResult.Yes)
            {
                TravelWinRepository package = new TravelWinRepository();
                int selectedPackage         = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);
                package.DeletePackage(selectedPackage);
                gridPackages.DataSource = package.GetPackages();
            }
        }
        public void RefreshData()
        {
            TravelWinRepository packages = new TravelWinRepository();

            gridPackages.DataSource = packages.GetPackages();
            int selectedPackage = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);

            gridProducts.DataSource = packages.GetProducts(selectedPackage);
            for (int i = 0; i < gridPackages.RowCount; i++)
            {
                if (Convert.ToBoolean(gridPackages.Rows[i].Cells["Expired"].Value))
                {
                    gridPackages.Rows[i].DefaultCellStyle.BackColor = Color.Red;
                }
            }
            gridAllProducts.DataSource = packages.GetProductSuppliers();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            TravelWinRepository packages = new TravelWinRepository();

            gridPackages.DataSource = packages.GetPackages();
            int selectedPackage = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);

            gridProducts.DataSource         = packages.GetProducts(selectedPackage);
            gridAllProducts.DataSource      = packages.GetProductSuppliers();
            AddPackage.callRefreshData     += RefreshData;
            UpdatePackage.callRefreshData  += RefreshData;
            ProductManager.callRefreshData += RefreshData;

            for (int i = 0; i < gridPackages.RowCount; i++)
            {
                if (Convert.ToBoolean(gridPackages.Rows[i].Cells["Expired"].Value))
                {
                    gridPackages.Rows[i].DefaultCellStyle.BackColor = Color.Red;
                }
            }
        }