public async Task <IActionResult> AddPayrollDeduction(PayrollDeduction item)
{
_context.PayrollDeductions.Add(item);
await _context.SaveChangesAsync();
return(RedirectToAction("PayrollDeductionsList", new { id = item.PayrollId }));
}
public async Task <ActionResult <PayrollDeduction> > Update([FromBody] PayrollDeduction _PayrollDeduction)
{
PayrollDeduction PayrollDeductionq = _PayrollDeduction;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
PayrollDeductionq = await(from c in _context.PayrollDeduction
.Where(q => q.PayrollDeductionId == _PayrollDeduction.PayrollDeductionId)
select c
).FirstOrDefaultAsync();
_context.Entry(PayrollDeductionq).CurrentValues.SetValues((_PayrollDeduction));
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = PayrollDeductionq.PayrollDeductionId,
DocType = "PayrollDeduction",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(PayrollDeductionq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Actualizar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = PayrollDeductionq.UsuarioCreacion,
UsuarioModificacion = PayrollDeductionq.UsuarioModificacion,
UsuarioEjecucion = PayrollDeductionq.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(PayrollDeductionq)));
}
public async Task <IActionResult> GetSeveridadRiesgoById(Int64 IdPayrollDeduction)
{
PayrollDeduction Items = new PayrollDeduction();
try
{
Items = await _context.PayrollDeduction.Where(q => q.PayrollDeductionId == IdPayrollDeduction).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
