public async Task <IEnumerable <Nomina> > Nomina([FromRoute] int mes)
{
// Initialization.
List <Nomina> lst = new List <Nomina>();
try
{
// Settings.
SqlParameter usernameParam = new SqlParameter("@mes", mes);
// Processing.
string sqlQuery = "EXEC [dbo].[store_nominaMensual] @mes";
lst = await _context.Query <Nomina>().FromSql(sqlQuery, usernameParam).ToListAsync();
}
catch (Exception ex)
{
throw ex;
}
// Info.
return(lst);
}