public object GetNotes(string Email)
{
var list = new List <NotesTbl>();
var label = new List <LabelTbl>();
var SharingNote = new List <CollaboratorTbl>();
var Label = from t in _context.tblLabel where t.Email == Email select t;
foreach (var lbl in Label)
{
label.Add(lbl);
}
GetNotesData data = new GetNotesData();
var Notesdata = from t in _context.tblNotes where t.Email == Email select t;
foreach (var item in Notesdata)
{
list.Add(item);
}
var collaborator = from t in _context.tblCollaborator where t.SharedId == Email select t;
foreach (var emaildata in collaborator)
{
var noteid = emaildata.NoteId;
NotesTbl note = _context.tblNotes.Where <NotesTbl>(t => t.ID == noteid).First();
list.Add(note);
}
data.noteData = list;
data.label = label;
return(data);
}
public IList <GetNotesData> GetNotes(Guid userId)
{
try
{
var list = new List <NotesModel>();
var labels = new List <LabelsModel>();
GetNotesData data = new GetNotesData();
var notesData = from notes in this.context.Notes
where notes.userId == userId orderby notes.Id descending select notes;
foreach (var item in notesData)
{
list.Add(item);
}
var Label = from t in context.labels where t.UserId == userId select t;
foreach (var lbl in Label)
{
labels.Add(lbl);
}
data.notesData = list;
data.labelsData = labels;
var notesdata = new List <GetNotesData>();
notesdata.Add(data);
return(notesdata.ToArray());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public object ReminderNotes(Guid userId)
{
try
{
var list = new List <NotesModel>();
GetNotesData data = new GetNotesData();
var notesData = from notes in this.context.Notes where (notes.userId == userId) && (notes.Reminder != null) select notes;
foreach (var item in notesData)
{
list.Add(item);
}
data.notesData = list;
return(data);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public object GetArchiveNotes(Guid userId)
{
try
{
var list = new List <NotesModel>();
GetNotesData data = new GetNotesData();
var notesData = from notes in this.context.Notes where (notes.userId == userId) && (notes.IsArchive == true) && (notes.IsTrash == false) select notes;
foreach (var item in notesData)
{
list.Add(item);
}
data.notesData = list;
return(data);
}
catch (Exception ex)
{
return(ex.Message);
}
}
