private void PackagesBindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (Validation()) { Package pkg = new Package(); pkg.PkgName = pkgNameTextBox.Text; pkg.pkgStDate = pkgStartDateDateTimePicker.Value; pkg.pkgEndDate = pkgEndDateDateTimePicker.Value; pkg.pkgDesc = pkgDescTextBox.Text; pkg.pkgBasePrice = Convert.ToDouble(pkgBasePriceTextBox.Text); pkg.pkgAgentCom = Convert.ToDouble(pkgAgencyCommissionTextBox.Text); PackageDB.AddPackage(pkg); this.Validate(); } }
private void ToolStripBtnSave_Click(object sender, EventArgs e) { if (Validation()) { int pkgId = 0; Package pkg = new Package(); pkg.PkgName = pkgNameTextBox.Text; pkg.pkgStDate = pkgStartDateDateTimePicker.Value; pkg.pkgEndDate = pkgEndDateDateTimePicker.Value; pkg.pkgDesc = pkgDescTextBox.Text; pkg.pkgBasePrice = Convert.ToDouble(pkgBasePriceTextBox.Text); pkg.pkgAgentCom = Convert.ToDouble(pkgAgencyCommissionTextBox.Text); if (packageIdTextBox.Text == "-1") { pkgId = PackageDB.AddPackage(pkg); if (pkgId != 0) { if (dgvPkgProd.Rows.Count > 0) { for (int i = 0; i < dgvPkgProd.Rows.Count; i++) { Prod_Suppliers prodsup = new Prod_Suppliers(); Products prod = ProductDB.GetProductsbyName(dgvPkgProd.Rows[i].Cells[0].Value.ToString()); prodsup.nProdId = prod.nProdId; //cbProducts.SelectedValue); Suppliers sup = SupplierDB.GetSuppliersbyName(dgvPkgProd.Rows[i].Cells[1].Value.ToString()); prodsup.nSupId = sup.nSupId; // Convert.ToInt32(cbSups.SelectedValue); DataTable dt = Prod_SuppliersDB.GetProd_SupbyPsId(prodsup.nProdId, prodsup.nSupId); int prodsupid = Convert.ToInt32(dt.Rows[0]["ProductSupplierId"]); //int prodsupid = Prod_SuppliersDB.AddRecord(prodsup); Pkg_Product_Suppliers pps = new Pkg_Product_Suppliers(); pps.prodSupId = prodsupid; pps.pkgId = pkgId; Pkg_Product_SuppliersDB.AddPPSData(pps); } } } } else { //update package pkgId = Convert.ToInt32(packageIdTextBox.Text); if (pkgId != 0) { Package oldpkg = new Package(); oldpkg.nPkgId = pkgId; PackageDB.UpdatePkg(oldpkg, pkg); DataTable dtprodsup = Pkg_Product_SuppliersDB.GetAllPkgProdSupData(pkgId); if (dgvPkgProd.Rows.Count > 0) { for (int i = 0; i < dgvPkgProd.Rows.Count; i++) { string strprodname = dgvPkgProd.Rows[i].Cells[0].Value.ToString(); string strsupName = dgvPkgProd.Rows[i].Cells[1].Value.ToString(); for (int j = 0; j < dtprodsup.Rows.Count; j++) { if (strprodname != dtprodsup.Rows[j]["ProdName"].ToString() && strsupName != dtprodsup.Rows[j]["SupName"].ToString()) { Prod_Suppliers prodsup = new Prod_Suppliers(); Products prod = ProductDB.GetProductsbyName(dgvPkgProd.Rows[i].Cells[0].Value.ToString()); prodsup.nProdId = prod.nProdId; //cbProducts.SelectedValue); Suppliers sup = SupplierDB.GetSuppliersbyName(dgvPkgProd.Rows[i].Cells[1].Value.ToString()); prodsup.nSupId = sup.nSupId; // Convert.ToInt32(cbSups.SelectedValue); DataTable dt = Prod_SuppliersDB.GetProd_SupbyPsId(prodsup.nProdId, prodsup.nSupId); Prod_Suppliers newprodsup = new Prod_Suppliers(); newprodsup.nProdSupId = Convert.ToInt32(dt.Rows[0]["ProductSupplierId"]); int prodsupid = newprodsup.nProdSupId; Pkg_Product_Suppliers oldpps = new Pkg_Product_Suppliers(); Pkg_Product_Suppliers pps = new Pkg_Product_Suppliers(); pps.prodSupId = prodsupid; oldpps.pkgId = pkgId; Pkg_Product_SuppliersDB.UpdatePkgData(oldpps, pps); } } } } } } BindingSource pkgbindsource = new BindingSource(); pkgbindsource.DataSource = PackageDB.GetAllPkg(); PackagesBindingNavigator.BindingSource = pkgbindsource; refreshitems(); } }