private NoteModel CreateNote(OrgComm.Data.Models.Note note) { NoteModel noteModel = null; using (OrgCommEntities dbc = new OrgCommEntities(DBConfigs.OrgCommConnectionString)) { if (!dbc.Members.Any(r => (!r.DelFlag) && (r.Id.Equals(note.MemberId)))) { throw new OrgException("Invalid member"); } dbc.Notes.Add(note); dbc.SaveChanges(); noteModel = new NoteModel { Id = note.Id, Text = note.Text, Image = (note.Image == null) ? null : NewsBL.ImageUrlFormatString.Replace("{0}", note.Id.ToString()), Type = note.Type, CreatedDate = note.CreatedDate.ToString(AppConfigs.GeneralDateTimeFormat), Ticks = note.CreatedDate.Ticks }; var lookupNoteType = dbc.Lookups.SingleOrDefault(r => (r.TypeId == (int)OrgComm.Data.Models.Lookup.LookupType.NoteType) && (r.Value == (int)note.Type)); if (lookupNoteType != null) { noteModel.TypeDescription = lookupNoteType.Description; } } return(noteModel); }
private NoteModel UpdateNote(int?memberId, OrgComm.Data.Models.Note updateNote) { NoteModel noteModel = null; using (OrgCommEntities dbc = new OrgCommEntities(DBConfigs.OrgCommConnectionString)) { var note = dbc.Notes.SingleOrDefault(r => r.Id.Equals(updateNote.Id)); if (note == null) { throw new OrgException("Invalid note"); } if (memberId.HasValue && !note.MemberId.Equals(memberId.Value)) { throw new OrgException("Invalid note owner"); } if (updateNote.Type == (int)OrgComm.Data.Models.Note.NoteType.Text) { note.Type = updateNote.Type; note.Text = updateNote.Text; note.Image = null; } else if (updateNote.Type == (int)OrgComm.Data.Models.Note.NoteType.Image) { note.Type = updateNote.Type; note.Text = null; note.Image = updateNote.Image; } dbc.SaveChanges(); noteModel = new NoteModel { Id = note.Id, Text = note.Text, Image = (note.Image == null) ? null : NewsBL.ImageUrlFormatString.Replace("{0}", note.Id.ToString()), Type = note.Type, CreatedDate = note.CreatedDate.ToString(AppConfigs.GeneralDateTimeFormat), Ticks = note.CreatedDate.Ticks }; var lookupNoteType = dbc.Lookups.SingleOrDefault(r => (r.TypeId == (int)OrgComm.Data.Models.Lookup.LookupType.NoteType) && (r.Value == (int)note.Type)); if (lookupNoteType != null) { noteModel.TypeDescription = lookupNoteType.Description; } } return(noteModel); }