예제 #1
0
        public DTOParties SelectByDate(DateTime date)
        {
            string     retour = " * from parties where date = " + date + ";";
            DataTable  table  = _dbal.Select(retour);
            DTOParties partie = new DTOParties(Convert.ToInt32(table.Rows[0]["id"]), Convert.ToDateTime(table.Rows[0]["date"]), Convert.ToString(table.Rows[0]["heure"]), Convert.ToInt32(table.Rows[0]["nbjoueur"]));

            for (int i = 0; i < table.Rows.Count; i++)
            {
                DAOxClients dAOxClients = new DAOxClients(_dbal);
                DTOClients  clients     = dAOxClients.SelectByIdClients(Convert.ToString(table.Rows[i]["pseudo_client"]));

                DAOxSalle dAOxSalle = new DAOxSalle(_dbal);
                DTOSalle  salle     = dAOxSalle.SelectByIdSalle(Convert.ToInt32(table.Rows[i]["idSalle"]));

                partie.SetClient(clients);
                partie.SetSalle(salle);
            }
            return(partie);
        }
예제 #2
0
        public List <DTOParties> SelectAllPartie()
        {
            DataTable         table      = _dbal.SelectAll("Parties");
            List <DTOParties> listpartie = new List <DTOParties>();

            for (int i = 0; i < table.Rows.Count; i++)
            {
                DAOxClients dAOxClients = new DAOxClients(_dbal);
                DTOClients  client      = dAOxClients.SelectByIdClients(Convert.ToString(table.Rows[i]["pseudo_client"]));

                DAOxSalle dAOxSalle = new DAOxSalle(_dbal);
                DTOSalle  salle     = dAOxSalle.SelectByIdSalle(Convert.ToInt32(table.Rows[i]["idSalle"]));

                DataRow    row    = table.Rows[0];
                DTOParties partie = new DTOParties(Convert.ToInt32(table.Rows[i]["id"]), Convert.ToDateTime(table.Rows[i]["date"]), Convert.ToString(table.Rows[i]["heure"]), Convert.ToInt32(table.Rows[i]["nbjoueur"]), client, salle);
                listpartie.Add(partie);
            }
            return(listpartie);
        }