Epicor 10 BPM C#

system · June 24, 2014, 12:59pm

I have a template I created. It is just a shell, but I can usually just choose my needs, fill in the XXXs and all is good.

Erp.Tables.XXX XXX;

Erp.Tables.XXX_UD XXX_UD;

using (var txscope = IceDataContext.CreateDefaultTransactionScope())

{

foreach (var XXX_Recs in (from XXX_Row in Db.XXX

var XXX_Recs = (from XXX_Row in Db.XXX

from XXX_UD_Row in Db.XXX_UD

where XXX_Row.Company == Session.CompanyID

&& XXX_Row.SysRowID == XXX_UD_Row.ForeignSysRowID

&& XXX_Row.YYY == false

select new { XXX_Row, XXX_UD_Row })).FirstOrDefault();

{

if (XXX_Recs != null)

{

XXX_Recs.XXX_Row.YYY = false;

XXX_Recs.XXX_UD_Row.YYY = false;

Db.Validate(XXX_Recs.XXX_Row);

Db.Validate(XXX_Recs.XXX_UD_Row);

}

} /*** XXX ***/

txscope.Complete();

}

Brenda J. Mohr

E10.0.600.2

Humtown Products

44708 Columbiana-Waterford Rd.

P.O. Box 367

Columbiana, Oh 44408

Phone: 330 482-5555

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, June 20, 2014 9:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 10 BPM C#

Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()
                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)
                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }
    }

system · June 20, 2014, 9:53am

Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()
                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)
                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }
    }

system · June 20, 2014, 9:56am

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br>

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â
Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)
Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = false;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = true;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â }
Â Â Â }

</div> <div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 10:06am

This is from the trace.

<businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>
<methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()
                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)
                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {
                Ice.Tablesets.UserFileTableset UserFileDataSet;
                Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);
                UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = false;
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = true;
                    }
                hUserFile.Update(ref UserFileDataSet);
                hUserFile = null;
            }
    }

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div style="" class="ygrps-yiv-1155712232"> <div style="" class="ygrps-yiv-1155712232">Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br style="" class="ygrps-yiv-1155712232">

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }
    }

</div> <div class="ygrps-yiv-1155712232" style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 10:10am

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">

Â <businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

Â <methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â
Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)
Â Â Â Â Â Â Â Â Â {

Â Â Â
Â Â Â Â Â Â Â Â Â Ice.Tablesets.UserFileTableset UserFileDataSet;
Â Â Â Â Â Â Â Â Â Â Â Â Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);
Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = false;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = true;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â hUserFile.Update(ref UserFileDataSet);

Â Â Â Â Â Â Â Â Â Â Â Â hUserFile = null;
Â Â Â Â Â Â Â Â Â }
Â Â Â }

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br>

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â
Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)
Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = false;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = true;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â }
Â Â Â }

</div> <div style="color:#fff;min-height:0;"></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 10:23am

I have debugged it, it sets the field correctly and hits the update method with no errors.

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, June 20, 2014 10:10 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651 --

#ygrps-yiv-969460091yiv0521660651 .ygrps-yiv-969460091yiv0521660651ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651photo-title
a,
#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651photo-title a:active,
#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651photo-title a:hover,
#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651attach-table div.ygrps-yiv-969460091yiv0521660651attach-row {
clear:both;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651attach-table div.ygrps-yiv-969460091yiv0521660651attach-row div {
float:left;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651ygrp-file {
width:30px;}
#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651attach-table div.ygrps-yiv-969460091yiv0521660651attach-row div div a {
text-decoration:none;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651attach-table div.ygrps-yiv-969460091yiv0521660651attach-row div div span {
font-weight:normal;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 div.ygrps-yiv-969460091yiv0521660651ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-969460091
#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651 –
#ygrps-yiv-969460091yiv0521660651ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651ygrp-mkp #ygrps-yiv-969460091yiv0521660651hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651ygrp-mkp #ygrps-yiv-969460091yiv0521660651ads {
margin-bottom:10px;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651ygrp-mkp .ygrps-yiv-969460091yiv0521660651ad {
padding:0 0;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651ygrp-mkp .ygrps-yiv-969460091yiv0521660651ad p {
margin:0;}

#ygrps-yiv-969460091 #ygrps-yiv-969460091yiv0521660651 #ygrps-yiv-969460091yiv0521660651ygrp-mkp .ygrps-yiv-969460091yiv0521660651ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-969460091

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div>
  
  
  <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">
<businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

<methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {


            Ice.Tablesets.UserFileTableset UserFileDataSet;
                Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);
                UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = false;

                    }

                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = true;
                    }
                hUserFile.Update(ref UserFileDataSet);

                hUserFile = null;
            }
    }
