public bool AddUserCandy(AddUserCandyDto newUserCandy, int userId, int candyId)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"INSERT INTO [UsersCandy]
([CandyId]
,[UserId]
,[IsTraded])
OUTPUT inserted.*
VALUES
(@cId
,@uId
,'false')";
var userCandyObj = new
{
uId = userId,
cId = candyId,
};
return(db.Execute(sql, userCandyObj) == 1);
}
}
public void Add(AddUserCandyDto newUserCandy, int userId, int candyId)
{
_repo.AddUserCandy(newUserCandy, userId, candyId);
}
