/// <summary>
/// Action <code>ActionBootstrapContacts</code> that represents the Service Studio user action
/// <code>BootstrapContacts</code> <p> Description: Populates the database with the contacts from th
/// e excel file if the corresponding database table is still empty</p>
/// </summary>
public static void ActionBootstrapContacts(HeContext heContext)
{
lcvBootstrapContacts localVars = new lcvBootstrapContacts();
if (heContext != null && heContext.RequestTracer != null)
{
heContext.RequestTracer.RegisterInternalCall("K1bGnfsi2kam_D7_C_yQqA", "BootstrapContacts", "X0RMeX3yYU+0eg2nFEDfaA", "ContactManager");
}
// Query datasetGetContacts
int datasetGetContacts_maxRecords = 0;
localVars.queryResGetContacts_outParamList = FuncActionBootstrapContacts.datasetGetContacts(heContext, datasetGetContacts_maxRecords, IterationMultiplicity.Never, out localVars.queryResGetContacts_outParamCount);
if ((localVars.queryResGetContacts_outParamList.Empty))
{
// ExcelToRecordList ExcelToRLBootstrapContactsConvertFromExcel
FuncActionBootstrapContacts.ExcelToRLBootstrapContactsConvertFromExcel(heContext, RuntimePlatformUtils.GetResourceBinary("bin2\\hidden_resources\\ContactManager\\Contacts.xlsx", "bin2\\hidden_resources\\ContactManager\\Contacts.xlsx"), "Contacts", out localVars.resConvertFromExcel_outParamOut);
// Foreach ConvertFromExcel
localVars.resConvertFromExcel_outParamOut.StartIteration();
try {
while (!((localVars.resConvertFromExcel_outParamOut.Eof)))
{
// Assign ContactRecord
// ContactRecord.Contact.Name = ConvertFromExcel.Current.Excel_Contacts.Name
localVars.varLcContactRecord.ssENContact.ssName = localVars.resConvertFromExcel_outParamOut.CurrentRec.ssSTExcel_Contacts.ssName;
// ContactRecord.Contact.JobTitle = ConvertFromExcel.Current.Excel_Contacts.JobTitle
localVars.varLcContactRecord.ssENContact.ssJobTitle = localVars.resConvertFromExcel_outParamOut.CurrentRec.ssSTExcel_Contacts.ssJobTitle;
// ContactRecord.Contact.Phone = ConvertFromExcel.Current.Excel_Contacts.Phone
localVars.varLcContactRecord.ssENContact.ssPhone = localVars.resConvertFromExcel_outParamOut.CurrentRec.ssSTExcel_Contacts.ssPhone;
// ContactRecord.Contact.Email = ConvertFromExcel.Current.Excel_Contacts.Email
localVars.varLcContactRecord.ssENContact.ssEmail = localVars.resConvertFromExcel_outParamOut.CurrentRec.ssSTExcel_Contacts.ssEmail;
// CreateContact
ExtendedActions.CreateContact(heContext, localVars.varLcContactRecord, out localVars.resCreateContact_outParamId);
localVars.resConvertFromExcel_outParamOut.Advance();
}
} finally {
localVars.resConvertFromExcel_outParamOut.EndIteration();
}
}
}
