public void SaveAnnouncement(AnnouncementInfo announcementInfo)
{
Data.Announcement announcement = ConvertToDb(announcementInfo);
_context.Announcements.Add(announcement);
_context.SaveChanges();
}
public void DeleteAnnouncement(int id)
{
using (OCCDB db = new OCCDB())
{
Data.Announcement announcement = (from a in db.Announcements where a.ID == id select a).FirstOrDefault();
db.Announcements.Remove(announcement);
db.SaveChanges();
}
}
public static Announcement Map(this Data.Announcement a)
{
Announcement announcement = new Announcement
{
ID = a.ID,
EventID = a.Event_ID,
Title = a.Title,
Content = a.Content,
PublishDate = a.PublishDate
};
return(announcement);
}
public AnnouncementInfo ConvertToFacade(Data.Announcement announcement)
{
return(new AnnouncementInfo
{
Id = announcement.Id,
Title = announcement.Title,
Description = announcement.Description,
CreatedOn = announcement.CreatedOn,
CreatedByAccountId = announcement.CreatedByAccountId,
ModifiedOn = announcement.ModifiedOn,
ModifiedByAccountId = announcement.ModifiedByAccountId
});
}
public void DeleteAnnouncement(int id)
{
Data.Announcement announcement = _context.Announcements.Find(id);
if (announcement != null)
{
_context.Announcements.Remove(announcement);
_context.SaveChanges();
}
else
{
throw new ArgumentNullException();
}
}
public void CreateAnnouncement(Announcement announcement)
{
using (OCCDB db = new OCCDB())
{
Data.Announcement a = new Data.Announcement()
{
Event_ID = announcement.EventID,
Title = announcement.Title,
Content = announcement.Content,
PublishDate = announcement.PublishDate
};
db.Announcements.Add(a);
db.SaveChanges();
}
}
public void UpdateAnnouncement(AnnouncementInfo announcementInfo)
{
Data.Announcement announcement = _context.Announcements.Find(announcementInfo.Id);
if (announcement != null)
{
announcement.Title = announcementInfo.Title;
announcement.Description = announcementInfo.Description;
announcement.ModifiedOn = announcementInfo.ModifiedOn;
announcement.ModifiedByAccountId = announcementInfo.ModifiedByAccountId;
_context.SaveChanges();
}
else
{
throw new ArgumentNullException();
}
}
public void CreateAnnouncement(Announcement announcement)
{
using (OCCDB db = new OCCDB())
{
Data.Announcement a = new Data.Announcement()
{
Event_ID = announcement.EventID,
Title = announcement.Title,
Content = announcement.Content,
PublishDate = announcement.PublishDate
};
db.Announcements.Add(a);
db.SaveChanges();
}
}
public static Data.Announcement Map(this Announcement a)
{
Data.Announcement announcement = new Data.Announcement
{
ID = a.ID,
Event_ID = a.EventID,
Title = a.Title,
Content = a.Content,
PublishDate = a.PublishDate
};
return announcement;
}
