/// <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); }