示例#1
0
        public ProductMaterialsOrderUpdate UpdateMaterialsOrder(ProductMaterialsOrderUpdate productMaterialsOrderUpdate)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand command = new SqlCommand("ProcedureUpdateProductsMaterialsOrder", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("@ProductMaterialOrderIDUpdate", productMaterialsOrderUpdate.MaterialsOrderID);
                    command.Parameters.AddWithValue("@ProductMaterialIDValueUpdate", productMaterialsOrderUpdate.MaterialID);

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

                return(productMaterialsOrderUpdate);
            }
        }
示例#2
0
 public IActionResult Put([FromBody] ProductMaterialsOrderUpdate productMaterialsOrderUpdate)
 {
     return(Ok(new ProductMaterialsOrderDataLayer(_configuration).UpdateMaterialsOrder(productMaterialsOrderUpdate)));
 }