private DBProductTemplate GetProductTemplateFromReader(IDataReader dataReader)
{
DBProductTemplate productTemplate = new DBProductTemplate();
productTemplate.ProductTemplateID = NopSqlDataHelper.GetInt(dataReader, "ProductTemplateID");
productTemplate.Name = NopSqlDataHelper.GetString(dataReader, "Name");
productTemplate.TemplatePath = NopSqlDataHelper.GetString(dataReader, "TemplatePath");
productTemplate.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
productTemplate.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
productTemplate.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn");
return(productTemplate);
}
private DBProductTemplate GetProductTemplateFromReader(IDataReader dataReader)
{
var item = new DBProductTemplate();
item.ProductTemplateId = NopSqlDataHelper.GetInt(dataReader, "ProductTemplateID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.TemplatePath = NopSqlDataHelper.GetString(dataReader, "TemplatePath");
item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
item.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn");
return(item);
}
/// <summary>
/// Deletes a product template
/// </summary>
/// <param name="ProductTemplateID">Product template identifier</param>
public override void DeleteProductTemplate(int ProductTemplateID)
{
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DBProductTemplate productTemplate = GetProductTemplateByID(ProductTemplateID);
if (productTemplate != null)
{
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTemplateDelete");
db.AddInParameter(dbCommand, "ProductTemplateID", DbType.Int32, ProductTemplateID);
int retValue = db.ExecuteNonQuery(dbCommand);
}
}
/// <summary>
/// Gets all product templates
/// </summary>
/// <returns>Product template collection</returns>
public override DBProductTemplateCollection GetAllProductTemplates()
{
DBProductTemplateCollection productTemplateCollection = new DBProductTemplateCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTemplateLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBProductTemplate productTemplate = GetProductTemplateFromReader(dataReader);
productTemplateCollection.Add(productTemplate);
}
}
return(productTemplateCollection);
}
/// <summary>
/// Inserts a product template
/// </summary>
/// <param name="name">The name</param>
/// <param name="templatePath">The template path</param>
/// <param name="displayOrder">The display order</param>
/// <param name="createdOn">The date and time of instance creation</param>
/// <param name="updatedOn">The date and time of instance update</param>
/// <returns>Product template</returns>
public override DBProductTemplate InsertProductTemplate(string name, string templatePath,
int displayOrder, DateTime createdOn, DateTime updatedOn)
{
DBProductTemplate item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTemplateInsert");
db.AddOutParameter(dbCommand, "ProductTemplateID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "TemplatePath", DbType.String, templatePath);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, updatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int productTemplateId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@ProductTemplateID"));
item = GetProductTemplateById(productTemplateId);
}
return(item);
}
/// <summary>
/// Inserts a product template
/// </summary>
/// <param name="Name">The name</param>
/// <param name="TemplatePath">The template path</param>
/// <param name="DisplayOrder">The display order</param>
/// <param name="CreatedOn">The date and time of instance creation</param>
/// <param name="UpdatedOn">The date and time of instance update</param>
/// <returns>Product template</returns>
public override DBProductTemplate InsertProductTemplate(string Name, string TemplatePath,
int DisplayOrder, DateTime CreatedOn, DateTime UpdatedOn)
{
DBProductTemplate productTemplate = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTemplateInsert");
db.AddOutParameter(dbCommand, "ProductTemplateID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "TemplatePath", DbType.String, TemplatePath);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn);
db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, UpdatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int ProductTemplateID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@ProductTemplateID"));
productTemplate = GetProductTemplateByID(ProductTemplateID);
}
return(productTemplate);
}
/// <summary>
/// Gets a product template
/// </summary>
/// <param name="productTemplateId">Product template identifier</param>
/// <returns>Product template</returns>
public override DBProductTemplate GetProductTemplateById(int productTemplateId)
{
DBProductTemplate item = null;
if (productTemplateId == 0)
{
return(item);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTemplateLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ProductTemplateID", DbType.Int32, productTemplateId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetProductTemplateFromReader(dataReader);
}
}
return(item);
}
