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