/// <summary>
/// Gets all warehouses
/// </summary>
/// <returns>Warehouse collection</returns>
public static WarehouseCollection GetAllWarehouses()
{
DBWarehouseCollection dbCollection = DBProviderManager <DBWarehouseProvider> .Provider.GetAllWarehouses();
WarehouseCollection warehouses = DBMapping(dbCollection);
return(warehouses);
}
private static WarehouseCollection DBMapping(DBWarehouseCollection dbCollection)
{
if (dbCollection == null)
{
return(null);
}
WarehouseCollection collection = new WarehouseCollection();
foreach (DBWarehouse dbItem in dbCollection)
{
Warehouse item = DBMapping(dbItem);
collection.Add(item);
}
return(collection);
}
/// <summary>
/// Gets all warehouses
/// </summary>
/// <returns>Warehouse collection</returns>
public override DBWarehouseCollection GetAllWarehouses()
{
var result = new DBWarehouseCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_WarehouseLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
var item = GetWarehouseFromReader(dataReader);
result.Add(item);
}
}
return(result);
}
