/// <summary>
/// Loads the given OrderItem object from the given database data reader.
/// </summary>
/// <param name="orderItem">The OrderItem object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(OrderItem orderItem, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
orderItem.OrderItemId = dr.GetInt32(0);
orderItem.OrderId = dr.GetInt32(1);
orderItem.ParentItemId = NullableData.GetInt32(dr, 2);
orderItem.OrderItemTypeId = dr.GetInt16(3);
orderItem.ShippableId = dr.GetByte(4);
orderItem.OrderShipmentId = NullableData.GetInt32(dr, 5);
orderItem.ProductId = NullableData.GetInt32(dr, 6);
orderItem.Name = dr.GetString(7);
orderItem.OptionList = NullableData.GetString(dr, 8);
orderItem.VariantName = NullableData.GetString(dr, 9);
orderItem.Sku = NullableData.GetString(dr, 10);
orderItem.Price = dr.GetDecimal(11);
orderItem.Weight = dr.GetDecimal(12);
orderItem.CostOfGoods = dr.GetDecimal(13);
orderItem.Quantity = dr.GetInt16(14);
orderItem.LineMessage = NullableData.GetString(dr, 15);
orderItem.OrderBy = dr.GetInt16(16);
orderItem.GiftMessage = NullableData.GetString(dr, 17);
orderItem.TaxCodeId = NullableData.GetInt32(dr, 18);
orderItem.WrapStyleId = NullableData.GetInt32(dr, 19);
orderItem.WishlistItemId = NullableData.GetInt32(dr, 20);
orderItem.InventoryStatusId = dr.GetInt16(21);
orderItem.TaxRate = dr.GetDecimal(22);
orderItem.TaxAmount = dr.GetDecimal(23);
orderItem.KitList = NullableData.GetString(dr, 24);
orderItem.CustomFields.Parse(NullableData.GetString(dr, 25));
orderItem.IsDirty = false;
}
/// <summary>
/// Loads the given ProductVariant object from the given database data reader.
/// </summary>
/// <param name="productVariant">The ProductVariant object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(ProductVariant productVariant, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
productVariant.ProductVariantId = dr.GetInt32(0);
productVariant.ProductId = dr.GetInt32(1);
productVariant.Option1 = dr.GetInt32(2);
productVariant.Option2 = dr.GetInt32(3);
productVariant.Option3 = dr.GetInt32(4);
productVariant.Option4 = dr.GetInt32(5);
productVariant.Option5 = dr.GetInt32(6);
productVariant.Option6 = dr.GetInt32(7);
productVariant.Option7 = dr.GetInt32(8);
productVariant.Option8 = dr.GetInt32(9);
productVariant.VariantName = NullableData.GetString(dr, 10);
productVariant.Sku = NullableData.GetString(dr, 11);
productVariant.Price = NullableData.GetDecimal(dr, 12);
productVariant.PriceModeId = dr.GetByte(13);
productVariant.Weight = NullableData.GetDecimal(dr, 14);
productVariant.WeightModeId = dr.GetByte(15);
productVariant.CostOfGoods = NullableData.GetDecimal(dr, 16);
productVariant.InStock = dr.GetInt32(17);
productVariant.InStockWarningLevel = dr.GetInt32(18);
productVariant.Available = dr.GetBoolean(19);
productVariant.IsDirty = false;
}
/// <summary>
/// Loads the given OrderShipment object from the given database data reader.
/// </summary>
/// <param name="orderShipment">The OrderShipment object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(OrderShipment orderShipment, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
orderShipment.OrderShipmentId = dr.GetInt32(0);
orderShipment.OrderId = dr.GetInt32(1);
orderShipment.WarehouseId = NullableData.GetInt32(dr, 2);
orderShipment.ShipToFirstName = NullableData.GetString(dr, 3);
orderShipment.ShipToLastName = NullableData.GetString(dr, 4);
orderShipment.ShipToCompany = NullableData.GetString(dr, 5);
orderShipment.ShipToAddress1 = NullableData.GetString(dr, 6);
orderShipment.ShipToAddress2 = NullableData.GetString(dr, 7);
orderShipment.ShipToCity = NullableData.GetString(dr, 8);
orderShipment.ShipToProvince = NullableData.GetString(dr, 9);
orderShipment.ShipToPostalCode = NullableData.GetString(dr, 10);
orderShipment.ShipToCountryCode = NullableData.GetString(dr, 11);
orderShipment.ShipToPhone = NullableData.GetString(dr, 12);
orderShipment.ShipToFax = NullableData.GetString(dr, 13);
orderShipment.ShipToEmail = NullableData.GetString(dr, 14);
orderShipment.ShipToResidence = NullableData.GetBoolean(dr, 15);
orderShipment.ShipMethodId = NullableData.GetInt32(dr, 16);
orderShipment.ShipMethodName = NullableData.GetString(dr, 17);
orderShipment.ShipMessage = NullableData.GetString(dr, 18);
orderShipment.ShipDate = LocaleHelper.ToLocalTime(NullableData.GetDateTime(dr, 19));
orderShipment.IsDirty = false;
}
/// <summary>
/// Loads the given BasketItem object from the given database data reader.
/// </summary>
/// <param name="basketItem">The BasketItem object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(BasketItem basketItem, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
basketItem.BasketItemId = dr.GetInt32(0);
basketItem.ParentItemId = dr.GetInt32(1);
basketItem.BasketId = dr.GetInt32(2);
basketItem.BasketShipmentId = NullableData.GetInt32(dr, 3);
basketItem.ProductId = dr.GetInt32(4);
basketItem.OptionList = NullableData.GetString(dr, 5);
basketItem.TaxCodeId = NullableData.GetInt32(dr, 6);
basketItem.Name = dr.GetString(7);
basketItem.Sku = NullableData.GetString(dr, 8);
basketItem.Price = dr.GetDecimal(9);
basketItem.Weight = dr.GetDecimal(10);
basketItem.Quantity = dr.GetInt16(11);
basketItem.LineMessage = NullableData.GetString(dr, 12);
basketItem.OrderItemTypeId = dr.GetInt16(13);
basketItem.OrderBy = dr.GetInt16(14);
basketItem.WrapStyleId = NullableData.GetInt32(dr, 15);
basketItem.GiftMessage = NullableData.GetString(dr, 16);
basketItem.WishlistItemId = NullableData.GetInt32(dr, 17);
basketItem.ShippableId = dr.GetByte(18);
basketItem.LastModifiedDate = LocaleHelper.ToLocalTime(dr.GetDateTime(19));
basketItem.TaxRate = dr.GetDecimal(20);
basketItem.TaxAmount = dr.GetDecimal(21);
basketItem.KitList = NullableData.GetString(dr, 22);
basketItem.CustomFields.Parse(NullableData.GetString(dr, 23));
basketItem.IsDirty = false;
}
internal void DeserializeData(BinaryReader reader, ComponentDataPool componentDataPool)
{
StringData stringDataInstance = componentDataPool.GetStringDataInstance();
stringDataInstance.DeserializeData(reader, componentDataPool);
if (string.IsNullOrEmpty(stringDataInstance.Data))
{
throw new CorruptSyncStateException(new LocalizedString("[MeetingOrganizerEntry.DeserializeData] deserialized Uid was null or empty."), null);
}
this.CleanGlobalObjectId = new GlobalObjectId(stringDataInstance.Data);
DateTimeData dateTimeDataInstance = componentDataPool.GetDateTimeDataInstance();
dateTimeDataInstance.DeserializeData(reader, componentDataPool);
this.EntryTime = (DateTime)dateTimeDataInstance.Data;
StringData stringDataInstance2 = componentDataPool.GetStringDataInstance();
stringDataInstance2.DeserializeData(reader, componentDataPool);
this.Organizer = stringDataInstance2.Data;
NullableData <BooleanData, bool> nullableData = new NullableData <BooleanData, bool>();
nullableData.DeserializeData(reader, componentDataPool);
this.IsOrganizer = nullableData.Data;
StringData stringDataInstance3 = componentDataPool.GetStringDataInstance();
stringDataInstance3.DeserializeData(reader, componentDataPool);
this.Subject = stringDataInstance3.Data;
}
/// <summary>
/// Loads the given Affiliate object from the given database data reader.
/// </summary>
/// <param name="affiliate">The Affiliate object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Affiliate affiliate, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
affiliate.AffiliateId = dr.GetInt32(0);
affiliate.StoreId = dr.GetInt32(1);
affiliate.Name = dr.GetString(2);
affiliate.PayeeName = NullableData.GetString(dr, 3);
affiliate.FirstName = NullableData.GetString(dr, 4);
affiliate.LastName = NullableData.GetString(dr, 5);
affiliate.Company = NullableData.GetString(dr, 6);
affiliate.Address1 = NullableData.GetString(dr, 7);
affiliate.Address2 = NullableData.GetString(dr, 8);
affiliate.City = NullableData.GetString(dr, 9);
affiliate.Province = NullableData.GetString(dr, 10);
affiliate.PostalCode = NullableData.GetString(dr, 11);
affiliate.CountryCode = NullableData.GetString(dr, 12);
affiliate.PhoneNumber = NullableData.GetString(dr, 13);
affiliate.FaxNumber = NullableData.GetString(dr, 14);
affiliate.MobileNumber = NullableData.GetString(dr, 15);
affiliate.WebsiteUrl = NullableData.GetString(dr, 16);
affiliate.Email = NullableData.GetString(dr, 17);
affiliate.CommissionRate = dr.GetDecimal(18);
affiliate.CommissionIsPercent = dr.GetBoolean(19);
affiliate.CommissionOnTotal = dr.GetBoolean(20);
affiliate.ReferralPeriodId = dr.GetByte(21);
affiliate.ReferralDays = dr.GetInt16(22);
affiliate.GroupId = NullableData.GetInt32(dr, 23);
affiliate.IsDirty = false;
}
/// <summary>
/// Loads the given Basket object from the given database data reader.
/// </summary>
/// <param name="basket">The Basket object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Basket basket, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
basket.BasketId = dr.GetInt32(0);
basket.UserId = dr.GetInt32(1);
basket.ContentHash = NullableData.GetString(dr, 2);
basket.IsDirty = false;
}
/// <summary>
/// Loads the given UserGroup object from the given database data reader.
/// </summary>
/// <param name="userGroup">The UserGroup object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(UserGroup userGroup, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
userGroup.UserId = dr.GetInt32(0);
userGroup.GroupId = dr.GetInt32(1);
userGroup.SubscriptionId = NullableData.GetInt32(dr, 2);
userGroup.IsDirty = false;
}
/// <summary>
/// Loads the given Vendor object from the given database data reader.
/// </summary>
/// <param name="vendor">The Vendor object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Vendor vendor, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
vendor.VendorId = dr.GetInt32(0);
vendor.StoreId = dr.GetInt32(1);
vendor.Name = dr.GetString(2);
vendor.Email = NullableData.GetString(dr, 3);
vendor.IsDirty = false;
}
/// <summary>
/// Loads the given CategoryParent object from the given database data reader.
/// </summary>
/// <param name="categoryParent">The CategoryParent object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(CategoryParent categoryParent, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
categoryParent.CategoryId = dr.GetInt32(0);
categoryParent.ParentId = dr.GetInt32(1);
categoryParent.ParentLevel = NullableData.GetByte(dr, 2);
categoryParent.ParentNumber = NullableData.GetByte(dr, 3);
categoryParent.IsDirty = false;
}
/// <summary>
/// Loads the given Province object from the given database data reader.
/// </summary>
/// <param name="province">The Province object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Province province, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
province.ProvinceId = dr.GetInt32(0);
province.CountryCode = dr.GetString(1);
province.Name = dr.GetString(2);
province.ProvinceCode = NullableData.GetString(dr, 3);
province.IsDirty = false;
}
/// <summary>
/// Loads the given TrackingNumber object from the given database data reader.
/// </summary>
/// <param name="trackingNumber">The TrackingNumber object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(TrackingNumber trackingNumber, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
trackingNumber.TrackingNumberId = dr.GetInt32(0);
trackingNumber.OrderShipmentId = dr.GetInt32(1);
trackingNumber.ShipGatewayId = NullableData.GetInt32(dr, 2);
trackingNumber.TrackingNumberData = dr.GetString(3);
trackingNumber.IsDirty = false;
}
/// <summary>
/// Loads the given Wishlist object from the given database data reader.
/// </summary>
/// <param name="wishlist">The Wishlist object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Wishlist wishlist, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
wishlist.WishlistId = dr.GetInt32(0);
wishlist.UserId = dr.GetInt32(1);
wishlist.Name = NullableData.GetString(dr, 2);
wishlist.ViewPassword = NullableData.GetString(dr, 3);
wishlist.IsDirty = false;
}
/// <summary>
/// Loads the given Country object from the given database data reader.
/// </summary>
/// <param name="country">The Country object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Country country, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
country.CountryCode = dr.GetString(0);
country.StoreId = dr.GetInt32(1);
country.Name = dr.GetString(2);
country.AddressFormat = NullableData.GetString(dr, 3);
country.IsDirty = false;
}
/// <summary>
/// Gets cms path for the given node. Only supported for Category type catalog node objects
/// </summary>
/// <param name="categoryId">Id of the category</param>
/// <param name="currentNodeId">Id of the node</param>
/// <param name="currentNodeType">Type of node</param>
/// <returns>List of cms path nodes</returns>
public static List <CmsPathNode> GetCmsPath(int categoryId, int currentNodeId, CatalogNodeType currentNodeType)
{
List <CmsPathNode> path = new List <CmsPathNode>();
Database database = Token.Instance.Database;
StringBuilder selectQuery = new StringBuilder();
switch (currentNodeType)
{
case CatalogNodeType.Category:
selectQuery.Append("SELECT CP.ParentId AS NodeId, 0 As NodeType, C.Name, C.Summary, CP.ParentLevel, CP.ParentNumber");
selectQuery.Append(" FROM ac_CategoryParents AS CP INNER JOIN");
selectQuery.Append(" ac_Categories C ON CP.ParentId = C.CategoryId");
selectQuery.Append(" WHERE CP.CategoryId = @currentNodeId");
selectQuery.Append(" ORDER BY CP.ParentLevel");
break;
default:
throw new Exception("Not supported.");
}
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@currentNodeId", DbType.Int32, currentNodeId);
//EXECUTE THE COMMAND
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
int nodeId;
CatalogNodeType nodeType;
String url;
String title;
String description;
while (dr.Read())
{
nodeId = dr.GetInt32(0);
nodeType = (CatalogNodeType)dr.GetInt32(1);
switch (nodeType)
{
case CatalogNodeType.Category:
url = "~/Admin/Catalog/Browse.aspx?CategoryId=" + nodeId.ToString();
break;
default:
url = string.Empty;
break;
}
title = dr.GetString(2);
description = NullableData.GetString(dr, 3);
path.Add(new CmsPathNode(nodeId, nodeType, url, title, description));
}
dr.Close();
}
if (path.Count == 0)
{
return(null);
}
return(path);
}
/// <summary>
/// Loads the given Special object from the given database data reader.
/// </summary>
/// <param name="special">The Special object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Special special, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
special.SpecialId = dr.GetInt32(0);
special.ProductId = dr.GetInt32(1);
special.Price = dr.GetDecimal(2);
special.StartDate = LocaleHelper.ToLocalTime(NullableData.GetDateTime(dr, 3));
special.EndDate = LocaleHelper.ToLocalTime(NullableData.GetDateTime(dr, 4));
special.IsDirty = false;
}
/// <summary>
/// Loads the given IPLocation object from the given database data reader.
/// </summary>
/// <param name="iPLocation">The IPLocation object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(IPLocation iPLocation, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
iPLocation.IPRangeStart = dr.GetInt64(0);
iPLocation.IPRangeEnd = dr.GetInt64(1);
iPLocation.CountryCode = dr.GetString(2);
iPLocation.Region = NullableData.GetString(dr, 3);
iPLocation.City = NullableData.GetString(dr, 4);
iPLocation.IsDirty = false;
}
/// <summary>
/// Loads the given Profile object from the given database data reader.
/// </summary>
/// <param name="profile">The Profile object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Profile profile, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
profile.UserId = dr.GetInt32(0);
profile.PropertyNames = dr.GetString(1);
profile.PropertyValuesString = dr.GetString(2);
profile.PropertyValuesBinary = NullableData.GetBytes(dr, 3);
profile.LastUpdatedDate = LocaleHelper.ToLocalTime(NullableData.GetDateTime(dr, 4));
profile.IsDirty = false;
}
/// <summary>
/// Loads the given BannedIP object from the given database data reader.
/// </summary>
/// <param name="bannedIP">The BannedIP object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(BannedIP bannedIP, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
bannedIP.BannedIPId = dr.GetInt32(0);
bannedIP.StoreId = dr.GetInt32(1);
bannedIP.IPRangeStart = dr.GetInt64(2);
bannedIP.IPRangeEnd = dr.GetInt64(3);
bannedIP.Comment = NullableData.GetString(dr, 4);
bannedIP.IsDirty = false;
}
/// <summary>
/// Loads the given ProductImage object from the given database data reader.
/// </summary>
/// <param name="productImage">The ProductImage object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(ProductImage productImage, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
productImage.ProductImageId = dr.GetInt32(0);
productImage.ProductId = dr.GetInt32(1);
productImage.ImageUrl = dr.GetString(2);
productImage.ImageAltText = NullableData.GetString(dr, 3);
productImage.OrderBy = dr.GetInt16(4);
productImage.IsDirty = false;
}
/// <summary>
/// Loads the given ShipRateMatrix object from the given database data reader.
/// </summary>
/// <param name="shipRateMatrix">The ShipRateMatrix object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(ShipRateMatrix shipRateMatrix, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
shipRateMatrix.ShipRateMatrixId = dr.GetInt32(0);
shipRateMatrix.ShipMethodId = dr.GetInt32(1);
shipRateMatrix.RangeStart = NullableData.GetDecimal(dr, 2);
shipRateMatrix.RangeEnd = NullableData.GetDecimal(dr, 3);
shipRateMatrix.Rate = dr.GetDecimal(4);
shipRateMatrix.IsPercent = dr.GetBoolean(5);
shipRateMatrix.IsDirty = false;
}
/// <summary>
/// Loads the given PaymentGateway object from the given database data reader.
/// </summary>
/// <param name="paymentGateway">The PaymentGateway object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(PaymentGateway paymentGateway, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
paymentGateway.PaymentGatewayId = dr.GetInt32(0);
paymentGateway.StoreId = dr.GetInt32(1);
paymentGateway.Name = dr.GetString(2);
paymentGateway.ClassId = dr.GetString(3);
paymentGateway.ConfigData = NullableData.GetString(dr, 4);
paymentGateway.ReCrypt = dr.GetBoolean(5);
paymentGateway.IsDirty = false;
}
/// <summary>
/// Loads the given PaymentMethod object from the given database data reader.
/// </summary>
/// <param name="paymentMethod">The PaymentMethod object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(PaymentMethod paymentMethod, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
paymentMethod.PaymentMethodId = dr.GetInt32(0);
paymentMethod.StoreId = dr.GetInt32(1);
paymentMethod.Name = dr.GetString(2);
paymentMethod.PaymentInstrumentId = dr.GetInt16(3);
paymentMethod.PaymentGatewayId = NullableData.GetInt32(dr, 4);
paymentMethod.OrderBy = dr.GetInt16(5);
paymentMethod.IsDirty = false;
}
/// <summary>
/// Loads the given ReviewerProfile object from the given database data reader.
/// </summary>
/// <param name="reviewerProfile">The ReviewerProfile object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(ReviewerProfile reviewerProfile, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
reviewerProfile.ReviewerProfileId = dr.GetInt32(0);
reviewerProfile.Email = dr.GetString(1);
reviewerProfile.DisplayName = dr.GetString(2);
reviewerProfile.Location = NullableData.GetString(dr, 3);
reviewerProfile.EmailVerified = dr.GetBoolean(4);
reviewerProfile.EmailVerificationCode = NullableData.GetGuid(dr, 5);
reviewerProfile.IsDirty = false;
}
/// <summary>
/// Loads the given UserPersonalization object from the given database data reader.
/// </summary>
/// <param name="userPersonalization">The UserPersonalization object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(UserPersonalization userPersonalization, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
userPersonalization.PersonalizationPathId = dr.GetInt32(0);
userPersonalization.UserId = dr.GetInt32(1);
userPersonalization.PageSettings = NullableData.GetBytes(dr, 2);
userPersonalization.Theme = NullableData.GetString(dr, 3);
userPersonalization.MasterPageFile = NullableData.GetString(dr, 4);
userPersonalization.LastUpdatedDate = LocaleHelper.ToLocalTime(dr.GetDateTime(5));
userPersonalization.IsDirty = false;
}
/// <summary>
/// Loads the given ErrorMessage object from the given database data reader.
/// </summary>
/// <param name="errorMessage">The ErrorMessage object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(ErrorMessage errorMessage, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
errorMessage.ErrorMessageId = dr.GetInt32(0);
errorMessage.EntryDate = LocaleHelper.ToLocalTime(dr.GetDateTime(1));
errorMessage.StoreId = dr.GetInt32(2);
errorMessage.MessageSeverityId = dr.GetByte(3);
errorMessage.Text = dr.GetString(4);
errorMessage.DebugData = NullableData.GetString(dr, 5);
errorMessage.IsDirty = false;
}
/// <summary>
/// Loads the given OrderNote object from the given database data reader.
/// </summary>
/// <param name="orderNote">The OrderNote object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(OrderNote orderNote, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
orderNote.OrderNoteId = dr.GetInt32(0);
orderNote.OrderId = dr.GetInt32(1);
orderNote.UserId = NullableData.GetInt32(dr, 2);
orderNote.CreatedDate = LocaleHelper.ToLocalTime(dr.GetDateTime(3));
orderNote.Comment = dr.GetString(4);
orderNote.NoteTypeId = dr.GetByte(5);
orderNote.IsDirty = false;
}
/// <summary>
/// Loads the given Group object from the given database data reader.
/// </summary>
/// <param name="group">The Group object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(Group group, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
group.GroupId = dr.GetInt32(0);
group.StoreId = dr.GetInt32(1);
group.Name = dr.GetString(2);
group.Description = NullableData.GetString(dr, 3);
group.IsTaxExempt = dr.GetBoolean(4);
group.IsReadOnly = dr.GetBoolean(5);
group.IsDirty = false;
}
/// <summary>
/// Loads the given UserPassword object from the given database data reader.
/// </summary>
/// <param name="userPassword">The UserPassword object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(UserPassword userPassword, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
userPassword.UserId = dr.GetInt32(0);
userPassword.PasswordNumber = dr.GetByte(1);
userPassword.Password = dr.GetString(2);
userPassword.PasswordFormat = NullableData.GetString(dr, 3);
userPassword.CreateDate = LocaleHelper.ToLocalTime(dr.GetDateTime(4));
userPassword.ForceExpiration = dr.GetBoolean(5);
userPassword.IsDirty = false;
}
/// <summary>
/// Loads the given ProductCustomField object from the given database data reader.
/// </summary>
/// <param name="productCustomField">The ProductCustomField object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(ProductCustomField productCustomField, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
productCustomField.ProductFieldId = dr.GetInt32(0);
productCustomField.ProductId = dr.GetInt32(1);
productCustomField.IsUserDefined = dr.GetBoolean(2);
productCustomField.IsVisible = dr.GetBoolean(3);
productCustomField.FieldName = dr.GetString(4);
productCustomField.FieldValue = NullableData.GetString(dr, 5);
productCustomField.IsDirty = false;
}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}
){kind=link}