public async Task <IActionResult> Edit(int id, [Bind("SubstratumId,SubstratumName")] Substratum substratum)
{
if (id != substratum.SubstratumId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(substratum);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubstratumExists(substratum.SubstratumId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(substratum));
}
public async Task <ActionResult <Substratum> > Update([FromBody] Substratum _Substratum)
{
Substratum _Substratumq = _Substratum;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_Substratumq = await(from c in _context.Substratum
.Where(q => q.SubstratumId == _Substratum.SubstratumId)
select c
).FirstOrDefaultAsync();
_context.Entry(_Substratumq).CurrentValues.SetValues((_Substratum));
//_context.Substratum.Update(_Substratumq);
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _Substratumq.SubstratumId,
DocType = "Substratum",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_Substratumq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Actualizar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _Substratumq.UsuarioCreacion,
UsuarioModificacion = _Substratumq.UsuarioModificacion,
UsuarioEjecucion = _Substratumq.UsuarioModificacion,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_Substratumq)));
}
public async Task <IActionResult> Create([Bind("SubstratumId,SubstratumName")] Substratum substratum)
{
if (ModelState.IsValid)
{
_context.Add(substratum);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(substratum));
}
public async Task <IActionResult> GetSubstratumBySubstratumCode(String SubstratumCode)
{
Substratum Items = new Substratum();
try
{
Items = await _context.Substratum.Where(q => q.SubstratumCode == SubstratumCode).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
