Main.xaml

<Activity mc:Ignorable="sap sap2010" x:Class="JobApplicationBot_Main" sap2010:WorkflowViewState.IdRef="ActivityBuilder_1" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:s="clr-namespace:System;assembly=System.Private.CoreLib" xmlns:sap="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:sap2010="http://schemas.microsoft.com/netfx/2010/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=System.Private.CoreLib" xmlns:sco="clr-namespace:System.Collections.ObjectModel;assembly=System.Private.CoreLib" xmlns:sd="clr-namespace:System.Data;assembly=System.Data.Common" xmlns:ui="http://schemas.uipath.com/workflow/activities" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
  <TextExpression.NamespacesForImplementation>
    <sco:Collection x:TypeArguments="x:String">
      <x:String>GlobalConstantsNamespace</x:String>
      <x:String>GlobalVariablesNamespace</x:String>
      <x:String>System</x:String>
      <x:String>System.Collections.Generic</x:String>
      <x:String>System.Collections.ObjectModel</x:String>
      <x:String>System.Data</x:String>
      <x:String>System.Linq</x:String>
      <x:String>UiPath.Core</x:String>
      <x:String>UiPath.Core.Activities</x:String>
      <x:String>System.Activities</x:String>
      <x:String>System.Collections</x:String>
      <x:String>System.Activities.Statements</x:String>
      <x:String>System.ComponentModel</x:String>
      <x:String>System.Runtime.Serialization</x:String>
      <x:String>System.Xml.Serialization</x:String>
      <x:String>UiPath.Excel</x:String>
      <x:String>UiPath.Excel.Activities</x:String>
    </sco:Collection>
  </TextExpression.NamespacesForImplementation>
  <TextExpression.ReferencesForImplementation>
    <sco:Collection x:TypeArguments="AssemblyReference">
      <AssemblyReference>System.Activities</AssemblyReference>
      <AssemblyReference>System.Collections</AssemblyReference>
      <AssemblyReference>System.Collections.NonGeneric</AssemblyReference>
      <AssemblyReference>System.ComponentModel</AssemblyReference>
      <AssemblyReference>System.ComponentModel.Primitives</AssemblyReference>
      <AssemblyReference>System.ComponentModel.TypeConverter</AssemblyReference>
      <AssemblyReference>System.Data</AssemblyReference>
      <AssemblyReference>System.Data.Common</AssemblyReference>
      <AssemblyReference>System.Linq</AssemblyReference>
      <AssemblyReference>System.ObjectModel</AssemblyReference>
      <AssemblyReference>System.Private.CoreLib</AssemblyReference>
      <AssemblyReference>System.Runtime.Serialization</AssemblyReference>
      <AssemblyReference>System.Xml</AssemblyReference>
      <AssemblyReference>System.Xml.Linq</AssemblyReference>
      <AssemblyReference>UiPath.Excel</AssemblyReference>
      <AssemblyReference>UiPath.Excel.Activities</AssemblyReference>
      <AssemblyReference>UiPath.Mail.Activities</AssemblyReference>
      <AssemblyReference>UiPath.Platform</AssemblyReference>
      <AssemblyReference>UiPath.Studio.Constants</AssemblyReference>
      <AssemblyReference>UiPath.System.Activities</AssemblyReference>
    </sco:Collection>
  </TextExpression.ReferencesForImplementation>
  <Sequence DisplayName="Main - Job Application Bot" sap:VirtualizedContainerService.HintSize="1542,8126" sap2010:WorkflowViewState.IdRef="Sequence_1">
    <Sequence.Variables>
      <Variable x:TypeArguments="scg:Dictionary(x:String, x:String)" Name="configDict" />
      <Variable x:TypeArguments="sd:DataTable" Name="configTableTemp" />
      <Variable x:TypeArguments="x:String" Name="smtpServer" />
      <Variable x:TypeArguments="x:Int32" Name="smtpPort" />
      <Variable x:TypeArguments="x:String" Name="senderEmail" />
      <Variable x:TypeArguments="x:String" Name="senderPassword" />
      <Variable x:TypeArguments="x:String" Name="emailSubjectTemplate" />
      <Variable x:TypeArguments="x:String" Name="emailBodyTemplate" />
      <Variable x:TypeArguments="x:Boolean" Name="isBodyHtml" />
      <Variable x:TypeArguments="x:String" Name="defaultAttachmentPath" />
      <Variable x:TypeArguments="x:Int32" Name="retryCount" />
      <Variable x:TypeArguments="x:Int32" Name="delayBetweenEmailsSeconds" />
      <Variable x:TypeArguments="x:Boolean" Name="isDryRun" />
      <Variable x:TypeArguments="sd:DataTable" Name="companiesTable" />
      <Variable x:TypeArguments="x:String" Name="companyName" />
      <Variable x:TypeArguments="x:String" Name="recipientEmail" />
      <Variable x:TypeArguments="x:String" Name="specificAttachment" />
      <Variable x:TypeArguments="x:String" Name="finalAttachmentPath" />
      <Variable x:TypeArguments="x:String" Name="finalSubject" />
      <Variable x:TypeArguments="x:String" Name="finalBody" />
      <Variable x:TypeArguments="scg:List(x:String)" Name="attachmentList" />
      <Variable x:TypeArguments="x:Boolean" Name="emailSuccess" />
      <Variable x:TypeArguments="x:String" Name="emailError" />
      <Variable x:TypeArguments="x:Int32" Name="retryAttemptUsed" />
      <Variable x:TypeArguments="x:Int32" Default="0" Name="successCount" />
      <Variable x:TypeArguments="x:Int32" Default="0" Name="failureCount" />
      <Variable x:TypeArguments="x:String" Default="[&quot;data\Log.xlsx&quot;]" Name="logFilePath" />
    </Sequence.Variables>
    <sap:WorkflowViewStateService.ViewState>
      <scg:Dictionary x:TypeArguments="x:String, x:Object">
        <x:Boolean x:Key="IsExpanded">True</x:Boolean>
      </scg:Dictionary>
    </sap:WorkflowViewStateService.ViewState>
    <ui:LogMessage DisplayName="[Log] Starting Job Application Bot" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="LogMessage_1" Level="Info" Message="[&quot;=== Job Application Bot Started at &quot; &amp; System.DateTime.Now.ToString(&quot;yyyy-MM-dd HH:mm:ss&quot;) &amp; &quot; ===&quot;]" />
    <Assign DisplayName="Initialize Config Dictionary" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_1">
      <Assign.To>
        <OutArgument x:TypeArguments="scg:Dictionary(x:String, x:String)">[configDict]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="scg:Dictionary(x:String, x:String)">[New Dictionary(Of String, String)()]</InArgument>
      </Assign.Value>
    </Assign>
    <ui:ReadRange AddHeaders="True" DataTable="[configTableTemp]" DisplayName="Read Config.xlsx" sap:VirtualizedContainerService.HintSize="524,227" sap2010:WorkflowViewState.IdRef="ReadRange_1" SheetName="Sheet1" WorkbookPath="data\Config.xlsx">
      <ui:ReadRange.Range>
        <InArgument x:TypeArguments="x:String">
          <Literal x:TypeArguments="x:String" Value="" />
        </InArgument>
      </ui:ReadRange.Range>
    </ui:ReadRange>
    <ui:ForEach x:TypeArguments="sd:DataRow" CurrentIndex="{x:Null}" DisplayName="Populate Config Dictionary" sap:VirtualizedContainerService.HintSize="524,344" sap2010:WorkflowViewState.IdRef="ForEach`1_1" Values="[configTableTemp.AsEnumerable()]">
      <ui:ForEach.Body>
        <ActivityAction x:TypeArguments="sd:DataRow">
          <ActivityAction.Argument>
            <DelegateInArgument x:TypeArguments="sd:DataRow" Name="row" />
          </ActivityAction.Argument>
          <Assign sap:VirtualizedContainerService.HintSize="334,143" sap2010:WorkflowViewState.IdRef="Assign_9">
            <Assign.To>
              <OutArgument x:TypeArguments="x:String">[configDict(row(0).ToString().Trim())]</OutArgument>
            </Assign.To>
            <Assign.Value>
              <InArgument x:TypeArguments="x:String">[row(1).ToString().Trim()]</InArgument>
            </Assign.Value>
          </Assign>
        </ActivityAction>
      </ui:ForEach.Body>
    </ui:ForEach>
    <Assign DisplayName="Set SMTP Server" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_2">
      <Assign.To>
        <OutArgument x:TypeArguments="x:String">[smtpServer]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:String">[If(configDict.ContainsKey("SmtpServer"), configDict("SmtpServer"), "smtp.gmail.com")]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set SMTP Port" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_3">
      <Assign.To>
        <OutArgument x:TypeArguments="x:Int32">[smtpPort]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:Int32">[If(configDict.ContainsKey("Port"), Integer.Parse(configDict("Port")), 587)]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set Sender Email" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_4">
      <Assign.To>
        <OutArgument x:TypeArguments="x:String">[senderEmail]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:String">[If(configDict.ContainsKey("SenderEmail"), configDict("SenderEmail"), "")]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set Sender Password" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_5">
      <Assign.To>
        <OutArgument x:TypeArguments="x:String">[senderPassword]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:String">[If(configDict.ContainsKey("SenderPassword"), configDict("SenderPassword"), "")]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set Subject Template" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_6">
      <Assign.To>
        <OutArgument x:TypeArguments="x:String">[emailSubjectTemplate]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:String">[If(configDict.ContainsKey("EmailSubject"), configDict("EmailSubject"), "")]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set Body Template" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_7">
      <Assign.To>
        <OutArgument x:TypeArguments="x:String">[emailBodyTemplate]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:String">[If(configDict.ContainsKey("EmailBody"), configDict("EmailBody"), "")]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set IsBodyHtml" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_8">
      <Assign.To>
        <OutArgument x:TypeArguments="x:Boolean">[isBodyHtml]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:Boolean">[If(configDict.ContainsKey("IsBodyHtml"), Boolean.Parse(configDict("IsBodyHtml")), False)]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set Default Attachment Path" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_10">
      <Assign.To>
        <OutArgument x:TypeArguments="x:String">[defaultAttachmentPath]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:String">[If(configDict.ContainsKey("DefaultAttachmentPath"), configDict("DefaultAttachmentPath"), "attachments\CV.pdf")]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set Retry Count" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_11">
      <Assign.To>
        <OutArgument x:TypeArguments="x:Int32">[retryCount]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:Int32">[If(configDict.ContainsKey("RetryCount"), Integer.Parse(configDict("RetryCount")), 2)]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set Delay Between Emails" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_12">
      <Assign.To>
        <OutArgument x:TypeArguments="x:Int32">[delayBetweenEmailsSeconds]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:Int32">[If(configDict.ContainsKey("DelayBetweenEmailsSeconds"), Integer.Parse(configDict("DelayBetweenEmailsSeconds")), 3)]</InArgument>
      </Assign.Value>
    </Assign>
    <Assign DisplayName="Set DryRun Flag" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="Assign_13">
      <Assign.To>
        <OutArgument x:TypeArguments="x:Boolean">[isDryRun]</OutArgument>
      </Assign.To>
      <Assign.Value>
        <InArgument x:TypeArguments="x:Boolean">[If(configDict.ContainsKey("DryRun"), Boolean.Parse(configDict("DryRun")), False)]</InArgument>
      </Assign.Value>
    </Assign>
    <If Condition="[String.IsNullOrWhiteSpace(senderEmail)]" DisplayName="[Check] Is Sender Email Empty?" sap2010:WorkflowViewState.IdRef="If_SenderCheck">
      <If.Then>
        <ui:LogMessage DisplayName="[Log] Sender Email Warning" Level="Warn" Message="[&quot;SenderEmail is empty! Check your Config.xlsx. Mails will fail to send.&quot;]" />
      </If.Then>
    </If>
    <If Condition="[isDryRun]" DisplayName="[Check] Dry Run Mode?" sap:VirtualizedContainerService.HintSize="524,394" sap2010:WorkflowViewState.IdRef="If_1">
      <If.Then>
        <ui:LogMessage DisplayName="[Log] DRY RUN MODE ACTIVE" sap:VirtualizedContainerService.HintSize="450,143" sap2010:WorkflowViewState.IdRef="LogMessage_2" Level="Warn" Message="[&quot;⚠️ DRY RUN MODE IS ACTIVE – No emails will be sent.&quot;]" />
      </If.Then>
      <If.Else>
        <Sequence DisplayName="Else" sap:VirtualizedContainerService.HintSize="450,90" sap2010:WorkflowViewState.IdRef="Sequence_6">
          <sap:WorkflowViewStateService.ViewState>
            <scg:Dictionary x:TypeArguments="x:String, x:Object">
              <x:Boolean x:Key="IsExpanded">True</x:Boolean>
            </scg:Dictionary>
          </sap:WorkflowViewStateService.ViewState>
        </Sequence>
      </If.Else>
    </If>
    <ui:ReadRange AddHeaders="True" DataTable="[companiesTable]" DisplayName="Read Companies.xlsx" sap:VirtualizedContainerService.HintSize="524,227" sap2010:WorkflowViewState.IdRef="ReadRange_2" SheetName="Sheet1" WorkbookPath="data\Companies.xlsx">
      <ui:ReadRange.Range>
        <InArgument x:TypeArguments="x:String">
          <Literal x:TypeArguments="x:String" Value="" />
        </InArgument>
      </ui:ReadRange.Range>
    </ui:ReadRange>
    <ui:LogMessage DisplayName="[Log] Companies Loaded" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="LogMessage_3" Level="Info" Message="[&quot;Loaded &quot; &amp; companiesTable.Rows.Count.ToString() &amp; &quot; companies from Companies.xlsx&quot;]" />
    <ui:ForEach x:TypeArguments="sd:DataRow" CurrentIndex="{x:Null}" DisplayName="For Each Company Row" sap:VirtualizedContainerService.HintSize="524,4172" sap2010:WorkflowViewState.IdRef="ForEach`1_2" Values="[companiesTable.AsEnumerable()]">
      <ui:ForEach.Body>
        <ActivityAction x:TypeArguments="sd:DataRow">
          <ActivityAction.Argument>
            <DelegateInArgument x:TypeArguments="sd:DataRow" Name="companyRow" />
          </ActivityAction.Argument>
          <Sequence DisplayName="Process Company" sap:VirtualizedContainerService.HintSize="522,4041" sap2010:WorkflowViewState.IdRef="Sequence_5">
            <sap:WorkflowViewStateService.ViewState>
              <scg:Dictionary x:TypeArguments="x:String, x:Object">
                <x:Boolean x:Key="IsExpanded">True</x:Boolean>
              </scg:Dictionary>
            </sap:WorkflowViewStateService.ViewState>
            <TryCatch DisplayName="[TryCatch] Process Each Company" sap:VirtualizedContainerService.HintSize="488,3981" sap2010:WorkflowViewState.IdRef="TryCatch_1">
              <TryCatch.Try>
                <Sequence DisplayName="Extract &amp; Send" sap:VirtualizedContainerService.HintSize="486,3325" sap2010:WorkflowViewState.IdRef="Sequence_3">
                  <sap:WorkflowViewStateService.ViewState>
                    <scg:Dictionary x:TypeArguments="x:String, x:Object">
                      <x:Boolean x:Key="IsExpanded">True</x:Boolean>
                    </scg:Dictionary>
                  </sap:WorkflowViewStateService.ViewState>
                  <Assign DisplayName="Get CompanyName" sap:VirtualizedContainerService.HintSize="452,175" sap2010:WorkflowViewState.IdRef="Assign_14">
                    <Assign.To>
                      <OutArgument x:TypeArguments="x:String">[companyName]</OutArgument>
                    </Assign.To>
                    <Assign.Value>
                      <InArgument x:TypeArguments="x:String">[companyRow("CompanyName").ToString().Trim()]</InArgument>
                    </Assign.Value>
                  </Assign>
                  <Assign DisplayName="Get RecipientEmail" sap:VirtualizedContainerService.HintSize="452,175" sap2010:WorkflowViewState.IdRef="Assign_15">
                    <Assign.To>
                      <OutArgument x:TypeArguments="x:String">[recipientEmail]</OutArgument>
                    </Assign.To>
                    <Assign.Value>
                      <InArgument x:TypeArguments="x:String">[companyRow("RecipientEmail").ToString().Trim()]</InArgument>
                    </Assign.Value>
                  </Assign>
                  <Assign DisplayName="Get SpecificAttachment" sap:VirtualizedContainerService.HintSize="452,175" sap2010:WorkflowViewState.IdRef="Assign_16">
                    <Assign.To>
                      <OutArgument x:TypeArguments="x:String">[specificAttachment]</OutArgument>
                    </Assign.To>
                    <Assign.Value>
                      <InArgument x:TypeArguments="x:String">[If(companiesTable.Columns.Contains("SpecificAttachmentPath") AndAlso Not String.IsNullOrWhiteSpace(companyRow("SpecificAttachmentPath").ToString()), companyRow("SpecificAttachmentPath").ToString().Trim(), "")]</InArgument>
                    </Assign.Value>
                  </Assign>
                  <Assign DisplayName="Resolve Attachment Path" sap:VirtualizedContainerService.HintSize="452,175" sap2010:WorkflowViewState.IdRef="Assign_17">
                    <Assign.To>
                      <OutArgument x:TypeArguments="x:String">[finalAttachmentPath]</OutArgument>
                    </Assign.To>
                    <Assign.Value>
                      <InArgument x:TypeArguments="x:String">[If(Not String.IsNullOrEmpty(specificAttachment), specificAttachment, defaultAttachmentPath)]</InArgument>
                    </Assign.Value>
                  </Assign>
                  <ui:InvokeWorkflowFile ArgumentsVariable="{x:Null}" DisplayName="Replace Placeholders – Subject" sap:VirtualizedContainerService.HintSize="452,177" sap2010:WorkflowViewState.IdRef="InvokeWorkflowFile_1" UnSafe="False" WorkflowFileName="workflows\ReplacePlaceholders.xaml">
                    <ui:InvokeWorkflowFile.Arguments>
                      <InArgument x:TypeArguments="x:String" x:Key="OriginalText">[emailSubjectTemplate]</InArgument>
                      <InArgument x:TypeArguments="x:String" x:Key="CompanyName">[companyName]</InArgument>
                      <OutArgument x:TypeArguments="x:String" x:Key="TransformedText">[finalSubject]</OutArgument>
                    </ui:InvokeWorkflowFile.Arguments>
                  </ui:InvokeWorkflowFile>
                  <ui:InvokeWorkflowFile ArgumentsVariable="{x:Null}" DisplayName="Replace Placeholders – Body" sap:VirtualizedContainerService.HintSize="452,177" sap2010:WorkflowViewState.IdRef="InvokeWorkflowFile_2" UnSafe="False" WorkflowFileName="workflows\ReplacePlaceholders.xaml">
                    <ui:InvokeWorkflowFile.Arguments>
                      <InArgument x:TypeArguments="x:String" x:Key="OriginalText">[emailBodyTemplate]</InArgument>
                      <InArgument x:TypeArguments="x:String" x:Key="CompanyName">[companyName]</InArgument>
                      <OutArgument x:TypeArguments="x:String" x:Key="TransformedText">[finalBody]</OutArgument>
                    </ui:InvokeWorkflowFile.Arguments>
                  </ui:InvokeWorkflowFile>
                  <Assign DisplayName="Build Attachment List" sap:VirtualizedContainerService.HintSize="452,175" sap2010:WorkflowViewState.IdRef="Assign_18">
                    <Assign.To>
                      <OutArgument x:TypeArguments="scg:List(x:String)">[attachmentList]</OutArgument>
                    </Assign.To>
                    <Assign.Value>
                      <InArgument x:TypeArguments="scg:List(x:String)">[New List(Of String) From { finalAttachmentPath }]</InArgument>
                    </Assign.Value>
                  </Assign>
                  <If Condition="[isDryRun]" DisplayName="[Check] Is DryRun?" sap:VirtualizedContainerService.HintSize="452,1057" sap2010:WorkflowViewState.IdRef="If_2">
                    <If.Then>
                      <Sequence DisplayName="Dry Run – Log Only" sap:VirtualizedContainerService.HintSize="450,751" sap2010:WorkflowViewState.IdRef="Sequence_2">
                        <sap:WorkflowViewStateService.ViewState>
                          <scg:Dictionary x:TypeArguments="x:String, x:Object">
                            <x:Boolean x:Key="IsExpanded">True</x:Boolean>
                          </scg:Dictionary>
                        </sap:WorkflowViewStateService.ViewState>
                        <ui:LogMessage DisplayName="[DryRun] Would Send Email" sap:VirtualizedContainerService.HintSize="416,175" sap2010:WorkflowViewState.IdRef="LogMessage_4" Level="Info" Message="[&quot;[DRY RUN] Would send to &quot; &amp; recipientEmail &amp; &quot; | Company: &quot; &amp; companyName &amp; &quot; | Subject: &quot; &amp; finalSubject]" />
                        <Assign DisplayName="Set Success" sap:VirtualizedContainerService.HintSize="416,175" sap2010:WorkflowViewState.IdRef="Assign_19">
                          <Assign.To>
                            <OutArgument x:TypeArguments="x:Boolean">[emailSuccess]</OutArgument>
                          </Assign.To>
                          <Assign.Value>
                            <InArgument x:TypeArguments="x:Boolean">[True]</InArgument>
                          </Assign.Value>
                        </Assign>
                        <Assign DisplayName="Clear Error" sap:VirtualizedContainerService.HintSize="416,175" sap2010:WorkflowViewState.IdRef="Assign_20">
                          <Assign.To>
                            <OutArgument x:TypeArguments="x:String">[emailError]</OutArgument>
                          </Assign.To>
                          <Assign.Value>
                            <InArgument x:TypeArguments="x:String">["DryRun - Not Sent"]</InArgument>
                          </Assign.Value>
                        </Assign>
                        <Assign DisplayName="Set Retry" sap:VirtualizedContainerService.HintSize="416,166" sap2010:WorkflowViewState.IdRef="Assign_21">
                          <Assign.To>
                            <OutArgument x:TypeArguments="x:Int32">[retryAttemptUsed]</OutArgument>
                          </Assign.To>
                          <Assign.Value>
                            <InArgument x:TypeArguments="x:Int32">[0]</InArgument>
                          </Assign.Value>
                        </Assign>
                      </Sequence>
                    </If.Then>
                    <If.Else>
                      <ui:InvokeWorkflowFile ArgumentsVariable="{x:Null}" DisplayName="Invoke SendEmail.xaml" sap:VirtualizedContainerService.HintSize="450,145" sap2010:WorkflowViewState.IdRef="InvokeWorkflowFile_3" UnSafe="False" WorkflowFileName="workflows\SendEmail.xaml">
                        <ui:InvokeWorkflowFile.Arguments>
                          <InArgument x:TypeArguments="x:String" x:Key="SmtpServer">[smtpServer]</InArgument>
                          <InArgument x:TypeArguments="x:Int32" x:Key="Port">[smtpPort]</InArgument>
                          <InArgument x:TypeArguments="x:String" x:Key="SenderEmail">[senderEmail]</InArgument>
                          <InArgument x:TypeArguments="x:String" x:Key="SenderPassword">[senderPassword]</InArgument>
                          <InArgument x:TypeArguments="x:String" x:Key="RecipientEmail">[recipientEmail]</InArgument>
                          <InArgument x:TypeArguments="x:String" x:Key="Subject">[finalSubject]</InArgument>
                          <InArgument x:TypeArguments="x:String" x:Key="Body">[finalBody]</InArgument>
                          <InArgument x:TypeArguments="x:Boolean" x:Key="IsBodyHtml">[isBodyHtml]</InArgument>
                          <InArgument x:TypeArguments="scg:List(x:String)" x:Key="AttachmentPaths">[attachmentList]</InArgument>
                          <InArgument x:TypeArguments="x:Int32" x:Key="RetryCount">[retryCount]</InArgument>
                          <OutArgument x:TypeArguments="x:Boolean" x:Key="Success">[emailSuccess]</OutArgument>
                          <OutArgument x:TypeArguments="x:String" x:Key="FinalErrorMessage">[emailError]</OutArgument>
                          <OutArgument x:TypeArguments="x:Int32" x:Key="RetryAttemptUsed">[retryAttemptUsed]</OutArgument>
                        </ui:InvokeWorkflowFile.Arguments>
                      </ui:InvokeWorkflowFile>
                    </If.Else>
                  </If>
                  <ui:InvokeWorkflowFile ArgumentsVariable="{x:Null}" DisplayName="Invoke LogResult.xaml" sap:VirtualizedContainerService.HintSize="452,177" sap2010:WorkflowViewState.IdRef="InvokeWorkflowFile_4" UnSafe="False" WorkflowFileName="workflows\LogResult.xaml">
                    <ui:InvokeWorkflowFile.Arguments>
                      <InArgument x:TypeArguments="x:String" x:Key="CompanyName">[companyName]</InArgument>
                      <InArgument x:TypeArguments="x:String" x:Key="RecipientEmail">[recipientEmail]</InArgument>
                      <InArgument x:TypeArguments="x:String" x:Key="Status">[If(emailSuccess, If(isDryRun, "DryRun", "Success"), "Failed")]</InArgument>
                      <InArgument x:TypeArguments="x:String" x:Key="ErrorMessage">[If(String.IsNullOrEmpty(emailError), "", emailError)]</InArgument>
                      <InArgument x:TypeArguments="x:Int32" x:Key="RetryAttempt">[retryAttemptUsed]</InArgument>
                      <InArgument x:TypeArguments="x:String" x:Key="LogFilePath">[logFilePath]</InArgument>
                    </ui:InvokeWorkflowFile.Arguments>
                  </ui:InvokeWorkflowFile>
                  <If Condition="[emailSuccess]" DisplayName="[Check] Update Success/Fail Counter" sap:VirtualizedContainerService.HintSize="452,469" sap2010:WorkflowViewState.IdRef="If_3">
                    <If.Then>
                      <Assign DisplayName="Increment SuccessCount" sap:VirtualizedContainerService.HintSize="334,143" sap2010:WorkflowViewState.IdRef="Assign_22">
                        <Assign.To>
                          <OutArgument x:TypeArguments="x:Int32">[successCount]</OutArgument>
                        </Assign.To>
                        <Assign.Value>
                          <InArgument x:TypeArguments="x:Int32">[successCount + 1]</InArgument>
                        </Assign.Value>
                      </Assign>
                    </If.Then>
                    <If.Else>
                      <Assign DisplayName="Increment FailureCount" sap:VirtualizedContainerService.HintSize="334,143" sap2010:WorkflowViewState.IdRef="Assign_23">
                        <Assign.To>
                          <OutArgument x:TypeArguments="x:Int32">[failureCount]</OutArgument>
                        </Assign.To>
                        <Assign.Value>
                          <InArgument x:TypeArguments="x:Int32">[failureCount + 1]</InArgument>
                        </Assign.Value>
                      </Assign>
                    </If.Else>
                  </If>
                  <If Condition="[Not isDryRun]" DisplayName="[Check] Apply Delay?" sap:VirtualizedContainerService.HintSize="452,333" sap2010:WorkflowViewState.IdRef="If_4">
                    <If.Then>
                      <Delay DisplayName="Delay Between Emails" Duration="[TimeSpan.FromSeconds(delayBetweenEmailsSeconds)]" sap:VirtualizedContainerService.HintSize="450,91" sap2010:WorkflowViewState.IdRef="Delay_1" />
                    </If.Then>
                    <If.Else>
                      <Sequence DisplayName="Else" sap:VirtualizedContainerService.HintSize="450,90" sap2010:WorkflowViewState.IdRef="Sequence_7">
                        <sap:WorkflowViewStateService.ViewState>
                          <scg:Dictionary x:TypeArguments="x:String, x:Object">
                            <x:Boolean x:Key="IsExpanded">True</x:Boolean>
                          </scg:Dictionary>
                        </sap:WorkflowViewStateService.ViewState>
                      </Sequence>
                    </If.Else>
                  </If>
                </Sequence>
              </TryCatch.Try>
              <TryCatch.Catches>
                <Catch x:TypeArguments="s:Exception" sap2010:WorkflowViewState.IdRef="Catch`1_1">
                  <ActivityAction x:TypeArguments="s:Exception">
                    <ActivityAction.Argument>
                      <DelegateInArgument x:TypeArguments="s:Exception" Name="rowException" />
                    </ActivityAction.Argument>
                    <Sequence DisplayName="Handle Row-Level Exception" sap:VirtualizedContainerService.HintSize="486,401" sap2010:WorkflowViewState.IdRef="Sequence_4">
                      <sap:WorkflowViewStateService.ViewState>
                        <scg:Dictionary x:TypeArguments="x:String, x:Object">
                          <x:Boolean x:Key="IsExpanded">True</x:Boolean>
                        </scg:Dictionary>
                      </sap:WorkflowViewStateService.ViewState>
                      <ui:LogMessage DisplayName="[Log] Unhandled Row Exception" sap:VirtualizedContainerService.HintSize="452,175" sap2010:WorkflowViewState.IdRef="LogMessage_5" Level="Error" Message="[&quot;Unhandled error for row: &quot; &amp; rowException.Message]" />
                      <Assign DisplayName="Increment FailureCount (exception)" sap:VirtualizedContainerService.HintSize="452,166" sap2010:WorkflowViewState.IdRef="Assign_24">
                        <Assign.To>
                          <OutArgument x:TypeArguments="x:Int32">[failureCount]</OutArgument>
                        </Assign.To>
                        <Assign.Value>
                          <InArgument x:TypeArguments="x:Int32">[failureCount + 1]</InArgument>
                        </Assign.Value>
                      </Assign>
                    </Sequence>
                  </ActivityAction>
                </Catch>
              </TryCatch.Catches>
              <TryCatch.Finally>
                <Sequence DisplayName="Finally" sap:VirtualizedContainerService.HintSize="486,90" sap2010:WorkflowViewState.IdRef="Sequence_8">
                  <sap:WorkflowViewStateService.ViewState>
                    <scg:Dictionary x:TypeArguments="x:String, x:Object">
                      <x:Boolean x:Key="IsExpanded">True</x:Boolean>
                    </scg:Dictionary>
                  </sap:WorkflowViewStateService.ViewState>
                </Sequence>
              </TryCatch.Finally>
            </TryCatch>
          </Sequence>
        </ActivityAction>
      </ui:ForEach.Body>
    </ui:ForEach>
    <ui:LogMessage DisplayName="[Log] Final Summary" sap:VirtualizedContainerService.HintSize="524,175" sap2010:WorkflowViewState.IdRef="LogMessage_6" Level="Info" Message="[&quot;=== COMPLETED | Successes: &quot; &amp; successCount.ToString() &amp; &quot; | Failures: &quot; &amp; failureCount.ToString() &amp; &quot; ===&quot;]" />
    <ui:MessageBox ChosenButton="{x:Null}" AutoCloseAfter="00:00:00" Caption="[&quot;Job Application Bot – Done&quot;]" DisplayName="Final Summary Message Box" sap:VirtualizedContainerService.HintSize="524,114" sap2010:WorkflowViewState.IdRef="MessageBox_1" Text="[&quot;✅ Emails processed!&quot; &amp; Environment.NewLine &amp; Environment.NewLine &amp; &quot;✔ Successful: &quot; &amp; successCount.ToString() &amp; Environment.NewLine &amp; &quot;✖ Failed:     &quot; &amp; failureCount.ToString() &amp; Environment.NewLine &amp; Environment.NewLine &amp; If(isDryRun, &quot;⚠️  DRY RUN MODE – No emails were actually sent.&quot;, &quot;Check data\Log.xlsx for details.&quot;)]" />
  </Sequence>
</Activity>