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());
}
}
}
