private DBProductManufacturer GetProductManufacturerFromReader(IDataReader dataReader)
{
DBProductManufacturer productManufacturer = new DBProductManufacturer();
productManufacturer.ProductManufacturerID = NopSqlDataHelper.GetInt(dataReader, "ProductManufacturerID");
productManufacturer.ProductID = NopSqlDataHelper.GetInt(dataReader, "ProductID");
productManufacturer.ManufacturerID = NopSqlDataHelper.GetInt(dataReader, "ManufacturerID");
productManufacturer.IsFeaturedProduct = NopSqlDataHelper.GetBoolean(dataReader, "IsFeaturedProduct");
productManufacturer.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(productManufacturer);
}
private DBProductManufacturer GetProductManufacturerFromReader(IDataReader dataReader)
{
var item = new DBProductManufacturer();
item.ProductManufacturerId = NopSqlDataHelper.GetInt(dataReader, "ProductManufacturerID");
item.ProductId = NopSqlDataHelper.GetInt(dataReader, "ProductID");
item.ManufacturerId = NopSqlDataHelper.GetInt(dataReader, "ManufacturerID");
item.IsFeaturedProduct = NopSqlDataHelper.GetBoolean(dataReader, "IsFeaturedProduct");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(item);
}
/// <summary>
/// Inserts a product manufacturer mapping
/// </summary>
/// <param name="ProductID">Product identifier</param>
/// <param name="ManufacturerID">Manufacturer identifier</param>
/// <param name="IsFeaturedProduct">A value indicating whether the product is featured</param>
/// <param name="DisplayOrder">The display order</param>
/// <returns>Product manufacturer mapping </returns>
public override DBProductManufacturer InsertProductManufacturer(int ProductID, int ManufacturerID, bool IsFeaturedProduct, int DisplayOrder)
{
DBProductManufacturer productManufacturer = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_Product_Manufacturer_MappingInsert");
db.AddOutParameter(dbCommand, "ProductManufacturerID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "ProductID", DbType.Int32, ProductID);
db.AddInParameter(dbCommand, "ManufacturerID", DbType.Int32, ManufacturerID);
db.AddInParameter(dbCommand, "IsFeaturedProduct", DbType.Boolean, IsFeaturedProduct);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int ProductManufacturerID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@ProductManufacturerID"));
productManufacturer = GetProductManufacturerByID(ProductManufacturerID);
}
return(productManufacturer);
}
/// <summary>
/// Gets a product manufacturer mapping collection
/// </summary>
/// <param name="ProductID">Product identifier</param>
/// <param name="showHidden">A value indicating whether to show hidden records</param>
/// <returns>Product manufacturer mapping collection</returns>
public override DBProductManufacturerCollection GetProductManufacturersByProductID(int ProductID, bool showHidden)
{
DBProductManufacturerCollection productManufacturerCollection = new DBProductManufacturerCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_Product_Manufacturer_MappingLoadByProductID");
db.AddInParameter(dbCommand, "ProductID", DbType.Int32, ProductID);
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBProductManufacturer productManufacturer = GetProductManufacturerFromReader(dataReader);
productManufacturerCollection.Add(productManufacturer);
}
}
return(productManufacturerCollection);
}
/// <summary>
/// Updates the product manufacturer mapping
/// </summary>
/// <param name="productManufacturerId">Product manufacturer mapping identifier</param>
/// <param name="productId">Product identifier</param>
/// <param name="manufacturerId">Manufacturer identifier</param>
/// <param name="isFeaturedProduct">A value indicating whether the product is featured</param>
/// <param name="displayOrder">The display order</param>
/// <returns>Product manufacturer mapping </returns>
public override DBProductManufacturer UpdateProductManufacturer(int productManufacturerId,
int productId, int manufacturerId, bool isFeaturedProduct, int displayOrder)
{
DBProductManufacturer item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_Product_Manufacturer_MappingUpdate");
db.AddInParameter(dbCommand, "ProductManufacturerID", DbType.Int32, productManufacturerId);
db.AddInParameter(dbCommand, "ProductID", DbType.Int32, productId);
db.AddInParameter(dbCommand, "ManufacturerID", DbType.Int32, manufacturerId);
db.AddInParameter(dbCommand, "IsFeaturedProduct", DbType.Boolean, isFeaturedProduct);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetProductManufacturerById(productManufacturerId);
}
return(item);
}
/// <summary>
/// Gets a product manufacturer mapping
/// </summary>
/// <param name="ProductManufacturerID">Product manufacturer mapping identifier</param>
/// <returns>Product manufacturer mapping</returns>
public override DBProductManufacturer GetProductManufacturerByID(int ProductManufacturerID)
{
DBProductManufacturer productManufacturer = null;
if (ProductManufacturerID == 0)
{
return(productManufacturer);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_Product_Manufacturer_MappingLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ProductManufacturerID", DbType.Int32, ProductManufacturerID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
productManufacturer = GetProductManufacturerFromReader(dataReader);
}
}
return(productManufacturer);
}
private static ProductManufacturer DBMapping(DBProductManufacturer dbItem)
{
if (dbItem == null)
return null;
ProductManufacturer item = new ProductManufacturer();
item.ProductManufacturerID = dbItem.ProductManufacturerID;
item.ProductID = dbItem.ProductID;
item.ManufacturerID = dbItem.ManufacturerID;
item.IsFeaturedProduct = dbItem.IsFeaturedProduct;
item.DisplayOrder = dbItem.DisplayOrder;
return item;
}
