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()); } }
private void AddPackageForm_Load(object sender, EventArgs e) { List <Package> packageView = TravelPackageDB.GetPackages(lstViewTravelPackages); ClearLabels(); btnEditPackage.Enabled = false; btnDeletePackage.Enabled = false; }
private void ClearForm() { lstViewTravelPackages.Clear(); List <Package> refreshPackageView = TravelPackageDB.GetPackages(lstViewTravelPackages); ClearLabels(); btnEditPackage.Enabled = false; btnDeletePackage.Enabled = false; }
private void LstViewTravelPackages_SelectedIndexChanged(object sender, EventArgs e) { TravelPackageDB packageDetails = new TravelPackageDB(); packageDetails.ShowSelectedOrder(lstViewTravelPackages, lblPackageID, lblPackageName, lblStartDate, lblEndDate, lblDescription, lblBasePrice, lblCommission); ShowLabels(); btnEditPackage.Enabled = true; btnDeletePackage.Enabled = true; int packageId = Convert.ToInt32(lblPackageID.Text); List <Package> packageProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId); }
// lists all products in package and available products not yet added public AddProductForm(int packageId, string packageName) { InitializeComponent(); lblPackageName.Text = packageName; lblPackageId.Text = Convert.ToString(packageId); if (lstProducts.Items != null) { List <Package> packageProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId); List <Package> showProducts = TravelPackageDB.ShowAllProducts(lstAllProducts, packageId); } }
// delete package with dialog box private void BtnDeletePackage_Click(object sender, EventArgs e) { string packageName = lblPackageName.Text; DialogResult deleteClient = MessageBox.Show("Are you sure you want to delete the " + packageName + " package?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (deleteClient == DialogResult.Yes) { int packageID = Convert.ToInt32(lblPackageID.Text); TravelPackageDB deletePackage = new TravelPackageDB(); deletePackage.DeleteTravelPackage(lstViewTravelPackages, packageID); ClearForm(); } }
// remove product from package private void BtnRemoveProduct_Click(object sender, EventArgs e) { if (lstProducts.SelectedItem == null) { MessageBox.Show("A product must be selected to remove"); } else { int packageId = Convert.ToInt32(lblPackageId.Text); int productId = Convert.ToInt32(lblProductId.Text); TravelPackageDB removeProduct = new TravelPackageDB(); removeProduct.RemovePackageProduct(productId, packageId); List <Package> refreshProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId); List <Package> showProducts = TravelPackageDB.ShowAllProducts(lstAllProducts, packageId); } }
// add product to package private void BtnAdd_Click(object sender, EventArgs e) { if (lstAllProducts.SelectedItem == null) { MessageBox.Show("A product must be selected to add"); } else { int packageId = Convert.ToInt32(lblPackageId.Text); int productId = Convert.ToInt32(lblListNewProd.Text); TravelPackageDB getProdSupplierId = new TravelPackageDB(); int supplierId = getProdSupplierId.GetSupplierId(productId); getProdSupplierId.AddPackageToProd(Convert.ToInt32(lblPackageId.Text), supplierId); List <Package> refreshProducts = TravelPackageDB.GetPackageProducts(lstProducts, packageId); List <Package> showProducts = TravelPackageDB.ShowAllProducts(lstAllProducts, packageId); } }
// 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()); } } }
// selects index of product not added to package private void LstAllProducts_SelectedIndexChanged(object sender, EventArgs e) { TravelPackageDB getProdId = new TravelPackageDB(); getProdId.GetProductId(lstAllProducts.Text, lblListNewProd); }