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);
}
