public void AddFollowedEvent(FollowedEvents faToAdd) { using var db = new SqlConnection(_connectionString); var sql = @"INSERT INTO [dbo].[FollowedEvents] ([EventId] ,[UserId]) OUTPUT inserted.FollowedEventsId VALUES (@EventId, @UserId)"; var newId = db.ExecuteScalar <int>(sql, faToAdd); faToAdd.FollowedEventsId = newId; }
public FollowedEvents Update(int followedEventsId, FollowedEvents followedEventToUpdate) { var sql = @"UPDATE [dbo].[FollowedEvents] SET [EventId] = @EventId ,[UserId] = @UserId OUTPUT inserted.* WHERE FollowedEventsId = @FollowedEventsId"; using var db = new SqlConnection(_connectionString); var parameters = new { followedEventToUpdate.EventId, followedEventToUpdate.UserId, followedEventsId }; var updatedFE = db.QueryFirstOrDefault <FollowedEvents>(sql, parameters); return(updatedFE); }
public IActionResult UpdateFollowedEvent(int followedEventsId, FollowedEvents feToUpdate) { var updatedFE = _repo.Update(followedEventsId, feToUpdate); return(Ok(updatedFE)); }
public IActionResult AddFollowedEvent(FollowedEvents followedEventToAdd) { _repo.AddFollowedEvent(followedEventToAdd); return(Created($"/ api / followedevents /{ followedEventToAdd.FollowedEventsId}", followedEventToAdd)); }