public async Task RemoveAuthor(string downloadid, string userid)
{
if ((await _downloadTable.SelectById(downloadid)).Any())
{
if ((await _userTable.SelectById(userid)).Any())
{
DownloadAuthorModel author = new DownloadAuthorModel {
DownloadId = downloadid, UserId = userid
};
await _downloadAuthorTable.Delete(author);
}
else
{
throw new ArgumentException("No user with the provided ID could be found.");
}
}
}
public async Task Delete(DownloadAuthorModel author)
{
string sql = "DELETE FROM `downloadauthors` WHERE `DownloadId` = @DownloadId AND `UserId` = @UserId";
await _sqlDataAccess.SaveData(sql, author);
}
public async Task Insert(DownloadAuthorModel author)
{
string sql = "INSERT INTO `downloadauthors` (DownloadId, UserId) VALUES (@DownloadId, @UserId)";
await _sqlDataAccess.SaveData(sql, author);
}