public bool DeleteFieldValueByITemID(long id)
{
List<CCFieldValue> dbEntryList = context.CCFieldValues.Where(fv => fv.ItemID==id).ToList();
foreach (var dbEntry in dbEntryList)
{
if (dbEntry != null)
{
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = dbEntry.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = dbEntry.FieldID;
HistoryLog.ItemID = dbEntry.ItemID;
HistoryLog.NewValue = dbEntry.Value;
HistoryLog.OldValue = "";
HistoryLog.Source = "Web";
HistoryLog.Action = "Delete";
context.CCHistoryLog.Add(HistoryLog);
context.CCFieldValues.Remove(dbEntry);
context.SaveChanges();
}
}
return true;
}
public bool DeleteContact(long id)
{
CCItems dbEntry = context.CCContacts.Find(id);
if (dbEntry != null)
{
// context.CCContacts.Remove(dbEntry);
dbEntry.LastUpdated = DateTime.Now.ToUniversalTime();
dbEntry.isDeleted = true;
context.SaveChanges();
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = dbEntry.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = 0;
HistoryLog.ItemID = dbEntry.ItemID;
HistoryLog.NewValue = "" ;
HistoryLog.OldValue = "";
HistoryLog.Source = "Web";
HistoryLog.Action = "Delete";
HistoryLog.ConnectionID = 0;
context.CCHistoryLog.Add(HistoryLog);
context.SaveChanges();
return true;
}
return false;
}
public CCHistoryLog SaveHistoryLog(CCHistoryLog historyLogsObj)
{
if (historyLogsObj.ID == 0)
{
context.CCHistoryLog.Add(historyLogsObj);
context.SaveChanges();
}
return historyLogsObj;
}
public bool DeleteFieldValue(long id)
{
CCFieldValue dbEntry = context.CCFieldValues.Find(id);
if (dbEntry != null)
{
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = dbEntry.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = dbEntry.FieldID;
HistoryLog.ItemID = dbEntry.ItemID;
HistoryLog.NewValue = dbEntry.Value;
HistoryLog.OldValue = "";
HistoryLog.Source = "Web";
HistoryLog.Action = "Delete";
context.CCHistoryLog.Add(HistoryLog);
context.CCFieldValues.Remove(dbEntry);
context.SaveChanges();
return true;
}
return false;
}
public bool UpdateContact(CCItems contactObj)
{
CCItems dbEntry = context.CCContacts.Find(contactObj.ItemID);
if (dbEntry != null)
{
dbEntry.LastUpdated = DateTime.Now.ToUniversalTime();
dbEntry.DeDupeValue = contactObj.DeDupeValue;
if (dbEntry.TextBody != contactObj.TextBody)
dbEntry.TextBody = contactObj.TextBody;
if (dbEntry.Notes != contactObj.Notes)
dbEntry.Notes = contactObj.Notes;
if (dbEntry.isDeleted != contactObj.isDeleted)
{
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = dbEntry.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = 0;
HistoryLog.ItemID = dbEntry.ItemID;
HistoryLog.NewValue = "";
HistoryLog.OldValue = "";
HistoryLog.Source = "Web";
HistoryLog.Action = "Delete-Revert";
HistoryLog.ConnectionID = 0;
context.CCHistoryLog.Add(HistoryLog);
context.SaveChanges();
dbEntry.isDeleted = contactObj.isDeleted;
}
context.SaveChanges();
return true;
}
return false;
}
public CCFieldValue RevertChangeToFieldValues(CCFieldValue FieldValueObj, CCHistoryLog HistLogObj)
{
CCFieldValue dbEntry = context.CCFieldValues.Find(FieldValueObj.ValueID);
if (dbEntry != null)
{
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = FieldValueObj.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = dbEntry.FieldID;
HistoryLog.ItemID = dbEntry.ItemID;
HistoryLog.NewValue = FieldValueObj.Value;
HistoryLog.OldValue = HistLogObj.NewValue;
HistoryLog.Source = "Web";
HistoryLog.Action = "Update";
HistoryLog.ConnectionID = 0;
context.CCHistoryLog.Add(HistoryLog);
dbEntry.Value = FieldValueObj.Value;
context.SaveChanges();
}
return FieldValueObj;
}
public CCFieldValue SaveFieldValues(CCFieldValue FieldValueObj)
{
if (FieldValueObj.ValueID == 0)
{
context.CCFieldValues.Add(FieldValueObj);
//context.SaveChanges();
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = FieldValueObj.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = FieldValueObj.FieldID;
HistoryLog.ItemID = FieldValueObj.ItemID;
HistoryLog.NewValue = FieldValueObj.Value;
HistoryLog.OldValue = "";
HistoryLog.Source = "Web";
HistoryLog.Action = "Insert";
HistoryLog.ConnectionID = 0;
context.CCHistoryLog.Add(HistoryLog);
context.SaveChanges();
}
else
{
CCFieldValue dbEntry = context.CCFieldValues.Find(FieldValueObj.ValueID);
if (dbEntry != null)
{
if (dbEntry.Value != FieldValueObj.Value)
{
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = FieldValueObj.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = dbEntry.FieldID;
HistoryLog.ItemID = dbEntry.ItemID;
HistoryLog.NewValue = FieldValueObj.Value;
HistoryLog.OldValue = dbEntry.Value;
HistoryLog.Source = "Web";
HistoryLog.Action = "Update";
HistoryLog.ConnectionID = 0;
context.CCHistoryLog.Add(HistoryLog);
//context.SaveChanges();
dbEntry.LastUpdated = DateTime.UtcNow;
}
dbEntry.Value = FieldValueObj.Value;
context.SaveChanges();
}
}
return FieldValueObj;
}
public List<CCFieldValue> SaveFieldsObjValues(List<CCFieldValue> FieldValues)
{
foreach (CCFieldValue fieldvalues in FieldValues)
{
context.CCFieldValues.Add(fieldvalues);
CCHistoryLog HistoryLog = new CCHistoryLog();
HistoryLog.AccountGUID = fieldvalues.AccountGUID;
HistoryLog.Date = DateTime.Now;
HistoryLog.FieldID = fieldvalues.FieldID;
HistoryLog.ItemID = fieldvalues.ItemID;
HistoryLog.NewValue = fieldvalues.Value;
HistoryLog.OldValue = "";
HistoryLog.Source = "Web";
HistoryLog.Action = "Insert";
HistoryLog.ConnectionID = 0;
context.CCHistoryLog.Add(HistoryLog);
//context.SaveChanges();
}
context.SaveChanges();
return FieldValues;
}