public GuildLink AddLink(GuildLink linkToAdd)
{
var sql = @"
insert into[GuildLinks](LinkTitle, LinkDescription, LinkUrl, IsAvailable, GuildId)
output inserted.*
values(@LinkTitle, @LinkDescription, @LinkUrl, 1, @GuildId);
";
using (var db = new SqlConnection(connectionString))
{
var parameters = new
{
LinkTitle = linkToAdd.LinkTitle,
LinkDescription = linkToAdd.LinkDescription,
LinkUrl = linkToAdd.LinkUrl,
GuildId = linkToAdd.GuildId
};
var result = db.QueryFirstOrDefault <GuildLink>(sql, parameters);
return(result);
}
}
public IActionResult CreateNewLink(GuildLink newLinkToAdd)
{
var link = _linksRepository.AddLink(newLinkToAdd);
return(Created("Created new link succesffully", link));
}
