/// <summary>
/// Gets all ShippingByWeights
/// </summary>
/// <returns>ShippingByWeight collection</returns>
public static ShippingByWeightCollection GetAll()
{
DBShippingByWeightCollection dbCollection = DBProviderManager <DBShippingByWeightProvider> .Provider.GetAll();
ShippingByWeightCollection collection = DBMapping(dbCollection);
return(collection);
}
/// <summary>
/// Gets all ShippingByWeights by shipping method identifier
/// </summary>
/// <param name="ShippingMethodID">The shipping method identifier</param>
/// <returns>ShippingByWeight collection</returns>
public static ShippingByWeightCollection GetAllByShippingMethodID(int ShippingMethodID)
{
DBShippingByWeightCollection dbCollection = DBProviderManager <DBShippingByWeightProvider> .Provider.GetAllByShippingMethodID(ShippingMethodID);
ShippingByWeightCollection collection = DBMapping(dbCollection);
return(collection);
}
private static ShippingByWeightCollection DBMapping(DBShippingByWeightCollection dbCollection)
{
if (dbCollection == null)
return null;
ShippingByWeightCollection collection = new ShippingByWeightCollection();
foreach (DBShippingByWeight dbItem in dbCollection)
{
ShippingByWeight item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
/// <summary>
/// Gets all ShippingByWeights
/// </summary>
/// <returns>ShippingByWeight collection</returns>
public override DBShippingByWeightCollection GetAll()
{
DBShippingByWeightCollection shippingByWeightCollection = new DBShippingByWeightCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBShippingByWeight shippingByWeight = GetShippingByWeightFromReader(dataReader);
shippingByWeightCollection.Add(shippingByWeight);
}
}
return(shippingByWeightCollection);
}
private static ShippingByWeightCollection DBMapping(DBShippingByWeightCollection dbCollection)
{
if (dbCollection == null)
{
return(null);
}
var collection = new ShippingByWeightCollection();
foreach (var dbItem in dbCollection)
{
var item = DBMapping(dbItem);
collection.Add(item);
}
return(collection);
}
/// <summary>
/// Gets all ShippingByWeights by shipping method identifier
/// </summary>
/// <param name="ShippingMethodID">The shipping method identifier</param>
/// <returns>ShippingByWeight collection</returns>
public override DBShippingByWeightCollection GetAllByShippingMethodID(int ShippingMethodID)
{
DBShippingByWeightCollection shippingByWeightCollection = new DBShippingByWeightCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadByShippingMethodID");
db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, ShippingMethodID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBShippingByWeight shippingByWeight = GetShippingByWeightFromReader(dataReader);
shippingByWeightCollection.Add(shippingByWeight);
}
}
return(shippingByWeightCollection);
}
/// <summary>
/// Gets all ShippingByWeights by shipping method identifier
/// </summary>
/// <param name="ShippingMethodID">The shipping method identifier</param>
/// <returns>ShippingByWeight collection</returns>
public override DBShippingByWeightCollection GetAllByShippingMethodID(int ShippingMethodID)
{
DBShippingByWeightCollection shippingByWeightCollection = new DBShippingByWeightCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadByShippingMethodID");
db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, ShippingMethodID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBShippingByWeight shippingByWeight = GetShippingByWeightFromReader(dataReader);
shippingByWeightCollection.Add(shippingByWeight);
}
}
return shippingByWeightCollection;
}
/// <summary>
/// Gets all ShippingByWeights
/// </summary>
/// <returns>ShippingByWeight collection</returns>
public override DBShippingByWeightCollection GetAll()
{
DBShippingByWeightCollection shippingByWeightCollection = new DBShippingByWeightCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBShippingByWeight shippingByWeight = GetShippingByWeightFromReader(dataReader);
shippingByWeightCollection.Add(shippingByWeight);
}
}
return shippingByWeightCollection;
}
