/// <summary> /// Gets all ShippingByTotals /// </summary> /// <returns>ShippingByTotal collection</returns> public static ShippingByTotalCollection GetAll() { DBShippingByTotalCollection dbCollection = DBProviderManager <DBShippingByTotalProvider> .Provider.GetAll(); ShippingByTotalCollection collection = DBMapping(dbCollection); return(collection); }
/// <summary> /// Gets all ShippingByTotals by shipping method identifier /// </summary> /// <param name="ShippingMethodID">The shipping method identifier</param> /// <returns>ShippingByTotal collection</returns> public static ShippingByTotalCollection GetAllByShippingMethodID(int ShippingMethodID) { DBShippingByTotalCollection dbCollection = DBProviderManager <DBShippingByTotalProvider> .Provider.GetAllByShippingMethodID(ShippingMethodID); ShippingByTotalCollection collection = DBMapping(dbCollection); return(collection); }
/// <summary> /// Gets all ShippingByTotals /// </summary> /// <returns>ShippingByTotal collection</returns> public override DBShippingByTotalCollection GetAll() { var result = new DBShippingByTotalCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByTotalLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetShippingByTotalFromReader(dataReader); result.Add(item); } } return(result); }
private static ShippingByTotalCollection DBMapping(DBShippingByTotalCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new ShippingByTotalCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all ShippingByTotals by shipping method identifier /// </summary> /// <param name="shippingMethodId">The shipping method identifier</param> /// <returns>ShippingByTotal collection</returns> public override DBShippingByTotalCollection GetAllByShippingMethodId(int shippingMethodId) { var result = new DBShippingByTotalCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByTotalLoadByShippingMethodID"); db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, shippingMethodId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetShippingByTotalFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all ShippingByTotals by shipping method identifier /// </summary> /// <param name="ShippingMethodID">The shipping method identifier</param> /// <returns>ShippingByTotal collection</returns> public override DBShippingByTotalCollection GetAllByShippingMethodID(int ShippingMethodID) { DBShippingByTotalCollection shippingByTotalCollection = new DBShippingByTotalCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByTotalLoadByShippingMethodID"); db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, ShippingMethodID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBShippingByTotal shippingByTotal = GetShippingByTotalFromReader(dataReader); shippingByTotalCollection.Add(shippingByTotal); } } return(shippingByTotalCollection); }