private DBShippingRateComputationMethod GetShippingRateComputationMethodFromReader(IDataReader dataReader)
{
DBShippingRateComputationMethod shippingRateComputationMethod = new DBShippingRateComputationMethod();
shippingRateComputationMethod.ShippingRateComputationMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingRateComputationMethodID");
shippingRateComputationMethod.Name = NopSqlDataHelper.GetString(dataReader, "Name");
shippingRateComputationMethod.Description = NopSqlDataHelper.GetString(dataReader, "Description");
shippingRateComputationMethod.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath");
shippingRateComputationMethod.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName");
shippingRateComputationMethod.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return shippingRateComputationMethod;
}
private DBShippingRateComputationMethod GetShippingRateComputationMethodFromReader(IDataReader dataReader)
{
DBShippingRateComputationMethod shippingRateComputationMethod = new DBShippingRateComputationMethod();
shippingRateComputationMethod.ShippingRateComputationMethodID = NopSqlDataHelper.GetInt(dataReader, "ShippingRateComputationMethodID");
shippingRateComputationMethod.Name = NopSqlDataHelper.GetString(dataReader, "Name");
shippingRateComputationMethod.Description = NopSqlDataHelper.GetString(dataReader, "Description");
shippingRateComputationMethod.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath");
shippingRateComputationMethod.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName");
shippingRateComputationMethod.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(shippingRateComputationMethod);
}
private DBShippingRateComputationMethod GetShippingRateComputationMethodFromReader(IDataReader dataReader)
{
var item = new DBShippingRateComputationMethod();
item.ShippingRateComputationMethodId = NopSqlDataHelper.GetInt(dataReader, "ShippingRateComputationMethodID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.Description = NopSqlDataHelper.GetString(dataReader, "Description");
item.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath");
item.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName");
item.IsActive = NopSqlDataHelper.GetBoolean(dataReader, "IsActive");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
/// <summary>
/// Gets all shipping rate computation methods
/// </summary>
/// <returns>Shipping rate computation method collection</returns>
public override DBShippingRateComputationMethodCollection GetAllShippingRateComputationMethods()
{
DBShippingRateComputationMethodCollection shippingRateComputationMethodCollection = new DBShippingRateComputationMethodCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingRateComputationMethodLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBShippingRateComputationMethod shippingRateComputationMethod = GetShippingRateComputationMethodFromReader(dataReader);
shippingRateComputationMethodCollection.Add(shippingRateComputationMethod);
}
}
return(shippingRateComputationMethodCollection);
}
/// <summary>
/// Updates the shipping rate computation method
/// </summary>
/// <param name="ShippingRateComputationMethodID">The shipping rate computation method identifier</param>
/// <param name="Name">The name</param>
/// <param name="Description">The description</param>
/// <param name="ConfigureTemplatePath">The configure template path</param>
/// <param name="ClassName">The class name</param>
/// <param name="DisplayOrder">The display order</param>
/// <returns>Shipping rate computation method</returns>
public override DBShippingRateComputationMethod UpdateShippingRateComputationMethod(int ShippingRateComputationMethodID, string Name, string Description,
string ConfigureTemplatePath, string ClassName, int DisplayOrder)
{
DBShippingRateComputationMethod shippingRateComputationMethod = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingRateComputationMethodUpdate");
db.AddInParameter(dbCommand, "ShippingRateComputationMethodID", DbType.Int32, ShippingRateComputationMethodID);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "Description", DbType.String, Description);
db.AddInParameter(dbCommand, "ConfigureTemplatePath", DbType.String, ConfigureTemplatePath);
db.AddInParameter(dbCommand, "ClassName", DbType.String, ClassName);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
shippingRateComputationMethod = GetShippingRateComputationMethodByID(ShippingRateComputationMethodID);
}
return(shippingRateComputationMethod);
}
/// <summary>
/// Gets a shipping rate computation method
/// </summary>
/// <param name="shippingRateComputationMethodId">Shipping rate computation method identifier</param>
/// <returns>Shipping rate computation method</returns>
public override DBShippingRateComputationMethod GetShippingRateComputationMethodById(int shippingRateComputationMethodId)
{
DBShippingRateComputationMethod item = null;
if (shippingRateComputationMethodId == 0)
{
return(item);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingRateComputationMethodLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ShippingRateComputationMethodID", DbType.Int32, shippingRateComputationMethodId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetShippingRateComputationMethodFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Updates the shipping rate computation method
/// </summary>
/// <param name="shippingRateComputationMethodId">The shipping rate computation method identifier</param>
/// <param name="name">The name</param>
/// <param name="description">The description</param>
/// <param name="configureTemplatePath">The configure template path</param>
/// <param name="className">The class name</param>
/// <param name="isActive">The value indicating whether the method is active</param>
/// <param name="displayOrder">The display order</param>
/// <returns>Shipping rate computation method</returns>
public override DBShippingRateComputationMethod UpdateShippingRateComputationMethod(int shippingRateComputationMethodId,
string name, string description, string configureTemplatePath, string className,
bool isActive, int displayOrder)
{
DBShippingRateComputationMethod item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingRateComputationMethodUpdate");
db.AddInParameter(dbCommand, "ShippingRateComputationMethodID", DbType.Int32, shippingRateComputationMethodId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "Description", DbType.String, description);
db.AddInParameter(dbCommand, "ConfigureTemplatePath", DbType.String, configureTemplatePath);
db.AddInParameter(dbCommand, "ClassName", DbType.String, className);
db.AddInParameter(dbCommand, "IsActive", DbType.Boolean, isActive);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetShippingRateComputationMethodById(shippingRateComputationMethodId);
}
return(item);
}