private DBACL GetAclFromReader(IDataReader dataReader)
{
var item = new DBACL();
item.AclId = NopSqlDataHelper.GetInt(dataReader, "ACLID");
item.CustomerActionId = NopSqlDataHelper.GetInt(dataReader, "CustomerActionID");
item.CustomerRoleId = NopSqlDataHelper.GetInt(dataReader, "CustomerRoleID");
item.Allow = NopSqlDataHelper.GetBoolean(dataReader, "Allow");
return(item);
}
private DBPicture GetPictureFromReader(IDataReader dataReader)
{
DBPicture picture = new DBPicture();
picture.PictureID = NopSqlDataHelper.GetInt(dataReader, "PictureID");
picture.PictureBinary = NopSqlDataHelper.GetBytes(dataReader, "PictureBinary");
picture.Extension = NopSqlDataHelper.GetString(dataReader, "Extension");
picture.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew");
return(picture);
}
private DBPicture GetPictureFromReader(IDataReader dataReader)
{
var item = new DBPicture();
item.PictureId = NopSqlDataHelper.GetInt(dataReader, "PictureID");
item.PictureBinary = NopSqlDataHelper.GetBytes(dataReader, "PictureBinary");
item.Extension = NopSqlDataHelper.GetString(dataReader, "Extension");
item.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew");
return(item);
}
private DBActivityLogType GetActivityLogTypeFromReader(IDataReader dataReader)
{
var item = new DBActivityLogType();
item.ActivityLogTypeId = NopSqlDataHelper.GetInt(dataReader, "ActivityLogTypeID");
item.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.Enabled = NopSqlDataHelper.GetBoolean(dataReader, "Enabled");
return(item);
}
private DBProductManufacturer GetProductManufacturerFromReader(IDataReader dataReader)
{
DBProductManufacturer productManufacturer = new DBProductManufacturer();
productManufacturer.ProductManufacturerID = NopSqlDataHelper.GetInt(dataReader, "ProductManufacturerID");
productManufacturer.ProductID = NopSqlDataHelper.GetInt(dataReader, "ProductID");
productManufacturer.ManufacturerID = NopSqlDataHelper.GetInt(dataReader, "ManufacturerID");
productManufacturer.IsFeaturedProduct = NopSqlDataHelper.GetBoolean(dataReader, "IsFeaturedProduct");
productManufacturer.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(productManufacturer);
}
private DBProductCategory GetProductCategoryFromReader(IDataReader dataReader)
{
DBProductCategory productCategory = new DBProductCategory();
productCategory.ProductCategoryID = NopSqlDataHelper.GetInt(dataReader, "ProductCategoryID");
productCategory.ProductID = NopSqlDataHelper.GetInt(dataReader, "ProductID");
productCategory.CategoryID = NopSqlDataHelper.GetInt(dataReader, "CategoryID");
productCategory.IsFeaturedProduct = NopSqlDataHelper.GetBoolean(dataReader, "IsFeaturedProduct");
productCategory.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(productCategory);
}
private DBProductVariantAttributeCombination GetProductVariantAttributeCombinationFromReader(IDataReader dataReader)
{
var item = new DBProductVariantAttributeCombination();
item.ProductVariantAttributeCombinationId = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeCombinationID");
item.ProductVariantId = NopSqlDataHelper.GetInt(dataReader, "ProductVariantID");
item.AttributesXml = NopSqlDataHelper.GetString(dataReader, "AttributesXML");
item.StockQuantity = NopSqlDataHelper.GetInt(dataReader, "StockQuantity");
item.AllowOutOfStockOrders = NopSqlDataHelper.GetBoolean(dataReader, "AllowOutOfStockOrders");
return(item);
}
private DBCreditCardType GetCreditCardTypeFromReader(IDataReader dataReader)
{
DBCreditCardType creditCardType = new DBCreditCardType();
creditCardType.CreditCardTypeID = NopSqlDataHelper.GetInt(dataReader, "CreditCardTypeID");
creditCardType.Name = NopSqlDataHelper.GetString(dataReader, "Name");
creditCardType.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
creditCardType.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
creditCardType.Deleted = NopSqlDataHelper.GetBoolean(dataReader, "Deleted");
return(creditCardType);
}
private DBLanguage GetLanguageFromReader(IDataReader dataReader)
{
DBLanguage language = new DBLanguage();
language.LanguageID = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
language.Name = NopSqlDataHelper.GetString(dataReader, "Name");
language.LanguageCulture = NopSqlDataHelper.GetString(dataReader, "LanguageCulture");
language.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published");
language.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(language);
}
private DBProductManufacturer GetProductManufacturerFromReader(IDataReader dataReader)
{
var item = new DBProductManufacturer();
item.ProductManufacturerId = NopSqlDataHelper.GetInt(dataReader, "ProductManufacturerID");
item.ProductId = NopSqlDataHelper.GetInt(dataReader, "ProductID");
item.ManufacturerId = NopSqlDataHelper.GetInt(dataReader, "ManufacturerID");
item.IsFeaturedProduct = NopSqlDataHelper.GetBoolean(dataReader, "IsFeaturedProduct");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
private DBProductCategory GetProductCategoryFromReader(IDataReader dataReader)
{
var item = new DBProductCategory();
item.ProductCategoryId = NopSqlDataHelper.GetInt(dataReader, "ProductCategoryID");
item.ProductId = NopSqlDataHelper.GetInt(dataReader, "ProductID");
item.CategoryId = NopSqlDataHelper.GetInt(dataReader, "CategoryID");
item.IsFeaturedProduct = NopSqlDataHelper.GetBoolean(dataReader, "IsFeaturedProduct");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
/// <summary>
/// Maps a data reader to a product specification attribute
/// </summary>
/// <param name="dataReader">IDataReader</param>
/// <returns>Product specification attribute</returns>
private DBProductSpecificationAttribute GetProductSpecificationAttributeFromReader(IDataReader dataReader)
{
var item = new DBProductSpecificationAttribute();
item.ProductSpecificationAttributeId = NopSqlDataHelper.GetInt(dataReader, "ProductSpecificationAttributeID");
item.ProductId = NopSqlDataHelper.GetInt(dataReader, "ProductID");
item.SpecificationAttributeOptionId = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeOptionID");
item.AllowFiltering = NopSqlDataHelper.GetBoolean(dataReader, "AllowFiltering");
item.ShowOnProductPage = NopSqlDataHelper.GetBoolean(dataReader, "ShowOnProductPage");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
private DBPoll GetPollFromReader(IDataReader dataReader)
{
var item = new DBPoll();
item.PollId = NopSqlDataHelper.GetInt(dataReader, "PollID");
item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
item.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
private DBPoll GetPollFromReader(IDataReader dataReader)
{
DBPoll poll = new DBPoll();
poll.PollID = NopSqlDataHelper.GetInt(dataReader, "PollID");
poll.LanguageID = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
poll.Name = NopSqlDataHelper.GetString(dataReader, "Name");
poll.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
poll.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published");
poll.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(poll);
}
private DBNewsLetterSubscription GetNewsLetterSubscriptionFromReader(IDataReader dataReader)
{
var item = new DBNewsLetterSubscription();
item.NewsLetterSubscriptionId = NopSqlDataHelper.GetInt(dataReader, "NewsLetterSubscriptionID");
item.NewsLetterSubscriptionGuid = NopSqlDataHelper.GetGuid(dataReader, "NewsLetterSubscriptionGuid");
item.Email = NopSqlDataHelper.GetString(dataReader, "Email");
item.IsActive = NopSqlDataHelper.GetBoolean(dataReader, "Active");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(item);
}
private DBLanguage GetLanguageFromReader(IDataReader dataReader)
{
var item = new DBLanguage();
item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.LanguageCulture = NopSqlDataHelper.GetString(dataReader, "LanguageCulture");
item.FlagImageFileName = NopSqlDataHelper.GetString(dataReader, "FlagImageFileName");
item.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
private DBShippingByTotal GetShippingByTotalFromReader(IDataReader dataReader)
{
var item = new DBShippingByTotal();
item.ShippingByTotalId = NopSqlDataHelper.GetInt(dataReader, "ShippingByTotalID");
item.ShippingMethodId = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID");
item.From = NopSqlDataHelper.GetDecimal(dataReader, "From");
item.To = NopSqlDataHelper.GetDecimal(dataReader, "To");
item.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
item.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage");
item.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount");
return(item);
}
private DBShippingByTotal GetShippingByTotalFromReader(IDataReader dataReader)
{
DBShippingByTotal shippingByTotal = new DBShippingByTotal();
shippingByTotal.ShippingByTotalID = NopSqlDataHelper.GetInt(dataReader, "ShippingByTotalID");
shippingByTotal.ShippingMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID");
shippingByTotal.From = NopSqlDataHelper.GetDecimal(dataReader, "From");
shippingByTotal.To = NopSqlDataHelper.GetDecimal(dataReader, "To");
shippingByTotal.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
shippingByTotal.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage");
shippingByTotal.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount");
return(shippingByTotal);
}
private DBCheckoutAttributeValue GetCheckoutAttributeValueFromReader(IDataReader dataReader)
{
var item = new DBCheckoutAttributeValue();
item.CheckoutAttributeValueId = NopSqlDataHelper.GetInt(dataReader, "CheckoutAttributeValueID");
item.CheckoutAttributeId = NopSqlDataHelper.GetInt(dataReader, "CheckoutAttributeID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.PriceAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "PriceAdjustment");
item.WeightAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "WeightAdjustment");
item.IsPreSelected = NopSqlDataHelper.GetBoolean(dataReader, "IsPreSelected");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
private DBProductVariantAttribute GetProductVariantAttributeFromReader(IDataReader dataReader)
{
DBProductVariantAttribute productVariantAttribute = new DBProductVariantAttribute();
productVariantAttribute.ProductVariantAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeID");
productVariantAttribute.ProductVariantID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantID");
productVariantAttribute.ProductAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductAttributeID");
productVariantAttribute.TextPrompt = NopSqlDataHelper.GetString(dataReader, "TextPrompt");
productVariantAttribute.IsRequired = NopSqlDataHelper.GetBoolean(dataReader, "IsRequired");
productVariantAttribute.AttributeControlTypeID = NopSqlDataHelper.GetInt(dataReader, "AttributeControlTypeID");
productVariantAttribute.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(productVariantAttribute);
}
private DBProductVariantAttributeValue GetProductVariantAttributeValueFromReader(IDataReader dataReader)
{
DBProductVariantAttributeValue productVariantAttributeValue = new DBProductVariantAttributeValue();
productVariantAttributeValue.ProductVariantAttributeValueID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeValueID");
productVariantAttributeValue.ProductVariantAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeID");
productVariantAttributeValue.Name = NopSqlDataHelper.GetString(dataReader, "Name");
productVariantAttributeValue.PriceAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "PriceAdjustment");
productVariantAttributeValue.WeightAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "WeightAdjustment");
productVariantAttributeValue.IsPreSelected = NopSqlDataHelper.GetBoolean(dataReader, "IsPreSelected");
productVariantAttributeValue.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(productVariantAttributeValue);
}
private DBLocalizedMessageTemplate GetLocalizedMessageTemplateFromReader(IDataReader dataReader)
{
var item = new DBLocalizedMessageTemplate();
item.MessageTemplateLocalizedId = NopSqlDataHelper.GetInt(dataReader, "MessageTemplateLocalizedID");
item.MessageTemplateId = NopSqlDataHelper.GetInt(dataReader, "MessageTemplateID");
item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
item.BccEmailAddresses = NopSqlDataHelper.GetString(dataReader, "BCCEmailAddresses");
item.Subject = NopSqlDataHelper.GetString(dataReader, "Subject");
item.Body = NopSqlDataHelper.GetString(dataReader, "Body");
item.IsActive = NopSqlDataHelper.GetBoolean(dataReader, "IsActive");
return(item);
}
private DBShippingByWeight GetShippingByWeightFromReader(IDataReader dataReader)
{
DBShippingByWeight shippingByWeight = new DBShippingByWeight();
shippingByWeight.ShippingByWeightID = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightID");
shippingByWeight.ShippingMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID");
shippingByWeight.From = NopSqlDataHelper.GetDecimal(dataReader, "From");
shippingByWeight.To = NopSqlDataHelper.GetDecimal(dataReader, "To");
shippingByWeight.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
shippingByWeight.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage");
shippingByWeight.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount");
return(shippingByWeight);
}
private DBDownload GetDownloadFromReader(IDataReader dataReader)
{
DBDownload download = new DBDownload();
download.DownloadID = NopSqlDataHelper.GetInt(dataReader, "DownloadID");
download.UseDownloadURL = NopSqlDataHelper.GetBoolean(dataReader, "UseDownloadURL");
download.DownloadURL = NopSqlDataHelper.GetString(dataReader, "DownloadURL");
download.DownloadBinary = NopSqlDataHelper.GetBytes(dataReader, "DownloadBinary");
download.ContentType = NopSqlDataHelper.GetString(dataReader, "ContentType");
download.Extension = NopSqlDataHelper.GetString(dataReader, "Extension");
download.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew");
return(download);
}
private DBBlogPost GetBlogPostFromReader(IDataReader dataReader)
{
DBBlogPost blogPost = new DBBlogPost();
blogPost.BlogPostID = NopSqlDataHelper.GetInt(dataReader, "BlogPostID");
blogPost.LanguageID = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
blogPost.BlogPostTitle = NopSqlDataHelper.GetString(dataReader, "BlogPostTitle");
blogPost.BlogPostBody = NopSqlDataHelper.GetString(dataReader, "BlogPostBody");
blogPost.BlogPostAllowComments = NopSqlDataHelper.GetBoolean(dataReader, "BlogPostAllowComments");
blogPost.CreatedByID = NopSqlDataHelper.GetInt(dataReader, "CreatedByID");
blogPost.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(blogPost);
}
private DBShippingRateComputationMethod GetShippingRateComputationMethodFromReader(IDataReader dataReader)
{
var item = new DBShippingRateComputationMethod();
item.ShippingRateComputationMethodId = NopSqlDataHelper.GetInt(dataReader, "ShippingRateComputationMethodID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.Description = NopSqlDataHelper.GetString(dataReader, "Description");
item.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath");
item.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName");
item.IsActive = NopSqlDataHelper.GetBoolean(dataReader, "IsActive");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
private DBDownload GetDownloadFromReader(IDataReader dataReader)
{
var item = new DBDownload();
item.DownloadId = NopSqlDataHelper.GetInt(dataReader, "DownloadID");
item.UseDownloadUrl = NopSqlDataHelper.GetBoolean(dataReader, "UseDownloadURL");
item.DownloadUrl = NopSqlDataHelper.GetString(dataReader, "DownloadURL");
item.DownloadBinary = NopSqlDataHelper.GetBytes(dataReader, "DownloadBinary");
item.ContentType = NopSqlDataHelper.GetString(dataReader, "ContentType");
item.Filename = NopSqlDataHelper.GetString(dataReader, "Filename");
item.Extension = NopSqlDataHelper.GetString(dataReader, "Extension");
item.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew");
return(item);
}
private DBNews GetNewsFromReader(IDataReader dataReader)
{
DBNews news = new DBNews();
news.NewsID = NopSqlDataHelper.GetInt(dataReader, "NewsID");
news.LanguageID = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
news.Title = NopSqlDataHelper.GetString(dataReader, "Title");
news.Short = NopSqlDataHelper.GetString(dataReader, "Short");
news.Full = NopSqlDataHelper.GetString(dataReader, "Full");
news.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published");
news.AllowComments = NopSqlDataHelper.GetBoolean(dataReader, "AllowComments");
news.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(news);
}
private DBShippingByWeightAndCountry GetShippingByWeightAndCountryFromReader(IDataReader dataReader)
{
DBShippingByWeightAndCountry shippingByWeightAndCountry = new DBShippingByWeightAndCountry();
shippingByWeightAndCountry.ShippingByWeightAndCountryID = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightAndCountryID");
shippingByWeightAndCountry.ShippingMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID");
shippingByWeightAndCountry.CountryID = NopSqlDataHelper.GetInt(dataReader, "CountryID");
shippingByWeightAndCountry.From = NopSqlDataHelper.GetDecimal(dataReader, "From");
shippingByWeightAndCountry.To = NopSqlDataHelper.GetDecimal(dataReader, "To");
shippingByWeightAndCountry.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
shippingByWeightAndCountry.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage");
shippingByWeightAndCountry.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount");
return(shippingByWeightAndCountry);
}
private DBNews GetNewsFromReader(IDataReader dataReader)
{
var item = new DBNews();
item.NewsId = NopSqlDataHelper.GetInt(dataReader, "NewsID");
item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
item.Title = NopSqlDataHelper.GetString(dataReader, "Title");
item.Short = NopSqlDataHelper.GetString(dataReader, "Short");
item.Full = NopSqlDataHelper.GetString(dataReader, "Full");
item.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published");
item.AllowComments = NopSqlDataHelper.GetBoolean(dataReader, "AllowComments");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(item);
}