/// <summary>
///
/// </summary>
/// <param name="siteTagId"></param>
public void DeleteFieldsByContentId(long contentId)
{
ContentLibrary contLib = new ContentLibrary();
//DELETE VALUES FOR THE CONTENT and ITS CHILDS
var values = from v in _context.awContentCustomFieldValues
join f in _context.awContentCustomFields on v.customFieldId equals f.customFieldId
where f.contentId.Equals(contentId)
select v;
//DELETE FIELDS FOR THE CONTENT and ITS CHILDS
var fields = from f in _context.awContentCustomFields
where f.contentId.Equals(contentId)
select f;
_context.awContentCustomFieldValues.DeleteAllOnSubmit(values);
_context.awContentCustomFields.DeleteAllOnSubmit(fields);
_context.SubmitChanges();
}
/// <summary>
/// if not exists add static and custom content fields to the form,,,
/// NOTE: this method DOES NOT call SUBMITCHANGES
/// </summary>
/// <param name="contentId"></param>
/// <param name="contentFormId"></param>
public void AddFieldsToForm(long contentId, long contentFormId, bool submitChanges)
{
//Cleanup if exists
CleanupCustomFields();
//Add static fields first
int sortOrder = 1;
foreach (string field in Enum.GetNames(typeof(StaticFieldsName)))
{
awContentFormFieldSetting set = new awContentFormFieldSetting();
set.contentFormFieldSettingId = AWAPI_Common.library.MiscLibrary.CreateUniqueId();
set.contentFormId = contentFormId;
set.staticFieldName = field;
set.isContentCustomField = false;
set.isEnabled = false;
set.isVisible = false;
set.sortOrder = sortOrder;
AddFieldSetting(set);
sortOrder++;
}
//add custom fields
awContent content = new ContentLibrary().Get(contentId);
System.Collections.Generic.IEnumerable <AWAPI_Data.CustomEntities.ContentCustomField> cstFlds = new ContentCustomFieldLibrary().GetFieldList(contentId, true);
if (cstFlds != null && cstFlds.Count() > 0)
{
var customFields = from r in cstFlds
where r.isEnabled &&
(r.applyToSubContents == false && r.fieldContentId.Equals(contentId) ||
r.applyToSubContents && r.fieldContentId.Equals(content.parentContentId))
orderby r.sortOrder
select r;
if (customFields != null && customFields.Count() > 0)
{
cstFlds = customFields.ToList();
foreach (AWAPI_Data.CustomEntities.ContentCustomField cf in cstFlds)
{
awContentFormFieldSetting set = new awContentFormFieldSetting();
set.contentFormFieldSettingId = AWAPI_Common.library.MiscLibrary.CreateUniqueId();
set.contentFormId = contentFormId;
set.contentCustomFieldId = cf.customFieldId;
set.staticFieldName = "";
set.isContentCustomField = true;
set.isEnabled = false;
set.isVisible = false;
set.sortOrder = sortOrder;
AddFieldSetting(set);
sortOrder = sortOrder + 10;
}
}
}
if (submitChanges)
{
_context.SubmitChanges();
}
}