public bool DeleteAndInsertAll(List<Note> input, User author)
{
DalSmartNote.SmartNoteDal dal = new DalSmartNote.SmartNoteDal();
bool ret = dal.DeleteAndInsertAll(input, author);
return ret;
}
public async Task<List<Note>> GetAllNote(User input)
{
DalSmartNote.SmartNoteDal dal = new DalSmartNote.SmartNoteDal();
List<Note> ret = await dal.GetAllNote(input);
return ret;
}
public Task<List<Note>> GetAllNote(User input)
{
var collection = _database.GetCollection<Note>("notes");
var filter = Builders<Note>.Filter.Eq("Author", input);
var ret = collection.Find(filter).ToListAsync();
return ret;
}
public bool DeleteAndInsertAll(List<Note> input, User author)
{
var collection = _database.GetCollection<Note>("notes");
var filter = Builders<Note>.Filter.Eq("Author", author);
var ret = collection.DeleteManyAsync(filter);
collection.InsertManyAsync(input);
return true;
}
public List<Note> GetAllNote(User input, int sortBy)
{
using (var db = new SQLiteContext())
{
List<Note> notes = null;
switch(sortBy)
{
case 0:
notes = db.Notes.OrderBy(n => n.Title).ToList();
break;
case 1:
notes = db.Notes.OrderByDescending(n => n.Title).ToList();
break;
case 2:
notes = db.Notes.OrderBy(n => n.Priority).ToList();
break;
case 3:
notes = db.Notes.OrderByDescending(n => n.Priority).ToList();
break;
case 4:
notes = db.Notes.OrderBy(n => n.ModoficationDate).ToList();
break;
case 5:
notes = db.Notes.OrderByDescending(n => n.ModoficationDate).ToList();
break;
}
foreach (var item in notes)
{
item.Attachments = db.Attachments.Where(a => a.Note.Id == item.Id).ToList();
item.Links = db.NoteToNote.Where(n => n.OriginalNote.Id == item.Id).ToList();
foreach (var n in item.Links)
{
var p = n.ReferenceNote.Title;
}
}
return notes;
}
}
public List<Note> GetNotesByParams(User user, string title, string content, DateTime? creatinDate, DateTime? modDate, int? priority,
bool? hasfile, bool? byTitle, bool? byCreationDate, bool? byModifyDate, bool? byPriority, bool? byContent)
{
List<Note> ret = null;
List<Note> allNotes = GetAllNote(user, 0);
Func<Note, bool> func = (n) => (
//(n.Author.Id == user.Id) &&
(byTitle.Value == true ? n.Title.Contains(title) : true) &&
(hasfile.Value == true ? (n.Attachments != null && n.Attachments.Count > 0) : true) &&
(byCreationDate.Value == true ? n.CreationDate.Date == creatinDate.Value.Date : true) &&
(byModifyDate.Value == true ? n.ModoficationDate.Date == modDate.Value.Date : true) &&
(byPriority.Value == true ? (priority.HasValue && priority == n.Priority) : true) &&
(byContent.Value == true ? n.PlainText.Contains(content) : true)
);
if (allNotes != null)
{
ret = allNotes.Where(func).ToList();
}
return ret;
}
public List<Note> GetAllNote(User input, int sortBy)
{
return smartNoteDal.GetAllNote(input, sortBy);
}