public void InitializeSQLiteDatabase()
{
// SQLite adatbázis inicializáció.
using(var db = new SQLiteContext())
{
db.Database.Migrate();
}
}
public bool InsertNote(Note input)
{
using (var db = new SQLiteContext())
{
db.Notes.Add(input);
db.SaveChanges();
return db.Notes.Where(n => n.Id == input.Id).FirstOrDefault() == null ? false : true;
}
}
public bool UpdateNote(Note input)
{
using (var db = new SQLiteContext())
{
foreach (var item in input.Links)
{
db.NoteToNote.Add(item);
}
db.Notes.Update(input);
db.SaveChanges();
Note note = getNote(input);
return note.ModoficationDate.Date.Equals(DateTime.Today.Date) ? true : false;
}
}
public bool DeleteNote(Note input)
{
using(var db = new SQLiteContext())
{
Note note = getNote(input);
if(note != null)
{
db.Notes.Remove(note);
db.SaveChanges();
// Ha törlés után megtalálom a listában, akkor nem sikerült a törlés.
return db.Notes.Where(n => n.Id == input.Id).FirstOrDefault() == null ? true : false;
}
else
{
return false;
}
}
}
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;
}
}
private Note getNote(Note input)
{
using (var db = new SQLiteContext())
{
Note note = db.Notes.Where(n => n.Id == input.Id).FirstOrDefault();
if(note != null)
{
note.Attachments = db.Attachments.Where(a => a.Note.Id == note.Id).ToList();
return note;
}
else
{
return null;
}
}
}