private void BTN_MODIF_Inventaire_Click(object sender, EventArgs e) { FORM_Inventaire FI = new FORM_Inventaire(); FI.conn = this.conn; FI.Titre = "Modification"; FI.ID = (int)DGV_Inventaire.SelectedRows[0].Cells[0].Value; FI.Description = DGV_Inventaire.SelectedRows[0].Cells[1].Value.ToString(); FI.IDFournisseur = DGV_Fournisseur.SelectedRows[0].Cells[0].Value.ToString() + " - " + DGV_Fournisseur.SelectedRows[0].Cells[1].Value.ToString(); FI.QteStock = Double.Parse(DGV_Inventaire.SelectedRows[0].Cells[2].Value.ToString()); FI.QteMinimum = Double.Parse(DGV_Inventaire.SelectedRows[0].Cells[3].Value.ToString()); FI.QteMaximum = Double.Parse(DGV_Inventaire.SelectedRows[0].Cells[4].Value.ToString()); if (FI.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string sql = "update inventaire set DescriptionInventaire = @DescriptionInventaire, IDFournisseur = @IDFournisseur," + "QteStock = @QteStock, QteMinimum = @QteMinimum, QteMaximum = @QteMaximum where IDInventaire = @IDInventaire"; try { SqlCommand sqlModifier = new SqlCommand(sql, conn); SqlParameter SQLParaDesc = new SqlParameter("@DescriptionInventaire", SqlDbType.VarChar, 50); SqlParameter SQLParamIDF = new SqlParameter("@IDFournisseur", SqlDbType.Int); SqlParameter SQLParamStock = new SqlParameter("@QteStock", SqlDbType.Int); SqlParameter SQLParamMin = new SqlParameter("@QteMinimum", SqlDbType.Int); SqlParameter SQLParamMax = new SqlParameter("@QteMaximum", SqlDbType.Int); SqlParameter SQLParamID = new SqlParameter("@IDInventaire", SqlDbType.Int, 10); SQLParaDesc.Value = FI.Description; SQLParamIDF.Value = Int32.Parse(FI.IDFournisseur); SQLParamStock.Value = FI.QteStock; SQLParamMin.Value = FI.QteMinimum; SQLParamMax.Value = FI.QteMaximum; SQLParamID.Value = FI.ID; sqlModifier.Parameters.Add(SQLParaDesc); sqlModifier.Parameters.Add(SQLParamIDF); sqlModifier.Parameters.Add(SQLParamStock); sqlModifier.Parameters.Add(SQLParamMin); sqlModifier.Parameters.Add(SQLParamMax); sqlModifier.Parameters.Add(SQLParamID); sqlModifier.ExecuteNonQuery(); ReloadDGVInventaire(); ReloadDGVQteMin(); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } } }
private void BTN_AJTER_Inventaire_Click(object sender, EventArgs e) { FORM_Inventaire FI = new FORM_Inventaire(); FI.Titre = "Ajout"; FI.conn = this.conn; if (FI.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string sql = "insert into Inventaire (DescriptionInventaire,IDFournisseur,QteStock,QteMinimum,QteMaximum)" + " VALUES(@DescriptionInventaire,@IDFournisseur,@QteStock,@QteMinimum,@QteMaximum)"; try { SqlCommand sqlAjout = new SqlCommand(sql, conn); SqlParameter SQLParaDesc = new SqlParameter("@DescriptionInventaire", SqlDbType.VarChar, 50); SqlParameter SQLParamIDF = new SqlParameter("@IDFournisseur", SqlDbType.Int); SqlParameter SQLParamStock = new SqlParameter("@QteStock", SqlDbType.Int); SqlParameter SQLParamMin = new SqlParameter("@QteMinimum", SqlDbType.Int); SqlParameter SQLParamMax = new SqlParameter("@QteMaximum", SqlDbType.Int); SQLParaDesc.Value = FI.Description; SQLParamIDF.Value = FI.IDFournisseur; SQLParamStock.Value = FI.QteStock; SQLParamMin.Value = FI.QteMinimum; SQLParamMax.Value = FI.QteMaximum; sqlAjout.Parameters.Add(SQLParaDesc); sqlAjout.Parameters.Add(SQLParamIDF); sqlAjout.Parameters.Add(SQLParamStock); sqlAjout.Parameters.Add(SQLParamMin); sqlAjout.Parameters.Add(SQLParamMax); sqlAjout.ExecuteNonQuery(); ReloadDGVInventaire(); ReloadDGVQteMin(); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } } }