public static List <NotesModel> EditNote(int id, NotesModel Note, int Userid) { using (var dbContext = new FiszkiContext()) { var editedNote = dbContext.NotesTable.FirstOrDefault(x => x.id == id && x.userId == Userid); { editedNote.type = Note.type; editedNote.title = Note.title; editedNote.articleUrl = Note.articleUrl; editedNote.noteContent = Note.noteContent; editedNote.dateUser = Note.dateUser; editedNote.lastEdit = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); editedNote.rating = Note.rating; editedNote.isActive = 1; }; dbContext.SaveChanges(); var EditetItem = dbContext.NotesTable.Where(item => item.id == id).ToList(); return(EditetItem); } }
public static List <NotesModel> AddNote(NotesModel NewNote, int Userid) { using (var dbContext = new FiszkiContext()) { var newNote = new NotesModel { userId = Userid, type = NewNote.type, title = NewNote.title, articleUrl = NewNote.articleUrl, noteContent = NewNote.noteContent, dateUser = NewNote.dateUser, created = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), lastEdit = null, rating = NewNote.rating, isActive = 1, }; dbContext.NotesTable.Add(newNote); dbContext.SaveChanges(); int id = newNote.id; return(dbContext.NotesTable.Where(item => item.id == id).ToList()); } }