Ejemplo n.º 1
0
        public static Affecter findByNumero(string numero)
        {
            Affecter    affecter = null;
            OdbcCommand cmd      = new OdbcCommand("select * from affecter where Numero=?", AccesBd.getConnection());

            cmd.Parameters.Add("@numero", OdbcType.VarChar).Value = numero;
            OdbcDataReader dr = cmd.ExecuteReader();

            if (dr.Read())
            {
                affecter = new Affecter {
                    Id = dr.GetInt32(0), Numero = dr.GetString(1), DateDebut = dr.GetDateTime(2), DateFin = dr.GetDateTime(3), ligne = LigneDao.findByNumero(dr.GetString(4)), bus = BusDao.findByNumero(dr.GetString(5))
                };
            }
            cmd.Dispose();
            return(affecter);
        }
Ejemplo n.º 2
0
        public static Points find(int Id)
        {
            Points      point = null;
            OdbcCommand cmd   = new OdbcCommand("select * from point where Id=?", AccesBd.getConnection());

            cmd.Parameters.Add("@id", OdbcType.Int).Value = Id;
            OdbcDataReader dr = cmd.ExecuteReader();

            if (dr.Read())
            {
                point = new Points {
                    Id = dr.GetInt32(0), Numero = dr.GetString(1), Description = dr.GetString(2), coordonnee = dr.GetString(3), Etat = dr.GetString(4), ligne = LigneDao.findByNumero(dr.GetString(5))
                };
            }
            cmd.Dispose();
            return(point);
        }