We’re on 10.1.400.28. I’m attempting to set JobHead.JobReleased from a Customized UI Form ( UD08 Base ). The user sees a subset of data on an epiUltraGrid ( this works - the Job data is correct for the Serial Number entered ), then can click an epiButton to Release the Job.
In the current manual process, the user opens JobEntry to do this. In the Customization, I tried using the Methods for the JobEntry adapter. I started with ChangeJobHeadJobReleased - this is the code from the Business Logic Wizard :
private void CallJobEntryAdapterChangeJobHeadJobReleasedMethod()
{
try
{
// Declare and Initialize EpiDataView Variables
// Declare and create an instance of the Adapter.
JobEntryAdapter adapterJobEntry = new JobEntryAdapter(this.oTrans);
adapterJobEntry.BOConnect();
// Call Adapter method
bool result = adapterJobEntry.ChangeJobHeadJobReleased();
// Cleanup Adapter Reference
adapterJobEntry.Dispose();
} catch (System.Exception ex)
{
ExceptionBox.Show(ex);
}
}
No success. The two examples I found on the 'net for this method passed a dataset parameter to adapterJobEntry.ChangeJobHeadJobReleased(), but when I try this the compile fails - it won’t accept a parameter.
The compile succeeds without error if I omit the parameter, but clicking the button in the Customization results in the error :
Business Layer Exception
JobHead has not changed.
Exception caught in: Epicor.ServiceModel
Since adapterJobEntry.ChangeJobHeadJobReleased() won’t accept a parameter, I thought it may just affect the present data. On the JobEntry Adapter, I found CallJobEntryAdapterGetCurrentDataSetMethod() :
private void CallJobEntryAdapterGetCurrentDataSetMethod()
{
try
{
// Declare and Initialize EpiDataView Variables
// Declare and create an instance of the Adapter.
JobEntryAdapter adapterJobEntry = new JobEntryAdapter(this.oTrans);
adapterJobEntry.BOConnect();
// Declare and Initialize Variables
Ice.Lib.Searches.DataSetMode dsMode;
// Call Adapter method
System.Data.DataSet dsJobEntry = adapterJobEntry.GetCurrentDataSet(dsMode);
// Cleanup Adapter Reference
adapterJobEntry.Dispose();
} catch (System.Exception ex)
{
ExceptionBox.Show(ex);
}
}
Combining these, I put the JobReleased line into the GetCurrentDataSet after the call to GetCurrentDataSet, as shown below. This compiles, but results in a different error from the Customization :
private void CallJobEntryAdapterGetCurrentDataSetMethod()
{
try
{
// Declare and Initialize EpiDataView Variables
EpiDataView edv_WIP_Status = ((EpiDataView)(this.oTrans.EpiDataViews["edv_WIP_Status"]));
// Check if valid EpiDataView Row(s) are selected
if ((edv_WIP_Status.Row < 0)) { return; }
// Declare and create an instance of the Adapter.
JobEntryAdapter adapterJobEntry = new JobEntryAdapter(this.oTrans);
adapterJobEntry.BOConnect();
// Declare and Initialize Variables
Ice.Lib.Searches.DataSetMode dsMode = ((Ice.Lib.Searches.DataSetMode)(edv_WIP_Status.dataView[edv_WIP_Status.Row]["JobHead_JobNum"]));
// Call Adapter method
System.Data.DataSet dsJobEntry = adapterJobEntry.GetCurrentDataSet(dsMode);
// Call Adapter method
bool result = adapterJobEntry.ChangeJobHeadJobReleased( );
// Cleanup Adapter Reference
adapterJobEntry.Dispose();
} catch (System.Exception ex)
{
ExceptionBox.Show(ex);
}
}
Clicking the button in the Customization with this code in place results in the error :
Application Error
Exception caught in: App.UD08Entry.UD08Form.EP.EmbedTek.Customization.ETK_Depot_Hydra_WIP.CustomCode
Error Detail
============
Message: Specified cast is not valid.
Program: App.UD08Entry.UD08Form.EP.EmbedTek.Customization.ETK_Depot_Hydra_WIP.CustomCode.dll
Method: CallJobEntryAdapterGetCurrentDataSetMethod
Client Stack Trace
==================
at Script.CallJobEntryAdapterGetCurrentDataSetMethod()
Should I be trying to use ChangeJobHeadJobReleased to Release the Job ? I ran this by our resident EpiGuru. He made several attempts at getting the button-click to Release the Job by pulling the dataset differently and setting the Fields directly with an Update, but still no success. This is where the code is now :
private void CallJobEntryAdapterGetCurrentDataSetMethod()
{
try
{
// Declare and Initialize EpiDataView Variables
EpiDataView edv_WIP_Status = ((EpiDataView)(this.oTrans.EpiDataViews["edv_WIP_Status"]));
// Check if valid EpiDataView Row(s) are selected
if ((edv_WIP_Status.Row < 0)) { return; }
// Declare and create an instance of the Adapter.
JobEntryAdapter adapterJobEntry = new JobEntryAdapter(this.oTrans);
adapterJobEntry.BOConnect();
// Declare and Initialize Variables
//Ice.Lib.Searches.DataSetMode dsMode = ((Ice.Lib.Searches.DataSetMode)(edv_WIP_Status.dataView[edv_WIP_Status.Row]["JobHead_JobNum"]));
//GetJobHead by ID
bool result = adapterJobEntry.GetByID(edv_WIP_Status.dataView[edv_WIP_Status.Row]["JobHead_JobNum"]);
//Create and JobHeadDataSet
//adapterJobEntry.GetByID(edv_WIP_Status.dataView[edv_WIP_Status.Row]["JobHead_JobNum"]);
//JobEntryDataSet jeData = adapterJobEntry.JobEntryData;
//JobHeadDataTable jhTable = adapterJobEntry.JobEntryData.JobHead;
JobEntryDataSet.JobHeadDataTable adapterRow = adapterJobEntry.JobEntryData.JobHead;
adapterJobEntry.Update ();
//JobEntryDataSet jobDS = adapterJobEntry.DataSet;
/*
sods = hSO.GetByID(OrderNr[i]);
sods.OrderHed[0]["c_ReprintEmail_c"]=true;
sods.OrderHed[0].RowMod="U";
hSO.Update (ref sods);
jobDS.["JobReleased"] = true;
jobDS.["JobEngineered"] = true;
*/
//Update JobEntry
// adapterJobEntry.Update(jobDS);
// Call Adapter method
//System.Data.DataSet dsJobEntry = adapterJobEntry.GetCurrentDataSet(dsMode);
// Call Adapter method
//bool result = adapterJobEntry.ChangeJobHeadJobReleased();
// Cleanup Adapter Reference
adapterJobEntry.Dispose();
} catch (System.Exception ex)
{
//ExceptionBox.Show(ex);
}
}
These approaches had similar results : either no change in the data, or the “JobHead has not changed” error I first had.
Thanks for reading,
Ken Brunelli, EmbedTek
