public void ControleApprovDetail(DetailApprovisionnement approv, int action = 1) { InitializeConnexion(); using (IDbCommand cmd = ImplementeConnexion.Instance.Con.CreateCommand()) { cmd.CommandText = "sp_merge_detail_approv"; cmd.CommandType = CommandType.StoredProcedure; SetParameter(cmd, "@code_approv", DbType.Int32, 4, approv.CodeApprov); SetParameter(cmd, "@code", DbType.Int32, 4, approv.Code); SetParameter(cmd, "@code_piece", DbType.Int32, 4, approv.CodePiece); SetParameter(cmd, "@quantite", DbType.Int32, 4, approv.Quantite); SetParameter(cmd, "@prix", DbType.Double, 8, approv.Prix); SetParameter(cmd, "@action", DbType.Int32, 4, action); cmd.ExecuteNonQuery(); } }
private void ControleDetailApprovisionnement(bool save) { try { if (save) { if (IsNotEmpty(2)) { detailApprov = new DetailApprovisionnement { Code = "0", CodeApprov = Convert.ToInt32(TxtCodeApprov.Text), CodePiece = _idPiece, Prix = double.Parse(TxtPrixApprov.Text), Quantite = Convert.ToInt32(TxtQteApprov.Text) }; Glossaire.Instance.ControleApprovDetail(detailApprov); } else { detailApprov = new DetailApprovisionnement { Code = TxtCodeDetailApprov.Text, CodeApprov = Convert.ToInt32(TxtCodeApprov.Text), CodePiece = _idPiece, Prix = Convert.ToDouble(TxtPrixApprov.Text), Quantite = Convert.ToInt32(TxtQteApprov.Text) }; Glossaire.Instance.ControleApprovDetail(detailApprov, 2); } } else { detailApprov = new DetailApprovisionnement { Code = TxtCodeDetailApprov.Text, CodeApprov = Convert.ToInt32(TxtCodeApprov.Text), CodePiece = _idPiece, Prix = Convert.ToDouble(TxtPrixApprov.Text), Quantite = Convert.ToInt32(TxtQteApprov.Text) }; Glossaire.Instance.ControleApprovDetail(detailApprov, 2); } ClearFields(2); LoadCombo(); LoadGridControle(2); } 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(); } } } }