public Note Add(Note note) { var entry = context.Add(note); context.SaveChanges(); return(entry.Entity); }
public void EditNote(int id, NoteWithCategories newNote) { var oldNote = _context.Notes.Where(n => n.NoteID == id && n.Timestamp == newNote.Timestamp).FirstOrDefault(); if (oldNote == null) { throw new Exception("The file does not exist or has been changed"); } // Find differences in standard fields and replace if needed if (oldNote.Title != newNote.Title || oldNote.Description != newNote.Description || oldNote.NoteDate != newNote.NoteDate || oldNote.IsMarkdown != newNote.IsMarkdown) { oldNote.Title = newNote.Title; oldNote.Description = newNote.Description; oldNote.NoteDate = newNote.NoteDate; oldNote.IsMarkdown = newNote.IsMarkdown; } // Find differences in categories var categoriesInDb = _context.NoteCategories .Where(nc => nc.Note == oldNote) .Include(nc => nc.Category); var newCategories = newNote.Categories .Except(categoriesInDb.Select(c => c.Category.Title)); foreach (var newCategory in newCategories) { var categoryInDb = _context.Categories .Where(c => c.Title == newCategory) .FirstOrDefault(); if (categoryInDb == null) { categoryInDb = new Category { Title = newCategory }; } _context.Add(new NoteCategory { Note = oldNote, Category = categoryInDb }); } var deletedCategories = categoriesInDb .Where(c => !newNote.Categories.Contains(c.Category.Title)); _context.RemoveRange(deletedCategories); _context.SaveChanges(); }
public Note CreateNote(Note createdNote) { var note = db.Add(createdNote); db.SaveChanges(); return(note.Entity); }
public async Task <IActionResult> Create([Bind("ID,Title,Body")] Note note) { if (ModelState.IsValid) { _context.Add(note); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(note)); }
public async Task <IActionResult> Create([Bind("ID,Name")] Category category) { if (ModelState.IsValid) { _context.Add(category); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(category)); }
public async Task <IActionResult> Create([Bind("Id,Owner,NoteTitle,NoteContent")] Notes notes) { if (ModelState.IsValid) { _context.Add(notes); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(notes)); }
public async Task <IActionResult> Create([Bind("ID,Email,Name,CreatedOn")] User user) { if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(user)); }
public async Task <IActionResult> Create([Bind("Id,Name,UrlSlug,Description")] Tag tag) { if (ModelState.IsValid) { _context.Add(tag); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tag)); }
public async Task <IActionResult> Create([Bind("ID,Title,Notes,CreatedOn,CategoryId,UserId,IsDeleted")] Note note) { if (ModelState.IsValid) { _context.Add(note); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CategoryId"] = new SelectList(_context.Categories, "ID", "ID", note.CategoryId); ViewData["UserId"] = new SelectList(_context.Users, "ID", "ID", note.UserId); return(View(note)); }
public bool Salvar(Notes notes) { if (notes.Id != null) { _notesContext.Update(notes); } else { _notesContext.Add(notes); } _notesContext.SaveChanges(); return(true); }
public bool Salvar(Users dados) { if (dados.Id > 0) { _notesContext.Update(dados); } else { _notesContext.Add(dados); } _notesContext.SaveChanges(); return(true); }
public IActionResult Create([Bind("ID,Title,Content,FinishDate,Finished,Importance")] Note note) { if (ModelState.IsValid) { if (note.Finished) { note.FinishedDate = DateTime.Now; } _context.Add(note); _context.SaveChanges(); return(RedirectToAction("Index")); } return(BadRequest()); }
public async Task <IActionResult> Create([Bind("Id,Name,Text,Date_system,UrlNote,TagID,CategoryID")] Note note) { if (ModelState.IsValid) { _context.Add(note); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CategoryID"] = new SelectList(_context.Category, "Id", "Name", note.CategoryID); ViewData["TagID"] = new SelectList(_context.Tag, "Id", "Name", note.TagID); return(View(note)); }