Example #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);
        }
Example #2
0
        public static Attribuer find(int Id)
        {
            Attribuer   attribuer = null;
            OdbcCommand cmd       = new OdbcCommand("select * from attribuer where Id=?", AccesBd.getConnection());

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

            if (dr.Read())
            {
                attribuer = new Attribuer {
                    Id = dr.GetInt32(0), Numero = dr.GetString(1), DateDebut = dr.GetDateTime(2), DateFin = dr.GetDateTime(3), bus = BusDao.findByNumero(dr.GetString(4)), chauffeur = ChauffeurDao.findByNumero(dr.GetString(5))
                };
            }
            cmd.Dispose();
            return(attribuer);
        }