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