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