public ENCIIUPrincipal ObtenerPrincipalUno(string CodigoGrupoCIUU)
{
DbCommand oCommand = null;
ENCIIUPrincipal oENCIIUPrincipal = new ENCIIUPrincipal();
try
{
oCommand = GenericDataAccess.CreateCommand(dataProviderName, connectionString, "usp_SCTR_Ubigeo_sel_uno");
GenericDataAccess.AgregarParametro(oCommand, "@argTipo", "1", TipoParametro.STR, Direccion.INPUT);
GenericDataAccess.AgregarParametro(oCommand, "@argCodGrupo", CodigoGrupoCIUU, TipoParametro.STR, Direccion.INPUT);
GenericDataAccess.AgregarParametro(oCommand, "@argCodCIIU", "", TipoParametro.STR, Direccion.INPUT);
GenericDataAccess.AgregarParametro(oCommand, "@argErrorCode", 1, TipoParametro.INT, Direccion.OUTPUT);
DbDataReader oDataReader = GenericDataAccess.ExecuteReader(oCommand);
while (oDataReader.Read())
{
oENCIIUPrincipal.CodigoCIIU = oDataReader["CodigoCIIU"].ToString();
oENCIIUPrincipal.DescripcionCIIU = oDataReader["DescripcionCIIU"].ToString();
}
return(oENCIIUPrincipal);
}
catch (Exception ex)
{
throw new Exception();
}
finally
{
GenericDataAccess.CerrarConexion(oCommand, null);
}
}
public List <ENCIIUPrincipal> ObtenerTodosPrincipal()
{
DbCommand oCommand = null /* TODO Change to default(_) if this is not a reference type */;
List <ENCIIUPrincipal> oLista = new List <ENCIIUPrincipal>();
try
{
oCommand = GenericDataAccess.CreateCommand(dataProviderName, connectionString, "usp_SCTR_CIIU_sel");
GenericDataAccess.AgregarParametro(oCommand, "@argTipo", "1", TipoParametro.STR, Direccion.INPUT);
GenericDataAccess.AgregarParametro(oCommand, "@argCodGrupo", "", TipoParametro.STR, Direccion.INPUT);
GenericDataAccess.AgregarParametro(oCommand, "@argErrorCode", 1, TipoParametro.INT, Direccion.OUTPUT);
DbDataReader oDataReader = GenericDataAccess.ExecuteReader(oCommand);
while (oDataReader.Read())
{
ENCIIUPrincipal oENLista = new ENCIIUPrincipal();
oENLista.CodigoCIIU = oDataReader["CodigoCIIU"].ToString();
oENLista.DescripcionCIIU = oDataReader["DescripcionCIIU"].ToString();
oLista.Add(oENLista);
}
return(oLista);
}
catch (Exception ex)
{
throw new Exception();
}
finally
{
GenericDataAccess.CerrarConexion(oCommand, null /* TODO Change to default(_) if this is not a reference type */);
}
}
