public void PasteUdListRowCommand()
        {
            try
            {
                UdListColumnMetaDataList.Sort(delegate(ColumnMetaData c1, ColumnMetaData c2)
                                              { return(c1.Order.CompareTo(c2.Order)); });

                char[] rowSplitter    = { '\r', '\n' };
                char[] columnSplitter = { '\t' };
                //get the text from clipboard
                IDataObject dataInClipboard   = Clipboard.GetDataObject();
                string      stringInClipboard = (string)dataInClipboard.GetData(DataFormats.Text);
                //split it into rows...
                string[] rowsInClipboard = stringInClipboard.Split(rowSplitter, StringSplitOptions.RemoveEmptyEntries);

                foreach (string row in rowsInClipboard)
                {
                    NewUdListCommand(""); //this will generate a new udList and set it as the selected udList...
                    //split row into cell values
                    string[] valuesInRow = row.Split(columnSplitter);
                    int      i           = 0;
                    foreach (string columnValue in valuesInRow)
                    {
                        SelectedUdList.SetPropertyValue(UdListColumnMetaDataList[i].Name, columnValue);
                        i++;
                    }
                }
            }
            catch (Exception ex)
            {
                NotifyMessage(ex.InnerException.ToString());
            }
        }
        private void SelectedUdList_PropertyChanged(object sender, PropertyChangedEventArgs e)
        {
            //these properties are not to be persisted we will igore them...
            if (e.PropertyName == "IsSelected" ||
                e.PropertyName == "IsExpanded" ||
                e.PropertyName == "IsValid" ||
                e.PropertyName == "NotValidMessage" ||
                e.PropertyName == "LastModifiedBy" ||
                e.PropertyName == "LastModifiedByDate")
            {
                return;
            }

            //Key ID Logic...
            if (e.PropertyName == "UdListID")
            {//make sure it is has changed...
                if (SelectedUdListMirror.UdListID != SelectedUdList.UdListID)
                {
                    //if their are no records it is a key change
                    if (UdListList != null && UdListList.Count == 0 &&
                        SelectedUdList != null && !string.IsNullOrEmpty(SelectedUdList.UdListID))
                    {
                        ChangeKeyLogic();
                        return;
                    }

                    EntityStates entityState = GetUdListState(SelectedUdList);

                    if (entityState == EntityStates.Unchanged ||
                        entityState == EntityStates.Modified)
                    {
                        if (Dirty && AllowCommit)
                        {
                            NotifySaveRequired("Do you want to save changes?", _saveRequiredResultActions.ChangeKeyLogic);
                        }
                        else
                        {
                            ChangeKeyLogic();
                        }

                        return;
                    }
                }
            }//end KeyID logic...

            object propertyChangedValue = SelectedUdList.GetPropertyValue(e.PropertyName);
            object prevPropertyValue    = SelectedUdListMirror.GetPropertyValue(e.PropertyName);
            string propertyType         = SelectedUdList.GetPropertyType(e.PropertyName);
            //in some instances the value is not really changing but yet it still is tripping property change..
            //This will ensure that the field has physically been modified...
            //As well when we revert back it constitutes a property change but they will be = and it will bypass the logic...
            bool objectsAreEqual;

            if (propertyChangedValue == null)
            {
                if (prevPropertyValue == null)
                {
                    objectsAreEqual = true;
                }
                else//only one value is null
                {
                    objectsAreEqual = false;
                }
            }
            else
            {
                if (prevPropertyValue == null)//only one value is null
                {
                    objectsAreEqual = false;
                }
                else //both values are not null use .Equals...
                {
                    objectsAreEqual = propertyChangedValue.Equals(prevPropertyValue);
                }
            }
            if (!objectsAreEqual)
            {
                //Here we do property change validation if false is returned we will reset the value
                //Back to its mirrored value and return out of the property change w/o updating the repository...
                if (UdListPropertyChangeIsValid(e.PropertyName, propertyChangedValue, prevPropertyValue, propertyType))
                {
                    Update(SelectedUdList);
                    //set the mirrored objects field...
                    SelectedUdListMirror.SetPropertyValue(e.PropertyName, propertyChangedValue);
                    SelectedUdListMirror.IsValid         = SelectedUdList.IsValid;
                    SelectedUdListMirror.IsExpanded      = SelectedUdList.IsExpanded;
                    SelectedUdListMirror.NotValidMessage = SelectedUdList.NotValidMessage;
                }
                else
                {//revert back to its previous value...
                    SelectedUdList.SetPropertyValue(e.PropertyName, prevPropertyValue);
                    SelectedUdList.IsValid         = SelectedUdListMirror.IsValid;
                    SelectedUdList.IsExpanded      = SelectedUdListMirror.IsExpanded;
                    SelectedUdList.NotValidMessage = SelectedUdListMirror.NotValidMessage;
                    return;
                }
            }
        }