/// <summary>
        /// Gets values from Hansoft and updates data model.
        /// </summary>
        private void UpdateRow(HPMUniqueID taskID, HPMUniqueID projectID, HPMWIColumn column, DataRow drow, bool isForDisplay)
        {
            // get values for multi choice columns by their respective methods...
            string id = Convert.ToString((HPMUInt32)column.Column.m_ColumnID);
            if (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.BugPriority)
            {
                drow[id] = Convert.ToInt32(m_VirtSession.TaskGetAgilePriorityCategory(taskID));
            }
            else if (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.Risk)
            {
                drow[id] = Convert.ToInt32(m_VirtSession.TaskGetRisk(taskID));
            }
            else if (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.Severity)
            {
                drow[id] = Convert.ToInt32(m_VirtSession.TaskGetSeverity(taskID));
            }
            else if (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.Confidence)
            {
                drow[id] = Convert.ToInt32(m_VirtSession.TaskGetConfidence(taskID));
            }
            else if ((column.Column.m_ColumnType == EHPMColumnType.CustomColumn) && (column.Type == (int)EHPMProjectCustomColumnsColumnType.DropList))
            {
                string value = m_VirtSession.TaskGetCustomColumnData(taskID, (uint)column.Column.m_ColumnID);
                if (value == "")
                    drow[id] = 0;
                else
                    drow[id] = Convert.ToInt32(value);
            }
            else
            {
                // and use TaskRefGetColumnText to get formatted value for remaining columns
                HPMColumnTextOptions options = new HPMColumnTextOptions();
                options.m_bExpandResources = false;
                options.m_bDisplayUnits = isForDisplay;
                options.m_bForDisplay = isForDisplay;
                options.m_bMyWork = false;
                options.m_bNeedFullProjectPath = false;
                options.m_bOnlyFirstResource = false;
                options.m_bNeedSprintInSubProjectPath = false;
                options.m_bSeparateSubProjectPath = false;

                HPMUniqueID taskrefid = m_VirtSession.TaskGetMainReference(taskID);

                HPMString value = m_VirtSession.TaskRefGetColumnText(taskrefid, column.Column, options);
                drow[id] = value;
            }

        }
 private bool IsNumericColumn(HPMWIColumn column)
 {
     if ((column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.DatabaseID) || (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.ID) || (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.BugPriority) ||
         (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.Risk) || (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.Severity) || (column.Column.m_ColumnID == (int)EHPMProjectDefaultColumn.Confidence))
     {
         return true;
     }
     else if ((column.Column.m_ColumnType == EHPMColumnType.CustomColumn) && (column.Type == (int)EHPMProjectCustomColumnsColumnType.DropList))
         return true;
     return false;
 }