public void ControleCategoriePiece(CategoriePiece categ, int action = 1) { InitializeConnexion(); using (IDbCommand cmd = ImplementeConnexion.Instance.Con.CreateCommand()) { cmd.CommandText = "sp_merge_categorie_piece"; cmd.CommandType = CommandType.StoredProcedure; SetParameter(cmd, "@code", DbType.Int32, 4, Convert.ToInt32(categ.Code)); SetParameter(cmd, "@designation", DbType.String, 100, categ.Designation); SetParameter(cmd, "@action", DbType.Int32, 4, action); cmd.ExecuteNonQuery(); } }
private void ControleCategoriePiece(bool save) { try { if (save) { if (IsNotEmpty(1)) { categPiece = new CategoriePiece { Code = "0", Designation = TxtDesignCategPiece.Text.ToUpper().Trim() }; Glossaire.Instance.ControleCategoriePiece(categPiece); } else { categPiece = new CategoriePiece { Code = TxtCodeCategPiece.Text.Trim(), Designation = TxtDesignCategPiece.Text.ToUpper().Trim() }; Glossaire.Instance.ControleCategoriePiece(categPiece, 2); } } else { categPiece = new CategoriePiece { Code = TxtCodeCategPiece.Text.Trim(), Designation = TxtDesignCategPiece.Text.ToUpper().Trim() }; Glossaire.Instance.ControleCategoriePiece(categPiece, 3); } ClearFields(1); LoadCombo(); LoadGridControle(1); } catch (InvalidOperationException ex) { MessageBox.Show("Une erreur est survenue pendant l'opération ! " + ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } catch (System.Data.SqlClient.SqlException ex) { MessageBox.Show("Une erreur est survenue pendant l'opération ! " + ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } catch (Exception ex) { MessageBox.Show("Une erreur est survenue pendant l'opération ! " + ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } finally { if (ImplementeConnexion.Instance.Con != null) { if (ImplementeConnexion.Instance.Con.State == System.Data.ConnectionState.Open) { ImplementeConnexion.Instance.Con.Close(); } } } }