public int CompareTo(object obj)
        {
            var objTable = (VpaTableViewModel)obj;

            switch (_parentViewModel.SortColumn)
            {
            case "ColumnCardinality":
                return(RowsCount.CompareTo(objTable.RowsCount) * _parentViewModel.SortDirection);

            case "TotalSize":
                return(ColumnsTotalSize.CompareTo(objTable.ColumnsTotalSize) * _parentViewModel.SortDirection);

            case "DictionarySize":
                return(ColumnsDictionarySize.CompareTo(objTable.ColumnsDictionarySize) * _parentViewModel.SortDirection);

            case "DataSize":
                return(ColumnsDataSize.CompareTo(objTable.ColumnsDataSize) * _parentViewModel.SortDirection);

            case "HierarchiesSize":
                return(ColumnsHierarchySize.CompareTo(objTable.ColumnsHierarchySize) * _parentViewModel.SortDirection);

            default:
                return(TableName.CompareTo(objTable.TableName) * _parentViewModel.SortDirection);
            }
        }
Exemple #2
0
        public int CompareTo(object obj)
        {
            var objTable = (VpaTableViewModel)obj;

            switch (SortColumn)
            {
            case "ColumnCardinality":
                return(RowsCount.CompareTo(objTable.RowsCount) * SortDirection);

            case "TotalSize":
                return(TotalSize.CompareTo(objTable.TotalSize) * SortDirection);

            case "DictionarySize":
                return(DictionarySize.CompareTo(objTable.DictionarySize) * SortDirection);

            case "DataSize":
                return(DataSize.CompareTo(objTable.DataSize) * SortDirection);

            case "HierarchiesSize":
                return(HierarchiesSize.CompareTo(objTable.HierarchiesSize) * SortDirection);

            case "TableSize":
                return(TableSize.CompareTo(objTable.TableSize) * SortDirection);

            case "PercentageDatabase":
                return(PercentageDatabase.CompareTo(objTable.PercentageDatabase) * SortDirection);

            case "SegmentsNumber":
                return(SegmentsNumber.CompareTo(objTable.SegmentsNumber) * SortDirection);

            case "PartitionsNumber":
                return(PartitionsNumber.CompareTo(objTable.PartitionsNumber) * SortDirection);

            case "ColumnsNumber":
                return(ColumnsNumber.CompareTo(objTable.ColumnsNumber) * SortDirection);

            case "ReferentialIntegrityViolationCount":
                return(ReferentialIntegrityViolationCount.CompareTo(objTable.ReferentialIntegrityViolationCount) * SortDirection);

            case "UserHierarchiesSize":
                return(UserHierarchiesSize.CompareTo(objTable.UserHierarchiesSize) * SortDirection);

            case "RelationshipSize":
                return(RelationshipSize.CompareTo(objTable.RelationshipSize) * SortDirection);

            case "RowsCount":
                return(RowsCount.CompareTo(objTable.RowsCount) * SortDirection);

            case "MissingKeys":
                return(RelationshipFromMissingKeys.CompareTo(objTable.RelationshipFromMissingKeys) * SortDirection);

            case "FromColumnCardinality":
                return(RelationshipMaxFromCardinality.CompareTo(objTable.RelationshipMaxFromCardinality) * SortDirection);

            case "ToColumnCardinality":
                return(RelationshipMaxToCardinality.CompareTo(objTable.RelationshipMaxToCardinality) * SortDirection);

            case "InvalidRows":
                return(RelationshipInvalidRows.CompareTo(objTable.RelationshipInvalidRows) * SortDirection);

            case "UsedSize":
                return(RelationshipSize.CompareTo(objTable.RelationshipSize) * SortDirection);

            default:
                return(TableName.CompareTo(objTable.TableName) * SortDirection);
            }
        }
 public int CompareTo(EntityTable other)
 {
     return((other == null)? +1:TableName.CompareTo(other.TableName));
 }