private void btnAddPack_Click(object sender, EventArgs e) { if (Validator.IsPresent(packageIdTextBox) && Validator.IsCorrectLength(packageIdTextBox, 10) && IsUniqueCode(packageIdTextBox) && // coded below in this form Validator.IsPresent(pkgNameTextBox) && Validator.IsCorrectLength(pkgNameTextBox, 50) && Validator.IsPresent(pkgDescTextBox) && Validator.IsCorrectLength(pkgDescTextBox, 50) && Validator.IsPresent(pkgBasePriceTextBox) && Validator.IsDecimal(pkgBasePriceTextBox) && Validator.IsNonNegativeDecimal(pkgBasePriceTextBox) && Validator.IsPresent(pkgAgencyCommissionTextBox) && Validator.IsDecimal(pkgAgencyCommissionTextBox) && Validator.IsNonNegativeInt(pkgAgencyCommissionTextBox) ) { Package newPckage = new Package // create Package using provided data { PackageId = Convert.ToInt32(packageIdTextBox.Text), PkgName = pkgNameTextBox.Text, PkgStartDate = Convert.ToDateTime(pkgStartDateDateTimePicker.Text), PkgEndDate = Convert.ToDateTime(pkgEndDateDateTimePicker.Text), PkgDesc = pkgDescTextBox.Text, PkgBasePrice = Convert.ToDecimal(pkgBasePriceTextBox.Text), PkgAgencyCommission = Convert.ToDecimal(pkgAgencyCommissionTextBox.Text), }; int SupId = (int)cboSupplies.SelectedValue; int cod = 0; var codprosup = from prosup in dbContext.Products_Suppliers join supplier in dbContext.Suppliers on prosup.SupplierId equals supplier.SupplierId where prosup.SupplierId == SupId select new { prosup.ProductSupplierId }; foreach (var item in codprosup) { cod = item.ProductSupplierId; } // MessageBox.Show(cod.ToString()); //LoadproSup(SupId); // insert through data context object from the main form dbContext.Packages.InsertOnSubmit(newPckage); dbContext.SubmitChanges(); // submit to the database Packages_Products_Supplier newPacksup = new Packages_Products_Supplier { PackageId = Convert.ToInt32(packageIdTextBox.Text), ProductSupplierId = cod, }; // insert through data context object from the main form dbContext.Packages_Products_Suppliers.InsertOnSubmit(newPacksup); dbContext.SubmitChanges(); // submit to the database DialogResult = DialogResult.OK; } }
private void btnAddPack_Click(object sender, EventArgs e) { try { if (//Validator.IsPresent(packageIdTextBox) && //Validator.IsCorrectLength(packageIdTextBox, 10) && //IsUniqueCode(packageIdTextBox) && // coded below in this form Validator.IsPresent(pkgNameTextBox) && Validator.IsCorrectLength(pkgNameTextBox, 50) && Validator.IsPresent(pkgDescTextBox) && Validator.IsCorrectLength(pkgDescTextBox, 50) && Validator.IsPresent(pkgBasePriceTextBox) && Validator.IsDecimal(pkgBasePriceTextBox) && Validator.IsNonNegativeDecimal(pkgBasePriceTextBox) && Validator.IsPresent(pkgAgencyCommissionTextBox) && Validator.IsDecimal(pkgAgencyCommissionTextBox) && Validator.IsNonNegativeInt(pkgAgencyCommissionTextBox) && //validate comission ValidateCommission(pkgAgencyCommissionTextBox, pkgBasePriceTextBox) && //validate Endate ValidateEndDate(pkgEndDateDateTimePicker, pkgStartDateDateTimePicker) && ValidateProducts(cboProducts) ) { Package newPckage = new Package // create Package using provided data { //PackageId = Convert.ToInt32(packageIdTextBox.Text), PkgName = pkgNameTextBox.Text, PkgStartDate = Convert.ToDateTime(pkgStartDateDateTimePicker.Text), PkgEndDate = Convert.ToDateTime(pkgEndDateDateTimePicker.Text), PkgDesc = pkgDescTextBox.Text, PkgBasePrice = Convert.ToDecimal(pkgBasePriceTextBox.Text), PkgAgencyCommission = Convert.ToDecimal(pkgAgencyCommissionTextBox.Text), }; int SupId = (int)cboSupplies.SelectedValue; int cod = 0; var codprosup = from prosup in dbContext.Products_Suppliers join supplier in dbContext.Suppliers on prosup.SupplierId equals supplier.SupplierId where prosup.SupplierId == SupId select new { prosup.ProductSupplierId }; foreach (var item in codprosup) { cod = item.ProductSupplierId; } // MessageBox.Show(cod.ToString()); //LoadproSup(SupId); // insert through data context object from the main form dbContext.Packages.InsertOnSubmit(newPckage); dbContext.SubmitChanges(); // submit to the database foreach (DataGridViewRow dgvRenglon in dgvProducts.Rows) { if (dgvRenglon.Cells[0].Value.ToString() != null) { MessageBox.Show(dgvRenglon.Cells[0].Value.ToString()); } Packages_Products_Supplier newPacksup = new Packages_Products_Supplier { PackageId = newPckage.PackageId, ProductSupplierId = Convert.ToInt32(dgvRenglon.Cells[0].Value.ToString()), }; dbContext.Packages_Products_Suppliers.InsertOnSubmit(newPacksup); dbContext.SubmitChanges(); } //Packages_Products_Supplier newPacksup = new Packages_Products_Supplier //{ // PackageId = GetKeyPack(), // ProductSupplierId = cod, //}; // insert through data context object from the main form //using (var scope = new TransactionScope()) //{ // dbContext.SubmitChanges(); // submit to the database // scope.Complete(); //} DialogResult = DialogResult.OK; MessageBox.Show("Package was entry"); this.Refresh(); cleanForm(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void detach_Packages_Products_Suppliers(Packages_Products_Supplier entity) { this.SendPropertyChanging(); entity.Products_Supplier = null; }
partial void DeletePackages_Products_Supplier(Packages_Products_Supplier instance);
private void attach_Packages_Products_Suppliers(Packages_Products_Supplier entity) { this.SendPropertyChanging(); entity.Package = this; }
partial void InsertPackages_Products_Supplier(Packages_Products_Supplier instance);