//-------------------REMOVE OR DELETE ProductsSupplier -------------------------------------------------- private void btnRemove_Click_1(object sender, EventArgs e) { selectedProductsSupplier = context.ProductsSuppliers.Find(selected_ProductsSupplierID); DialogResult result = MessageBox.Show($"Are you sure you want to delete {selectedProductsSupplier.ProductSupplierId}?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { try { context.ProductsSuppliers.Remove(selectedProductsSupplier); context.SaveChanges(true); DisplayLVProductsSuppliers(); } //catch (DbUpdateConcurrencyException ex) //{ // HandleConcurrencyError(ex); //} catch (DbUpdateException ex) { HandleDataError(ex); } catch (Exception ex) { HandleGeneralError(ex); } } ManageControls(false); }
//-------------------MODIFY productsSupplier -------------------------------------------------- private void btnModify_Click_1(object sender, EventArgs e) { //create second form frmAddModifyProdSupp secondForm = new frmAddModifyProdSupp(); secondForm.isAdd = false; secondForm.productsSupplier = context.ProductsSuppliers.Find(selected_ProductsSupplierID); DialogResult result = secondForm.ShowDialog();//accept returns ok if (result == DialogResult.OK) { selectedProductsSupplier = secondForm.productsSupplier; try { context.SaveChanges(); DisplayLVProductsSuppliers(); } //catch (DbUpdateConcurrencyException ex) //{ // HandleConcurrencyError(ex); //} catch (DbUpdateException ex) { HandleDataError(ex); } catch (Exception ex) { HandleGeneralError(ex); } } ManageControls(false); }
private void button1_Click(object sender, EventArgs e) { ProductsSuppliers info = new ProductsSuppliers(); info = SuppliersFunctions.GetTwoValues(Convert.ToInt32(relationshipInitial.Text)); productCurrent.Text = info.ProdName; supplierCurrent.Text = info.SupName; }
public static List <ProductsSuppliers> GetRelations() { string configString = ConfigurationManager.ConnectionStrings["TravelExperts"].ConnectionString; List <ProductsSuppliers> Suppliers = new List <ProductsSuppliers>(); ProductsSuppliers Sup; SqlConnection con = new SqlConnection(configString); string selectQuery = " select ProductSupplierId, ProductId, SupplierId from dbo.Products_Suppliers"; SqlCommand cmd = new SqlCommand(selectQuery, con); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Sup = new ProductsSuppliers(); Sup.ProductSupplierId = Convert.ToInt32(reader["ProductSupplierId"]); if (reader["ProductId"] == DBNull.Value) { Sup.ProductId = null; } else { Sup.ProductId = Convert.ToInt32(reader["ProductId"]); } if (reader["SupplierId"] == DBNull.Value) { Sup.SupplierId = null; } else { Sup.SupplierId = Convert.ToInt32(reader["SupplierId"]); } //Sup.ProductId = Convert.ToInt32(reader["ProductId"]); //Sup.SupplierId = Convert.ToInt32(reader["SupplierId"]); Suppliers.Add(Sup); } } catch (SqlException ex) { throw ex; } finally { con.Close(); } return(Suppliers); }
private void btnOk_Click(object sender, EventArgs e) { //load productsSupplier data if (isAdd) { productsSupplier = new ProductsSuppliers(); } //packageproductsSupplierID automatically generated and is not modified var selectedProduct = cboProduct.SelectedValue.ToString(); var selectedSupplier = cboSupplier.SelectedValue.ToString(); productsSupplier.SupplierId = Convert.ToInt32(selectedSupplier); productsSupplier.ProductId = Convert.ToInt32(selectedProduct); //set dialog result to ok this.DialogResult = DialogResult.OK; }
//-------------------ADD productsSupplier-------------------------------------------------- private void btnAdd_Click(object sender, EventArgs e) { //create second form frmAddModifyProdSupp addModifySupplier = new frmAddModifyProdSupp(); addModifySupplier.isAdd = true; addModifySupplier.productsSupplier = null; DialogResult result = addModifySupplier.ShowDialog();//accept returns ok //if dialogresult is ok, save productsSupplier, and display items in list view if (result == DialogResult.OK) { selectedProductsSupplier = addModifySupplier.productsSupplier; selectedProductsSupplierIds = addModifySupplier.selectedProductsSupplierIds; try { var newProductsSupplier = context.ProductsSuppliers.Add(selectedProductsSupplier); context.SaveChanges(); DisplayLVProductsSuppliers(); } //catch (DbUpdateConcurrencyException ex) //{ // HandleConcurrencyError(ex); //} catch (DbUpdateException ex) { HandleDataError(ex); } catch (Exception ex) { HandleGeneralError(ex); } } }
public static ProductsSuppliers GetTwoValues(int ProdSupID) { string configString = ConfigurationManager.ConnectionStrings["TravelExperts"].ConnectionString; //List<ProductsSuppliers> InfoList = new List<ProductsSuppliers>(); ProductsSuppliers info = new ProductsSuppliers(); SqlConnection con = new SqlConnection(configString); string selectQuery = " select ProdName, SupName from dbo.Products_Suppliers ps " + "join Products p on ps.ProductId = p.ProductId " + "join Suppliers s on ps.SupplierId = s.SupplierId " + "where ProductSupplierId = @ProductSupplierId"; SqlCommand cmd = new SqlCommand(selectQuery, con); cmd.Parameters.AddWithValue("@ProductSupplierId", ProdSupID); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { info.ProdName = Convert.ToString(reader["ProdName"]); info.SupName = Convert.ToString(reader["SupName"]); } } catch (SqlException ex) { throw ex; } finally { con.Close(); } return(info); }