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)); }