public List<Notes> GetAllNotesAsList()
{
List<Notes> data = new List<Notes>();
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
data = (from notes in db.Notes
orderby notes.date descending
select notes).ToList();
}
return data.ToList<Notes>();
}
public bool Save(Notes note)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
db.Notes.InsertOnSubmit(note);
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
public bool DestroyOldNotes(int days)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
var destroy = db.Notes.Where(t => t.date < DateTime.Now.AddDays(-days)).ToList();
db.Notes.DeleteAllOnSubmit(destroy);
db.SubmitChanges();
return true;
}
}
catch (Exception)
{
return false;
}
}
public bool Destroy(Notes note)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
var excluir = db.Notes.Where(t => t.id == note.id).First();
db.Notes.DeleteOnSubmit(excluir);
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
internal Notes GetNote(int id)
{
List<Notes> data = new List<Notes>();
using(DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
data = (from e in db.Notes
where e.id == id
select e).ToList();
}
return data[0];
}
//ToDo Update note using Linq
internal bool UpdateNote(int id, string note)
{
try
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
Notes update = (from tar in db.Notes
where tar.id == id
select tar).First();
update.note = note;
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
internal IEnumerable<Notes> GetSimilarNotes(string keyword)
{
using (DataBaseContext db = new DataBaseContext(DataBaseContext.ConnectionString))
{
var data = from note in db.Notes
where note.note.Contains(keyword)
select note;
return new ObservableCollection<Notes>(data);
}
}