Ejemplo n.º 1
0
        /// <summary>
        ///     Gets the child related data.
        /// </summary>
        /// <param name="childTableType">Type of the child table.</param>
        /// <param name="relation">The relation.</param>
        /// <returns></returns>
        protected TableMetadata[] GetChildRelatedTableData(Type childTableType, ChildTableRelation relation)
        {
            PersistentObject persistent = null;

            try
            {
                //create a instance of the table so we can check the relations between out table and this
                TableMetadata childTable = (TableMetadata)Activator.CreateInstance(childTableType);

                object value = GetField(relation.ForeignKeyName).fieldValue;

                //we have the relation between the 2 tables.
                persistent = new PersistentObject(this);
                TableMetadata[] data = (TableMetadata[])persistent.GetTableMetadata(relation.RelatedTableName, childTableType, value);

                return(data);
            }
            catch
            {
                throw;
            }
            finally
            {
                if (persistent != null)
                {
                    persistent.Dispose();
                }
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        ///     Returns a DataSet which contains data from the related table
        /// </summary>
        /// <param name="relatedTableName">Name of the related table</param>
        /// <param name="foreignKeyValue">Value of the foreign key</param>
        /// <returns>DataSet containing data from the related table</returns>
        public DataSet GetDataSet(string relatedTableName, object foreignKeyValue)
        {
            SqlGenerator generator = new SqlGenerator();

            DataSet ds = new DataSet();

            ExecutionQuery selectQuery = new ExecutionQuery();

            TableRelation[] relations = mappedObject.Relations;

            for (int i = 0; i < relations.Length; i++)
            {
                if (relations[i].RelatedTableName == relatedTableName.Trim())
                {
                    DatabaseField keyField;

                    //check if we have a ParentRelation or a ChildRelation
                    if (relations[i] is ParentTableRelation)
                    {
                        DatabaseField primaryKeyField = mappedObject.GetPrimaryKeyField();

                        //this is the parent so we select from the child table.
                        keyField = new DatabaseField(primaryKeyField.fieldType, ((ParentTableRelation)relations[i]).ForeignKeyName, false, false, foreignKeyValue);
                    }
                    else
                    {
                        //child relation
                        ChildTableRelation childRelation = (ChildTableRelation)relations[i];

                        //this is the child so get data from the parent
                        keyField = new DatabaseField(mappedObject.GetPrimaryKeyField().fieldType, childRelation.RelatedTableKeyName, true, false, foreignKeyValue);
                    }

                    selectQuery = generator.GenerateSelectQuery(database, relations[i].RelatedTableName, keyField);
                    break;
                }
            }

            if (selectQuery.Query == string.Empty)
            {
                throw new ArgumentException("Invalid relation name");
            }

            //run the query in the associated context
            if (contextSession != null)
            {
                ds = execEngine.ExecuteDataSet(selectQuery);
            }
            else
            {
                using (ExecutionEngine e = new ExecutionEngine())
                {
                    ds = e.ExecuteDataSet(selectQuery);
                }
            }

            return(ds);
        }
Ejemplo n.º 3
0
        /// <summary>
        ///     Get data from a related table (doen't matter if parent of child) based
        ///     on the relation name and the primary key's fieldValue from the related table.
        /// </summary>
        /// <param name="relatedTableName">The name of the related table class name</param>
        /// <param name="classType">Class type of the related TableMetadata entity</param>
        /// <param name="foreignKeyValue">Foreign key's fieldValue</param>
        /// <returns>TableMetadata array which contains the specified data </returns>
        public Array GetTableMetadata(string relatedTableName, Type classType, object foreignKeyValue)
        {
            ArrayList alList = null;

            SqlGenerator generator = new SqlGenerator();

            try
            {
                ExecutionQuery selectQuery = new ExecutionQuery();

                //hold the table's relations.
                TableRelation[] relations = mappedObject.Relations;

                //loop and get the relation

                for (int i = 0; i < relations.Length; i++)
                {
                    if (relations[i].RelatedTableName == relatedTableName.Trim())
                    {
                        DatabaseField keyField;

                        //check if we habe a ParentRelation or a ChildRelation
                        if (relations[i] is ParentTableRelation)
                        {
                            DatabaseField primaryKeyField = mappedObject.GetPrimaryKeyField();

                            //this is the parent so we select from the child table.
                            keyField = new DatabaseField(primaryKeyField.fieldType, ((ParentTableRelation)relations[i]).ForeignKeyName, false, false, foreignKeyValue);
                        }
                        else
                        {
                            //child relation
                            ChildTableRelation childRelation = (ChildTableRelation)relations[i];

                            //this is the child so get data from the parent
                            keyField = new DatabaseField(mappedObject.GetPrimaryKeyField().fieldType, childRelation.RelatedTableKeyName, true, false, foreignKeyValue);
                        }

                        selectQuery = generator.GenerateSelectQuery(database, relations[i].RelatedTableName, keyField);

                        break;
                    }
                }

                if (selectQuery.Query == string.Empty)
                {
                    throw new Exception("Invalid related table name");
                }

                object tableMetadata = Activator.CreateInstance(classType);

                alList = MapDataReaderToTableMetadata(selectQuery, (TableMetadata)tableMetadata);

                Array array = Array.CreateInstance(classType, alList.Count);

                alList.CopyTo(array);

                return(array);
            }
            finally
            {
                if (alList != null)
                {
                    alList.Clear();
                }
            }
        }