private static ManufacturerCollection DBMapping(DBManufacturerCollection dbCollection)
{
if (dbCollection == null)
return null;
ManufacturerCollection collection = new ManufacturerCollection();
foreach (DBManufacturer dbItem in dbCollection)
{
Manufacturer item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
private static ManufacturerCollection DBMapping(DBManufacturerCollection dbCollection)
{
if (dbCollection == null)
{
return(null);
}
ManufacturerCollection collection = new ManufacturerCollection();
foreach (DBManufacturer dbItem in dbCollection)
{
Manufacturer item = DBMapping(dbItem);
collection.Add(item);
}
return(collection);
}
/// <summary>
/// Gets all manufacturers
/// </summary>
/// <param name="showHidden">A value indicating whether to show hidden records</param>
/// <returns>Manufacturer collection</returns>
public override DBManufacturerCollection GetAllManufacturers(bool showHidden)
{
DBManufacturerCollection manufacturerCollection = new DBManufacturerCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerLoadAll");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBManufacturer manufacturer = GetManufacturerFromReader(dataReader);
manufacturerCollection.Add(manufacturer);
}
}
return(manufacturerCollection);
}
/// <summary>
/// Gets all manufacturers
/// </summary>
/// <param name="showHidden">A value indicating whether to show hidden records</param>
/// <param name="languageId">Language identifier</param>
/// <returns>Manufacturer collection</returns>
public override DBManufacturerCollection GetAllManufacturers(bool showHidden, int languageId)
{
var result = new DBManufacturerCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerLoadAll");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
var item = GetManufacturerFromReader(dataReader);
result.Add(item);
}
}
return(result);
}
/// <summary>
/// Gets all manufacturers
/// </summary>
/// <param name="showHidden">A value indicating whether to show hidden records</param>
/// <returns>Manufacturer collection</returns>
public static ManufacturerCollection GetAllManufacturers(bool showHidden)
{
string key = string.Format(MANUFACTURERS_ALL_KEY, showHidden);
object obj2 = NopCache.Get(key);
if (ManufacturerManager.ManufacturersCacheEnabled && (obj2 != null))
{
return((ManufacturerCollection)obj2);
}
DBManufacturerCollection dbCollection = DBProviderManager <DBManufacturerProvider> .Provider.GetAllManufacturers(showHidden);
ManufacturerCollection manufacturerCollection = DBMapping(dbCollection);
if (ManufacturerManager.ManufacturersCacheEnabled)
{
NopCache.Max(key, manufacturerCollection);
}
return(manufacturerCollection);
}
