예제 #1
0
        public ProductQuantitiesInsert InsertProductQuantitiy(ProductQuantitiesInsert productQuantitiesInsert)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand command = new SqlCommand("ProcedureInsertProductsQuantities", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("@ProductID_Input", productQuantitiesInsert.ProductID);
                    command.Parameters.AddWithValue("@ProductQuantity_Input", productQuantitiesInsert.ProductQuantity);

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

                return(productQuantitiesInsert);
            }
        }
예제 #2
0
 //[Consumes("application/json")]
 public IActionResult Post([FromBody] ProductQuantitiesInsert productQuantitiesInsert)
 {
     return(Ok(new ProductQuantitiesDataLayer(_configuration).InsertProductQuantitiy(productQuantitiesInsert)));
 }