public void DeleteNote(int NoteId)
{
var db = new DataAccess.Model1();
var result = db.Notes.Where(n => n.NoteId == NoteId).SingleOrDefault();
if (result != null)
{
db.Notes.Remove(result);
}
db.SaveChanges();
}
public List <Models.NoteViewModel> GetAllNotes()
{
var db = new DataAccess.Model1();
var result = db.Notes.Select(n => new NoteViewModel()
{
NoteId = n.NoteId,
Contents = n.Contents,
DateCreated = n.DateCreated,
DateModified = n.DateModified,
Title = n.Title
}).ToList();
return(result);
}
public bool UpdateNote(NoteViewModel item)
{
var db = new DataAccess.Model1();
var theNote = db.Notes.Where(n => n.NoteId == item.NoteId).SingleOrDefault();
theNote.Contents = item.Contents;
theNote.DateCreated = DateTime.Now;
theNote.DateModified = DateTime.Now; // Datetiem2 ERROR ******
theNote.Title = item.Title;
if (db.SaveChanges() == 1)
{
return(true);
}
return(false);
}
public bool AddNote(NoteViewModel item)
{
var db = new DataAccess.Model1();
var note = new Notes();
note.NoteId = item.NoteId;
note.Contents = item.Contents;
note.Title = item.Title;
note.DateCreated = DateTime.Now; //item.DateCreated; // DateTime / DateTime2 ERROR ***********************
note.DateModified = DateTime.Now; // item.DateModified;
note.ApplicationUserId = "";
db.Notes.Add(note);
if (db.SaveChanges() == 1)
{
return(true);
}
return(false);
}
