Client Multi-Threading?

[rosshughes]

There have been times I have needed to open up an XLS file or process a BAQ grid in a client module to process some data. I realize that there are other tools (DMT, BPM, SC, etc.) to get jobs done so not really looking for other avenues…just learning about client side processing.

Whether I am calling updatable BAQ’s or objects/methods, during the iteration process it locks up the epicor session while processing. Is there a way to avoid this with some kind of multi-threading option or is this the way Epicor client processing works and the best approach is two sessions for these circumstances?

I saw this post and it looks related.

E10 BPM Threading

One reminder - SQL Server does NOT allow threading on the same connection. This means standing up new connections in a suppressed transaction - so no roll backs. There are a LOT of implications when you start digging into multiple threads so be MASSIVELY careful. The basis of a lot of server code - in general not just E10 or .NET - is single threaded and for a reason. e.g. - nodejs is a single thread.

Thanks for any thoughts,
Ross

[Aaron_Moreng]

I assume the task you’re trying to accomplish is to free up the UI thread. I’ve done this utilizing a client customization and an old school BackgroundWorker class in a custom form. Not sure if it is exactly what you’re asking but maybe it will help a little

  
// **************************************************
// Custom code for UD01Form
// Created: 6/1/2018 12:10:31 PM
// **************************************************
using System;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using Ice.BO;
using Ice.UI;
using Ice.Lib;
using Ice.Adapters;
using Ice.Lib.Customization;
using Ice.Lib.ExtendedProps;
using Ice.Lib.Framework;
using Ice.Lib.Searches;
using Ice.UI.FormFunctions;
using Infragistics.Win.UltraWinToolbars;
using Infragistics.Win.UltraWinGrid.ExcelExport;
using Ice.Proxy.Lib;
using Ice.Core;
using Ice.Tablesets;
using System.Collections;
using System.Text;
using System.ComponentModel;
using System.Linq;

public class Script
{
	// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **
	// Begin Wizard Added Module Level Variables **

	// End Wizard Added Module Level Variables **

	// Add Custom Module Level Variables Here **
	DataTable dtInput = new DataTable();
	private EpiDataView edvInput;
	
	private StringBuilder builder;
	private BackgroundWorker worker;
	private System.Windows.Forms.ProgressBar pbProgress;
	private int totalRecCount = 0;

	public void InitializeCustomCode()
	{
		// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
		// Begin Wizard Added Variable Initialization

		// End Wizard Added Variable Initialization

		// Begin Wizard Added Custom Method Calls

		this.grdInput.InitializeLayout += new Infragistics.Win.UltraWinGrid.InitializeLayoutEventHandler(this.grdInput_InitializeLayout);
		this.btnProcesss.Click += new System.EventHandler(this.btnProcesss_Click);
		this.btnClear.Click += new System.EventHandler(this.btnClear_Click);
		// End Wizard Added Custom Method Calls
		dtInput.Columns.Add("Donor",typeof(string));
		dtInput.Columns.Add("OPO Name", typeof(string));
		dtInput.Columns.Add("OPO Donor Number", typeof(string));	
		
		edvInput = new EpiDataView();
		edvInput.dataView = dtInput.DefaultView;
		oTrans.Add("edvInput", edvInput);
	
		grdInput.EpiAllowPaste = true;
		grdInput.EpiAllowPasteInsert = true;
		//grdInput.InsertNewRowAfterLastRow = true;
	
		builder = new StringBuilder();
		SetUpPB();
	
		this.worker = new BackgroundWorker();
		this.worker.DoWork += new DoWorkEventHandler(this.worker_DoWork);
		this.worker.ProgressChanged += new ProgressChangedEventHandler(this.worker_ProgressChanged);
		this.worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(this.worker_RunWorkerCompleted);
		this.worker.WorkerReportsProgress = true;
		this.worker.WorkerSupportsCancellation = false;
	}

	public void DestroyCustomCode()
	{
		// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
		// Begin Wizard Added Object Disposal
		this.grdInput.InitializeLayout -= new Infragistics.Win.UltraWinGrid.InitializeLayoutEventHandler(this.grdInput_InitializeLayout);
		this.btnProcesss.Click -= new System.EventHandler(this.btnProcesss_Click);
		this.btnClear.Click -= new System.EventHandler(this.btnClear_Click);
		// End Wizard Added Object Disposal

		// Begin Custom Code Disposal

		// End Custom Code Disposal
		pbProgress.Dispose();
		pbProgress=null;
	
		this.worker.DoWork -= new DoWorkEventHandler(this.worker_DoWork);
		this.worker.ProgressChanged -= new ProgressChangedEventHandler(this.worker_ProgressChanged);
		this.worker.RunWorkerCompleted -= new RunWorkerCompletedEventHandler(this.worker_RunWorkerCompleted);
		
	}

