/// <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);
}
/// <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;
}
