private SyncState <Outlook.ContactItem> UpdateFromCrm(Outlook.MAPIFolder folder, eEntryValue candidateItem)
{
SyncState <Outlook.ContactItem> result;
dynamic crmItem = JsonConvert.DeserializeObject(candidateItem.name_value_object.ToString());
String id = crmItem.id.value.ToString();
var oItem = ItemsSyncState.FirstOrDefault(a => a.CrmEntryId == crmItem.id.value.ToString());
if (ShouldSyncContact(crmItem))
{
Log.Info(
string.Format(
"ContactSyncing.UpdateFromCrm, entry id is '{0}', sync_contact is true, syncing",
id));
if (oItem == null)
{
result = AddNewItemFromCrmToOutlook(folder, crmItem);
}
else
{
result = UpdateExistingOutlookItemFromCrm(crmItem, oItem);
}
}
else
{
Log.Info(
string.Format(
"ContactSyncing.UpdateFromCrm, entry id is '{0}', sync_contact is false, not syncing",
id));
result = oItem;
}
return(result);
}
override protected void OutlookItemChanged(Outlook.TaskItem oItem)
{
Log.Debug("Outlook Tasks ItemChange");
string entryId = oItem.EntryID;
Log.Warn("\toItem.EntryID= " + entryId);
var taskitem = ItemsSyncState.FirstOrDefault(a => a.OutlookItem.EntryID == entryId);
if (taskitem != null)
{
if ((DateTime.UtcNow - taskitem.OModifiedDate).TotalSeconds > 5)
{
Log.Warn("2 callitem.IsUpdate = " + taskitem.IsUpdate);
taskitem.IsUpdate = 0;
}
Log.Warn("Before UtcNow - callitem.OModifiedDate= " + (DateTime.UtcNow - taskitem.OModifiedDate).TotalSeconds.ToString());
if ((int)(DateTime.UtcNow - taskitem.OModifiedDate).TotalSeconds > 2 && taskitem.IsUpdate == 0)
{
taskitem.OModifiedDate = DateTime.UtcNow;
Log.Warn("1 callitem.IsUpdate = " + taskitem.IsUpdate);
taskitem.IsUpdate++;
}
Log.Warn("callitem = " + taskitem.OutlookItem.Subject);
Log.Warn("callitem.SEntryID = " + taskitem.CrmEntryId);
Log.Warn("callitem mod_date= " + taskitem.OModifiedDate.ToString());
Log.Warn("UtcNow - callitem.OModifiedDate= " + (DateTime.UtcNow - taskitem.OModifiedDate).TotalSeconds.ToString());
}
else
{
Log.Warn("not found callitem ");
}
if (IsCurrentView && ItemsSyncState.Exists(a => a.OutlookItem.EntryID == entryId && //// if (IsTaskView && lTaskItems.Exists(a => a.oItem.EntryID == entryId && a.OModifiedDate != "Fresh"))
taskitem.IsUpdate == 1
)
)
{
Outlook.UserProperty oProp1 = oItem.UserProperties["SEntryID"];
if (oProp1 != null)
{
Log.Warn("\tgo to AddTaskToS");
taskitem.IsUpdate++;
AddOrUpdateItemFromOutlookToCrm(oItem, this.DefaultCrmModule, oProp1.Value.ToString());
}
}
}
protected override SyncState <Outlook.ContactItem> UpdateFromCrm(Outlook.MAPIFolder folder, string crmType, eEntryValue crmItem)
{
SyncState <Outlook.ContactItem> result;
String id = crmItem.GetValueAsString("id");
var syncStateForItem = ItemsSyncState.FirstOrDefault(a => a.CrmEntryId == crmItem.GetValueAsString("id"));
if (ShouldSyncContact(crmItem))
{
Log.Info(
string.Format(
"ContactSyncing.UpdateFromCrm, entry id is '{0}', sync_contact is true, syncing",
id));
if (syncStateForItem == null)
{
result = AddNewItemFromCrmToOutlook(folder, crmItem);
}
else
{
result = UpdateExistingOutlookItemFromCrm(crmItem, syncStateForItem);
}
}
else if (syncStateForItem != null &&
syncStateForItem.OutlookItem != null &&
ShouldSyncFlagChanged(syncStateForItem.OutlookItem, crmItem))
{
/* The date_modified value in CRM does not get updated when the sync_contact value
* is changed. But seeing this value can only be updated at the CRM side, if it
* has changed the change must have been at the CRM side. Note also that it must
* have changed to 'false', because if it had changed to 'true' we would have
* synced normally in the above branch. Delete from Outlook. */
Log.Warn($"ContactSyncing.UpdateFromCrm, entry id is '{id}', sync_contact has changed to {ShouldSyncContact(crmItem)}, deleting");
this.RemoveItemAndSyncState(syncStateForItem);
result = syncStateForItem;
}
else
{
Log.Info(
string.Format(
"ContactSyncing.UpdateFromCrm, entry id is '{0}', sync_contact is false, not syncing",
id));
result = syncStateForItem;
}
return(result);
}
protected override SyncState <Outlook.TaskItem> UpdateFromCrm(Outlook.MAPIFolder tasksFolder, string crmType, eEntryValue crmItem)
{
SyncState <Outlook.TaskItem> result = null;
if (clsSuiteCRMHelper.GetUserId() == crmItem.GetValueAsString("assigned_user_id"))
{
DateTime?date_start = null;
DateTime?date_due = null;
string time_start = "--:--", time_due = "--:--";
if (!string.IsNullOrWhiteSpace(crmItem.GetValueAsString("date_start")))
{
Log.Warn("\tSET date_start = dResult.date_start");
date_start = DateTime.ParseExact(crmItem.GetValueAsString("date_start"), "yyyy-MM-dd HH:mm:ss", null);
date_start = date_start.Value.Add(new DateTimeOffset(DateTime.Now).Offset);
time_start =
TimeSpan.FromHours(date_start.Value.Hour)
.Add(TimeSpan.FromMinutes(date_start.Value.Minute))
.ToString(@"hh\:mm");
}
if (date_start != null && date_start >= GetStartDate())
{
if (!string.IsNullOrWhiteSpace(crmItem.GetValueAsString("date_due")))
{
date_due = DateTime.ParseExact(crmItem.GetValueAsString("date_due"), "yyyy-MM-dd HH:mm:ss", null);
date_due = date_due.Value.Add(new DateTimeOffset(DateTime.Now).Offset);
time_due =
TimeSpan.FromHours(date_due.Value.Hour).Add(TimeSpan.FromMinutes(date_due.Value.Minute)).ToString(@"hh\:mm");
;
}
var oItem = ItemsSyncState.FirstOrDefault(a => a.CrmEntryId == crmItem.GetValueAsString("id"));
if (oItem == null)
{
result = AddNewItemFromCrmToOutlook(tasksFolder, crmItem, date_start, date_due, time_start, time_due);
}
else
{
result = UpdateExistingOutlookItemFromCrm(crmItem, date_start, date_due, time_start, time_due, oItem);
}
}
}
return(result);
}
private SyncState <Outlook.ContactItem> AddOrGetSyncState(Outlook.ContactItem oItem)
{
var entryId = oItem.EntryID;
var existingState = ItemsSyncState.FirstOrDefault(a => a.OutlookItem.EntryID == entryId);
if (existingState != null)
{
existingState.OutlookItem = oItem;
return(existingState);
}
else
{
var newState = new ContactSyncState
{
OutlookItem = oItem,
CrmEntryId = oItem.UserProperties["SEntryID"]?.Value.ToString(),
OModifiedDate = ParseDateTimeFromUserProperty(oItem.UserProperties["SOModifiedDate"]?.Value.ToString()),
};
ItemsSyncState.Add(newState);
return(newState);
}
}
/// <summary>
/// Get the existing sync state representing the item with this CRM id, if it exists, else null.
/// </summary>
/// <param name="crmItemId">The id of a CRM item</param>
/// <returns>the existing sync state representing the item with this CRM id, if it exists, else null.</returns>
protected SyncState <OutlookItemType> GetExistingSyncState(string crmItemId)
{
SyncState <OutlookItemType> result;
try
{
/* if there are duplicate entries I want them logged */
result = ItemsSyncState.SingleOrDefault(a => a.CrmEntryId == crmItemId);
}
catch (InvalidOperationException notUnique)
{
Log.Error(
String.Format(
"AppointmentSyncing.AddItemFromOutlookToCrm: CRM Id {0} was not unique in this.ItemsSyncState?",
crmItemId),
notUnique);
/* but if it isn't unique, the first will actually do for now */
result = ItemsSyncState.FirstOrDefault(a => a.CrmEntryId == crmItemId);
}
return(result);
}
protected override SyncState <Outlook.AppointmentItem> GetExistingSyncState(Outlook.AppointmentItem oItem)
{
return(ItemsSyncState.FirstOrDefault(a => !a.IsDeletedInOutlook && a.OutlookItem.EntryID == oItem.EntryID));
}
private void AddToCrm(Outlook.TaskItem oItem, string sID = "")
{
Log.Warn("AddTaskToS");
//if (!settings.SyncCalendar)
// return;
if (oItem == null)
{
return;
}
try
{
string _result = String.Empty;
eNameValue[] data = new eNameValue[7];
string strStatus = String.Empty;
string strImportance = String.Empty;
switch (oItem.Status)
{
case Outlook.OlTaskStatus.olTaskNotStarted:
strStatus = "Not Started";
break;
case Outlook.OlTaskStatus.olTaskInProgress:
strStatus = "In Progress";
break;
case Outlook.OlTaskStatus.olTaskComplete:
strStatus = "Completed";
break;
case Outlook.OlTaskStatus.olTaskDeferred:
strStatus = "Deferred";
break;
}
switch (oItem.Importance)
{
case Outlook.OlImportance.olImportanceLow:
strImportance = "Low";
break;
case Outlook.OlImportance.olImportanceNormal:
strImportance = "Medium";
break;
case Outlook.OlImportance.olImportanceHigh:
strImportance = "High";
break;
}
DateTime uTCDateTime = new DateTime();
DateTime time2 = new DateTime();
uTCDateTime = oItem.StartDate.ToUniversalTime();
if (oItem.DueDate != null)
{
time2 = oItem.DueDate.ToUniversalTime();
}
string body = String.Empty;
string str, str2;
str = str2 = String.Empty;
if (oItem.Body != null)
{
body = oItem.Body.ToString();
var times = this.ParseTimesFromTaskBody(body);
if (times != null)
{
uTCDateTime = uTCDateTime.Add(times[0]);
time2 = time2.Add(times[1]);
//check max date, date must has value !
if (uTCDateTime.ToUniversalTime().Year < 4000)
{
str = string.Format("{0:yyyy-MM-dd HH:mm:ss}", uTCDateTime.ToUniversalTime());
}
if (time2.ToUniversalTime().Year < 4000)
{
str2 = string.Format("{0:yyyy-MM-dd HH:mm:ss}", time2.ToUniversalTime());
}
}
else
{
str = oItem.StartDate.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
str2 = oItem.DueDate.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
}
}
else
{
str = oItem.StartDate.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
str2 = oItem.DueDate.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
}
//str = "2016-11-10 11:34:01";
//str2 = "2016-11-19 11:34:01";
string description = String.Empty;
if (!string.IsNullOrEmpty(body))
{
int lastIndex = body.LastIndexOf("#<");
if (lastIndex >= 0)
{
description = body.Remove(lastIndex);
}
else
{
description = body;
}
}
Log.Warn("\tdescription= " + description);
data[0] = clsSuiteCRMHelper.SetNameValuePair("name", oItem.Subject);
data[1] = clsSuiteCRMHelper.SetNameValuePair("description", description);
data[2] = clsSuiteCRMHelper.SetNameValuePair("status", strStatus);
data[3] = clsSuiteCRMHelper.SetNameValuePair("date_due", str2);
data[4] = clsSuiteCRMHelper.SetNameValuePair("date_start", str);
data[5] = clsSuiteCRMHelper.SetNameValuePair("priority", strImportance);
if (sID == String.Empty)
{
data[6] = clsSuiteCRMHelper.SetNameValuePair("assigned_user_id", clsSuiteCRMHelper.GetUserId());
}
else
{
data[6] = clsSuiteCRMHelper.SetNameValuePair("id", sID);
}
_result = clsSuiteCRMHelper.SetEntryUnsafe(data, "Tasks");
Outlook.UserProperty oProp = oItem.UserProperties["SOModifiedDate"];
if (oProp == null)
{
oProp = oItem.UserProperties.Add("SOModifiedDate", Outlook.OlUserPropertyType.olText);
}
oProp.Value = DateTime.UtcNow;
Outlook.UserProperty oProp2 = oItem.UserProperties["SEntryID"];
if (oProp2 == null)
{
oProp2 = oItem.UserProperties.Add("SEntryID", Outlook.OlUserPropertyType.olText);
}
oProp2.Value = _result;
string entryId = oItem.EntryID;
oItem.Save();
var sItem = ItemsSyncState.FirstOrDefault(a => a.OutlookItem.EntryID == entryId);
if (sItem != null)
{
sItem.OutlookItem = oItem;
sItem.OModifiedDate = DateTime.UtcNow;
sItem.CrmEntryId = _result;
}
else
{
ItemsSyncState.Add(new TaskSyncState {
CrmEntryId = _result, OModifiedDate = DateTime.UtcNow, OutlookItem = oItem
});
}
Log.Warn("\tdate_start= " + str + ", date_due=" + str2);
}
catch (Exception ex)
{
Log.Error("ThisAddIn.AddTaskToS", ex);
}
}
private SyncState <Outlook.TaskItem> UpdateFromCrm(Outlook.MAPIFolder tasksFolder, eEntryValue oResult)
{
dynamic dResult = JsonConvert.DeserializeObject(oResult.name_value_object.ToString());
//
if (clsSuiteCRMHelper.GetUserId() != dResult.assigned_user_id.value.ToString())
{
return(null);
}
DateTime?date_start = null;
DateTime?date_due = null;
string time_start = "--:--", time_due = "--:--";
if (!string.IsNullOrWhiteSpace(dResult.date_start.value.ToString()) &&
!string.IsNullOrEmpty(dResult.date_start.value.ToString()))
{
Log.Warn("\tSET date_start = dResult.date_start");
date_start = DateTime.ParseExact(dResult.date_start.value.ToString(), "yyyy-MM-dd HH:mm:ss", null);
date_start = date_start.Value.Add(new DateTimeOffset(DateTime.Now).Offset);
time_start =
TimeSpan.FromHours(date_start.Value.Hour)
.Add(TimeSpan.FromMinutes(date_start.Value.Minute))
.ToString(@"hh\:mm");
}
if (date_start != null && date_start < GetStartDate())
{
Log.Warn("\tdate_start=" + date_start.ToString() + ", GetStartDate= " + GetStartDate().ToString());
return(null);
}
if (!string.IsNullOrWhiteSpace(dResult.date_due.value.ToString()))
{
date_due = DateTime.ParseExact(dResult.date_due.value.ToString(), "yyyy-MM-dd HH:mm:ss", null);
date_due = date_due.Value.Add(new DateTimeOffset(DateTime.Now).Offset);
time_due =
TimeSpan.FromHours(date_due.Value.Hour).Add(TimeSpan.FromMinutes(date_due.Value.Minute)).ToString(@"hh\:mm");
;
}
foreach (var lt in ItemsSyncState)
{
Log.Warn("\tTask= " + lt.CrmEntryId);
}
var oItem = ItemsSyncState.FirstOrDefault(a => a.CrmEntryId == dResult.id.value.ToString());
if (oItem == null)
{
Log.Warn("\tif default");
Outlook.TaskItem tItem = tasksFolder.Items.Add(Outlook.OlItemType.olTaskItem);
tItem.Subject = dResult.name.value.ToString();
if (!string.IsNullOrWhiteSpace(dResult.date_start.value.ToString()))
{
tItem.StartDate = date_start.Value;
}
if (!string.IsNullOrWhiteSpace(dResult.date_due.value.ToString()))
{
tItem.DueDate = date_due.Value; // DateTime.Parse(dResult.date_due.value.ToString());
}
string body = dResult.description.value.ToString();
tItem.Body = string.Concat(body, "#<", time_start, "#", time_due);
tItem.Status = GetStatus(dResult.status.value.ToString());
tItem.Importance = GetImportance(dResult.priority.value.ToString());
Outlook.UserProperty oProp = tItem.UserProperties.Add("SOModifiedDate", Outlook.OlUserPropertyType.olText);
oProp.Value = dResult.date_modified.value.ToString();
Outlook.UserProperty oProp2 = tItem.UserProperties.Add("SEntryID", Outlook.OlUserPropertyType.olText);
oProp2.Value = dResult.id.value.ToString();
var newState = new TaskSyncState
{
OutlookItem = tItem,
OModifiedDate = DateTime.ParseExact(dResult.date_modified.value.ToString(), "yyyy-MM-dd HH:mm:ss", null),
CrmEntryId = dResult.id.value.ToString(),
};
ItemsSyncState.Add(newState);
Log.Warn("\tsave 0");
tItem.Save();
return(newState);
}
else
{
Log.Warn("\telse not default");
Outlook.TaskItem tItem = oItem.OutlookItem;
Outlook.UserProperty oProp = tItem.UserProperties["SOModifiedDate"];
Log.Warn(
(string)
("\toProp.Value= " + oProp.Value + ", dResult.date_modified=" + dResult.date_modified.value.ToString()));
if (oProp.Value != dResult.date_modified.value.ToString())
{
tItem.Subject = dResult.name.value.ToString();
if (!string.IsNullOrWhiteSpace(dResult.date_start.value.ToString()))
{
Log.Warn("\ttItem.StartDate= " + tItem.StartDate + ", date_start=" + date_start);
tItem.StartDate = date_start.Value;
}
if (!string.IsNullOrWhiteSpace(dResult.date_due.value.ToString()))
{
tItem.DueDate = date_due.Value; // DateTime.Parse(dResult.date_due.value.ToString());
}
string body = dResult.description.value.ToString();
tItem.Body = string.Concat(body, "#<", time_start, "#", time_due);
tItem.Status = GetStatus(dResult.status.value.ToString());
tItem.Importance = GetImportance(dResult.priority.value.ToString());
if (oProp == null)
{
oProp = tItem.UserProperties.Add("SOModifiedDate", Outlook.OlUserPropertyType.olText);
}
oProp.Value = dResult.date_modified.value.ToString();
Outlook.UserProperty oProp2 = tItem.UserProperties["SEntryID"];
if (oProp2 == null)
{
oProp2 = tItem.UserProperties.Add("SEntryID", Outlook.OlUserPropertyType.olText);
}
oProp2.Value = dResult.id.value.ToString();
Log.Warn("\tsave 1");
tItem.Save();
}
oItem.OModifiedDate = DateTime.ParseExact(dResult.date_modified.value.ToString(), "yyyy-MM-dd HH:mm:ss", null);
return(oItem);
}
}
