DBTool for Oracle - Part 1

using System;
using Harlinn.Oracle.DBTool.Types.Database;
using System.Collections.Generic;

using Harlinn.Oracle.DBTool.Utils;

namespace Harlinn.Oracle.DBTool.Types.Projects
{
    [Serializable]
    public class ProjectTabularReference : ProjectElement
    {
        private string referencedSchema;
        private string referencedTable;
        private bool isLookup;

        public ProjectTabularReference()
        {

        }
        public ProjectTabularReference(ProjectTabularReferences parent, DBUserTableConstraint dbConstraint)
            : base(parent, dbConstraint.Name)
        {
            DBUserTableConstraint referencedConstraint = dbConstraint.GetReferencedConstraint();
            DBUserTable dbReferencedTable = referencedConstraint.Constraints.Table;

            referencedSchema = dbReferencedTable.GetOwner();
            referencedTable = dbReferencedTable.Name;

            GetColumns().AddColumns(dbConstraint, referencedConstraint);
        }

        public override ProjectElementType ElementType
        {
            get
            {
                return ProjectElementType.ProjectTabularReference;
            }
        }


        public override void WriteElement(System.IO.BinaryWriter writer)
        {
            base.WriteElement(writer);

            writer.WriteNullable(ReferencedSchema);
            writer.WriteNullable(ReferencedTable);
            writer.Write(IsLookup);

            ProjectTabularReferenceColumns projectTabularReferenceColumns = GetColumns();
            projectTabularReferenceColumns.WriteElement(writer);

        }

        public override void ReadElement(System.IO.BinaryReader reader)
        {
            base.ReadElement(reader);
            ReferencedSchema = reader.ReadNullableString();
            ReferencedTable = reader.ReadNullableString();
            IsLookup = reader.ReadBoolean();

            Children.Clear();

            ProjectTabularReferenceColumns columns = new ProjectTabularReferenceColumns(this);
            Children.Add(columns);
            columns.ReadElement(reader);

        }



        public override void Refresh()
        {
            base.Refresh();
            Children.Clear();

            ProjectTabularReferenceColumns columns = new ProjectTabularReferenceColumns(this);
            Children.Add(columns);
        }

        public ProjectTabularReferences GetReferences()
        {
            ProjectTabularReferences result = (ProjectTabularReferences)Parent;
            return result;
        }



        public ProjectTabularReferenceColumns GetColumns()
        {
            ProjectTabularReferenceColumns result = GetChildByName<ProjectTabularReferenceColumns>("Columns");
            return result;
        }


        public ProjectTabularReferenceColumn GetColumn(string name)
        {
            return GetColumns().GetColumn(name);
        }


        public string ReferencedSchema
        {
            get
            {
                return referencedSchema;
            }
            set
            {
                if (referencedSchema == value)
                    return;
                referencedSchema = value;
                OnPropertyChanged("ReferencedSchema");
            }
        }
        public string ReferencedTable
        {
            get
            {
                return referencedTable;
            }
            set
            {
                if (referencedTable == value)
                    return;
                referencedTable = value;
                OnPropertyChanged("ReferencedTable");
            }
        }


        public bool IsLookup
        {
            get
            {
                return isLookup;
            }
            set
            {
                if (isLookup == value)
                    return;
                isLookup = value;
            }
        }


        public ProjectTabular GetTabular()
        {
            ProjectTabular result = GetReferences().GetTabular();
            return result;
        }


        public List<ProjectTabularField> GetFieldList()
        {

            List<ProjectTabularField> result = new List<ProjectTabularField>();
            ProjectTabular tabular = GetTabular();

            if (tabular != null)
            {
                ProjectTabularReferenceColumns columns = GetColumns();
                ProjectTabularFields fields = tabular.GetFields();

                foreach (ProjectTabularReferenceColumn column in columns.Children)
                {
                    string columnName = column.Name;
                    ProjectTabularField field = fields.GetField(columnName);
                    if (field != null)
                    {
                        result.Add(field);
                    }
                }
            }

            return result;
        }


    }
}