	private void SetUpPB()
	{
		pbProgress = new System.Windows.Forms.ProgressBar();
		//Draw a textbox where you'd like the PB to be and get its Location from there then remove textbox
		pbProgress.Location = new System.Drawing.Point(14, 335);
		pbProgress.Name = "pbProgress";
		//Draw a TextBox where you'd like the PB to be and get its Size from there then remove textbox
		pbProgress.Size = new System.Drawing.Size(688, 20);
		//Get a Hold of the Parent Container where you'd like the PB to be
		Ice.UI.App.UD01Entry.DetailPanel pnl =(Ice.UI.App.UD01Entry.DetailPanel)csm.GetNativeControlReference("d5488fbc-e47b-46b6-aa3e-9ab7d923315a");		
		//Add PB to the above container
		pnl.Controls.Add(pbProgress);
	}	

	private void UD01Form_Load(object sender, EventArgs args)
	{
		// Add Event Handler Code
		// Hide Native Toolbar Controls 
		baseToolbarsManager.Tools["NewTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["RefreshTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["DeleteTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["SaveTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["EditMenu"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["HelpMenu"].SharedProps.Visible=false;	
		baseToolbarsManager.Tools["ToolsMenu"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["ActionsMenu"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["FileMenu"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["AttachmentTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["ClearTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["CopyTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["CutTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["PasteTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["UndoTool"].SharedProps.Visible=false;
		baseToolbarsManager.Tools["PrimarySearchTool"].SharedProps.Visible=false;

		dtInput.Clear();
		
		txtProgress.Text = builder.ToString();
	}

	private void grdInput_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs args)
	{
		// ** Place Event Handling Code Here **
		grdInput.EpiAllowPaste = true;
		grdInput.EpiAllowPasteInsert = true;
		grdInput.InsertNewRowAfterLastRow = false;
	}



	private void worker_DoWork(object sender, DoWorkEventArgs e)
    {
		//sender is BackgoundWorker
		//this is where the background operation goes
		using(UD100Adapter adapterUD100 = new UD100Adapter(oTrans))
		{
			adapterUD100.BOConnect();	
			builder.Append("Start Process...").AppendLine();	
			
			//foreach(DataRow dr in dtInput.Rows)		
			for(int i = 0; i<dtInput.Rows.Count; i++)		
			{
				var dr = dtInput.Rows[i];
				string whereClause = string.Format("Key1 like '{0}-%'", dr["Donor"].ToString());
				//start log
				builder.Append(string.Format("Looking up Donor {0}...", dr["Donor"].ToString())).AppendLine();		

				//the Hashtable stores the runtime search criteria
				System.Collections.Hashtable wcs = new Hashtable(1);
				wcs.Clear();	
				wcs.Add("UD100", whereClause);
				Ice.Lib.Searches.SearchOptions opts = Ice.Lib.Searches.SearchOptions.CreateRuntimeSearch(wcs, Ice.Lib.Searches.DataSetMode.RowsDataSet);	   
				adapterUD100.InvokeSearch(opts);
				
				int rowCount = adapterUD100.UD100Data.UD100.Rows.Count;
				if(rowCount>0)	
				{	
					foreach(DataRow udRow in adapterUD100.UD100Data.UD100.Rows)
					{	
						//modify here
						udRow.BeginEdit();
						udRow["Character04"] = dr["OPO Name"];
						udRow["Character05"] = dr["OPO Donor Number"];
						udRow["RowMod"] = "U";
						udRow.EndEdit();
						//update log
						builder.Append(string.Format("{0}: Success!", udRow["Key1"].ToString())).AppendLine();
						totalRecCount++;
					}
					//update
					adapterUD100.Update();	
					worker.ReportProgress(i);
				}
				
				else
				{
					//update log
					builder.Append(string.Format("******Failed to find UD100 recs for {0}******", dr["Donor"].ToString())).AppendLine();
				}					
				txtProgress.Text = builder.ToString();
			}
			adapterUD100.Dispose();
			worker.ReportProgress(100);
			
		}	
	}
	
	private void worker_ProgressChanged(object sender, ProgressChangedEventArgs e)
    {
		//notifies progress bar when changed
		pbProgress.Value = e.ProgressPercentage;		
	}
	
	private void worker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
	{
		//On completed, do the appropriate task		
		if(e.Error !=null)		
		{
			MessageBox.Show("Error while performing tasks!");
		}
		else
		{
			MessageBox.Show(string.Format("Complete. {0} records updated!", totalRecCount.ToString()));
		}
		//re-enable the UI interface to prevent weird threading issues
		btnProcesss.ReadOnly = false;
		btnClear.ReadOnly = false;
	}

	private void btnProcesss_Click(object sender, System.EventArgs args)
	{
		// ** Place Event Handling Code Here **
	
		if (dtInput.Rows.Count>0)
		{
			try
			{
				worker.RunWorkerAsync();

				builder.Clear();
				pbProgress.Value = 0;
				totalRecCount = 0;
				btnProcesss.ReadOnly = true;
				btnClear.ReadOnly = true;				
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
		}	
		else
		{
			MessageBox.Show("Add Inputs");
		}
	}

	private void btnClear_Click(object sender, System.EventArgs args)
	{
		// ** Place Event Handling Code Here **
		dtInput.Clear();
		builder.Clear();
		txtProgress.Text = string.Empty;
		pbProgress.Value = 0;
		totalRecCount = 0;
	}
}

[rosshughes]

That is exactly what I am trying to do and appreciate the example. I will give it a try.

Thanks, Aaron!

Ross