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); }