private static UbigeoInfo CargarUbigeoPagInfo(IDataReader dr)
        {
            int colCount = dr.FieldCount;
            var values   = new object[colCount];

            #region Indices
            int indUbigeoId        = dr.GetOrdinal("UbigeoId");
            int indCodDepartamento = dr.GetOrdinal("CodDepartamento");
            int indDepartamento    = dr.GetOrdinal("Departamento");
            int indCodProvincia    = dr.GetOrdinal("CodProvincia");
            int indProvincia       = dr.GetOrdinal("Provincia");
            int indCodDistrito     = dr.GetOrdinal("CodDistrito");
            int indDistrito        = dr.GetOrdinal("Distrito");
            int indNumeroFila      = dr.GetOrdinal("NumeroFila");
            int indTotalFilas      = dr.GetOrdinal("TotalFilas");
            #endregion

            var ubigeoInfo = new UbigeoInfo();
            dr.GetValues(values);

            #region Campos
            ubigeoInfo.UbigeoId        = Convert.ToInt32(values[indUbigeoId]);
            ubigeoInfo.CodDepartamento = Convert.ToInt32(values[indCodDepartamento]);
            ubigeoInfo.Departamento    = Convert.ToString(values[indDepartamento]);
            ubigeoInfo.CodProvincia    = Convert.ToInt32(values[indCodProvincia]);
            ubigeoInfo.Provincia       = Convert.ToString(values[indProvincia]);
            ubigeoInfo.CodDistrito     = Convert.ToInt32(values[indCodDistrito]);
            ubigeoInfo.Distrito        = Convert.ToString(values[indDistrito]);
            ubigeoInfo.NumeroFila      = Convert.ToInt32(values[indNumeroFila]);
            ubigeoInfo.TotalFilas      = Convert.ToInt32(values[indTotalFilas]);
            #endregion

            return(ubigeoInfo);
        }
        private static UbigeoInfo CargarUbigeoInfo(IDataReader dr)
        {
            int colCount = dr.FieldCount;
            var values   = new object[colCount];

            #region Indices
            int indUbigeoId      = dr.GetOrdinal("UbigeoId");
            int indCodigo        = dr.GetOrdinal("Codigo");
            int indNombre        = dr.GetOrdinal("Nombre");
            int indUbigeoPadreId = dr.GetOrdinal("UbigeoPadreId");
            int indTipoUbigeoId  = dr.GetOrdinal("TipoUbigeoId");
            #endregion

            var ubigeoInfo = new UbigeoInfo();
            dr.GetValues(values);

            #region Campos
            ubigeoInfo.UbigeoId      = Convert.ToInt32(values[indUbigeoId]);
            ubigeoInfo.Codigo        = Convert.ToString(values[indCodigo]);
            ubigeoInfo.Nombre        = Convert.ToString(values[indNombre]);
            ubigeoInfo.UbigeoPadreId = Convert.ToInt16(values[indUbigeoPadreId]);
            ubigeoInfo.TipoUbigeoId  = Convert.ToInt16(values[indTipoUbigeoId]);
            #endregion

            return(ubigeoInfo);
        }
        private static UbigeoInfo CargarUbigeoProvInfo(IDataReader dr)
        {
            int colCount = dr.FieldCount;
            var values   = new object[colCount];

            #region Indices
            int indUbigeoId = dr.GetOrdinal("UbigeoId");
            int Provincia   = dr.GetOrdinal("Provincia");

            #endregion

            var ubigeoInfo = new UbigeoInfo();
            dr.GetValues(values);

            #region Campos
            ubigeoInfo.UbigeoId  = Convert.ToInt32(values[indUbigeoId]);
            ubigeoInfo.Provincia = Convert.ToString(values[Provincia]);

            #endregion

            return(ubigeoInfo);
        }