public async Task <IActionResult> Add(int playlist_id, string tag_name)
{
if (playlist_id <= 0)
{
return(ErrorProblem());
}
if (String.IsNullOrEmpty(tag_name))
{
return(ErrorProblem());
}
AbstractTagDto checkTag = await _tagEntity.GetByName(tag_name);
AbstractTagDto tagAdd = new TagDto();
tagAdd.Name = tag_name;
tagAdd.OwnerId = playlist_id;
if (checkTag.Id > 0)
{
tagAdd = checkTag;
tagAdd.OwnerId = playlist_id;
}
else
{
tagAdd.Id = await _tagEntity.Add(tagAdd);
}
await _playlistEntity.AddTag(tagAdd);
return(Content(""));
}
public async Task <bool> AddTag(AbstractTagDto pTag)
{
if (pTag == null)
{
throw new ArgumentNullException(nameof(pTag) + " is null");
}
using (System.Data.IDbConnection db = new MySqlConnection(_baseSettings.GetConnString()))
{
string sql_qry = " INSERT INTO tag_owner_rel (TagId, OwnerId) VALUES (@p_TagId, @p_OwnerId) ";
await db.ExecuteAsync(sql_qry,
param : new
{
@p_TagId = pTag.Id,
p_OwnerId = pTag.OwnerId
});
}
return(true);
}
