public static Note Get(int id) { Note result = null; using (MemoTestContext ctx = new MemoTestContext(GetConnectionString())) { result = (from note in ctx.Notes where note.Id == id select note).FirstOrDefault(); } return(result); }
public static Note Create(Note note) { note.CreationDate = DateTime.Now; note.EditionDate = DateTime.Now; using (MemoTestContext ctx = new MemoTestContext(GetConnectionString())) { ctx.Notes.Add(note); ctx.SaveChanges(); } return(note); }
public static List <Note> Retrieve(NoteRequest request) { List <Note> list = new List <Note>(); using (MemoTestContext ctx = new MemoTestContext(GetConnectionString())) { list.AddRange((from note in ctx.Notes where (string.IsNullOrEmpty(request.Name) || note.Name == request.Name) orderby note.IsMarked descending, note.CreationDate descending select note).ToList()); } return(list); }
public static Note Update(Note note) { using (MemoTestContext ctx = new MemoTestContext(GetConnectionString())) { var result = ctx.Notes.FirstOrDefault(n => n.Id == note.Id); if (result != null) { result.Name = note.Name; result.Data = note.Data; result.IsMarked = note.IsMarked; result.EditionDate = DateTime.Now; ctx.SaveChanges(); } return(result); } }
public static void Delete(int id) { using (MemoTestContext ctx = new MemoTestContext(GetConnectionString())) { Note note = new Note() { Id = id }; ctx.Notes.Attach(note); ctx.Notes.Remove(note); ctx.SaveChanges(); //var result = ctx.Notes.FirstOrDefault(n => n.Id == id); //if (result != null) //{ // ctx.Notes.Remove(result); // ctx.SaveChanges(); //} } }