Пример #1
0
        public int InsertProduct(ProductsInsert productsInsert)
        {
            int ProductIDFromInsert = 0;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand command = new SqlCommand("ProcedureInsertProductsV3", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("@ProductSKUID", productsInsert.ProductSKUID);
                    command.Parameters.AddWithValue("@ProductNameID", productsInsert.ProductNameID);
                    command.Parameters.AddWithValue("@ProductBrandID", productsInsert.ProductBrandID);
                    command.Parameters.AddWithValue("@ProductPriceID", productsInsert.ProductPriceID);
                    command.Parameters.AddWithValue("@ProductVariableCostID", productsInsert.ProductVariableCostID);
                    command.Parameters.AddWithValue("@ProductStartFactorID", productsInsert.ProductStartFactorID);
                    command.Parameters.AddWithValue("@ProductGrowthFactorID", productsInsert.ProductGrowthFactorID);
                    command.Parameters.AddWithValue("@ProductID_Output", ProductIDFromInsert).Direction = ParameterDirection.Output;

                    connection.Open();
                    command.ExecuteNonQuery();

                    ProductIDFromInsert = Convert.ToInt32(command.Parameters["@ProductID_Output"].Value);
                }

                return(ProductIDFromInsert);
            }
        }
Пример #2
0
        public void InsertProductMaterial(int productID, ProductsInsertComplex productsInsertComplex)
        {
            ProductsInsert productsInsert = new ProductsInsert();

            foreach (ProductsInsertComplex.ProductsInsertMaterial productsInsertMaterial in productsInsertComplex.productsInsertMaterials)
            {
                InsertMaterial(productID, productsInsertMaterial.MaterialName);
                Console.WriteLine(productID + productsInsertMaterial.MaterialName);
            }
        }
Пример #3
0
        /*
         * public ProductsInsert InsertProduct(ProductsInsertComplex productsInsertComplex)
         * {
         *  ProductsInsert productsInsert = new ProductsInsert();
         *
         *  productsInsert = InsertProductToID(productsInsertComplex);
         *
         *
         *  return productsInsert;
         * }*/

        public ProductsInsert InsertProduct(ProductsInsertComplex productsInsertComplex)
        {
            SKUID          = InsertSKU(productsInsertComplex.ProductSKU);
            NameID         = InsertName(productsInsertComplex.ProductName);
            BrandID        = InsertBrand(productsInsertComplex.ProductBrand);
            PriceID        = InsertPrice(productsInsertComplex.ProductPrice);
            VariableCostID = InsertVariableCost(productsInsertComplex.ProductVariableCost);
            StartFactorID  = InsertStartFactor(productsInsertComplex.ProductStartFactor);
            GrowthFactorID = InsertGrowthFactor(productsInsertComplex.ProductGrowthFactor);

            ProductsInsert productsInsert = new ProductsInsert(SKUID, NameID, BrandID, PriceID, VariableCostID, StartFactorID, GrowthFactorID);

            return(productsInsert);
        }
Пример #4
0
        public IActionResult Post([FromBody] ProductsInsertComplex productsInsertComplex)
        {
            ProductsInsert productsInsert = new ProductsInsert(0, 0, 0, 0, 0, 0, 0);
            PriceOptimize  priceOptimize  = new PriceOptimize();

            productsInsertComplex.ProductPrice = priceOptimize.OptimizePrice(productsInsertComplex.ProductVariableCost, productsInsertComplex.ProductStartFactor, productsInsertComplex.ProductGrowthFactor);
            productsInsert = new ProductsInsertDataLayer(_configuration).InsertProduct(productsInsertComplex);


            int ProductID = new ProductsDataLayer(_configuration).InsertProduct(productsInsert);

            new ProductsInsertDataLayer(_configuration).InsertProductMaterial(ProductID, productsInsertComplex);
            new ProductsInsertDataLayer(_configuration).InsertProductQuantity(ProductID, productsInsertComplex);

            return(Ok());
        }