//add data to the database private void btnAddPkg_Click(object sender, EventArgs e) { DateTime newStartDate = new DateTime(); DateTime newEndDate = new DateTime(); decimal newBasePrice; decimal newCommission; // Check that the input data can be parsed if (!DateTime.TryParse(textBoxAddStartDate.Text, out newStartDate)) { MessageBox.Show("Please enter a date for the start date", "Error"); } if (!DateTime.TryParse(textBoxAddEndDate.Text, out newEndDate)) { MessageBox.Show("Please enter a date for the end date", "Error"); } if (!Decimal.TryParse(textBoxAddBasePrice.Text, out newBasePrice)) { MessageBox.Show("Please enter a decimal value for the base price", "Error"); } if (!Decimal.TryParse(textBoxAddComission.Text, out newCommission)) { MessageBox.Show("Please enter a decimal value for the agency commission", "Error"); } // Create the package object to be added Package newPkg = new Package(0, textBoxAddPkgName.Text, newStartDate, newEndDate, textBoxAddDesc.Text, newBasePrice, newCommission); // Validate the values of the input data. If the input is valid, add the new package // to the Packages table in the database. try { if (PackageValidation.ValidatePackageData(newPkg)) { PackageDB.AddPackage(newPkg); } LoadUIforPackages(); comboBoxPkgName.SelectedIndex = (packages.Count() - 1); panelDetailPkg.Visible = true; panelAddPkg.Visible = false; btnEditPkgClick.Enabled = true; btnDeletePkgClick.Enabled = true; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
private void btnSubmit_Click(object sender, EventArgs e) { //create package if (package == null) { if (ValidatePackageDataInput()) { //create package object Package p = new Package(); p.Name = txtName.Text; p.Description = txtDescription.Text; p.Start_Date = dtpStart.Value; p.End_Date = dtpEnd.Value; p.Base_Price = Convert.ToDecimal(txtPrice.Text); p.Agency_Commission = Convert.ToDecimal(txtCommission.Text); //insert package to DB if (PackageDB.AddPackage(p)) //package was created { //get list of added products and suppliers List <int> list = new List <int>(); foreach (DataGridViewRow item in dgvProductSuppliers.Rows) { int id = Convert.ToInt32(item.Cells[0].Value); list.Add(id); } p.ID = PackageDB.GetMaxPackageID(); //insert products suppliers foreach (int l in list) { PackageDB.AddPackageProductSupplier(p.ID, l); } MessageBox.Show("The Package was Added.", "Package was Added"); Close(); } else { MessageBox.Show("Error Occured. Try Again", "Package was NOT Added"); } } } //update package else { if (ValidatePackageDataInput()) { //edit package class package.Name = txtName.Text; package.Description = txtDescription.Text; package.Base_Price = Convert.ToDecimal(txtPrice.Text); package.Agency_Commission = Convert.ToDecimal(txtCommission.Text); package.Start_Date = dtpStart.Value; package.End_Date = dtpEnd.Value; //update db if (PackageDB.UpdatePackage(package)) { //delete or add PackageProductSupplier Records //get list of products and suppliers List <int> list = new List <int>(); foreach (DataGridViewRow item in dgvProductSuppliers.Rows) { int prodSupID = Convert.ToInt32(item.Cells[0].Value); list.Add(prodSupID); } //delete packageproductsupplier if (PackageDB.DeletePackageProductSupplier(package.ID, list)) { } //insert packageproductsupplier foreach (int l in list) { PackageDB.AddPackageProductSupplier(package.ID, l); } MessageBox.Show("The Package was Added.", "Package was Added"); Close(); } else { MessageBox.Show("Error occured when saving package"); } } } }