public void Create(User user)
{
using (var context = new NoteShareEntities())
{
user.CreatedOn = DateTime.Now;
context.Users.Add(user);
context.SaveChanges();
}
}
public void Create(Comment comment)
{
using (var context = new NoteShareEntities())
{
//comment.CreatedOn = DateTime.Now;
context.Comments.Add(comment);
context.SaveChanges();
}
}
public void Create(Note note)
{
using (var context = new NoteShareEntities())
{
note.CreatedOn = DateTime.Now;
note.User = context.Users.First();
context.Notes.Add(note);
context.SaveChanges();
}
}
public void Update(User user)
{
using (var context = new NoteShareEntities())
{
var existingUser = context.Users.SingleOrDefault(x => x.Id == user.Id);
if (existingUser != null)
{
existingUser.FullName = user.FullName;
existingUser.IsPremiumUser = user.IsPremiumUser;
context.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var context = new NoteShareEntities())
{
var note = context.Notes.SingleOrDefault(x => x.Id == id);
if (note != null)
{
context.Comments.RemoveRange(note.Comments);
context.Notes.Remove(note);
context.SaveChanges();
}
}
}
public void Update(Note note)
{
using (var context = new NoteShareEntities())
{
var existingNote = context.Notes.SingleOrDefault(x => x.Id == note.Id);
if (existingNote != null)
{
existingNote.Title = note.Title;
existingNote.Text = note.Text;
context.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var context = new NoteShareEntities())
{
var user = context.Users.SingleOrDefault(x => x.Id == id);
if (user != null)
{
context.Users.Remove(user);
context.SaveChanges();
}
}
}
