public static List <Note> getAllNotes()
{
using (var _context = new DbofSimpleNoteEntities())
{
var get = (from getnote in _context.Notes.AsEnumerable()
select new
{
SoThuTu = getnote.SoThuTu,
TieuDe = getnote.TieuDe,
NoiDung = getnote.NoiDung,
ThongTin = getnote.ThongTin,
Rac = getnote.Rac,
PintoTop = getnote.PintoTop,
Tags = getnote.Tags
})
.Select(x => new Note
{
SoThuTu = x.SoThuTu,
TieuDe = x.TieuDe,
NoiDung = x.NoiDung,
ThongTin = x.ThongTin,
Rac = x.Rac,
PintoTop = x.PintoTop,
Tags = x.Tags
}).ToList();
return(get);
}
}
public static Note getNote(int stt)
{
using (var _context = new DbofSimpleNoteEntities())
{
var get = (from getnote in (from note in _context.Notes.AsEnumerable()
select note)
where getnote.SoThuTu == stt
select new
{
SoThuTu = getnote.SoThuTu,
TieuDe = getnote.TieuDe,
NoiDung = getnote.NoiDung,
ThongTin = getnote.ThongTin,
Rac = getnote.Rac,
PintoTop = getnote.PintoTop,
Tags = getnote.Tags
})
.Select(x => new Note
{
SoThuTu = x.SoThuTu,
TieuDe = x.TieuDe,
NoiDung = x.NoiDung,
ThongTin = x.ThongTin,
Rac = x.Rac,
PintoTop = x.PintoTop,
Tags = x.Tags
}).SingleOrDefault();
return(get);
}
}
public static List <Note> getAllNotesbyString(string find)
{
using (var _context = new DbofSimpleNoteEntities())
{
var get = (from note in _context.Notes.AsEnumerable()
where note.NoiDung.Contains(find)
select new
{
SoThuTu = note.SoThuTu,
TieuDe = note.TieuDe,
NoiDung = note.NoiDung,
ThongTin = note.ThongTin,
Rac = note.Rac,
PintoTop = note.PintoTop,
Tags = note.Tags
})
.Select(x => new Note
{
SoThuTu = x.SoThuTu,
TieuDe = x.TieuDe,
NoiDung = x.NoiDung,
ThongTin = x.ThongTin,
Rac = x.Rac,
PintoTop = x.PintoTop,
Tags = x.Tags
}).ToList();
return(get);
}
}
public static bool deleteTag(Tag tag)
{
using (var _context = new DbofSimpleNoteEntities())
{
var get = (from gettag in _context.Tags
where gettag.TenTag == tag.TenTag
select gettag).SingleOrDefault();
foreach (var note in get.Notes)
{
foreach (var temp in note.Tags)
{
if (temp.TenTag == tag.TenTag)
{
note.Tags.Remove(temp);
break;
}
}
}
_context.Tags.Remove(get);
_context.SaveChanges();
return(true);
}
}
public static bool updateNote(Note note)
{
using (var _context = new DbofSimpleNoteEntities())
{
_context.Notes.AddOrUpdate(note);
_context.SaveChanges();
return(true);
}
}
public static bool addTag(Tag tag)
{
using (var _context = new DbofSimpleNoteEntities())
{
_context.Tags.Add(tag);
_context.SaveChanges();
return(true);
}
}
public static int getIdFromDb()
{
using (var _context = new DbofSimpleNoteEntities())
{
var stt = (from getnote in _context.Notes
select getnote.SoThuTu).ToList();
if (stt.Count <= 0)
{
return(1);
}
return(stt.Max() + 1);
}
}
public static Tag getoneTag(string tentag)
{
using (var _context = new DbofSimpleNoteEntities())
{
var get = (from gettag in _context.Tags
where gettag.TenTag == tentag
select gettag).ToList();
if (get.Count == 1)
{
return(get[0]);
}
else
{
return(null);
}
}
}
public static List <Tag> getAllTag()
{
using (var _context = new DbofSimpleNoteEntities())
{
var get = (from gettag in _context.Tags.AsEnumerable()
select new
{
TenTag = gettag.TenTag,
Notes = gettag.Notes
})
.Select(x => new Tag
{
TenTag = x.TenTag,
Notes = x.Notes
}).ToList();
return(get);
}
}
public static bool deleteNote(Note note)
{
using (var _context = new DbofSimpleNoteEntities())
{
var get = (from getnote in _context.Notes
where getnote.SoThuTu == note.SoThuTu
select getnote).SingleOrDefault();
foreach (var gettag in get.Tags)
{
foreach (var temp in gettag.Notes)
{
if (temp.SoThuTu == note.SoThuTu)
{
gettag.Notes.Remove(temp);
break;
}
}
}
_context.Notes.Remove(get);
_context.SaveChanges();
return(true);
}
}
public static bool addNote(Note note)
{
try
{
using (var _context = new DbofSimpleNoteEntities())
{
foreach (var temp in note.Tags)
{
var get = (from gettag in _context.Tags
where gettag.TenTag == temp.TenTag
select gettag).Single();
get.Notes.Add(note);
}
note.Tags.Clear();
_context.Notes.Add(note);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