From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#
Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?
Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Quis custodiet ipsos custodes?
On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:
<div>
  
  
  <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM&#39;s. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">
Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }
    }
</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 11:33am

Any other suggestions on how to accomplish this?

The same thing is happening on another data directive for SugPoDtl. I want to update Character01 with an address and in the BAQ the data is there, but on the form it does not show. Very strange...

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, June 20, 2014 10:10 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651 --

#ygrps-yiv-23080269yiv0521660651 .ygrps-yiv-23080269yiv0521660651ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651photo-title
a,
#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651photo-title a:active,
#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651photo-title a:hover,
#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651attach-table div.ygrps-yiv-23080269yiv0521660651attach-row {
clear:both;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651attach-table div.ygrps-yiv-23080269yiv0521660651attach-row div {
float:left;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651ygrp-file {
width:30px;}
#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651attach-table div.ygrps-yiv-23080269yiv0521660651attach-row div div a {
text-decoration:none;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651attach-table div.ygrps-yiv-23080269yiv0521660651attach-row div div span {
font-weight:normal;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 div.ygrps-yiv-23080269yiv0521660651ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-23080269
#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651 –
#ygrps-yiv-23080269yiv0521660651ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651ygrp-mkp #ygrps-yiv-23080269yiv0521660651hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651ygrp-mkp #ygrps-yiv-23080269yiv0521660651ads {
margin-bottom:10px;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651ygrp-mkp .ygrps-yiv-23080269yiv0521660651ad {
padding:0 0;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651ygrp-mkp .ygrps-yiv-23080269yiv0521660651ad p {
margin:0;}

#ygrps-yiv-23080269 #ygrps-yiv-23080269yiv0521660651 #ygrps-yiv-23080269yiv0521660651ygrp-mkp .ygrps-yiv-23080269yiv0521660651ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-23080269

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div>
  
  
  <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">
<businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

<methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {


            Ice.Tablesets.UserFileTableset UserFileDataSet;
                Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);
                UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = false;

                    }

                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = true;
                    }
                hUserFile.Update(ref UserFileDataSet);

                hUserFile = null;
            }
    }
From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#
Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?
Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Quis custodiet ipsos custodes?
On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:
<div>
  
  
  <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM&#39;s. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">
Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;

        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)
            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }
    }
</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 11:47am

Does it not show even after refresh?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@…

http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 11:33 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>Any other suggestions on how to accomplish this?</span></div>

The same thing is happening on another data directive for SugPoDtl. I want to update Character01 with an address and in the BAQ the data is there, but on the form it does not show. Very strange…

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 10:10 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">

Â <businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

Â <methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â

Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)

Â Â Â Â Â Â Â Â Â {

Â Â Â
Â Â Â Â Â Â Â Â Â Ice.Tablesets.UserFileTableset UserFileDataSet;
Â Â Â Â Â Â Â Â Â Â Â Â Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);

Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = false;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â hUserFile.Update(ref UserFileDataSet);

Â Â Â Â Â Â Â Â Â Â Â Â hUserFile = null;
Â Â Â Â Â Â Â Â Â }
Â Â Â }

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â

Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)

Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = false;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = true;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â }

Â Â Â }

</div> <div style="color:#fff;min-height:0;"></div>

</div> <div style="color:#fff;min-height:0;"></div>

</div><div><div class="ygrps-yiv-85532856h5">
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 12:26pm

Yes, does not show. I even close the form and reopen and the field still does not show the update.

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, June 20, 2014 11:46 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132 --

