public IList <DTOMatriculasPorUF> ObterMatriculasPorUf(DateTime?dataInicio, DateTime?dataFim)
{
IDictionary <string, object> lstParam = new Dictionary <string, object>();
lstParam.Add("pDataInicio",
(!dataInicio.HasValue ? "01/01/" + DateTime.Now.Year : dataInicio.Value.ToString("MM/dd/yyyy")) +
" 00:00:00");
lstParam.Add("pDataFim",
(!dataFim.HasValue ? DateTime.Now.Date.ToString("MM/dd/yyyy") : dataFim.Value.ToString("MM/dd/yyyy")) +
" 23:59:59");
var bmMatriculaOferta = new BMMatriculaOferta();
return(bmMatriculaOferta.ExecutarProcedure <DTOMatriculasPorUF>("DASHBOARD_REL_GraficoMatriculadosUF",
lstParam));
}
public IList <DTOConcluintesEspacoOcupacional> ObterConcluintesExternos(DateTime inicio, DateTime fim, int idUf)
{
var lstParam = new Dictionary <string, object>
{
{ "DataInicio", inicio },
{ "DataFim", fim }
};
if (idUf != 0)
{
lstParam.Add("IdUf", idUf);
}
var bmMatriculaOferta = new BMMatriculaOferta();
return
(bmMatriculaOferta.ExecutarProcedure <DTOConcluintesEspacoOcupacional>(
"DASHBOARD_REL_CONCLUINTES_EXTERNOS", lstParam));
}
public IList <DTOMatriculasPorMes> ObterMatriculasPorMes(DateTime?dataInicio, DateTime?dataFim, int idUf)
{
IDictionary <string, object> lstParam = new Dictionary <string, object>();
lstParam.Add("pDataInicio",
(!dataInicio.HasValue ? "01/01/" + DateTime.Now.Year : dataInicio.Value.ToString("MM/dd/yyyy")) +
" 00:00:00");
lstParam.Add("pDataFim",
(!dataFim.HasValue ? DateTime.Now.Date.ToString("MM/dd/yyyy") : dataFim.Value.ToString("MM/dd/yyyy")) +
" 23:59:59");
if (idUf != 0)
{
lstParam.Add("IdUf", idUf);
}
var bmMatriculaOferta = new BMMatriculaOferta();
return(bmMatriculaOferta.ExecutarProcedure <DTOMatriculasPorMes>("DASHBOARD_REL_MatriculasPorMes", lstParam));
}
public IList <DTOProcInscricoesPorStatusENivel> ConsultarRelatorioInscricoesPorStatusENivel(string statuses,
string niveisOcupacionais, int?idUf, int?idSolucaoEducacional, DateTime?dataInicial, DateTime?dataFinal, IEnumerable <int> pUfResponsavel)
{
var parametros = new Dictionary <string, object>
{
{
"p_Statuses", statuses
},
{
"p_NiveisOcupacionais", niveisOcupacionais
},
{
"p_UF", idUf
},
{
"p_SolucaoEducacional", idSolucaoEducacional
},
{
"p_DataInicioMatricula", dataInicial
},
{
"p_DataFimMatricula", dataFinal
}
};
if (pUfResponsavel != null && pUfResponsavel.Any())
{
parametros.Add("P_UFResponsavel", string.Join(", ", pUfResponsavel));
}
else
{
parametros.Add("P_UFResponsavel", DBNull.Value);
}
var bmMatriculaOferta = new BMMatriculaOferta();
return
(bmMatriculaOferta.ExecutarProcedure <DTOProcInscricoesPorStatusENivel>(
"SP_REL_INSCRICOES_POR_STATUS_E_NIVEL", parametros));
}
public DTOMatriculas ObterMatriculasConcluintes(DateTime?inicio, DateTime?fim, int idUf)
{
inicio = inicio.HasValue ? inicio : DateTime.Now.AddYears(-1);
fim = fim.HasValue ? fim : DateTime.Now;
var listPrm = new Dictionary <string, object>
{
{ "DataInicio", inicio },
{ "DataFim", fim }
};
if (idUf != 0)
{
listPrm.Add("IdUf", idUf);
}
var bmMatriculaOferta = new BMMatriculaOferta();
return
(bmMatriculaOferta.ExecutarProcedure <DTOMatriculas>("DASHBOARD_REL_CONCLUINTES", listPrm)
.FirstOrDefault());
}