private void insertHubspotLeadConversionEventRecord(int leadId, HubSpotLead leadRecord)
{
Dictionary<string, int> trimMap = getTrimMap(getMap("LeadConversionEvent"));
ArrayList guids = new ArrayList();
string sqlQuery = "conv_leadid = " + leadId + ""; //Didn't include criteria to check for records that haven't been deleted on purpose. We want all guids added to the list regardless of whether they have been deleted.
queryresult entityResult = binding.query(sqlQuery, "LeadConversionEvent");
ewarebase[] leadConversionEventBase = entityResult.records;
if (leadConversionEventBase != null)
{
//ULogging.writeToDebugLog(AppGlobal.getAppLogger(), "leadConversionEventBase.Length: " + leadId + " - " + leadConversionEventBase.Length);
for(int i = 0; i < leadConversionEventBase.Length; i++)
{
leadconversionevent leadConversionEvent = (leadconversionevent)leadConversionEventBase[i];
if(guids.Contains(leadConversionEvent.guid) == false)
{
guids.Add(leadConversionEvent.guid);
}
}
}
int counter = 0;
List<ewarebase> CRMBase = new List<ewarebase>();
ULogging.writeToDebugLog(AppGlobal.getAppLogger(), "leadRecord.LeadConversionEvents.Count: " + leadId + " - " + leadRecord.LeadConversionEvents.Count);
foreach (HubSpotLeadConversionEvent leadConversionEvent in leadRecord.LeadConversionEvents)
{
if (guids.Contains(leadConversionEvent.getStringValue("guid")) == false)
{
leadconversionevent CRMLeadConversionEvent = new leadconversionevent();
CRMLeadConversionEvent.leadid = leadId;
CRMLeadConversionEvent.leadidSpecified = true;
CRMLeadConversionEvent.conversiondate = leadConversionEvent.getDateTimeValueInLocalTime("convertDate");
CRMLeadConversionEvent.conversiondateSpecified = true;
CRMLeadConversionEvent.formid = getTrimmedValue(trimMap, "FORMID", leadConversionEvent.getStringValue("formId"));
CRMLeadConversionEvent.formguid = getTrimmedValue(trimMap, "FORMGUID", leadConversionEvent.getStringValue("formGuid"));
CRMLeadConversionEvent.formname = getTrimmedValue(trimMap, "FORMNAME", leadConversionEvent.getStringValue("formName"));
CRMLeadConversionEvent.formvalues = leadConversionEvent.FormValuesString.Replace("/n/r", Environment.NewLine).Replace("/n", Environment.NewLine);
CRMLeadConversionEvent.guid = getTrimmedValue(trimMap, "GUID", leadConversionEvent.getStringValue("guid"));
CRMLeadConversionEvent.leadguid = getTrimmedValue(trimMap, "LEADGUID", leadConversionEvent.getStringValue("leadGuid"));
CRMLeadConversionEvent.pagename = getTrimmedValue(trimMap, "PAGENAME", leadConversionEvent.getStringValue("pageName"));
CRMLeadConversionEvent.pagetype = getTrimmedValue(trimMap, "PAGETYPE", leadConversionEvent.getStringValue("pageType"));
CRMLeadConversionEvent.pageurl = getTrimmedValue(trimMap, "PAGEURL", leadConversionEvent.getStringValue("pageUrl"));
CRMLeadConversionEvent.portalid = getTrimmedValue(trimMap, "PORTALID", leadConversionEvent.getStringValue("portalId"));
CRMBase.Add(CRMLeadConversionEvent);
counter++;
}
}
if (CRMBase.Count > 0)
{
try
{
addresult CRMAddResult = binding.add("LeadConversionEvent", CRMBase.ToArray());
}
catch (Exception e)
{
ULogging.writeToDebugLog(AppGlobal.getAppLogger(), "EXCEPTION IN insertHubspotLeadConversionEventRecord", e);
}
}
}
private void insertContactHubspotForm_SubmissionRecord(int leadId, HubSpotLead aContactRecord)
{
HubSpotMap LeadConversionEvent = getMap("LeadConversionEvent");
ArrayList guids = new ArrayList();
string sqlQuery = "conv_leadid = " + leadId + ""; //Didn't include criteria to check for records that haven't been deleted on purpose. We want all guids added to the list regardless of whether they have been deleted.
queryresult entityResult = binding.query(sqlQuery, "LeadConversionEvent");
ewarebase[] leadConversionEventBase = entityResult.records;
if (leadConversionEventBase != null)
{
//ULogging.writeToDebugLog(AppGlobal.getAppLogger(), "leadConversionEventBase.Length: " + leadId + " - " + leadConversionEventBase.Length);
for (int i = 0; i < leadConversionEventBase.Length; i++)
{
leadconversionevent leadConversionEvent = (leadconversionevent)leadConversionEventBase[i];
if (guids.Contains(leadConversionEvent.guid) == false)
{
guids.Add(leadConversionEvent.guid);
}
}
}
int counter = 0;
List<ewarebase> CRMBase = new List<ewarebase>();
ULogging.writeToDebugLog(AppGlobal.getAppLogger(), "contactRecord.ContactForm_Submission.Count: " + leadId + " - " + aContactRecord.ContactForm_Submissions.Count);
foreach (HubSpotContactForm_Submission contactForm_Submission in aContactRecord.ContactForm_Submissions)
{
if (guids.Contains(contactForm_Submission.Conversion_Id) == false)
{
leadconversionevent CRMLeadConversionEvent = new leadconversionevent();
CRMLeadConversionEvent.leadid = leadId;
CRMLeadConversionEvent.leadidSpecified = true;
CRMLeadConversionEvent.conversiondate = contactForm_Submission.TimeStamp;
CRMLeadConversionEvent.conversiondateSpecified = true;
CRMLeadConversionEvent.formid = getTrimValue(LeadConversionEvent.getItem("formid"), contactForm_Submission.Form_Id);
CRMLeadConversionEvent.formguid = getTrimValue(LeadConversionEvent.getItem("formguid"), contactForm_Submission.Form_Id);
CRMLeadConversionEvent.formname = getTrimValue(LeadConversionEvent.getItem("formname"), contactForm_Submission.Page_Title);
CRMLeadConversionEvent.formvalues = buildFormValues(contactForm_Submission.Conversion_Id, aContactRecord); //leadConversionEvent.FormValuesString.Replace("/n/r", Environment.NewLine).Replace("/n", Environment.NewLine);
CRMLeadConversionEvent.guid = getTrimValue(LeadConversionEvent.getItem("guid"), contactForm_Submission.Conversion_Id);
CRMLeadConversionEvent.leadguid = getTrimValue(LeadConversionEvent.getItem("LEADGUID"), aContactRecord.ContactDetailRecord.getStringValue("vid"));
CRMLeadConversionEvent.pagename = getTrimValue(LeadConversionEvent.getItem("pagename"), contactForm_Submission.Page_Title);
CRMLeadConversionEvent.pagetype = getTrimValue(LeadConversionEvent.getItem("pagetype"), contactForm_Submission.Page_Id);
CRMLeadConversionEvent.pageurl = getTrimValue(LeadConversionEvent.getItem("pageurl"), contactForm_Submission.Page_Url);
CRMLeadConversionEvent.portalid = getTrimValue(LeadConversionEvent.getItem("portalid"), contactForm_Submission.Portal_Id);
CRMBase.Add(CRMLeadConversionEvent);
counter++;
}
}
if (CRMBase.Count > 0)
{
try
{
addresult CRMAddResult = binding.add("LeadConversionEvent", CRMBase.ToArray());
}
catch (Exception e)
{
ULogging.writeToDebugLog(AppGlobal.getAppLogger(), "EXCEPTION IN insertHubspotContactForm_SubmissionRecord", e);
}
}
}