Incrementally data pushing through post

 public void postLoad() 

    { 

        super(); 

  

            this.Approved ='True'; 

            this.Rejected = enum2Str(NoYes::No ); 

            this.Status ="Submitted"; 

            this.Type ="Actual"; 

            this.Owner     =  this.MDSCreatedBy; 

  

         

        SysDictEnum distEum = new SysDictEnum(enumnum(ProjTransType)); 

        ProjTransType    type =  ProjTransType::Cost; 

        this.CostArea = distEum.value2Label(type); 

        this.InvoiceProposalReady =enum2Str(NoYes::Yes); 

            this.GetDetails(); 

    } 

  

    /// <summary> 

    /// 

    /// </summary> 

    private void GetDetails() 

    { 

        HcmWorkerRecId              workerRecId; 

        HcmWorker                  hcmWorker; 

        DirPerson                  person; 

        DirPersonUser              personUser; 

        UserId                     userId  = curUserId(); 

        UserInfo                   userInfo  ; 

        ResourceView               resourceView; 

        smmActivities              smmActivities; 

        ProjPostedTransTable projPostedTransTableloc,projPostedTransTable ; 

        ProjPostedTransTableEntityPSA   postedTransTableEntityPSA; 

        ProjPostedTransTableStaging     projPostedTransTableStaging; 

        ProjCostTrans                   projCostTrans; 

  

          changecompany(this.DataAreaId) 

        { 

        projPostedTransTable = ProjPostedTransTable::findByTransId(this.TransId); 

  

        select * from resourceView where resourceView.RecId == projPostedTransTable.Resource; 

        select * from  hcmWorker  where 

                hcmWorker.PersonnelNumber == resourceView.ResourceId; 

        select  person 

            where    person.RecId  ==hcmWorker.Person 

            join personUser 

            where personUser.PersonParty == person.RecId; 

        select * from userInfo where userInfo.id  == personUser.User; 

        

        this.ResourceID =  userInfo.networkAlias; 

          

      

  

        //smmActivityNumber ActiviyNum = projPostedTransTable.ActivityNumber; 

        //select smmActivities where smmActivities.ActivityNumber == ActiviyNum; 

       // this.ProjectTask =  enum2Str(smmActivities.TeamTask); 

  

        ProjTransPosting  projTransPosting; 

  

        Select LEDGERTRANSDATE from projTransPosting 

            join projCostTrans 

                 where projTransPosting.TRANSID == projCostTrans.TRANSID 

                &&  projTransPosting.PROJTRANSTYPE == this.ProjTransType 

                &&  projTransPosting.costSales ==   ProjCostSales::Cost 

                && projTransPosting.TRANSID == projPostedTransTable.TransId; 

        this.LedgerPostedDate = projTransPosting.LedgerTransDate; 

  

  

         while select forupdate projPostedTransTableloc where projPostedTransTableloc.ProjId == this.ProjId 

            && projPostedTransTableloc.TransId == this.TransId 

        { 

            ttsbegin; 

            projPostedTransTableloc.MDSExportStatus =NoYes::Yes; 

            projPostedTransTableloc.doUpdate(); 

            ttscommit; 

        } 

        } 

             

    } 

  

}