public ConsultarTrackingContratoPorContratoIdBE ConsultarTrackingContratoPorContratoId(ConsultaTrackingContratoPorContratoIdRequestDTO request)
{
ConsultarTrackingContratoPorContratoIdBE consultarTrackingContratoPorContratoIdBE = _IContratoRepository.ConsultarTrackingContratoPorContratoId(request.ContratoId, request.Idioma);
consultarTrackingContratoPorContratoIdBE.Cargamentos = _IContratoRepository.ConsultarTrackingContratoCargamentoPorContratoId(request.ContratoId, request.Idioma).ToList();
consultarTrackingContratoPorContratoIdBE.Certificaciones = _IContratoRepository.ConsultarTrackingContratoCertificacionPorContratoId(request.ContratoId, request.Idioma).ToList();
return(consultarTrackingContratoPorContratoIdBE);
}
public ConsultarTrackingContratoPorContratoIdBE ConsultarTrackingContratoPorContratoId(int contratoId, string idioma)
{
ConsultarTrackingContratoPorContratoIdBE itemBE = null;
var parameters = new DynamicParameters();
parameters.Add("@ContratoId", contratoId);
parameters.Add("@Idioma", idioma);
using (IDbConnection db = new SqlConnection(_connectionString.Value.CoffeeConnectDB))
{
var list = db.Query <ConsultarTrackingContratoPorContratoIdBE>("uspTrackingContratoConsultarPorId", parameters, commandType: CommandType.StoredProcedure);
if (list.Any())
{
itemBE = list.First();
}
}
return(itemBE);
}
