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