/// <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); } } }