Ejemplo n.º 1
0
        /// <summary>
        /// Starts infinite loop to pull and push data. This is executed on a separate thread from within the calling code.
        /// </summary>
        internal void PushData()
        {
            Hashtable objDatasetVersions = new Hashtable();
            string    sErrorMessage      = "";
            PollPush  objPollPush        = new PollPush(UserCredential, ClientID);

            while (true)
            {
                objPollPush.ConnectionString   = ConnectionString;
                objPollPush.PowerBIDatasetName = PowerBIDatasetName;
                objPollPush.IsInitialLoad      = IsIntialLoad;
                objPollPush.datasetId          = datasetId;
                if (TableName.Contains(","))
                {
                    string[] sarrTables = TableName.Split(',');
                    foreach (string sTableName in sarrTables)
                    {
                        objPollPush.CurrentVersion = CurrentVersion[sTableName].ToString();
                        string sColumns = JobDetails.SelectSingleNode("./JobMetadata[@Datasetname='" + sTableName + "']").Attributes["Columns"].Value;

                        sErrorMessage = objPollPush.ValidatePushData(sTableName, sColumns, out RecordsAffected);
                        CurrentVersion[sTableName] = objPollPush.CurrentVersion;
                        if (RefreshJobDetailUI != null)
                        {
                            RefreshJobDetailUI(SelectedRow, sTableName, objPollPush.CurrentVersion, sErrorMessage, RecordsAffected);
                        }
                    }
                }
                else
                {
                    if (CurrentVersion[TableName] != null)
                    {
                        objPollPush.CurrentVersion = CurrentVersion[TableName].ToString();
                        string sColumns = JobDetails.SelectSingleNode("./JobMetadata[@Datasetname='" + TableName + "']").Attributes["Columns"].Value;

                        sErrorMessage             = objPollPush.ValidatePushData(TableName, sColumns, out RecordsAffected);
                        CurrentVersion[TableName] = objPollPush.CurrentVersion;

                        if (RefreshJobDetailUI != null)
                        {
                            RefreshJobDetailUI(SelectedRow, TableName, objPollPush.CurrentVersion, sErrorMessage, RecordsAffected);
                        }
                    }
                }

                Thread.Sleep(Interval * 1000);
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Starts infinite loop to pull and push data. This is executed on a separate thread from within the calling code.
        /// </summary>
        internal void PushData()
        {
            Hashtable objDatasetVersions = new Hashtable();
            string sErrorMessage = "";
            PollPush objPollPush = new PollPush(UserCredential, ClientID);
            while (true)
            {
                objPollPush.ConnectionString = ConnectionString;
                objPollPush.PowerBIDatasetName = PowerBIDatasetName;
                objPollPush.IsInitialLoad = IsIntialLoad;
                objPollPush.datasetId = datasetId;
                if (TableName.Contains(","))
                {
                    string[] sarrTables = TableName.Split(',');
                    foreach (string sTableName in sarrTables)
                    {
                        objPollPush.CurrentVersion = CurrentVersion[sTableName].ToString();
                        string sColumns = JobDetails.SelectSingleNode("./JobMetadata[@Datasetname='" + sTableName + "']").Attributes["Columns"].Value;

                        sErrorMessage = objPollPush.ValidatePushData(sTableName,sColumns, out RecordsAffected);
                        CurrentVersion[sTableName] = objPollPush.CurrentVersion;
                        if (RefreshJobDetailUI != null)
                            RefreshJobDetailUI(SelectedRow, sTableName, objPollPush.CurrentVersion, sErrorMessage, RecordsAffected);
                    }
                }
                else
                {
                    if (CurrentVersion[TableName] != null)
                    {
                        objPollPush.CurrentVersion = CurrentVersion[TableName].ToString();
                        string sColumns = JobDetails.SelectSingleNode("./JobMetadata[@Datasetname='" + TableName + "']").Attributes["Columns"].Value;

                        sErrorMessage = objPollPush.ValidatePushData(TableName, sColumns, out RecordsAffected);
                        CurrentVersion[TableName] = objPollPush.CurrentVersion;

                        if (RefreshJobDetailUI != null)
                            RefreshJobDetailUI(SelectedRow, TableName, objPollPush.CurrentVersion, sErrorMessage, RecordsAffected);
                    }
                }

                Thread.Sleep(Interval * 1000);
            }
        }