public IActionResult Edit(int id, [Bind("id,category,value")] mp_lookup mp_lookup) { if (id != mp_lookup.id) { return(NotFound()); } if (ModelState.IsValid) { try { _lookUpService.UpdateLookUp(mp_lookup); } catch (DbUpdateConcurrencyException) { if (!_lookUpService.LookUpExists(mp_lookup.id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(mp_lookup)); }
public async Task <IActionResult> Create([Bind("category,value")] mp_lookup mp_lookup) { if (ModelState.IsValid) { mp_lookup.deleted = 0; await _lookUpService.AddLookUp(mp_lookup); return(RedirectToAction(nameof(Index))); } return(View(mp_lookup)); }
public int UpdateLookUp(mp_lookup lookup) { var existing = _context.mp_lookup.FirstOrDefault(m => m.id == lookup.id); if (existing != null) { //do update lookup.deleted = 0; _context.Entry(existing).CurrentValues.SetValues(lookup); return _context.SaveChanges(); } return 0; }
public IActionResult Post([FromBody] string value, string category) { var lookup = new mp_lookup { category = category, value = value }; lookup = Options.AddLookup(lookup); return(Ok(lookup.id)); }
public static mp_lookup AddLookup(mp_lookup lookup) { //get the maximum lookup var count = _context.mp_lookup.Count(); lookup.id = count + 1; lookup.deleted = 0; _context.mp_lookup.Add(lookup); _context.SaveChanges(); return(lookup); }
public async Task<int> AddLookUp(mp_lookup lookup) { _context.Add(lookup); return await _context.SaveChangesAsync(); }