private DBSetting GetSettingFromReader(IDataReader dataReader)
{
DBSetting setting = new DBSetting();
setting.SettingID = NopSqlDataHelper.GetInt(dataReader, "SettingID");
setting.Name = NopSqlDataHelper.GetString(dataReader, "Name");
setting.Value = NopSqlDataHelper.GetString(dataReader, "Value");
setting.Description = NopSqlDataHelper.GetString(dataReader, "Description");
return(setting);
}
private DBSetting GetSettingFromReader(IDataReader dataReader)
{
var item = new DBSetting();
item.SettingId = NopSqlDataHelper.GetInt(dataReader, "SettingID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.Value = NopSqlDataHelper.GetString(dataReader, "Value");
item.Description = NopSqlDataHelper.GetString(dataReader, "Description");
return(item);
}
/// <summary>
/// Gets all settings
/// </summary>
/// <returns>Setting collection</returns>
public override DBSettingCollection GetAllSettings()
{
DBSettingCollection settingCollection = new DBSettingCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SettingLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBSetting setting = GetSettingFromReader(dataReader);
settingCollection.Add(setting);
}
}
return(settingCollection);
}
/// <summary>
/// Gets a setting
/// </summary>
/// <param name="SettingID">Setting identifer</param>
/// <returns>Setting</returns>
public override DBSetting GetSettingByID(int SettingID)
{
DBSetting setting = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SettingLoadByPrimaryKey");
db.AddInParameter(dbCommand, "SettingID", DbType.Int32, SettingID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
setting = GetSettingFromReader(dataReader);
}
}
return(setting);
}
/// <summary>
/// Updates a setting
/// </summary>
/// <param name="SettingID">Setting identifier</param>
/// <param name="Name">The name</param>
/// <param name="Value">The value</param>
/// <param name="Description">The description</param>
/// <returns>Setting</returns>
public override DBSetting UpdateSetting(int SettingID, string Name, string Value, string Description)
{
DBSetting setting = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SettingUpdate");
db.AddInParameter(dbCommand, "SettingID", DbType.Int32, SettingID);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "Value", DbType.String, Value);
db.AddInParameter(dbCommand, "Description", DbType.String, Description);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
setting = GetSettingByID(SettingID);
}
return(setting);
}
/// <summary>
/// Adds a setting
/// </summary>
/// <param name="name">The name</param>
/// <param name="value">The value</param>
/// <param name="description">The description</param>
/// <returns>Setting</returns>
public override DBSetting AddSetting(string name, string value, string description)
{
DBSetting item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_SettingInsert");
db.AddOutParameter(dbCommand, "SettingID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "Value", DbType.String, value);
db.AddInParameter(dbCommand, "Description", DbType.String, description);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int settingId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@SettingID"));
item = GetSettingById(settingId);
}
return(item);
}
