示例#1
0
        public MaterialsUpdate UpdateMaterial(MaterialsUpdate materialsUpdate)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand command = new SqlCommand("ProcedureUpdateMaterial", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("@MaterialIDUpdate", materialsUpdate.MaterialName);
                    command.Parameters.AddWithValue("@MaterialNameUpdate", materialsUpdate.MaterialID);

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

                return(materialsUpdate);
            }
        }
示例#2
0
 public IActionResult Put([FromBody] MaterialsUpdate materialsUpdate)
 {
     return(Ok(new MaterialsDataLayer(_configuration).UpdateMaterial(materialsUpdate)));
 }