#ygrps-yiv-1804238431yiv7943030132 .ygrps-yiv-1804238431yiv7943030132ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132photo-title
a,
#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132photo-title a:active,
#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132photo-title a:hover,
#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132attach-table div.ygrps-yiv-1804238431yiv7943030132attach-row {
clear:both;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132attach-table div.ygrps-yiv-1804238431yiv7943030132attach-row div {
float:left;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132ygrp-file {
width:30px;}
#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132attach-table div.ygrps-yiv-1804238431yiv7943030132attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132attach-table div.ygrps-yiv-1804238431yiv7943030132attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 div.ygrps-yiv-1804238431yiv7943030132ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1804238431
#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132 –
#ygrps-yiv-1804238431yiv7943030132ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132ygrp-mkp #ygrps-yiv-1804238431yiv7943030132hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132ygrp-mkp #ygrps-yiv-1804238431yiv7943030132ads {
margin-bottom:10px;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132ygrp-mkp .ygrps-yiv-1804238431yiv7943030132ad {
padding:0 0;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132ygrp-mkp .ygrps-yiv-1804238431yiv7943030132ad p {
margin:0;}

#ygrps-yiv-1804238431 #ygrps-yiv-1804238431yiv7943030132 #ygrps-yiv-1804238431yiv7943030132ygrp-mkp .ygrps-yiv-1804238431yiv7943030132ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1804238431

Does it not show even after refresh?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@…

http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 11:33 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div>
  
  
  <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>Any other suggestions on how to accomplish this?</span></div>
The same thing is happening on another data directive for SugPoDtl. I want to update Character01 with an address and in the BAQ the data is there, but on the form it does not show. Very strange…
From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 10:10 AM

Subject: Re: [Vantage] Epicor 10 BPM C#
Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.
Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Quis custodiet ipsos custodes?
On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:
<div>
  
  
  <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">
<businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

<methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;


        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)

            {


            Ice.Tablesets.UserFileTableset UserFileDataSet;
                Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);

                UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = false;

                    }

                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = true;

                    }
                hUserFile.Update(ref UserFileDataSet);

                hUserFile = null;
            }
    }
From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#
Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?
Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Quis custodiet ipsos custodes?
On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:
<div>
  
  
  <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM&#39;s. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">
Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;


        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)

            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }

    }
</div>
 


<div style="color:#fff;min-height:0;"></div>
</div>
 


<div style="color:#fff;min-height:0;"></div>

</div><div><div class="ygrps-yiv-1804238431yiv7943030132h5">
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 12:28pm

Hmm are you completing your context when you do Db.Validate? Are you 100% positive the data is getting to the DB? (Run a SQL Query outside of Epicor?)

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 12:26 PM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div>Yes, does not show. I even close the form and reopen and the field still does not show the update.<br>

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 11:46 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Does it not show even after refresh?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 11:33 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>Any other suggestions on how to accomplish this?</span></div>

The same thing is happening on another data directive for SugPoDtl. I want to update Character01 with an address and in the BAQ the data is there, but on the form it does not show. Very strange…

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 10:10 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">

Â <businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

Â <methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â

Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)

Â Â Â Â Â Â Â Â Â {

Â Â Â
Â Â Â Â Â Â Â Â Â Ice.Tablesets.UserFileTableset UserFileDataSet;
Â Â Â Â Â Â Â Â Â Â Â Â Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);

Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = false;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â hUserFile.Update(ref UserFileDataSet);

Â Â Â Â Â Â Â Â Â Â Â Â hUserFile = null;
Â Â Â Â Â Â Â Â Â }
Â Â Â }

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â

Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)

Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = false;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = true;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â }

Â Â Â }

</div> <div style="color:#fff;min-height:0;"></div>

</div> <div style="color:#fff;min-height:0;"></div>

</div><div><div> <div style="color:#fff;min-height:0;"></div>

</div><div><div class="ygrps-yiv-540885165h5">
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 12:30pm

Try this

using (var txscope = IceDataContext.CreateDefaultTransactionScope())
{

your db updating code here

txscope.Complete();

}

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 12:28 PM, Jose Gomez <jose@...> wrote:

Hmm are you completing your context when you do Db.Validate? Are you 100% positive the data is getting to the DB? (Run a SQL Query outside of Epicor?)

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 12:26 PM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div>Yes, does not show. I even close the form and reopen and the field still does not show the update.<br>

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 11:46 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Does it not show even after refresh?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 11:33 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>Any other suggestions on how to accomplish this?</span></div>

The same thing is happening on another data directive for SugPoDtl. I want to update Character01 with an address and in the BAQ the data is there, but on the form it does not show. Very strange…

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 10:10 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">

Â <businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

Â <methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â

Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)

