private static PaymentMethodCollection DBMapping(DBPaymentMethodCollection dbCollection) { if (dbCollection == null) return null; PaymentMethodCollection collection = new PaymentMethodCollection(); foreach (DBPaymentMethod dbItem in dbCollection) { PaymentMethod item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all payment methods /// </summary> /// <returns>Payment method collection</returns> public override DBPaymentMethodCollection GetAllPaymentMethods(bool showHidden) { DBPaymentMethodCollection paymentMethodCollection = new DBPaymentMethodCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodLoadAll"); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBPaymentMethod paymentMethod = GetPaymentMethodFromReader(dataReader); paymentMethodCollection.Add(paymentMethod); } } return(paymentMethodCollection); }
private static PaymentMethodCollection DBMapping(DBPaymentMethodCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new PaymentMethodCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all payment methods /// </summary> /// <returns>Payment method collection</returns> public static PaymentMethodCollection GetAllPaymentMethods() { bool showHidden = NopContext.Current.IsAdmin; string key = string.Format(PAYMENTMETHODS_ALL_KEY, showHidden); object obj2 = NopCache.Get(key); if (PaymentMethodManager.CacheEnabled && (obj2 != null)) { return((PaymentMethodCollection)obj2); } DBPaymentMethodCollection dbCollection = DBProviderManager <DBPaymentMethodProvider> .Provider.GetAllPaymentMethods(showHidden); PaymentMethodCollection paymentMethodCollection = DBMapping(dbCollection); if (PaymentMethodManager.CacheEnabled) { NopCache.Max(key, paymentMethodCollection); } return(paymentMethodCollection); }
/// <summary> /// Gets all payment methods /// </summary> /// <param name="showHidden">A value indicating whether to show hidden records</param> /// <param name="filterByCountryId">The country indentifier</param> /// <returns>Payment method collection</returns> public override DBPaymentMethodCollection GetAllPaymentMethods(bool showHidden, int?filterByCountryId) { var result = new DBPaymentMethodCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodLoadAll"); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); if (filterByCountryId.HasValue) { db.AddInParameter(dbCommand, "FilterByCountryID", DbType.Int32, filterByCountryId.Value); } using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetPaymentMethodFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all payment methods /// </summary> /// <returns>Payment method collection</returns> public override DBPaymentMethodCollection GetAllPaymentMethods(bool showHidden) { DBPaymentMethodCollection paymentMethodCollection = new DBPaymentMethodCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodLoadAll"); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBPaymentMethod paymentMethod = GetPaymentMethodFromReader(dataReader); paymentMethodCollection.Add(paymentMethod); } } return paymentMethodCollection; }