/// <summary>
/// Permet d'insérer dans la table distribuer
/// </summary>
/// <param name="ListEchantillon">Le dictionnaire d'échantillon</param>
/// <param name="rapNum">Le numéro du rapport</param>
/// <param name="offert">true si l'échantillon est offert</param>
private void Insert_distribuer(Dictionary <string, int> ListEchantillon, string rapNum, bool offert)
{
foreach (KeyValuePair <string, int> item in ListEchantillon)
{
Curs Insert_Distri = new Curs(connection);
string echoffquantite = item.Value.ToString();
if (offert)
{
Insert_Distri.DefFonctStockee("insert_distribuer_offert");
}
else
{
Insert_Distri.DefFonctStockee("insert_distribuer_presente");
}
Insert_Distri.AjouteparametreCol("MED_NOM", item.Key);
Insert_Distri.DirectionparametreCol("MED_NOM", ParameterDirection.Input);
Insert_Distri.AjouteparametreCol("COL_MAT", _colMatricule);
Insert_Distri.DirectionparametreCol("COL_MAT", ParameterDirection.Input);
Insert_Distri.AjouteparametreCol("RAP_NUM", rapNum);
Insert_Distri.DirectionparametreCol("RAP_NUM", ParameterDirection.Input);
Insert_Distri.AjouteparametreCol("QUANTITE", echoffquantite);
Insert_Distri.DirectionparametreCol("QUANTITE", ParameterDirection.Input);
Insert_Distri.Appelfonctstockee();
}
}