Beispiel #1
0
 public Boolean insert(Object o)
 {
     try
     {
         Activite     a                      = (Activite)o;
         int          id                     = a.id;
         String       nom_activite           = a.nom_Activite;
         int          capacite               = a.capacite;
         int          nombre_participant     = a.nombre_participant;
         String       date_debut             = a.date_debut;
         String       date_fin               = a.date_fin;
         double       prix_unitaire          = a.prix_unitaire;
         double       montant_prevu          = a.montant_prevu;
         double       montant_actuel         = a.montant_actuel;
         int          idBudgetCategorie      = a.idBudgetCategorie;
         int          idOrganisateur         = a.idOrganisateur;
         String       date_debut_inscription = a.date_debut_inscription;
         String       date_fin_inscription   = a.date_fin_inscription;
         int          nbr_point              = a.nbr_point;
         PLSQL.Pl_SQL plSql                  = new PLSQL.Pl_SQL();
         string       req                    = string.Format(plSql.AjouterActivite(nom_activite, capacite, date_debut, date_fin, prix_unitaire, montant_prevu, montant_actuel, idBudgetCategorie, idOrganisateur, date_debut_inscription, date_fin_inscription, nbr_point));
         cmd.Connection = cn;
         cn.Open();
         cmd.CommandText = req;
         cmd.ExecuteNonQuery();
         return(true);
     }
     catch (OleDbException ex)
     {
         System.Console.WriteLine("error :" + ex.Message);
         return(false);
     }
     finally
     {
         cn.Close();
     }
 }