private DBShippingByWeight GetShippingByWeightFromReader(IDataReader dataReader)
{
DBShippingByWeight shippingByWeight = new DBShippingByWeight();
shippingByWeight.ShippingByWeightID = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightID");
shippingByWeight.ShippingMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID");
shippingByWeight.From = NopSqlDataHelper.GetDecimal(dataReader, "From");
shippingByWeight.To = NopSqlDataHelper.GetDecimal(dataReader, "To");
shippingByWeight.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
shippingByWeight.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage");
shippingByWeight.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount");
return shippingByWeight;
}
private DBShippingByWeight GetShippingByWeightFromReader(IDataReader dataReader)
{
var item = new DBShippingByWeight();
item.ShippingByWeightId = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightID");
item.ShippingMethodId = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID");
item.From = NopSqlDataHelper.GetDecimal(dataReader, "From");
item.To = NopSqlDataHelper.GetDecimal(dataReader, "To");
item.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
item.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage");
item.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount");
return(item);
}
private DBShippingByWeight GetShippingByWeightFromReader(IDataReader dataReader)
{
DBShippingByWeight shippingByWeight = new DBShippingByWeight();
shippingByWeight.ShippingByWeightID = NopSqlDataHelper.GetInt(dataReader, "ShippingByWeightID");
shippingByWeight.ShippingMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingMethodID");
shippingByWeight.From = NopSqlDataHelper.GetDecimal(dataReader, "From");
shippingByWeight.To = NopSqlDataHelper.GetDecimal(dataReader, "To");
shippingByWeight.UsePercentage = NopSqlDataHelper.GetBoolean(dataReader, "UsePercentage");
shippingByWeight.ShippingChargePercentage = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargePercentage");
shippingByWeight.ShippingChargeAmount = NopSqlDataHelper.GetDecimal(dataReader, "ShippingChargeAmount");
return(shippingByWeight);
}
/// <summary>
/// Gets a ShippingByWeight
/// </summary>
/// <param name="ShippingByWeightID">ShippingByWeight identifier</param>
/// <returns>ShippingByWeight</returns>
public override DBShippingByWeight GetByID(int ShippingByWeightID)
{
DBShippingByWeight shippingByWeight = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ShippingByWeightID", DbType.Int32, ShippingByWeightID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
shippingByWeight = GetShippingByWeightFromReader(dataReader);
}
}
return(shippingByWeight);
}
private static ShippingByWeight DBMapping(DBShippingByWeight dbItem)
{
if (dbItem == null)
return null;
ShippingByWeight item = new ShippingByWeight();
item.ShippingByWeightID = dbItem.ShippingByWeightID;
item.ShippingMethodID = dbItem.ShippingMethodID;
item.From = dbItem.From;
item.To = dbItem.To;
item.UsePercentage = dbItem.UsePercentage;
item.ShippingChargePercentage = dbItem.ShippingChargePercentage;
item.ShippingChargeAmount = dbItem.ShippingChargeAmount;
return item;
}
/// <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>
/// Updates the ShippingByWeight
/// </summary>
/// <param name="ShippingByWeightID">The ShippingByWeight identifier</param>
/// <param name="ShippingMethodID">The shipping method identifier</param>
/// <param name="From">The "from" value</param>
/// <param name="To">The "to" value</param>
/// <param name="UsePercentage">A value indicating whether to use percentage</param>
/// <param name="ShippingChargePercentage">The shipping charge percentage</param>
/// <param name="ShippingChargeAmount">The shipping charge amount</param>
/// <returns>ShippingByWeight</returns>
public override DBShippingByWeight UpdateShippingByWeight(int ShippingByWeightID, int ShippingMethodID, decimal From, decimal To,
bool UsePercentage, decimal ShippingChargePercentage, decimal ShippingChargeAmount)
{
DBShippingByWeight shippingByWeight = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightUpdate");
db.AddInParameter(dbCommand, "ShippingByWeightID", DbType.Int32, ShippingByWeightID);
db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, ShippingMethodID);
db.AddInParameter(dbCommand, "From", DbType.Decimal, From);
db.AddInParameter(dbCommand, "To", DbType.Decimal, To);
db.AddInParameter(dbCommand, "UsePercentage", DbType.Boolean, UsePercentage);
db.AddInParameter(dbCommand, "ShippingChargePercentage", DbType.Decimal, ShippingChargePercentage);
db.AddInParameter(dbCommand, "ShippingChargeAmount", DbType.Decimal, ShippingChargeAmount);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
shippingByWeight = GetByID(ShippingByWeightID);
}
return(shippingByWeight);
}
/// <summary>
/// Updates the ShippingByWeight
/// </summary>
/// <param name="shippingByWeightId">The ShippingByWeight identifier</param>
/// <param name="shippingMethodId">The shipping method identifier</param>
/// <param name="from">The "from" value</param>
/// <param name="to">The "to" value</param>
/// <param name="usePercentage">A value indicating whether to use percentage</param>
/// <param name="shippingChargePercentage">The shipping charge percentage</param>
/// <param name="shippingChargeAmount">The shipping charge amount</param>
/// <returns>ShippingByWeight</returns>
public override DBShippingByWeight UpdateShippingByWeight(int shippingByWeightId,
int shippingMethodId, decimal from, decimal to, bool usePercentage,
decimal shippingChargePercentage, decimal shippingChargeAmount)
{
DBShippingByWeight item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingByWeightUpdate");
db.AddInParameter(dbCommand, "ShippingByWeightID", DbType.Int32, shippingByWeightId);
db.AddInParameter(dbCommand, "ShippingMethodID", DbType.Int32, shippingMethodId);
db.AddInParameter(dbCommand, "From", DbType.Decimal, from);
db.AddInParameter(dbCommand, "To", DbType.Decimal, to);
db.AddInParameter(dbCommand, "UsePercentage", DbType.Boolean, usePercentage);
db.AddInParameter(dbCommand, "ShippingChargePercentage", DbType.Decimal, shippingChargePercentage);
db.AddInParameter(dbCommand, "ShippingChargeAmount", DbType.Decimal, shippingChargeAmount);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetById(shippingByWeightId);
}
return(item);
}
