/// <summary>
/// Sets the settings.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="Settings">The settings.</param>
/// <remarks>Documented by Dev08, 2009-01-09</remarks>
public void SetSettings(int id, MLifter.DAL.Interfaces.ISettings Settings)
{
throw new NotAllowedInDbModeException();
//using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
//{
// cmd.CommandText = "UPDATE \"Cards\" SET settings_id=@value WHERE id=@id";
// cmd.Parameters.Add("@id", id);
// cmd.Parameters.Add("@value", (Settings as DbSettings).Id);
// MSSQLCEConn.ExecuteNonQuery(cmd);
//}
}
public void SetSettings(int id, MLifter.DAL.Interfaces.ISettings Settings)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "UPDATE \"Chapters\" SET settings_id=:value WHERE id=:id";
cmd.Parameters.Add("id", id);
cmd.Parameters.Add("value", (Settings as DbSettings).Id);
PostgreSQLConn.ExecuteNonQuery(cmd, Parent.CurrentUser);
}
}
}
