Exemplo n.º 1
0
        //Read
        public List <BestBuyProducts> Select()
        {
            MySqlConnection conn = new MySqlConnection();

            using (conn)
            {
                conn.Open();

                MySqlCommand cmd = conn.CreateCommand();

                cmd.CommandText = "SELECT ProductID, Name, Price " +
                                  "FROM products;";

                MySqlDataReader dataReader = cmd.ExecuteReader();

                List <BestBuyProducts> products = new List <BestBuyProducts>();

                while (dataReader.Read())
                {
                    BestBuyProducts product = new BestBuyProducts();
                    product.Id    = Convert.ToInt32(dataReader["ProductID"]);
                    product.Name  = dataReader["Name"].ToString();
                    product.Price = Convert.ToDouble(dataReader["Price"]);

                    products.Add(product);
                }

                return(products);
            }
        }
Exemplo n.º 2
0
        //Create
        public void Insert(BestBuyProducts product)
        {
            MySqlConnection conn = new MySqlConnection();

            using (conn)
            {
                MySqlCommand cmd = conn.CreateCommand();

                cmd.CommandText = "INSERT INTO products (Name, Price) " +
                                  "VALUES (@name, @price;";
                cmd.Parameters.AddWithValue("name", product.Name);
                cmd.Parameters.AddWithValue("price", product.Price);

                cmd.ExecuteNonQuery();
            }
        }
Exemplo n.º 3
0
        //Update
        public void Update(BestBuyProducts product)
        {
            MySqlConnection conn = new MySqlConnection();

            using (conn)
            {
                conn.Open();

                MySqlCommand cmd = conn.CreateCommand();

                cmd.CommandText = "UPDATE products " +
                                  "SET Name = @name, Price = @price " +
                                  "WHERE ProductID = @id;";
                cmd.Parameters.AddWithValue("name", product.Name);
                cmd.Parameters.AddWithValue("price", product.Price);
                cmd.Parameters.AddWithValue("id", product.Id);

                cmd.ExecuteNonQuery();
            }
        }