//mostrar monto total en bdd public IActionResult NominaTotal(ProcessNominas p) { p.Mes = DateTime.Today.Month; p.Age = DateTime.Now.Year; var nom = from m in _context.MantenimientoEmpleado where (m.Estatus == true) select m.Salario; p.MontoTotal = nom.Sum(); return(View(p)); }
//guarda el monto total de la nomina en la base de datos public async Task <IActionResult> GuardarRegistro(ProcessNominas p) { p.Mes = DateTime.Today.Month; p.Age = DateTime.Now.Year; var nom = from m in _context.MantenimientoEmpleado where (m.Estatus == true) select m.Salario; p.MontoTotal = nom.Sum(); _context.Add(p); await _context.SaveChangesAsync(); return(View(p)); }