public async Task <IActionResult> Update(TestTable model) { if (ModelState.IsValid) { //using (_context) <- this is dependency injection using (var context = new TestTableContext()) { TestTable user = new TestTable { Name = model.Name, Id = model.Id }; context.TestTable.Update(user); context.SaveChanges(); await context.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } } else { return(RedirectToAction("Error", "Home")); } }
public async Task <IActionResult> Add(TestTable model) { if (ModelState.IsValid) { //using (_context) <- this is dependency injection using (var context = new TestTableContext()) { TestTable user = new TestTable { Name = model.Name, Id = model.Id }; //Only use AddSync So if you use a value generator that might need to access the DB to get new values to assign to new entries, such as the SequenceHiLo generator, then use AddAsync(). context.TestTable.Add(user); await context.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } } else { return(RedirectToAction("Error", "Home")); } }
public async Task <ActionResult <TestTable> > PostTestTable([FromBody] TestTable item) { try { _context.TestTable.Add(item); await _context.SaveChangesAsync(); /* * return StatusCode(200); */ //return http 200 return(Ok()); } catch (Exception ex) { Console.WriteLine(ex); return(StatusCode(500)); } //return http 201 created //return CreatedAtAction(nameof(Get), new { id = item.Id, name=item.Name}, item); }