private static PaymentStatusCollection DBMapping(DBPaymentStatusCollection dbCollection) { if (dbCollection == null) return null; PaymentStatusCollection collection = new PaymentStatusCollection(); foreach (DBPaymentStatus dbItem in dbCollection) { PaymentStatus item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all payment statuses /// </summary> /// <returns>Payment status collection</returns> public override DBPaymentStatusCollection GetAllPaymentStatuses() { var result = new DBPaymentStatusCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentStatusLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetPaymentStatusFromReader(dataReader); result.Add(item); } } return(result); }
private static PaymentStatusCollection DBMapping(DBPaymentStatusCollection dbCollection) { if (dbCollection == null) { return(null); } PaymentStatusCollection collection = new PaymentStatusCollection(); foreach (DBPaymentStatus dbItem in dbCollection) { PaymentStatus item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all payment statuses /// </summary> /// <returns>Payment status collection</returns> public static PaymentStatusCollection GetAllPaymentStatuses() { string key = string.Format(PAYMENTSTATUSES_ALL_KEY); object obj2 = NopCache.Get(key); if (PaymentStatusManager.CacheEnabled && (obj2 != null)) { return((PaymentStatusCollection)obj2); } DBPaymentStatusCollection dbCollection = DBProviderManager <DBPaymentStatusProvider> .Provider.GetAllPaymentStatuses(); PaymentStatusCollection paymentStatusCollection = DBMapping(dbCollection); if (PaymentStatusManager.CacheEnabled) { NopCache.Max(key, paymentStatusCollection); } return(paymentStatusCollection); }