/// <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>
/// Gets specification attribute option collection
/// </summary>
/// <param name="specificationAttributeId">Specification attribute unique identifier</param>
/// <param name="languageId">Language identifier</param>
/// <returns>Specification attribute option collection</returns>
public override DBSpecificationAttributeOptionCollection GetSpecificationAttributeOptionsBySpecificationAttributeId(int specificationAttributeId, int languageId)
{
var result = new DBSpecificationAttributeOptionCollection();
if (specificationAttributeId == 0)
{
return(result);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionLoadBySpecificationAttributeID");
db.AddInParameter(dbCommand, "SpecificationAttributeID", DbType.Int32, specificationAttributeId);
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
var item = GetSpecificationAttributeOptionFromReader(dataReader);
result.Add(item);
}
}
return(result);
}
/// <summary>
/// Gets specification attribute option collection
/// </summary>
/// <returns>Specification attribute option collection</returns>
public static SpecificationAttributeOptionCollection GetSpecificationAttributeOptions()
{
DBSpecificationAttributeOptionCollection dbCollection = DBProviderManager <DBSpecificationAttributeProvider> .Provider.GetSpecificationAttributeOptions();
SpecificationAttributeOptionCollection specificationAttributeOptions = DBMapping(dbCollection);
return(specificationAttributeOptions);
}
/// <summary>
/// Maps a DBSpecificationAttributeOptionCollection to a SpecificationAttributeOptionCollections
/// </summary>
/// <param name="dbCollection">DBSpecificationAttributeOptionCollection</param>
/// <returns>SpecificationAttributeOptionCollection</returns>
private static SpecificationAttributeOptionCollection DBMapping(DBSpecificationAttributeOptionCollection dbCollection)
{
if (dbCollection == null)
{
return(null);
}
SpecificationAttributeOptionCollection collection = new SpecificationAttributeOptionCollection();
foreach (DBSpecificationAttributeOption dbItem in dbCollection)
{
SpecificationAttributeOption item = DBMapping(dbItem);
collection.Add(item);
}
return(collection);
}
/// <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>
/// 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>
/// 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;
}