Â Â Â Â Â Â Â Â Â {

Â Â Â
Â Â Â Â Â Â Â Â Â Ice.Tablesets.UserFileTableset UserFileDataSet;
Â Â Â Â Â Â Â Â Â Â Â Â Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);

Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = false;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UserFileDataSet.UserFile[0].UserDisabled = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â hUserFile.Update(ref UserFileDataSet);

Â Â Â Â Â Â Â Â Â Â Â Â hUserFile = null;
Â Â Â Â Â Â Â Â Â }
Â Â Â }

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select ttEmpBasic_Row))
Â Â Â {
Â Â Â Â Â Â var ttEmpBasicRow = ttEmpBasic_iterator;
Â Â Â Â Â Â Â Â Â

Â Â Â Â Â Â var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â select UserFile_Row).FirstOrDefault();
Â Â Â Â Â Â Â Â Â if (userFile != null)

Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = false;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userFile.UserDisabled = true;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Db.Validate();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â }

Â Â Â }

</div> <div style="color:#fff;min-height:0;"></div>

</div> <div style="color:#fff;min-height:0;"></div>

</div><div><div> <div style="color:#fff;min-height:0;"></div>

</div><div><div>
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 1:11pm

Unfortunately same result.

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, June 20, 2014 12:29 PM
Subject: Re: [Vantage] Epicor 10 BPM C#

Try this

using (var txscope = IceDataContext.CreateDefaultTransactionScope())
{

your db updating code here

txscope.Complete();

}

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 12:28 PM, Jose Gomez <jose@...> wrote:

Hmm are you completing your context when you do Db.Validate? Are you 100% positive the data is getting to the DB? (Run a SQL Query outside of Epicor?)

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com



Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 12:26 PM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div>Yes, does not show. I even close the form and reopen and the field still does not show the update.<br>

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 11:46 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Does it not show even after refresh?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com


Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 11:33 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>Any other suggestions on how to accomplish this?</span></div>

The same thing is happening on another data directive for SugPoDtl. I want to update Character01 with an address and in the BAQ the data is there, but on the form it does not show. Very strange…

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 10:10 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com


Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">

<businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

<methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;


        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)

            {


            Ice.Tablesets.UserFileTableset UserFileDataSet;
                Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);

                UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = false;

                    }

                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = true;

                    }
                hUserFile.Update(ref UserFileDataSet);

                hUserFile = null;
            }
    }

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com



Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;


        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)

            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }

    }

</div> <div style="color:#fff;min-height:0;"></div>

</div> <div style="color:#fff;min-height:0;"></div>

</div><div><div> <div style="color:#fff;min-height:0;"></div>

</div><div><div>
 


<div style="color:#fff;min-height:0;"></div>

system · June 20, 2014, 1:12pm

And yes, checking the data with either BAQ or SQL and it gets updated.

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, June 20, 2014 12:28 PM
Subject: Re: [Vantage] Epicor 10 BPM C#

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446 --

