private void loadContactForm_SubmissionArray(string jsonData)
{
if (ContactForm_SubmissionArray == null)
{
this.ContactForm_SubmissionArray = new List<HubSpotContactForm_Submission>();
}
JArray records = JArray.Parse(jsonData);
foreach (JObject record in records)
{
HubSpotContactForm_Submission ContactForm_Submission = new HubSpotContactForm_Submission(record);
ContactForm_SubmissionArray.Add(ContactForm_Submission);
}
}
private void updLeadContactEvent(string strGuid, HubSpotContactForm_Submission contactForm_Submission)
{
HubSpotMap mapCONTSUPP = getMap("CONTSUPP");
USQLServer.openConnection(SQLConnection);
string query = "UPDATE CONTSUPP SET ";
foreach (DictionaryEntry entry in mapCONTSUPP.Items)
{
HubSpotMapItem item = (HubSpotMapItem)entry.Value;
if (item.CRMFieldName.Equals("zip", StringComparison.OrdinalIgnoreCase) ||
//item.CRMFieldName.Equals("ext", StringComparison.OrdinalIgnoreCase) ||
item.CRMFieldName.Equals("contsupref", StringComparison.OrdinalIgnoreCase) ||
item.CRMFieldName.Equals("ADDRESS1", StringComparison.OrdinalIgnoreCase) ||
item.CRMFieldName.Equals("COUNTRY", StringComparison.OrdinalIgnoreCase))
{
query += item.CRMFieldName + " = @" + item.CRMFieldName + ", ";
}
}
query = query.Remove(query.LastIndexOf(","));
query += " where RECTYPE='P' and contact='HubSpot' and Address2='" + strGuid + "'";
SqlCommand updateCmd = new SqlCommand(query, SQLConnection);
string strValue = "";
SqlParameter parm;
foreach (DictionaryEntry entry in mapCONTSUPP.Items)
{
HubSpotMapItem item = (HubSpotMapItem)entry.Value;
if (item.CRMFieldName.Equals("zip", StringComparison.OrdinalIgnoreCase) ||
//item.CRMFieldName.Equals("ext", StringComparison.OrdinalIgnoreCase) ||
item.CRMFieldName.Equals("contsupref", StringComparison.OrdinalIgnoreCase) ||
item.CRMFieldName.Equals("ADDRESS1", StringComparison.OrdinalIgnoreCase) ||
item.CRMFieldName.Equals("COUNTRY", StringComparison.OrdinalIgnoreCase))
{
if (item.CRMFieldName.Equals("zip", StringComparison.OrdinalIgnoreCase))
strValue = SLX_Data.dateTimeToISODateString(contactForm_Submission.TimeStamp);
else if (item.CRMFieldName.Equals("ext", StringComparison.OrdinalIgnoreCase))
strValue = contactForm_Submission.Form_Id;
else if (item.CRMFieldName.Equals("contsupref", StringComparison.OrdinalIgnoreCase))
strValue = contactForm_Submission.Title;
else if (item.CRMFieldName.Equals("ADDRESS1", StringComparison.OrdinalIgnoreCase))
strValue = contactForm_Submission.Page_Title;
else if (item.CRMFieldName.Equals("COUNTRY", StringComparison.OrdinalIgnoreCase))
strValue = contactForm_Submission.Portal_Id;
else
strValue = "";
if (item.CrmDataType.Equals("NText", StringComparison.OrdinalIgnoreCase))
parm = new SqlParameter("@" + item.CRMFieldName, SqlDbType.NText);
else if (item.CrmDataType.Equals("Text", StringComparison.OrdinalIgnoreCase))
parm = new SqlParameter("@" + item.CRMFieldName, SqlDbType.Text);
else
parm = new SqlParameter("@" + item.CRMFieldName, SqlDbType.VarChar);
parm.Value = getTrimValue(strValue, item.MaxLength, item.CrmDataType);
updateCmd.Parameters.Add(parm);
}
}
try
{
//USQLServer.executeCommand(updateCmd, SQLConnection);
updateCmd.ExecuteNonQuery();
updateCmd.Dispose();
}
catch (System.Web.Services.Protocols.SoapException ex)
{
ULogging.writeToDebugLog(AppGlobal.getAppLogger(), "Contact to HubSpot Query: " + ex.Message);
}
USQLServer.closeConnection(SQLConnection);
}