Ejemplo n.º 1
0
        public static List <Feedback> getAllFeedbackByProduct(int productId)
        {
            List <Feedback> list = new List <Feedback>();

            using (MySqlCommand command = con.CreateCommand())
            {
                command.CommandText = "SELECT *  FROM pz.feedback inner join pz.user on user.id = feedback.user_id inner join goods on feedback.goods_id = goods.id where feedback.goods_id = @id";
                command.Parameters.Add(new MySqlParameter("@id", productId));
                using (MySqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        var feedback = new Feedback();
                        feedback.setId(int.Parse(reader["id"].ToString()));
                        int t    = int.Parse(reader["user_id"].ToString());
                        var user = new User();
                        using (MySqlCommand comm = con.CreateCommand())
                        {
                            comm.CommandText = "SELECT *  FROM pz.user where user.id = @id";
                            comm.Parameters.Add(new MySqlParameter("@id", t));
                            user.setId(int.Parse(reader["id"].ToString()));
                            user.setEmail(reader["email"].ToString());
                            user.setFirstName(reader["first_name"].ToString());
                            user.setLastName(reader["last_name"].ToString());
                            user.setPass(reader["password"].ToString());
                        }
                        feedback.setUser(user);
                        int tt   = int.Parse(reader["goods_id"].ToString());
                        var prod = new Product();
                        using (MySqlCommand comm = con.CreateCommand())
                        {
                            comm.CommandText = "SELECT *  FROM pz.goods where goods.id = @id";
                            comm.Parameters.Add(new MySqlParameter("@id", tt));
                            prod.setId(int.Parse(reader["id"].ToString()));
                            prod.setName(reader["name"].ToString());
                            prod.setDetails(reader["details"].ToString());
                            prod.setPotoUrl(reader["photo_url"].ToString());
                            prod.setNumber(int.Parse(reader["number"].ToString()));
                        }
                        feedback.setGoods(prod);
                        feedback.setText(reader["text"].ToString());
                        list.Add(feedback);
                    }
                }
            }
            return(list);
        }
Ejemplo n.º 2
0
        private static Product selectProduct(int id)
        {
            Product product = new Product();

            using (MySqlCommand command = con.CreateCommand())
            {
                command.CommandText = "SELECT *  FROM pz.goods where goods.id = @Id";
                command.Parameters.Add(new MySqlParameter("@Id", id));
                using (MySqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        product.setId(int.Parse(reader["id"].ToString()));
                        product.setName(reader["name"].ToString());
                        product.setDetails(reader["details"].ToString());
                        product.setPotoUrl(reader["photo_url"].ToString());
                        product.setPrice(decimal.Parse(reader["price"].ToString()));
                        product.setNumber(int.Parse(reader["number"].ToString()));
                    }
                }
            }
            return(product);
        }
Ejemplo n.º 3
0
        public static List <Product> getProducts()
        {
            List <Product> products = new List <Product>();

            using (MySqlCommand command = con.CreateCommand())
            {
                command.CommandText = "SELECT *  FROM pz.goods";
                using (MySqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        var product = new Product();
                        product.setId(int.Parse(reader["id"].ToString()));
                        product.setName(reader["name"].ToString());
                        product.setDetails(reader["details"].ToString());
                        product.setPotoUrl(reader["photo_url"].ToString());
                        product.setPrice(decimal.Parse(reader["price"].ToString()));
                        product.setNumber(int.Parse(reader["number"].ToString()));
                        products.Add(product);
                    }
                }
            }
            return(products);
        }