public void PasteRowCommand()
        {
            try
            {
                ExecutableProgramCodeColumnMetaDataList.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)
                {
                    NewExecutableProgramCodeCommand(""); //this will generate a new itemCode and set it as the selected itemCode...
                    //split row into cell values
                    string[] valuesInRow = row.Split(columnSplitter);
                    int      i           = 0;
                    foreach (string columnValue in valuesInRow)
                    {
                        SelectedExecutableProgramCode.SetPropertyValue(ExecutableProgramCodeColumnMetaDataList[i].Name, columnValue);
                        i++;
                    }
                }
            }
            catch (Exception ex)
            {
                NotifyMessage(ex.InnerException.ToString());
            }
        }
        private void SelectedExecutableProgramCode_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 == "ExecutableProgramCodeID")
            {//make sure it is has changed...
                if (SelectedExecutableProgramCodeMirror.ExecutableProgramCodeID != SelectedExecutableProgramCode.ExecutableProgramCodeID)
                {
                    //if their are no records it is a key change
                    if (ExecutableProgramCodeList != null && ExecutableProgramCodeList.Count == 0 &&
                        SelectedExecutableProgramCode != null && !string.IsNullOrEmpty(SelectedExecutableProgramCode.ExecutableProgramCodeID))
                    {
                        ChangeKeyLogic();
                        return;
                    }

                    EntityStates entityState = GetExecutableProgramCodeState(SelectedExecutableProgramCode);

                    if (entityState == EntityStates.Unchanged ||
                        entityState == EntityStates.Modified)
                    {                             //once a key is added it can not be modified...
                        if (Dirty && AllowCommit) //dirty record exists ask if save is required...
                        {
                            NotifySaveRequired("Do you want to save changes?", _saveRequiredResultActions.ChangeKeyLogic);
                        }
                        else
                        {
                            ChangeKeyLogic();
                        }

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

            object propertyChangedValue = SelectedExecutableProgramCode.GetPropertyValue(e.PropertyName);
            object prevPropertyValue    = SelectedExecutableProgramCodeMirror.GetPropertyValue(e.PropertyName);
            string propertyCode         = SelectedExecutableProgramCode.GetPropertyCode(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)//both values are 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 (ExecutableProgramCodePropertyChangeIsValid(e.PropertyName, propertyChangedValue, prevPropertyValue, propertyCode))
                {
                    Update(SelectedExecutableProgramCode);
                    SelectedExecutableProgramCodeMirror.SetPropertyValue(e.PropertyName, propertyChangedValue);
                    SelectedExecutableProgramCodeMirror.IsValid         = SelectedExecutableProgramCode.IsValid;
                    SelectedExecutableProgramCodeMirror.IsExpanded      = SelectedExecutableProgramCode.IsExpanded;
                    SelectedExecutableProgramCodeMirror.NotValidMessage = SelectedExecutableProgramCode.NotValidMessage;
                }
                else//revert back to its previous value...
                {
                    SelectedExecutableProgramCode.SetPropertyValue(e.PropertyName, prevPropertyValue);
                    SelectedExecutableProgramCode.IsValid         = SelectedExecutableProgramCodeMirror.IsValid;
                    SelectedExecutableProgramCode.IsExpanded      = SelectedExecutableProgramCodeMirror.IsExpanded;
                    SelectedExecutableProgramCode.NotValidMessage = SelectedExecutableProgramCodeMirror.NotValidMessage;
                }
            }
        }