示例#1
0
        public void AddProductOption(ProductOption productOption)
        {
            var query = @"INSERT INTO productoptions (id, productid, name, description) 
                values (@Id, @ProductId, @Name, @Description)";

            SqliteParameter[] parameters =
            {
                new SqliteParameter("@Id",          productOption.Id),
                new SqliteParameter("@ProductId",   productOption.ProductId),
                new SqliteParameter("@Name",        productOption.Name),
                new SqliteParameter("@Description", productOption.Description),
            };

            SqliteUtil.Insert(query, parameters);
        }
示例#2
0
        public void AddProduct(Product product)
        {
            var query = @"INSERT INTO Products (id, name, description, price, deliveryprice)
                values (@Id, @Name, @Description, @Price, @DeliveryPrice)";

            SqliteParameter[] parameters =
            {
                new SqliteParameter("@Id",            product.Id),
                new SqliteParameter("@Name",          product.Name),
                new SqliteParameter("@Description",   product.Description),
                new SqliteParameter("@Price",         product.Price),
                new SqliteParameter("@DeliveryPrice", product.DeliveryPrice)
            };

            SqliteUtil.Insert(query, parameters);
        }