private DBLog GetLogFromReader(IDataReader dataReader)
{
var item = new DBLog();
item.LogId = NopSqlDataHelper.GetInt(dataReader, "LogID");
item.LogTypeId = NopSqlDataHelper.GetInt(dataReader, "LogTypeID");
item.Severity = NopSqlDataHelper.GetInt(dataReader, "Severity");
item.Message = NopSqlDataHelper.GetString(dataReader, "Message");
item.Exception = NopSqlDataHelper.GetString(dataReader, "Exception");
item.IPAddress = NopSqlDataHelper.GetString(dataReader, "IPAddress");
item.CustomerId = NopSqlDataHelper.GetInt(dataReader, "CustomerID");
item.PageUrl = NopSqlDataHelper.GetString(dataReader, "PageURL");
item.ReferrerUrl = NopSqlDataHelper.GetString(dataReader, "ReferrerURL");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(item);
}
/// <summary>
/// Gets all tax rates
/// </summary>
/// <returns>Tax rate collection</returns>
public override DBTaxRateCollection GetAllTaxRates()
{
var result = new DBTaxRateCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxRateLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
var item = GetTaxRateFromReader(dataReader);
result.Add(item);
}
}
return(result);
}
/// <summary>
/// Updates the product attribute
/// </summary>
/// <param name="productAttributeId">Product attribute identifier</param>
/// <param name="name">The name</param>
/// <param name="description">The description</param>
/// <returns>Product attribute </returns>
public override DBProductAttribute UpdateProductAttribute(int productAttributeId,
string name, string description)
{
DBProductAttribute item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductAttributeUpdate");
db.AddInParameter(dbCommand, "ProductAttributeID", DbType.Int32, productAttributeId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "Description", DbType.String, description);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetProductAttributeById(productAttributeId, 0);
}
return(item);
}
private DBPaymentMethod GetPaymentMethodFromReader(IDataReader dataReader)
{
var item = new DBPaymentMethod();
item.PaymentMethodId = NopSqlDataHelper.GetInt(dataReader, "PaymentMethodID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.VisibleName = NopSqlDataHelper.GetString(dataReader, "VisibleName");
item.Description = NopSqlDataHelper.GetString(dataReader, "Description");
item.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath");
item.UserTemplatePath = NopSqlDataHelper.GetString(dataReader, "UserTemplatePath");
item.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName");
item.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
item.IsActive = NopSqlDataHelper.GetBoolean(dataReader, "IsActive");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
/// <summary>
/// Gets a locale string resource
/// </summary>
/// <param name="localeStringResourceId">Locale string resource identifier</param>
/// <returns>Locale string resource</returns>
public override DBLocaleStringResource GetLocaleStringResourceById(int localeStringResourceId)
{
DBLocaleStringResource item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_LocaleStringResourceLoadByPrimaryKey");
db.AddInParameter(dbCommand, "LocaleStringResourceID", DbType.Int32, localeStringResourceId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetLocaleStringResourceFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Gets a ShippingByWeightAndCountry
/// </summary>
/// <param name="shippingByWeightAndCountryId">ShippingByWeightAndCountry identifier</param>
/// <returns>ShippingByWeightAndCountry</returns>
public override DBShippingByWeightAndCountry GetById(int shippingByWeightAndCountryId)
{
DBShippingByWeightAndCountry item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightAndCountryLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ShippingByWeightAndCountryID", DbType.Int32, shippingByWeightAndCountryId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetShippingByWeightAndCountryFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Gets a measure weight by identifier
/// </summary>
/// <param name="MeasureWeightID">Measure weight identifier</param>
/// <returns>Measure weight</returns>
public override DBMeasureWeight GetMeasureWeightByID(int MeasureWeightID)
{
DBMeasureWeight measureWeight = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_MeasureWeightLoadByPrimaryKey");
db.AddInParameter(dbCommand, "MeasureWeightID", DbType.Int32, MeasureWeightID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
measureWeight = GetMeasureWeightFromReader(dataReader);
}
}
return(measureWeight);
}
/// <summary>
/// Gets all tax providers
/// </summary>
/// <returns>Shipping rate computation method collection</returns>
public override DBTaxProviderCollection GetAllTaxProviders()
{
DBTaxProviderCollection taxProviderCollection = new DBTaxProviderCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxProviderLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBTaxProvider taxProvider = GetTaxProviderFromReader(dataReader);
taxProviderCollection.Add(taxProvider);
}
}
return(taxProviderCollection);
}
/// <summary>
/// Gets a poll
/// </summary>
/// <param name="systemKeyword">Poll system keyword</param>
/// <returns>Poll</returns>
public override DBPoll GetPollBySystemKeyword(string systemKeyword)
{
DBPoll item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PollLoadBySystemKeyword");
db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, systemKeyword);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetPollFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Inserts a specification attribute
/// </summary>
/// <param name="name">The name</param>
/// <param name="displayOrder">Display order</param>
/// <returns>Specification attribute</returns>
public override DBSpecificationAttribute InsertSpecificationAttribute(string name, int displayOrder)
{
DBSpecificationAttribute specificationAttribute = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeInsert");
db.AddOutParameter(dbCommand, "SpecificationAttributeID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.String, displayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int SpecificationAttributeID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@SpecificationAttributeID"));
specificationAttribute = GetSpecificationAttributeByID(SpecificationAttributeID);
}
return(specificationAttribute);
}
/// <summary>
/// Updates the specification attribute
/// </summary>
/// <param name="specificationAttributeID">The specification attribute identifier</param>
/// <param name="name">The name</param>
/// <param name="displayOrder">Display order</param>
/// <returns>Specification attribute</returns>
public override DBSpecificationAttribute UpdateSpecificationAttribute(int specificationAttributeID, string name, int displayOrder)
{
DBSpecificationAttribute specificationAttribute = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeUpdate");
db.AddInParameter(dbCommand, "SpecificationAttributeID", DbType.Int32, specificationAttributeID);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.String, displayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
specificationAttribute = GetSpecificationAttributeByID(specificationAttributeID);
}
return(specificationAttribute);
}
/// <summary>
/// Gets a news comment
/// </summary>
/// <param name="NewsCommentID">News comment identifer</param>
/// <returns>News comment</returns>
public override DBNewsComment GetNewsCommentByID(int NewsCommentID)
{
DBNewsComment newsComment = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsCommentLoadByPrimaryKey");
db.AddInParameter(dbCommand, "NewsCommentID", DbType.Int32, NewsCommentID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
newsComment = GetNewsCommentFromReader(dataReader);
}
}
return(newsComment);
}
private DBCurrency GetCurrencyFromReader(IDataReader dataReader)
{
var item = new DBCurrency();
item.CurrencyId = NopSqlDataHelper.GetInt(dataReader, "CurrencyID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.CurrencyCode = NopSqlDataHelper.GetString(dataReader, "CurrencyCode");
item.Rate = NopSqlDataHelper.GetDecimal(dataReader, "Rate");
item.DisplayLocale = NopSqlDataHelper.GetString(dataReader, "DisplayLocale");
item.CustomFormatting = NopSqlDataHelper.GetString(dataReader, "CustomFormatting");
item.Published = NopSqlDataHelper.GetBoolean(dataReader, "Published");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
item.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn");
return(item);
}
/// <summary>
/// Gets all message templates
/// </summary>
/// <returns>Message template collection</returns>
public override DBMessageTemplateCollection GetAllMessageTemplates()
{
DBMessageTemplateCollection messageTemplateCollection = new DBMessageTemplateCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_MessageTemplateLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBMessageTemplate messageTemplate = GetMessageTemplateFromReader(dataReader);
messageTemplateCollection.Add(messageTemplate);
}
}
return(messageTemplateCollection);
}
/// <summary>
/// Gets an blog post
/// </summary>
/// <param name="blogPostId">Blog post identifier</param>
/// <returns>Blog post</returns>
public override DBBlogPost GetBlogPostById(int blogPostId)
{
DBBlogPost item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostLoadByPrimaryKey");
db.AddInParameter(dbCommand, "BlogPostID", DbType.Int32, blogPostId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetBlogPostFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Gets a product variant attribute combination
/// </summary>
/// <param name="productVariantAttributeCombinationId">Product variant attribute combination identifier</param>
/// <returns>Product variant attribute combination</returns>
public override DBProductVariantAttributeCombination GetProductVariantAttributeCombinationById(int productVariantAttributeCombinationId)
{
DBProductVariantAttributeCombination item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeCombinationLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ProductVariantAttributeCombinationID", DbType.Int32, productVariantAttributeCombinationId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetProductVariantAttributeCombinationFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Gets an activity log item
/// </summary>
/// <param name="activityLogId">Activity log identifier</param>
/// <returns>Activity log item</returns>
public override DBActivityLog GetActivityById(int activityLogId)
{
DBActivityLog item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ActivityLogLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ActivityLogID", DbType.Int32, activityLogId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetActivityLogFromReader(dataReader);
}
}
return(item);
}
private void BindData()
{
//pending
decimal os_pendingTotalSum = decimal.Zero;
int os_pendingCount = 0;
using (IDataReader orders_os_pending = OrderManager.GetOrderReport(OrderStatusEnum.Pending, null, null))
{
while (orders_os_pending.Read())
{
os_pendingTotalSum = NopSqlDataHelper.GetDecimal(orders_os_pending, "Total");
os_pendingCount = NopSqlDataHelper.GetInt(orders_os_pending, "Count");
}
lblTotalIncomplete.Text = os_pendingCount.ToString();
lblTotalIncompleteValue.Text = PriceHelper.FormatPrice(os_pendingTotalSum, true, false);
}
//not paid
decimal ps_pendingTotalSum = decimal.Zero;
int ps_pendingCount = 0;
using (IDataReader orders_ps_pending = OrderManager.GetOrderReport(null, PaymentStatusEnum.Pending, null))
{
while (orders_ps_pending.Read())
{
ps_pendingTotalSum = NopSqlDataHelper.GetDecimal(orders_ps_pending, "Total");
ps_pendingCount = NopSqlDataHelper.GetInt(orders_ps_pending, "Count");
}
lblTotalUnpaid.Text = ps_pendingCount.ToString();
lblTotalUnpaidValue.Text = PriceHelper.FormatPrice(ps_pendingTotalSum, true, false);
}
//not shipped
decimal ss_pendingTotalSum = decimal.Zero;
int ss_pendingCount = 0;
using (IDataReader orders_ss_pending = OrderManager.GetOrderReport(null, null, ShippingStatusEnum.NotYetShipped))
{
while (orders_ss_pending.Read())
{
ss_pendingTotalSum = NopSqlDataHelper.GetDecimal(orders_ss_pending, "Total");
ss_pendingCount = NopSqlDataHelper.GetInt(orders_ss_pending, "Count");
}
lblTotalUnshipped.Text = ss_pendingCount.ToString();
lblTotalUnshippedValue.Text = PriceHelper.FormatPrice(ss_pendingTotalSum, true, false);
}
}
/// <summary>
/// Gets all ShippingByWeightAndCountrys
/// </summary>
/// <returns>ShippingByWeightAndCountry collection</returns>
public override DBShippingByWeightAndCountryCollection GetAll()
{
DBShippingByWeightAndCountryCollection shippingByWeightAndCountryCollection = new DBShippingByWeightAndCountryCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightAndCountryLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBShippingByWeightAndCountry shippingByWeightAndCountry = GetShippingByWeightAndCountryFromReader(dataReader);
shippingByWeightAndCountryCollection.Add(shippingByWeightAndCountry);
}
}
return(shippingByWeightAndCountryCollection);
}
/// <summary>
/// Gets localized specification attribute option by specification attribute option id and language id
/// </summary>
/// <param name="specificationAttributeOptionId">Specification attribute option identifier</param>
/// <param name="languageId">Language identifier</param>
/// <returns>Localized specification attribute option</returns>
public override DBSpecificationAttributeOptionLocalized GetSpecificationAttributeOptionLocalizedBySpecificationAttributeOptionIdAndLanguageId(int specificationAttributeOptionId, int languageId)
{
DBSpecificationAttributeOptionLocalized item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionLocalizedLoadBySpecificationAttributeOptionIDAndLanguageID");
db.AddInParameter(dbCommand, "SpecificationAttributeOptionID", DbType.Int32, specificationAttributeOptionId);
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetSpecificationAttributeOptionLocalizedFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Gets all payment methods
/// </summary>
/// <returns>Payment method collection</returns>
public override DBPaymentMethodCollection GetAllPaymentMethods(bool showHidden)
{
DBPaymentMethodCollection paymentMethodCollection = new DBPaymentMethodCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodLoadAll");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBPaymentMethod paymentMethod = GetPaymentMethodFromReader(dataReader);
paymentMethodCollection.Add(paymentMethod);
}
}
return(paymentMethodCollection);
}
/// <summary>
/// Gets a setting
/// </summary>
/// <param name="SettingID">Setting identifer</param>
/// <returns>Setting</returns>
public override DBSetting GetSettingByID(int SettingID)
{
DBSetting setting = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SettingLoadByPrimaryKey");
db.AddInParameter(dbCommand, "SettingID", DbType.Int32, SettingID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
setting = GetSettingFromReader(dataReader);
}
}
return(setting);
}
/// <summary>
/// Updates a setting
/// </summary>
/// <param name="SettingID">Setting identifier</param>
/// <param name="Name">The name</param>
/// <param name="Value">The value</param>
/// <param name="Description">The description</param>
/// <returns>Setting</returns>
public override DBSetting UpdateSetting(int SettingID, string Name, string Value, string Description)
{
DBSetting setting = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SettingUpdate");
db.AddInParameter(dbCommand, "SettingID", DbType.Int32, SettingID);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "Value", DbType.String, Value);
db.AddInParameter(dbCommand, "Description", DbType.String, Description);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
setting = GetSettingByID(SettingID);
}
return(setting);
}
/// <summary>
/// Gets all currencies
/// </summary>
/// <returns>Currency collection</returns>
public override DBCurrencyCollection GetAllCurrencies(bool showHidden)
{
DBCurrencyCollection currencyCollection = new DBCurrencyCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CurrencyLoadAll");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBCurrency currency = GetCurrencyFromReader(dataReader);
currencyCollection.Add(currency);
}
}
return currencyCollection;
}
/// <summary>
/// Gets a currency
/// </summary>
/// <param name="CurrencyID">Currency identifier</param>
/// <returns>Currency</returns>
public override DBCurrency GetCurrencyByID(int CurrencyID)
{
DBCurrency currency = null;
if (CurrencyID == 0)
return currency;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CurrencyLoadByPrimaryKey");
db.AddInParameter(dbCommand, "CurrencyID", DbType.Int32, CurrencyID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
currency = GetCurrencyFromReader(dataReader);
}
}
return currency;
}
/// <summary>
/// Inserts a shipping method
/// </summary>
/// <param name="Name">The name</param>
/// <param name="Description">The description</param>
/// <param name="DisplayOrder">The display order</param>
/// <returns>Shipping method</returns>
public override DBShippingMethod InsertShippingMethod(string Name, string Description, int DisplayOrder)
{
DBShippingMethod shippingMethod = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingMethodInsert");
db.AddOutParameter(dbCommand, "ShippingMethodID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "Description", DbType.String, Description);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int ShippingMethodID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@ShippingMethodID"));
shippingMethod = GetShippingMethodByID(ShippingMethodID);
}
return(shippingMethod);
}
/// <summary>
/// Gets all log items
/// </summary>
/// <returns>Log item collection</returns>
public override DBLogCollection GetAllLogs()
{
DBLogCollection logCollection = new DBLogCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_LogLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBLog log = GetLogFromReader(dataReader);
logCollection.Add(log);
}
}
return(logCollection);
}
/// <summary>
/// Gets all languages
/// </summary>
/// <param name="showHidden">A value indicating whether to show hidden records</param>
/// <returns>Language collection</returns>
public override DBLanguageCollection GetAllLanguages(bool showHidden)
{
DBLanguageCollection languageCollection = new DBLanguageCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_LanguageLoadAll");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBLanguage language = GetLanguageFromReader(dataReader);
languageCollection.Add(language);
}
}
return(languageCollection);
}
/// <summary>
/// Gets all shipping statuses
/// </summary>
/// <returns>Shipping status collection</returns>
public override DBShippingStatusCollection GetAllShippingStatuses()
{
DBShippingStatusCollection shippingStatusCollection = new DBShippingStatusCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingStatusLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBShippingStatus shippingStatus = GetShippingStatusFromReader(dataReader);
shippingStatusCollection.Add(shippingStatus);
}
}
return(shippingStatusCollection);
}
/// <summary>
/// Gets all localized topics
/// </summary>
/// <param name="topicName">Topic name</param>
/// <returns>Localized topic collection</returns>
public override DBLocalizedTopicCollection GetAllLocalizedTopics(string topicName)
{
var result = new DBLocalizedTopicCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedLoadAllByName");
db.AddInParameter(dbCommand, "Name", DbType.String, topicName);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
var item = GetLocalizedTopicFromReader(dataReader);
result.Add(item);
}
}
return(result);
}
