Exemple #1
0
        private Task DetermineRelationshipType(List <RelationshipImportItem> listNew, List <TableDrivedEntityDTO> entities)
        {
            return(Task.Run(() =>
            {
                BizTableDrivedEntity bizTableDrivedEntity = new BizTableDrivedEntity();
                ModelDataHelper dataHelper = new ModelDataHelper();
                Dictionary <string, string> isaKeys = new Dictionary <string, string>();
                foreach (var item in listNew)
                {
                    var pkEntity = entities.First(x => x.Name == item.Relationship.Entity1);
                    var fkEntity = entities.First(x => x.Name == item.Relationship.Entity2);
                    item.Relationship.EntityID1 = pkEntity.ID;
                    item.Relationship.EntityID2 = fkEntity.ID;
                    item.Relationship.Entity1 = pkEntity.Name;
                    item.Relationship.Entity2 = fkEntity.Name;
                    item.Relationship.DatabaseID1 = pkEntity.DatabaseID;
                    item.Relationship.DatabaseID2 = fkEntity.DatabaseID;

                    foreach (var relcol in item.Relationship.RelationshipColumns)
                    {
                        var col1 = pkEntity.Columns.First(x => x.Name == relcol.FirstSideColumn.Name);
                        relcol.FirstSideColumnID = col1.ID;
                        relcol.FirstSideColumn = col1;

                        var col2 = fkEntity.Columns.First(x => x.Name == relcol.SecondSideColumn.Name);
                        relcol.SecondSideColumnID = col2.ID;
                        relcol.SecondSideColumn = col2;
                    }
                    //item.Relationship.RelatesOnPrimaryKeys = bizRelationship.RelatesOnPrimaryKeys(item.Relationship, new List<TableDrivedEntityDTO>() { pkEntity, fkEntity });
                    //item.Relationship.FKCoumnIsNullable = item.Relationship.RelationshipColumns.Any(x => x.SecondSideColumn.IsNull);


                    InfoUpdated(this, new ItemImportingStartedArg()
                    {
                        CurrentProgress = listNew.IndexOf(item) + 1, TotalProgressCount = listNew.Count, ItemName = "Determinig Relationship Type" + " " + item.Relationship.Name
                    });
                    item.Relationship.RelationInfo = dataHelper.GetRelationshipsInfo(item.Relationship, pkEntity, fkEntity);


                    //if (relationInfo.FKRelatesOnPrimaryKey)
                    //{
                    //    //var subEntity = bizTableDrivedEntity.GetTableDrivedEntity(relationship.EntityID2, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
                    //    //if (isaRelationship == null)
                    //    //{
                    //    //    isaRelationship = new Tuple<TableDrivedEntityDTO, List<Tuple<RelationshipDTO, TableDrivedEntityDTO>>>(entity, new List<Tuple<RelationshipDTO, TableDrivedEntityDTO>>() { new Tuple<RelationshipDTO, TableDrivedEntityDTO>(relationship, subEntity) });
                    //    //}
                    //    //else
                    //    //    isaRelationship.Item2.Add(new Tuple<RelationshipDTO, TableDrivedEntityDTO>(relationship, subEntity));
                    //    item.Relationship.TypeEnum = Enum_RelationshipType.SuperToSub;
                    //}
                    //else
                    //{
                    Enum_OrginalRelationshipType originalType = Enum_OrginalRelationshipType.None;
                    if (item.Relationship.FKSidePKColumnsAreFkColumns)
                    {
                        originalType = Enum_OrginalRelationshipType.SuperToSub;
                    }
                    else
                    {
                        if (Database.DBHasData)
                        {
                            if (item.Relationship.RelationInfo.MoreThanOneFkForEachPK == false)
                            {
                                originalType = Enum_OrginalRelationshipType.OneToOne;
                            }
                            else
                            {
                                originalType = Enum_OrginalRelationshipType.OneToMany;
                            }
                        }
                        else
                        {
                            originalType = Enum_OrginalRelationshipType.OneToMany;
                        }
                    }
                    if (originalType == Enum_OrginalRelationshipType.SuperToSub)
                    {
                        item.Relationship.OrginalTypeEnum = Enum_OrginalRelationshipType.SuperToSub;
                        if (isaKeys.ContainsKey(item.Relationship.Entity1))
                        {
                            item.Relationship.OrginalRelationshipGroup = isaKeys[item.Relationship.Entity1];
                        }
                        else
                        {
                            var key = "ISA_OnPK_" + item.Relationship.Entity1;
                            isaKeys.Add(item.Relationship.Entity1, key);
                            item.Relationship.OrginalRelationshipGroup = key;
                        }
                    }
                    else if (originalType == Enum_OrginalRelationshipType.OneToOne)
                    {
                        bool otoCondition = false;
                        if (item.Relationship.RelationInfo.FKHasData == true)
                        {
                            //این شرط جدید اضافه شد. برای اینکه اگر کلید خارجی جزو پرایمری ها باشد معلوم است که ارتباط چند به چند یا مالکیت منظور بوده است
                            if (!item.Relationship.RelationshipColumns.Any(x => x.SecondSideColumn.PrimaryKey))
                            {
                                long relcount = dataHelper.GetRelationDataCount(fkEntity, item.Relationship);
                                if (relcount > 10)
                                {
                                    long fkcount = dataHelper.GetDataCount(fkEntity);
                                    long pkcount = dataHelper.GetDataCount(pkEntity);

                                    long biggerCount = 0;
                                    long smallerCount = 0;
                                    if (fkcount >= pkcount)
                                    {
                                        biggerCount = fkcount;
                                        smallerCount = pkcount;
                                    }
                                    else
                                    {
                                        biggerCount = pkcount;
                                        smallerCount = fkcount;
                                    }
                                    //if (pkcount > relcount)
                                    //{
                                    if (biggerCount > 50000)
                                    {
                                        if (relcount >= biggerCount / 10)
                                        {
                                            otoCondition = true;
                                        }
                                    }
                                    else if (pkcount > 10000)
                                    {
                                        if (relcount >= biggerCount / 5)
                                        {
                                            otoCondition = true;
                                        }
                                    }
                                    else if (pkcount > 2000)
                                    {
                                        if (relcount >= biggerCount / 2.5)
                                        {
                                            otoCondition = true;
                                        }
                                    }
                                    else
                                    {
                                        if (relcount >= biggerCount / 1.5)
                                        {
                                            otoCondition = true;
                                        }
                                    }
                                }
                                //}
                                //else
                                //{
                                //    if(relcount>10)
                                //        otoCondition = true;
                                //}
                            }
                        }
                        if (otoCondition)
                        {
                            item.Relationship.OrginalTypeEnum = Enum_OrginalRelationshipType.OneToOne;
                        }
                        else
                        {
                            item.Relationship.OrginalTypeEnum = Enum_OrginalRelationshipType.OneToMany;
                        }
                    }
                    else
                    {
                        item.Relationship.OrginalTypeEnum = Enum_OrginalRelationshipType.OneToMany;
                    }
                    //}
                }
            }));
        }
