示例#1
0
        public List <Jouet> jouetAge(int idTrancheAge)
        {
            List <Jouet>  lesjouets    = new List <Jouet>();
            SqlConnection laConnection = seConnecter();

            SqlCommand maCommande;
            string     requete = "SELECT * FROM Jouet WHERE idTrancheage =" + age;;

            maCommande = new SqlCommand(requete, laConnection);

            SqlDataReader Listjouet = maCommande.ExecuteReader();

            while (Listjouet.Read())
            {
                string libelle  = (string)Listjouet["libelle"];
                Int32  prix     = (int)Listjouet["id"];
                int    idcatego = (int)Listjouet["idCategorie"];

                CategorieDAO uneCatgorie = new CategorieDAO();
                string       libelleCat  = uneCatgorie.getLibelleCat(idcatego);

                TrancheageDAO uneTranche = new TrancheageDAO();
                int           ageMin     = uneTranche.getAgeMin(idTrancheAge);
                int           ageMax     = uneTranche.getAgeMax(idTrancheAge);
                lesjouets.Add(new Jouet(libelle, prix, new Categorie(idcatego, libelleCat), new Trancheage(idTrancheAge, 10, 20)));
            }
            Listjouet.Close();
            return(lesjouets);

            throw new NotImplementedException();
        }
示例#2
0
        public Formaddjouet()
        {
            CategorieDAO  cat     = new CategorieDAO();
            TrancheageDAO tranche = new TrancheageDAO();

            InitializeComponent();
            cbcat.DataSource    = cat.findAll();
            cbcat.DisplayMember = "info";
            //cbcat.ValueMember = "Id";
            cbtrancheage.DataSource    = tranche.findAll();
            cbtrancheage.DisplayMember = "info";
            //cbtrancheage.ValueMember = "Code";
        }
示例#3
0
        private void cmb_enfant_SelectedIndexChanged(object sender, EventArgs e)
        {
            int val;

            Int32.TryParse(cmb_enfant.SelectedValue.ToString(), out val);
            TrancheageDAO     trancheAge     = new TrancheageDAO();
            List <Trancheage> listTrancheAge = trancheAge.findAll();

            //System.Windows.Forms.MessageBox.Show(val.ToString());

            EnfantDAO unEnfant = new EnfantDAO();
            int       age      = Int32.Parse(unEnfant.getAge(val));
            int       idTrancheAge;

            foreach (Trancheage uneTrancheAge in listTrancheAge)
            {
                if (age > uneTrancheAge.getAgeMin() && age < uneTrancheAge.getAgeMin())
                {
                    idTrancheAge = uneTrancheAge.getCode();
                }
            }
        }