public void DeleteNote(Guid userId, int noteId)
{
using(var context = new NotepadDBEntities()) {
// find the note that matches the noteID and delete it from the DB
var note = context.Notes.Where(n => n.NoteId.Equals(noteId)).Single();
context.Notes.DeleteObject(note);
context.SaveChanges();
}
}
public void DeleteNote(Guid userId, int noteId)
{
using (var context = new NotepadDBEntities())
{
var note = context
.Notes
.Where(n => n.NoteId.Equals(noteId)).Single();
context.Notes.DeleteObject(note);
context.SaveChanges();
}
}
public Guid AddUser(Guid userId, string userName)
{
using (var context = new NotepadDBEntities()) {
context.AddToUsers(new User() {
UserId = userId,
Name = userName,
});
context.SaveChanges();
return userId;
}
}
public void UpdateNote(int noteId, string noteText)
{
using (var context = new NotepadDBEntities())
{
var note = context
.Notes
.Where(n => n.NoteId.Equals(noteId)
).Single();
note.NoteText = noteText;
context.SaveChanges();
}
}
public Guid AddUser(Guid userId, string userName)
{
using (var context = new NotepadDBEntities())
{
context.AddToUsers(new User()
{
UserId = userId,
Name = userName,
});
context.SaveChanges();
return(userId);
}
}
public NoteDto GetNote(Guid userId, int noteId)
{
using(var context = new NotepadDBEntities()) {
var notes = (
from eachNote in context.Notes where eachNote.NoteId == noteId &&
eachNote.UserId == userId
select new NoteDto {
NoteId = noteId,
Description = eachNote.Description,
NoteText = eachNote.NoteText,
}).SingleOrDefault();
return notes;
}
}
public List<NoteDto> GetNotes(Guid userId)
{
using (var context = new NotepadDBEntities()) {
var notes = (
from eachNote in context.Notes where eachNote.UserId == userId
orderby eachNote.Description ascending
select new NoteDto {
NoteId = eachNote.NoteId,
Description = eachNote.Description,
NoteText = eachNote.NoteText,
}).ToList();
return notes;
}
}
public NoteDto GetNote(Guid userId, int noteId)
{
using (var context = new NotepadDBEntities())
{
var notes = (
from eachNote in context.Notes
where eachNote.NoteId == noteId &&
eachNote.UserId == userId
select new NoteDto
{
NoteId = eachNote.NoteId,
Description = eachNote.Description,
NoteText = eachNote.NoteText,
}
).SingleOrDefault();
return(notes);
}
}
public List <NoteDto> GetNotes(Guid userId)
{
using (var context = new NotepadDBEntities())
{
var notes = (
from eachNote in context.Notes
where eachNote.UserId == userId
orderby eachNote.Description ascending
select new NoteDto
{
NoteId = eachNote.NoteId,
Description = eachNote.Description,
NoteText = eachNote.NoteText,
}
).ToList();
return(notes);
}
}
public NoteDto AddNote(Guid userId, string noteDescription, string noteText)
{
using (var context = new NotepadDBEntities()) {
Note note = new Note() {
Description = noteDescription,
UserId = userId,
NoteText = noteText,
};
context.AddToNotes(note);
context.SaveChanges();
return new NoteDto() {
NoteId = note.NoteId,
Description = note.Description,
NoteText = note.NoteText,
};
}
}
public NoteDto AddNote(Guid userId, string notedescription, string noteText)
{
using (var context = new NotepadDBEntities())
{
Note note = new Note()
{
Description = notedescription,
UserId = userId,
NoteText = noteText,
};
context.AddToNotes(note);
context.SaveChanges();
return(new NoteDto()
{
NoteId = note.NoteId,
Description = note.Description,
NoteText = note.NoteText,
});
}
}
public void UpdateNote(int noteId, string noteText)
{
using(var context = new NotepadDBEntities()) {
// find the note that matches the noteID and update its content
var note = context.Notes.Where(n => n.NoteId.Equals(noteId)).Single();
note.NoteText = noteText;
context.SaveChanges();
}
}