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);
}
}
/*
* 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);
}
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());
}
public void InsertProductQuantity(int productID, ProductsInsertComplex productsInsertComplex)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("ProcedureInsertProductsQuantitiesProducts", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ProductID_Input", productID);
command.Parameters.AddWithValue("@ProductQuantity_Input", productsInsertComplex.ProductQuantity);
connection.Open();
command.ExecuteNonQuery();
}
}
}
