public CircleAnnouncement AddAnnouncement(CircleAnnouncement announcementToAdd)
{
DateTime dateTime = DateTime.Now;
var sql = @"
insert into[CircleAnnouncements](CircleId, AnnouncementDateTime, AnnouncementText)
output inserted.*
values(@CircleId, @AnnouncementDateTime, @AnnouncementText);
";
using (var db = new SqlConnection(connectionString))
{
var parameters = new
{
CircleId = announcementToAdd.CircleId,
AnnouncementDateTime = dateTime,
AnnouncementText = announcementToAdd.AnnouncementText
};
var result = db.QueryFirstOrDefault <CircleAnnouncement>(sql, parameters);
return(result);
}
}
public IActionResult CreateNewAnnouncement(CircleAnnouncement newAnnouncementToAdd)
{
var announcement = _announcementsRepo.AddAnnouncement(newAnnouncementToAdd);
return(Created("Create new announcement successfully", announcement));
}
