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();
}
