public void UpdateNote(UpdateNoteViewModel model) { if (ModelState.IsValid) { SqlCommand command = new SqlCommand( "UPDATE Note " + "SET Title = @title, Content = @content " + "WHERE ID= @id"); SqlParameter NID = new SqlParameter { ParameterName = "@id", Value = model.ID.GetDirectReference() }; SqlParameter TTL = new SqlParameter { ParameterName = "@title", Value = model.Title }; SqlParameter CTT = new SqlParameter { ParameterName = "@content", Value = model.Content }; command.Parameters.Add(NID); command.Parameters.Add(TTL); command.Parameters.Add(CTT); Debug.WriteLine(model.ID.GetDirectReference() + model.Title + model.Content); Utility.Constants.CallDB(command); } }
public IHttpActionResult UpdateNote([FromBody] UpdateNoteViewModel viewModel) { var note = this.noteRepository.GetByKey(viewModel.ID); if (note != null) { note = Mapper.Map(viewModel, note); } this.noteRepository.Update(note); this.RepositoryContext.Commit(); return(this.Ok()); }
public void UpdateNoteTest() { var updateViewModel = new UpdateNoteViewModel { Content = "updated", ID = guid2, Title = "updated title", Weather = "Foggy" }; var notesController = new NotesController(MockRepositoryContext.Object, mockNoteRepository.Object); notesController.UpdateNote(updateViewModel); Assert.AreEqual(updateViewModel.Content, notes[1].Content); Assert.AreEqual(guid2, notes[1].ID); Assert.AreEqual(updateViewModel.Title, notes[1].Title); Assert.AreEqual(Weather.Foggy, notes[1].Weather); }
public IActionResult Update(string id, [FromForm] UpdateNoteViewModel model) { if (!_noteService.CheckIfExists(id)) { return(View(Views.NotFound, id)); } if (!ModelState.IsValid) { return(View(model)); } var noteToUpdate = _mapper.Map <Note>(model); _noteService.Update(noteToUpdate); var idModel = new { id = model.Id }; return(RedirectToAction(NoteActions.GetNote, ControllerNames.Note, idModel)); }
public IActionResult Update(UpdateNoteViewModel note) { _noteService.Update(note); return(Ok()); }
public void Update(UpdateNoteViewModel noteModel) { var note = _mapper.Map <Note>(noteModel); _noteRepository.Update(note); }
public void UpdateNoteTest() { var updateViewModel = new UpdateNoteViewModel { Content = "updated", ID = guid2, Title = "updated title", Weather = "Foggy" }; var notesController = new NotesController(MockRepositoryContext.Object, mockNoteRepository.Object); notesController.UpdateNote(updateViewModel); Assert.AreEqual(updateViewModel.Content, notes[1].Content); Assert.AreEqual(guid2, notes[1].ID); Assert.AreEqual(updateViewModel.Title, notes[1].Title); Assert.AreEqual(Weather.Foggy, notes[1].Weather); }