public List <MessagesModel> GetMessagesInSeries(string seriesName) { List <MessagesModel> msgs = null; using (MessagesContainer cr = new MessagesContainer()) { msgs = (from c in cr.messages select new MessagesModel() { MessageTitle = c.MessageTitle, DateCreated = c.DateCreated, MessageDescription = c.MessageDescription, MessageAuthor = c.MessageAuthor, MessageHardCopy = c.MessageHardCopy, Series = c.Series, VideoFile = c.VideoFile, mp3File = c.mp3File, UID = c.UID }) .Where(m => m.Series.Equals(seriesName)) .OrderByDescending(m => m.DateCreated) .ToList(); } return(msgs); }
public MessagesModel SaveMessage(MessagesModel mm) { using (MessagesContainer cr = new MessagesContainer()) { message msg = null; if (mm.UID > 0) { msg = cr.messages.Where(m => m.UID == mm.UID).FirstOrDefault(); } if (msg == null) { msg = new message(); cr.Entry(msg).State = System.Data.EntityState.Added; } msg.MessageTitle = mm.MessageTitle; msg.DateCreated = mm.DateCreated; msg.MessageDescription = mm.MessageDescription; msg.MessageAuthor = mm.MessageAuthor; msg.MessageHardCopy = mm.MessageHardCopy; msg.Series = mm.Series; msg.VideoFile = mm.VideoFile; msg.mp3File = mm.mp3File; try { cr.SaveChanges(); } catch (System.Data.Entity.Infrastructure.DbUpdateException DbEx) { mm.errorMessage = DbEx.ToString(); } finally { mm.UID = msg.UID; ((IObjectContextAdapter)cr).ObjectContext.Detach(msg); } } return(mm); }