/// <summary> /// Loads the given UpsOrigin object from the given database data reader. /// </summary> /// <param name="upsOrigin">The UpsOrigin object to load.</param> /// <param name="dr">The database data reader to read data from.</param> public static void LoadDataReader(UpsOrigin upsOrigin, IDataReader dr) { //SET FIELDS FROM ROW DATA upsOrigin.CountryCode = dr.GetString(0); upsOrigin.CountryName = NullableData.GetString(dr, 1); upsOrigin.CurrencyName = NullableData.GetString(dr, 2); upsOrigin.CurrencyCode = NullableData.GetString(dr, 3); upsOrigin.EuroAllowed = NullableData.GetInt16(dr, 4); upsOrigin.MIVDollar = NullableData.GetDecimal(dr, 5); upsOrigin.MIVEuro = NullableData.GetDecimal(dr, 6); upsOrigin.UOM = NullableData.GetInt16(dr, 7); upsOrigin.MaxWeight = NullableData.GetDecimal(dr, 8); upsOrigin.MaxMetricWeight = NullableData.GetDecimal(dr, 9); upsOrigin.EUMember = NullableData.GetInt16(dr, 10); upsOrigin.IsDirty = false; }
/// <summary> /// Loads the given PageView object from the given database data reader. /// </summary> /// <param name="pageView">The PageView object to load.</param> /// <param name="dr">The database data reader to read data from.</param> public static void LoadDataReader(PageView pageView, IDataReader dr) { //SET FIELDS FROM ROW DATA pageView.PageViewId = dr.GetInt32(0); pageView.StoreId = dr.GetInt32(1); pageView.ActivityDate = LocaleHelper.ToLocalTime(dr.GetDateTime(2)); pageView.RemoteIP = dr.GetString(3); pageView.RequestMethod = dr.GetString(4); pageView.UserId = dr.GetInt32(5); pageView.UriStem = dr.GetString(6); pageView.UriQuery = NullableData.GetString(dr, 7); pageView.TimeTaken = dr.GetInt32(8); pageView.UserAgent = NullableData.GetString(dr, 9); pageView.Referrer = NullableData.GetString(dr, 10); pageView.CatalogNodeId = NullableData.GetInt32(dr, 11); pageView.CatalogNodeTypeId = NullableData.GetInt16(dr, 12); pageView.Browser = dr.GetString(13); pageView.BrowserName = dr.GetString(14); pageView.BrowserPlatform = dr.GetString(15); pageView.BrowserVersion = dr.GetString(16); pageView.AffiliateId = dr.GetInt32(17); pageView.IsDirty = false; }