|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Text;
using Harlinn.Oracle.DBTool.Types.Database;
namespace Harlinn.Oracle.DBTool.Types.Projects.Design
{
public class SequenceNameEditor : ObjectSelectorEditor
{
protected override void FillTreeWithData(Selector selector, ITypeDescriptorContext theCtx, IServiceProvider theProvider)
{
base.FillTreeWithData(selector, theCtx, theProvider); //clear the selection
ProjectTabularField field = (ProjectTabularField)theCtx.Instance;
ProjectTable projectTable = field.Tabular as ProjectTable;
if (projectTable == null)
{
return;
}
string schemaName = projectTable.SchemaName.ToUpperInvariant();
Model model = Model.Current;
if (model != null)
{
DBDatabase database = model.Database;
if (database != null)
{
DBUsers users = database.Users;
if (users != null)
{
foreach (DBUser user in users.Children)
{
if (schemaName == user.Name.ToUpperInvariant())
{
DBUserSequences sequences = user.Objects.Sequences;
foreach (DBUserSequence sequence in sequences.Children)
{
string qualifiedSequenceName = user.Name.ToUpperInvariant() + "." + sequence.Name.ToUpperInvariant();
SelectorNode sequenceSelectorNode = selector.AddNode(sequence.Name, qualifiedSequenceName, null);
if (qualifiedSequenceName == field.Sequence)
{
selector.SelectedNode = sequenceSelectorNode;
}
}
}
}
}
}
}
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Chief Architect - Sea Surveillance AS.
Specializing in integrated operations and high performance computing solutions.
I’ve been fooling around with computers since the early eighties, I’ve even done work on CP/M and MP/M.
Wrote my first “real” program on a BBC micro model B based on a series in a magazine at that time. It was fun and I got hooked on this thing called programming ...
A few Highlights:
- High performance application server development
- Model Driven Architecture and Code generators
- Real-Time Distributed Solutions
- C, C++, C#, Java, TSQL, PL/SQL, Delphi, ActionScript, Perl, Rexx
- Microsoft SQL Server, Oracle RDBMS, IBM DB2, PostGreSQL
- AMQP, Apache qpid, RabbitMQ, Microsoft Message Queuing, IBM WebSphereMQ, Oracle TuxidoMQ
- Oracle WebLogic, IBM WebSphere
- Corba, COM, DCE, WCF
- AspenTech InfoPlus.21(IP21), OsiSoft PI
More information about what I do for a living can be found at:
harlinn.com or
LinkedIn
You can contact me at
espen@harlinn.no