Exemple #2
0
        //DatabaseDTO Database { set; get; }
        public void ConvertRelationship(RelationshipDTO relationship, Enum_RelationshipType targetRaltionshipType)
        {
            ModelDataHelper dataHelper       = new ModelDataHelper();
            var             relationshinInfo = dataHelper.GetRelationshipsInfoWithEntityIds(MyProjectManager.GetMyProjectManager.GetRequester(), relationship);

            if (relationship.TypeEnum == Enum_RelationshipType.OneToMany ||
                targetRaltionshipType == Enum_RelationshipType.ManyToOne)
            {
                if (relationshinInfo.FKHasData == true && relationshinInfo.MoreThanOneFkForEachPK == true)
                {
                    throw new Exception("بعلت وجود ارتباط یک به چند بین داده های دو جدول امکان تبدیل وجود ندارد");
                }
            }

            if (targetRaltionshipType == Enum_RelationshipType.OneToMany ||
                targetRaltionshipType == Enum_RelationshipType.ManyToOne ||
                targetRaltionshipType == Enum_RelationshipType.ImplicitOneToOne ||
                targetRaltionshipType == Enum_RelationshipType.ExplicitOneToOne
                )
            {
                bizRelationship.ConvertRelationship(MyProjectManager.GetMyProjectManager.GetRequester(), relationship, targetRaltionshipType);
            }
            else if (targetRaltionshipType == Enum_RelationshipType.SuperToSub)
            {
                // OneToMany , ImplicitOneToOne , UnionToSubUnion_SubUnionHoldsKeys , SubUnionToUnion_UnionHoldsKeys
                var isaRelationships = bizISARelationship.GetISARelationshipsByEntityID(relationship.EntityID1);
                ISARelationshipCreateOrSelect(isaRelationships, relationship, targetRaltionshipType);
            }
            else if (targetRaltionshipType == Enum_RelationshipType.SubToSuper)
            {
                // ManyToOne , ExplicitOneToOne , UnionToSubUnion_UnionHoldsKeys , SubUnionToUnion_SubUnionHoldsKeys
                var isaRelationships = bizISARelationship.GetISARelationshipsByEntityID(relationship.EntityID2);
                ISARelationshipCreateOrSelect(isaRelationships, relationship, targetRaltionshipType);
            }
            else if (targetRaltionshipType == Enum_RelationshipType.SubUnionToUnion)
            {
                // OneToMany , ImplicitOneToOne , SuperToSub , UnionToSubUnion_SubUnionHoldsKeys
                var unionRelationships = bizUnionRelationship.GetUnionRelationshipsBySuperUnionEntity(relationship.EntityID2, true);
                UnionRelationshipCreateOrSelect(unionRelationships, true, relationship, targetRaltionshipType);
            }
            //else if (targetRaltionshipType == Enum_RelationshipType.SubUnionToUnion_SubUnionHoldsKeys)
            //{
            //    // ManyToOne , ExplicitOneToOne , SuperToSub , UnionToSubUnion_UnionHoldsKeys
            //    var unionRelationships = bizUnionRelationship.GetUnionRelationshipsBySuperUnionEntity(relationship.EntityID2, false);
            //    UnionRelationshipCreateOrSelect(unionRelationships, false, relationship, targetRaltionshipType);
            //}
            //else if (targetRaltionshipType == Enum_RelationshipType.UnionToSubUnion_SubUnionHoldsKeys)
            //{
            //    // OneToMany , ImplicitOneToOne , SuperToSub , SubUnionToUnion_UnionHoldsKeys
            //    var unionRelationships = bizUnionRelationship.GetUnionRelationshipsBySuperUnionEntity(relationship.EntityID1, true);
            //    UnionRelationshipCreateOrSelect(unionRelationships, true, relationship, targetRaltionshipType);
            //}
            else if (targetRaltionshipType == Enum_RelationshipType.UnionToSubUnion)
            {
                // ManyToOne , ExplicitOneToOne , SuperToSub , SubUnionToUnion_SubUnionHoldsKeys
                var unionRelationships = bizUnionRelationship.GetUnionRelationshipsBySuperUnionEntity(relationship.EntityID1, false);
                UnionRelationshipCreateOrSelect(unionRelationships, false, relationship, targetRaltionshipType);
            }

            //else if (relationship.TypeEnum == Enum_RelationshipType.ManyToOne)
            //{
            //    if (bizRelationship.RelationshipHasManyData(relationship))
            //    {
            //        throw new Exception("بعلت وجود ارتباط یک به چند بین داده های دو جدول امکان تبدیل وجود ندارد");
            //    }
            //    if (targetRaltionshipType == Enum_RelationshipType.ExplicitOneToOne)
            //        bizRelationship.ConvertManyToOneToExplicit(relationship);
            //    else if (targetRaltionshipType == Enum_RelationshipType.SubToSuper)
            //    {
            //        var isaRelationships = bizISARelationship.GetISARelationships(relationship.EntityID2);
            //        ISARelationshipCreateOrSelect(isaRelationships, relationship, targetRaltionshipType);
            //    }
            //    else if (targetRaltionshipType == Enum_RelationshipType.UnionToSubUnion_UnionHoldsKeys)
            //    {
            //        var unionRelationships = bizUnionRelationship.GetUnionRelationships(relationship.EntityID1, true);
            //        UnionRelationshipCreateOrSelect(unionRelationships, true, relationship, targetRaltionshipType);
            //    }
            //    else if (targetRaltionshipType == Enum_RelationshipType.SubUnionToUnion_SubUnionHoldsKeys)
            //    {
            //        var unionRelationships = bizUnionRelationship.GetUnionRelationships(relationship.EntityID1, false);
            //        UnionRelationshipCreateOrSelect(unionRelationships, false, relationship, targetRaltionshipType);
            //    }

            //}
        }