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