#ygrps-yiv-922691638yiv3311915446 .ygrps-yiv-922691638yiv3311915446ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446photo-title
a,
#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446photo-title a:active,
#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446photo-title a:hover,
#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446attach-table div.ygrps-yiv-922691638yiv3311915446attach-row {
clear:both;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446attach-table div.ygrps-yiv-922691638yiv3311915446attach-row div {
float:left;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446ygrp-file {
width:30px;}
#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446attach-table div.ygrps-yiv-922691638yiv3311915446attach-row div div a {
text-decoration:none;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446attach-table div.ygrps-yiv-922691638yiv3311915446attach-row div div span {
font-weight:normal;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 div.ygrps-yiv-922691638yiv3311915446ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-922691638
#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446 –
#ygrps-yiv-922691638yiv3311915446ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446ygrp-mkp #ygrps-yiv-922691638yiv3311915446hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446ygrp-mkp #ygrps-yiv-922691638yiv3311915446ads {
margin-bottom:10px;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446ygrp-mkp .ygrps-yiv-922691638yiv3311915446ad {
padding:0 0;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446ygrp-mkp .ygrps-yiv-922691638yiv3311915446ad p {
margin:0;}

#ygrps-yiv-922691638 #ygrps-yiv-922691638yiv3311915446 #ygrps-yiv-922691638yiv3311915446ygrp-mkp .ygrps-yiv-922691638yiv3311915446ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-922691638

Hmm are you completing your context when you do Db.Validate? Are you 100% positive the data is getting to the DB? (Run a SQL Query outside of Epicor?)

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 12:26 PM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div>Yes, does not show. I even close the form and reopen and the field still does not show the update.<br clear="none">

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 11:46 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Does it not show even after refresh?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com


Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 11:33 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>Any other suggestions on how to accomplish this?</span></div>

The same thing is happening on another data directive for SugPoDtl. I want to update Character01 with an address and in the BAQ the data is there, but on the form it does not show. Very strange…

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>

Sent: Friday, June 20, 2014 10:10 AM

Subject: Re: [Vantage] Epicor 10 BPM C#

Do you have Visual Studio? Have you tried debugging through it? You can do it even with Express.

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com


Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 10:06 AM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt;"><div><span>This is from the trace.</span></div><div style="color:rgb(0,0,0);font-size:10.6667px;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;background-color:transparent;font-style:normal;">

<businessObject>Ice.Proxy.BO.UserFileImpl</businessObject>

<methodName>Update</methodName>

I also tried this. It doesn't even update the database.

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;


        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)

            {


            Ice.Tablesets.UserFileTableset UserFileDataSet;
                Ice.Contracts.UserFileSvcContract hUserFile = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UserFileSvcContract>(Db);

                UserFileDataSet = hUserFile.GetByID(userFile.DcdUserID);

                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = false;

                    }

                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")
                    {
                        UserFileDataSet.UserFile[0].UserDisabled = true;

                    }
                hUserFile.Update(ref UserFileDataSet);

                hUserFile = null;
            }
    }

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>

To: Vantage <vantage@yahoogroups.com>
Sent:
Friday, June 20, 2014 9:55 AM
Subject: Re: [Vantage] Epicor 10 BPM C#

Did you trace out the UI when you manually disable is there another field / flag that gets set? Or maybe a BO Method?

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...

http://www.josecgomez.com



Quis custodiet ipsos custodes?

On Fri, Jun 20, 2014 at 9:53 AM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div>Can anyone tell me if they see an issue with this, still testing the waters on the new BPM's. It updates the database (I verify with a BAQ) but the field on the UI form does not reflect the update? This is happening on the EmpBasic Data Directive when the EmpStatus field changes.<br clear="none">

Thanks!

foreach (var ttEmpBasic_iterator in (from ttEmpBasic_Row in ttEmpBasic
                                                                    where ttEmpBasic_Row.RowMod.ToString().ToUpper() == IceRow.ROWSTATE_UPDATED.ToString().ToUpper()

                                                                    select ttEmpBasic_Row))
    {
        var ttEmpBasicRow = ttEmpBasic_iterator;


        var userFile = (from UserFile_Row in Db.UserFile.With(LockHint.UpdLock)

                                where UserFile_Row.DcdUserID == ttEmpBasicRow.DcdUserID
                                select UserFile_Row).FirstOrDefault();
            if (userFile != null)

            {
                if (ttEmpBasicRow.EmpStatus.ToUpper() == "A")

                    {
                        userFile.UserDisabled = false;
                        Db.Validate();
                    }
                else if (ttEmpBasicRow.EmpStatus.ToUpper() == "T")

                    {
                        userFile.UserDisabled = true;
                        Db.Validate();
                    }
            }

    }

</div> <div style="color:#fff;min-height:0;"></div>

</div> <div style="color:#fff;min-height:0;"></div>

</div><div><div> <div style="color:#fff;min-height:0;"></div>

</div><div><div class="ygrps-yiv-922691638yiv3311915446h5">
 


<div style="color:#fff;min-height:0;"></div>

Topic		Replies	Views
Updating table through bpm code Epicor ERP 10 bpm	12	7873	November 8, 2023
Epicor 10 BPM Blank Title 139812 Yahoo Archive	2	503	January 12, 2016
Trying to update Customer from CustCnt.Update post-processing BPM Epicor ERP 10 bpm	1	1431	December 11, 2020
Epicor 10 BPM Data from another table Yahoo Archive	5	3848	June 19, 2014
Update multiple tables with advanced BPM update Epicor ERP 10 bpm	12	7488	July 13, 2020

Epicor 10 BPM C#

Related Topics