public async Task AddMovies(Entities.Movies movie)
{
var sql = "INSERT INTO Movies([Name], [Category],[Rating]) Values(@Name,@Category,@Rating);";
using (var sqlConnection = new SqlConnection(connectionString))
{
await sqlConnection.OpenAsync();
await sqlConnection.ExecuteAsync(sql, new
{
movie.Name,
movie.Category,
movie.Rating
});
}
}
public async Task EditMovie(Entities.Movies movie)
{
string sql = "UPDATE Movies SET Name = @Name, Category =@Category, Rating= @Rating WHERE Id =" + movie.Id + ";";
using (var sqlConnection = new SqlConnection(connectionString))
{
await sqlConnection.OpenAsync();
await sqlConnection.ExecuteAsync(
sql, new
{
movie.Id,
movie.Name,
movie.Category,
movie.Rating
}
);
}
}
public async Task Put([FromBody] Entities.Movies movie)
{
await this._movies.EditMovie(movie);
}
public async Task Post([FromBody] Entities.Movies movie)
{
await this._movies.AddMovies(movie);
}
