/// <summary> /// Gets specification attribute option collection /// </summary> /// <param name="specificationAttributeID">Specification attribute unique identifier</param> /// <returns>Specification attribute option collection</returns> public override DBSpecificationAttributeOptionCollection GetSpecificationAttributeOptionsBySpecificationAttributeID(int specificationAttributeID) { DBSpecificationAttributeOptionCollection saoCol = new DBSpecificationAttributeOptionCollection(); if (specificationAttributeID == 0) { return(saoCol); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionLoadBySpecificationAttributeID"); db.AddInParameter(dbCommand, "SpecificationAttributeID", DbType.Int32, specificationAttributeID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBSpecificationAttributeOption sao = GetSpecificationAttributeOptionFromReader(dataReader); saoCol.Add(sao); } } return(saoCol); }
/// <summary> /// Maps a data reader to a specification attribute option /// </summary> /// <param name="dataReader">IDataReader</param> /// <returns>Specification attribute option</returns> private DBSpecificationAttributeOption GetSpecificationAttributeOptionFromReader(IDataReader dataReader) { DBSpecificationAttributeOption specificationAttributeOption = new DBSpecificationAttributeOption(); specificationAttributeOption.SpecificationAttributeOptionID = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeOptionID"); specificationAttributeOption.SpecificationAttributeID = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeID"); specificationAttributeOption.Name = NopSqlDataHelper.GetString(dataReader, "Name"); specificationAttributeOption.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return specificationAttributeOption; }
/// <summary> /// Maps a data reader to a specification attribute option /// </summary> /// <param name="dataReader">IDataReader</param> /// <returns>Specification attribute option</returns> private DBSpecificationAttributeOption GetSpecificationAttributeOptionFromReader(IDataReader dataReader) { var item = new DBSpecificationAttributeOption(); item.SpecificationAttributeOptionId = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeOptionID"); item.SpecificationAttributeId = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return(item); }
/// <summary> /// Maps a data reader to a specification attribute option /// </summary> /// <param name="dataReader">IDataReader</param> /// <returns>Specification attribute option</returns> private DBSpecificationAttributeOption GetSpecificationAttributeOptionFromReader(IDataReader dataReader) { DBSpecificationAttributeOption specificationAttributeOption = new DBSpecificationAttributeOption(); specificationAttributeOption.SpecificationAttributeOptionID = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeOptionID"); specificationAttributeOption.SpecificationAttributeID = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeID"); specificationAttributeOption.Name = NopSqlDataHelper.GetString(dataReader, "Name"); specificationAttributeOption.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return(specificationAttributeOption); }
/// <summary> /// Gets a specification attribute option collection /// </summary> /// <returns>Specification attribute option collection</returns> public override DBSpecificationAttributeOptionCollection GetSpecificationAttributeOptions() { DBSpecificationAttributeOptionCollection saoCol = new DBSpecificationAttributeOptionCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBSpecificationAttributeOption sao = GetSpecificationAttributeOptionFromReader(dataReader); saoCol.Add(sao); } } return(saoCol); }
/// <summary> /// Updates the specification attribute option /// </summary> /// <param name="specificationAttributeOptionId">The specification attribute option identifier</param> /// <param name="specificationAttributeId">The specification attribute identifier</param> /// <param name="name">The name</param> /// <param name="displayOrder">Display order</param> /// <returns>Specification attribute option</returns> public override DBSpecificationAttributeOption UpdateSpecificationAttributeOption(int specificationAttributeOptionId, int specificationAttributeId, string name, int displayOrder) { DBSpecificationAttributeOption item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionUpdate"); db.AddInParameter(dbCommand, "SpecificationAttributeOptionID", DbType.Int32, specificationAttributeOptionId); db.AddInParameter(dbCommand, "SpecificationAttributeID", DbType.Int32, specificationAttributeId); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "DisplayOrder", DbType.String, displayOrder); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetSpecificationAttributeOptionById(specificationAttributeOptionId, 0); } return(item); }
/// <summary> /// Inserts a specification attribute option /// </summary> /// <param name="name">The name</param> /// <param name="displayOrder">Display order</param> /// <returns>Specification attribute option</returns> public override DBSpecificationAttributeOption InsertSpecificationAttributeOption(int specificationAttributeID, string name, int displayOrder) { DBSpecificationAttributeOption sao = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionInsert"); db.AddOutParameter(dbCommand, "SpecificationAttributeOptionID", DbType.Int32, 0); db.AddInParameter(dbCommand, "SpecificationAttributeID", DbType.Int32, specificationAttributeID); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "DisplayOrder", DbType.String, displayOrder); if (db.ExecuteNonQuery(dbCommand) > 0) { int saoID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@SpecificationAttributeOptionID")); sao = GetSpecificationAttributeOptionByID(saoID); } return(sao); }
/// <summary> /// Gets a specification attribute option /// </summary> /// <param name="specificationAttributeOptionID">The specification attribute option identifier</param> /// <returns>Specification attribute option</returns> public override DBSpecificationAttributeOption GetSpecificationAttributeOptionByID(int specificationAttributeOptionID) { DBSpecificationAttributeOption sao = null; if (specificationAttributeOptionID == 0) { return(sao); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionLoadByPrimaryKey"); db.AddInParameter(dbCommand, "SpecificationAttributeOptionID", DbType.Int32, specificationAttributeOptionID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { sao = GetSpecificationAttributeOptionFromReader(dataReader); } } return(sao); }