示例#1
0
        // METHODES :

        public EquipeStat Select(string query)
        {
            EquipeStat stats = null;

            try {
                if (connexion.State == ConnectionState.Open)
                {
                    connexion = new SqlConnection(connexion.ConnectionString + "Password=itu");
                }
                connexion.Open();
                using (SqlCommand cmd = connexion.CreateCommand()) {
                    cmd.CommandText = query;
                    using (SqlDataReader reader = cmd.ExecuteReader()) {
                        stats = new EquipeStat();
                        EquipeStat p;
                        ActionDAO  acdao = new ActionDAO(connexion);
                        while (reader.Read())
                        {
                            Action action = acdao.Select("WHERE id='" + reader["action"].ToString() + "'").First();
                            int    nb     = int.Parse(reader["nombre"].ToString());

                            stats.Add(action.Nom, nb);
                        }
                    }
                } connexion.Close();
            } catch (Exception ex) {
                throw ex;
            } return(Complete(stats));
        }
示例#2
0
 private EquipeStat Complete(EquipeStat stat)
 {
     try {
         ActionDAO     acdao   = new ActionDAO(connexion);
         List <Action> actions = acdao.Select("WHERE id!='ACT01'");
         foreach (Action action in actions)
         {
             if (!stat.Exist(action.Nom))
             {
                 stat.Add(action.Nom, 0);
             }
         }
     } catch (Exception ex) {
         throw ex;
     } return(stat);
 }