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