コード例 #1
0
        private void UpdateValidityAssesment(bool actuallyDoIt = false)
        {
            ragSmiley1.Reset();
            try
            {
                var fks = new ColumnInfo[] { fk1.SelectedColumn, fk2.SelectedColumn, fk3.SelectedColumn }.Where(f => f != null).ToArray();
                var pks = new ColumnInfo[] { pk1.SelectedColumn, pk2.SelectedColumn, pk3.SelectedColumn }.Where(p => p != null).ToArray();

                if (fk1.SelectedColumn == null || pk1.SelectedColumn == null)
                {
                    throw new Exception("You must specify at least one pair of keys to join on, do this by dragging columns out of the collection into the key boxes");
                }

                if (
                    ((pk2.SelectedColumn == null) != (fk2.SelectedColumn == null))
                    ||
                    ((pk3.SelectedColumn == null) != (fk3.SelectedColumn == null)))
                {
                    throw new Exception("You must have the same number of primary and foregin keys (they must come in pairs)");
                }

                if (pks.Any(p => p.TableInfo_ID != _leftTableInfo.ID))
                {
                    throw new Exception("All Primary Keys must come from the Left hand TableInfo");
                }

                if (fks.Any(f => f.TableInfo_ID != _rightTableInfo.ID))
                {
                    throw new Exception("All Foreign Keys must come from the Right hand TableInfo");
                }


                ExtractionJoinType joinType;
                if (rbAllLeftHandTableRecords.Checked)
                {
                    joinType = ExtractionJoinType.Right; //confusing I know, basically JoinInfo database record has fk,pk and direction field assuming fk joins via that direction to pk which is the opposite to the layout of this form
                }
                else
                if (rbAllRightHandTableRecords.Checked)
                {
                    joinType = ExtractionJoinType.Left;
                }
                else if (rbJoinInner.Checked)
                {
                    joinType = ExtractionJoinType.Inner;
                }
                else
                {
                    throw new Exception("You must select an Extraction Join direction");
                }

                var cataRepo = _leftTableInfo.CatalogueRepository;

                for (int i = 0; i < pks.Length; i++)
                {
                    if (cataRepo.GetAllObjects <JoinInfo>().Any(j => j.PrimaryKey_ID == pks[i].ID && j.ForeignKey_ID == fks[i].ID))
                    {
                        throw new Exception("Join already exists between " + fks[i] + " and " + pks[i].ID);
                    }
                }


                if (actuallyDoIt)
                {
                    for (int i = 0; i < pks.Length; i++)
                    {
                        new JoinInfo(cataRepo, fks[i], pks[i], joinType, tbCollation.Text);
                    }

                    MessageBox.Show("Successfully Created Joins");
                    Activator.RefreshBus.Publish(this, new RefreshObjectEventArgs(_leftTableInfo));

                    foreach (KeyDropLocationUI ui in new[] { pk1, pk2, pk3, fk1, fk2, fk3 })
                    {
                        ui.Clear();
                    }
                }
                else
                {
                    btnCreateJoinInfo.Enabled = true;
                }
            }
            catch (Exception ex)
            {
                btnCreateJoinInfo.Enabled = false;
                ragSmiley1.Fatal(ex);
            }
        }