public IActionResult Trade(int id, TradeUserCandyDto userCandyUpdate)
{
var repo = new UserCandyRepository();
var updatedUserCandy = new UserCandy
{
CandyId = userCandyUpdate.CandyId,
UserId = userCandyUpdate.UserId,
IsTraded = true,
};
var userCandyThatGotUpdated = repo.TradeCandy(id, updatedUserCandy);
return(Ok(userCandyThatGotUpdated));
}
public UserCandy TradeCandy(int id, UserCandy userCandyUpdate)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"UPDATE [UsersCandy]
SET UserId = @nuId, IsTraded = 'true'
WHERE candyId = @cId AND userId = @ouId";
var u = userCandyUpdate;
var userCandyObj = new
{
//cId = u.id,
//nuId = newUserId,
//ouId = oldUserId,
};
var userCandy = db.QueryFirst <UserCandy>(sql, userCandyObj);
return(userCandy);
}
}
