/// <summary>
/// get DataProtectionKey by FriendlyName
/// </summary>
/// <param name="friendlyName">Friendly Name</param>
/// <returns></returns>
public DataProtectionKey GetElement(string friendlyName)
{
using (var con = new Npgsql.NpgsqlConnection(_connectionString))
{
var sql = @"select ""FriendlyName"",""XmlData"" from public.""DataProtectionKeys"" where ""FriendlyName""=@FriendlyName;";
using (var cmd = new Npgsql.NpgsqlCommand(sql, con))
{
DataProtectionKey dataProtectionKey = null;
cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@FriendlyName", friendlyName));
con.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
dataProtectionKey = new DataProtectionKey();
dataProtectionKey.FriendlyName = reader.GetString(0);
dataProtectionKey.XmlData = reader.GetString(1);
}
reader.Close();
}
con.Close();
return(dataProtectionKey);
}
}
}
public bool Update(DataProtectionKey dataProtectionKey)
{
using (var con = new Npgsql.NpgsqlConnection(_connectionString))
{
var sql = @"update public.""DataProtectionKeys"" set ""XmlData""=@XmlData where ""FriendlyName""=@FriendlyName;";
using (var cmd = new Npgsql.NpgsqlCommand(sql, con))
{
cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@FriendlyName", dataProtectionKey.FriendlyName));
cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@XmlData", dataProtectionKey.XmlData));
con.Open();
var result = cmd.ExecuteNonQuery() > 0;
con.Close();
return(result);
}
}
}
/// <summary>
/// add dataProtectionKey
/// </summary>
/// <param name="dataProtectionKey">Data Protection Key</param>
/// <returns></returns>
public bool Add(DataProtectionKey dataProtectionKey)
{
using (var con = new Npgsql.NpgsqlConnection(_connectionString))
{
var sql = @"INSERT INTO public.""DataProtectionKeys""(""FriendlyName"", ""XmlData"") VALUES(@FriendlyName, @XmlData);";
using (var cmd = new Npgsql.NpgsqlCommand(sql, con))
{
cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@FriendlyName", dataProtectionKey.FriendlyName));
cmd.Parameters.Add(new Npgsql.NpgsqlParameter("@XmlData", dataProtectionKey.XmlData));
con.Open();
var result = cmd.ExecuteNonQuery() > 0;
con.Close();
return(result);
}
}
}
