예제 #1
0
        // METHODES :

        public List <ProchainePartie> Select(string cond)
        {
            List <ProchainePartie> parties = null;

            try {
                if (connexion.State == ConnectionState.Open)
                {
                    connexion = new SqlConnection(connexion.ConnectionString + "Password=itu");
                }
                connexion.Open();
                using (SqlCommand cmd = connexion.CreateCommand()) {
                    string condition = "";
                    if (cond != null)
                    {
                        condition = " " + cond;
                    }
                    cmd.CommandText = "SELECT id, equipe1, equipe2, partie FROM ProchainePartie" + condition;
                    using (SqlDataReader reader = cmd.ExecuteReader()) {
                        parties = new List <ProchainePartie>();
                        ProchainePartie p;

                        EquipeDAO eqdao = new EquipeDAO(connexion);
                        PartieDAO pdao  = new PartieDAO(connexion);
                        while (reader.Read())
                        {
                            Partie partie = null;
                            if (reader["partie"].ToString() != "")
                            {
                                partie = pdao.Select("WHERE id='" + reader["partie"].ToString() + "'").First();
                            }

                            Equipe eq1 = eqdao.Select("WHERE id='" + reader["equipe1"].ToString() + "'").First();
                            Equipe eq2 = eqdao.Select("WHERE id='" + reader["equipe2"].ToString() + "'").First();

                            p = new ProchainePartie(reader["id"].ToString(), eq1, eq2, partie);
                            parties.Add(p);
                        }
                    }
                } connexion.Close();
            } catch (Exception ex) {
                throw ex;
            } return(parties);
        }
예제 #2
0
        // METHODES :

        public List <PartieDetails> Select(string cond)
        {
            List <PartieDetails> partiedetailss = null;

            try {
                if (connexion.State == ConnectionState.Open)
                {
                    connexion = new SqlConnection(connexion.ConnectionString + "Password=itu");
                }
                connexion.Open();
                using (SqlCommand cmd = connexion.CreateCommand()) {
                    string condition = "";
                    if (cond != null)
                    {
                        condition = " " + cond;
                    }
                    cmd.CommandText = "SELECT partie, mitemps, temps, equipe, details, action, remarque FROM PartieDetails" + condition;
                    using (SqlDataReader reader = cmd.ExecuteReader()) {
                        partiedetailss = new List <PartieDetails>();
                        PartieDetails p;

                        PartieDAO        ptdao  = new PartieDAO(connexion);
                        EquipeDAO        eqdao  = new EquipeDAO(connexion);
                        ActionDAO        actdao = new ActionDAO(connexion);
                        EquipeDetailsDAO eddao  = new EquipeDetailsDAO(connexion);
                        while (reader.Read())
                        {
                            Partie        pt      = ptdao.Select("WHERE id='" + reader["partie"].ToString() + "'").ElementAt(0);
                            Equipe        eq      = eqdao.Select("WHERE id='" + reader["equipe"].ToString() + "'").ElementAt(0);
                            EquipeDetails details = eddao.Select("WHERE id='" + reader["details"].ToString() + "'").ElementAt(0);
                            Action        act     = actdao.Select("WHERE id='" + reader["action"].ToString() + "'").ElementAt(0);

                            p = new PartieDetails(pt, int.Parse(reader["mitemps"].ToString()), Convert.ToDateTime(reader["temps"].ToString()), eq, details, act, reader["remarque"].ToString());
                            partiedetailss.Add(p);
                        }
                    }
                } connexion.Close();
            } catch (Exception ex) {
                throw ex;
                //Console.Error.WriteLine(ex.Message + " in : " + ex.StackTrace);
            } return(partiedetailss);
        }