private static void InsertSetting3(SQLiteCommand command, string environment, string version)
{
command.CommandText = ResourceReader.ReadEmbeddedResource <ConfiguationTestSQLite>("Resources.Insert Setting3.sql");
command.Parameters.Clear();
command.Parameters.Add("@Name", DbType.String, 200);
command.Parameters.Add("@Value", DbType.String, -1);
command.Parameters.Add("@Environment", DbType.String, 50);
command.Parameters.Add("@Version", DbType.String, 50);
foreach (var setting in SettingFactory.ReadSettings())
{
command.Parameters["@Name"].Value = setting.Name.ToString();
command.Parameters["@Value"].Value = setting.Value.ToString().Recode(Encoding.UTF8, Encoding.Default);
command.Parameters["@Environment"].Value = environment;
command.Parameters["@Version"].Value = version;
command.ExecuteNonQuery();
}
}
public static void ResetData()
{
var baseKey = Microsoft.Win32.Registry.CurrentUser;
using (var subKey = baseKey.OpenSubKey(@"Software\SmartConfig", writable: true))
{
if (subKey != null && subKey.GetSubKeyNames().Contains("Tests", StringComparer.OrdinalIgnoreCase))
{
subKey.DeleteSubKeyTree("Tests");
}
}
foreach (var setting in SettingFactory.ReadSettings())
{
//var registryPath = setting.Id.Context.Join("\\");
//var subKeyName = Path.Combine(TestRegistryKey, registryPath);
using (var subKey = baseKey.CreateSubKey(TestRegistryKey, writable: true))
{
subKey.SetValue(setting.Name.ToString(), setting.Value);
}
}
}
