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