public string UpdateRunTime([FromBody] UpdateRuntimeRequest req)
{
SqlConnection conn = new SqlConnection(this.connectionString);
conn.Open();
try
{
string queryString = "UPDATE MOVIE SET RUNTIME = @NEWRUNTIME WHERE TITLE = @MOVIETITLE";
SqlCommand command = new SqlCommand(queryString, conn);
command.Parameters.AddWithValue("@NEWRUNTIME", req.Title);
command.Parameters.AddWithValue("@MOVIETITLE", req.NewRunTime);
var result = command.ExecuteNonQuery();
return(result.ToString());
}
catch (SqlException ex)
{
return("Something went wrong.\n" + ex.Message);
}
finally
{
conn.Close();
}
}
public string UpdateMovieTitle([FromBody] UpdateRuntimeRequest request)
{
SqlConnection conn = new SqlConnection(this.connectionString);
string queryString = $"Update Movie set [RunTime] = '{request.newRuntime}' Where Title = '{request.newtitle}'";
SqlCommand command = new SqlCommand(queryString, conn);
conn.Open();
command.ExecuteNonQuery();
// command.Parameters.AddWithValue("@Runtime", test.RuningTime);
queryString = $"Select * From [Movie] Where [Title] = '{request.newtitle}'";
command = new SqlCommand(queryString, conn);
using (SqlDataReader reader = command.ExecuteReader()){
while (reader.Read())
{
Movie movie = new Movie()
{
MovieNum = (int)reader[0],
Title = (string)reader[1],
ReleasYear = (short)reader[2],
RuningTime = (short)reader[3]
};
}
}
var row = command.ExecuteNonQuery().ToString();
return(row);
}
