public async Task <bool> DeleteAnnouncement(ScrubbyAnnouncement announcement)
{
const string query = @"DELETE FROM announcements WHERE id = @id";
await using var conn = GetConnection();
return(await conn.ExecuteAsync(query, announcement) == 1);
}
public async Task <ScrubbyAnnouncement> CreateAnnouncement(ScrubbyAnnouncement announcement)
{
const string query = @"
INSERT INTO announcements (""start"", ""end"", message, active)
VALUES (@start, @end, @message, @active)
RETURNING id, ""start"", ""end"", message, active";
await using var conn = GetConnection();
return((await conn.QueryAsync <ScrubbyAnnouncement>(query, announcement)).FirstOrDefault());
}
public async Task <ScrubbyAnnouncement> UpdateAnnouncement(ScrubbyAnnouncement announcement)
{
const string query = @"
UPDATE announcements
SET
""start"" = @start,
""end"" = @end,
message = @message,
active = @active
WHERE id = @id
RETURNING id, ""start"", ""end"", message, active";
await using var conn = GetConnection();
return((await conn.QueryAsync <ScrubbyAnnouncement>(query, announcement)).FirstOrDefault());
}
public async Task <IActionResult> DeleteAnnouncement([FromBody] ScrubbyAnnouncement announcement)
{
return(await _announcements.DeleteAnnouncement(announcement) ? Ok() : NotFound());
}
public async Task <IActionResult> UpdateAnnouncement([FromBody] ScrubbyAnnouncement announcement)
{
var result = await _announcements.UpdateAnnouncement(announcement);
return(result != null?Ok(result) : BadRequest("Could not update announcement as submitted"));
}
