private static MeasureWeightCollection DBMapping(DBMeasureWeightCollection dbCollection) { if (dbCollection == null) return null; MeasureWeightCollection collection = new MeasureWeightCollection(); foreach (DBMeasureWeight dbItem in dbCollection) { MeasureWeight item = DBMapping(dbItem); collection.Add(item); } return collection; }
private static MeasureWeightCollection DBMapping(DBMeasureWeightCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new MeasureWeightCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all measure weights /// </summary> /// <returns>Measure weight collection</returns> public override DBMeasureWeightCollection GetAllMeasureWeights() { var result = new DBMeasureWeightCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_MeasureWeightLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetMeasureWeightFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all measure weights /// </summary> /// <returns>Measure weight collection</returns> public static MeasureWeightCollection GetAllMeasureWeights() { string key = MEASUREWEIGHTS_ALL_KEY; object obj2 = NopCache.Get(key); if (MeasureManager.CacheEnabled && (obj2 != null)) { return((MeasureWeightCollection)obj2); } DBMeasureWeightCollection dbCollection = DBProviderManager <DBMeasureProvider> .Provider.GetAllMeasureWeights(); MeasureWeightCollection measureWeightCollection = DBMapping(dbCollection); if (MeasureManager.CacheEnabled) { NopCache.Max(key, measureWeightCollection); } return(measureWeightCollection); }
/// <summary> /// Gets all measure weights /// </summary> /// <returns>Measure weight collection</returns> public override DBMeasureWeightCollection GetAllMeasureWeights() { DBMeasureWeightCollection measureWeightCollection = new DBMeasureWeightCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_MeasureWeightLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBMeasureWeight measureWeight = GetMeasureWeightFromReader(dataReader); measureWeightCollection.Add(measureWeight); } } return measureWeightCollection; }