/// <summary> /// Gets all affiliates /// </summary> /// <returns>Affiliate collection</returns> public static AffiliateCollection GetAllAffiliates() { DBAffiliateCollection dbCollection = DBProviderManager <DBAffiliateProvider> .Provider.GetAllAffiliates(); AffiliateCollection affiliates = DBMapping(dbCollection); return(affiliates); }
private static AffiliateCollection DBMapping(DBAffiliateCollection dbCollection) { if (dbCollection == null) return null; AffiliateCollection collection = new AffiliateCollection(); foreach (DBAffiliate dbItem in dbCollection) { Affiliate item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all affiliates /// </summary> /// <returns>Affiliate collection</returns> public override DBAffiliateCollection GetAllAffiliates() { DBAffiliateCollection affiliateCollection = new DBAffiliateCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_AffiliateLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBAffiliate affiliate = GetAffiliateFromReader(dataReader); affiliateCollection.Add(affiliate); } } return(affiliateCollection); }
private static AffiliateCollection DBMapping(DBAffiliateCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new AffiliateCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }