예제 #1
0
        public List <Carro> ListAll()
        {
            CarroMotorDAO    cm  = new CarroMotorDAO();
            CarroOpcionalDAO co  = new CarroOpcionalDAO();
            Database         db  = Database.GetInstance();
            string           qry = "SELECT * FROM carro";
            DataSet          ds  = db.ExecuteQuery(qry);

            List <Carro> lc = new List <Carro>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Carro c = new Carro();
                c.Id        = int.Parse(dr["Id"].ToString());
                c.Nome      = dr["nome"].ToString();
                c.Modelo    = dr["modelo"].ToString();
                c.PrecoBase = double.Parse(dr["precobase"].ToString());
                c.Removido  = int.Parse(dr["removido"].ToString());

                c.Motor    = cm.Read(c.Id);
                c.Opcional = co.Read(c.Id);

                lc.Add(c);
            }


            return(lc);
        }
예제 #2
0
        public void Update(Carro c)
        {
            Database db = Database.GetInstance();

            string qry = String.Format("UPDATE carro SET nome = '{0}', modelo = '{1}', precobase = '{2}' WHERE Id = '{3}'", c.Nome, c.Modelo, c.PrecoBase, c.Id);

            db.ExecuteNonQuery(qry);

            CarroOpcionalDAO co = new CarroOpcionalDAO();
            CarroMotorDAO    cm = new CarroMotorDAO();

            Console.WriteLine("o id eh " + c.Id);
            co.Delete(c.Id);
            cm.Delete(c.Id);

            foreach (Opcional o in c.Opcional)
            {
                co.Create(c.Id, o.Id);
            }

            foreach (Motor m in c.Motor)
            {
                cm.Create(c.Id, m.Id);
            }
        }