/// <summary>
/// Handles the Click event of the lbSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
protected void lbSave_Click(object sender, EventArgs e)
{
var rockContext = new RockContext();
ContentChannelType contentType;
ContentChannelTypeService contentTypeService = new ContentChannelTypeService(rockContext);
int contentTypeId = int.Parse(hfId.Value);
if (contentTypeId == 0)
{
contentType = new ContentChannelType();
contentTypeService.Add(contentType);
contentType.CreatedByPersonAliasId = CurrentPersonAliasId;
contentType.CreatedDateTime = RockDateTime.Now;
}
else
{
contentType = contentTypeService.Get(contentTypeId);
contentType.ModifiedByPersonAliasId = CurrentPersonAliasId;
contentType.ModifiedDateTime = RockDateTime.Now;
}
if (contentType != null)
{
contentType.Name = tbName.Text;
contentType.DateRangeType = ddlDateRangeType.SelectedValue.ConvertToEnum <ContentChannelDateType>();
contentType.IncludeTime = cbIncludeTime.Checked;
contentType.DisablePriority = cbDisablePriority.Checked;
contentType.DisableContentField = cbDisableContentField.Checked;
contentType.DisableStatus = cbDisableStatus.Checked;
contentType.ShowInChannelList = cbShowInChannelList.Checked;
if (!Page.IsValid || !contentType.IsValid)
{
// Controls will render the error messages
return;
}
rockContext.WrapTransaction(() =>
{
rockContext.SaveChanges();
// get it back to make sure we have a good Id for it for the Attributes
contentType = contentTypeService.Get(contentType.Guid);
// Save the Channel Attributes
int entityTypeId = EntityTypeCache.Get(typeof(ContentChannel)).Id;
SaveAttributes(contentType.Id, entityTypeId, ChannelAttributesState, rockContext);
// Save the Item Attributes
entityTypeId = EntityTypeCache.Get(typeof(ContentChannelItem)).Id;
SaveAttributes(contentType.Id, entityTypeId, ItemAttributesState, rockContext);
});
NavigateToParentPage();
}
}
/// <summary>
/// Shows the detail.
/// </summary>
/// <param name="contentTypeId">The marketing campaign ad type identifier.</param>
public void ShowDetail(int contentTypeId)
{
var rockContext = new RockContext();
ContentChannelType contentType = null;
if (!contentTypeId.Equals(0))
{
contentType = GetContentChannelType(contentTypeId);
pdAuditDetails.SetEntity(contentType, ResolveRockUrl("~"));
}
if (contentType == null)
{
contentType = new ContentChannelType {
Id = 0
};
// hide the panel drawer that show created and last modified dates
pdAuditDetails.Visible = false;
}
string title = contentType.Id > 0 ?
ActionTitle.Edit(ContentChannelType.FriendlyTypeName) :
ActionTitle.Add(ContentChannelType.FriendlyTypeName);
lTitle.Text = title.FormatAsHtmlTitle();
hfId.Value = contentType.Id.ToString();
tbName.Text = contentType.Name;
ddlDateRangeType.BindToEnum <ContentChannelDateType>();
ddlDateRangeType.SetValue((int)contentType.DateRangeType);
cbIncludeTime.Checked = contentType.IncludeTime;
cbDisablePriority.Checked = contentType.DisablePriority;
// load attribute data
ChannelAttributesState = new List <Attribute>();
ItemAttributesState = new List <Attribute>();
AttributeService attributeService = new AttributeService(new RockContext());
string qualifierValue = contentType.Id.ToString();
attributeService.GetByEntityTypeId(new ContentChannel().TypeId).AsQueryable()
.Where(a =>
a.EntityTypeQualifierColumn.Equals("ContentChannelTypeId", StringComparison.OrdinalIgnoreCase) &&
a.EntityTypeQualifierValue.Equals(qualifierValue))
.ToList()
.ForEach(a => ChannelAttributesState.Add(a));
BindChannelAttributesGrid();
attributeService.GetByEntityTypeId(new ContentChannelItem().TypeId).AsQueryable()
.Where(a =>
a.EntityTypeQualifierColumn.Equals("ContentChannelTypeId", StringComparison.OrdinalIgnoreCase) &&
a.EntityTypeQualifierValue.Equals(qualifierValue))
.ToList()
.ForEach(a => ItemAttributesState.Add(a));
BindItemAttributesGrid();
}
/// <summary>
/// Handles the Click event of the lbSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
protected void lbSave_Click(object sender, EventArgs e)
{
var rockContext = new RockContext();
ContentChannelType contentType;
ContentChannelTypeService contentTypeService = new ContentChannelTypeService(rockContext);
int contentTypeId = int.Parse(hfId.Value);
if (contentTypeId == 0)
{
contentType = new ContentChannelType();
contentTypeService.Add(contentType);
}
else
{
contentType = contentTypeService.Get(contentTypeId);
}
if (contentType != null)
{
contentType.Name = tbName.Text;
contentType.DateRangeType = (ContentChannelDateType)int.Parse(ddlDateRangeType.SelectedValue);
contentType.DisablePriority = cbDisablePriority.Checked;
if (!Page.IsValid || !contentType.IsValid)
{
// Controls will render the error messages
return;
}
rockContext.WrapTransaction(() =>
{
rockContext.SaveChanges();
// get it back to make sure we have a good Id for it for the Attributes
contentType = contentTypeService.Get(contentType.Guid);
// Save the Channel Attributes
int entityTypeId = EntityTypeCache.Read(typeof(ContentChannel)).Id;
SaveAttributes(contentType.Id, entityTypeId, ChannelAttributesState, rockContext);
// Save the Item Attributes
entityTypeId = EntityTypeCache.Read(typeof(ContentChannelItem)).Id;
SaveAttributes(contentType.Id, entityTypeId, ItemAttributesState, rockContext);
});
NavigateToParentPage();
}
}
/// <summary>
/// Handles the Delete event of the gContentChannelType control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RowEventArgs" /> instance containing the event data.</param>
protected void gContentChannelType_Delete(object sender, RowEventArgs e)
{
var rockContext = new RockContext();
ContentChannelTypeService contentTypeService = new ContentChannelTypeService(rockContext);
ContentChannelType contentType = contentTypeService.Get(e.RowKeyId);
if (contentType != null)
{
string errorMessage;
if (!contentTypeService.CanDelete(contentType, out errorMessage))
{
mdGridWarning.Show(errorMessage, ModalAlertType.Information);
return;
}
contentTypeService.Delete(contentType);
rockContext.SaveChanges();
}
BindGrid();
}
/// <summary>
/// Handles the Click event of the lbSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
protected void lbSave_Click( object sender, EventArgs e )
{
var rockContext = new RockContext();
ContentChannelType contentType;
ContentChannelTypeService contentTypeService = new ContentChannelTypeService( rockContext );
int contentTypeId = int.Parse( hfId.Value );
if ( contentTypeId == 0 )
{
contentType = new ContentChannelType();
contentTypeService.Add( contentType );
}
else
{
contentType = contentTypeService.Get( contentTypeId );
}
if ( contentType != null )
{
contentType.Name = tbName.Text;
contentType.DateRangeType = (ContentChannelDateType)int.Parse( ddlDateRangeType.SelectedValue );
contentType.IncludeTime = cbIncludeTime.Checked;
contentType.DisablePriority = cbDisablePriority.Checked;
if ( !Page.IsValid || !contentType.IsValid )
{
// Controls will render the error messages
return;
}
rockContext.WrapTransaction( () =>
{
rockContext.SaveChanges();
// get it back to make sure we have a good Id for it for the Attributes
contentType = contentTypeService.Get( contentType.Guid );
// Save the Channel Attributes
int entityTypeId = EntityTypeCache.Read( typeof( ContentChannel ) ).Id;
SaveAttributes( contentType.Id, entityTypeId, ChannelAttributesState, rockContext );
// Save the Item Attributes
entityTypeId = EntityTypeCache.Read( typeof( ContentChannelItem ) ).Id;
SaveAttributes( contentType.Id, entityTypeId, ItemAttributesState, rockContext );
} );
NavigateToParentPage();
}
}
/// <summary>
/// Shows the detail.
/// </summary>
/// <param name="contentTypeId">The marketing campaign ad type identifier.</param>
public void ShowDetail( int contentTypeId )
{
var rockContext = new RockContext();
ContentChannelType contentType = null;
if ( !contentTypeId.Equals( 0 ) )
{
contentType = GetContentChannelType( contentTypeId );
}
if ( contentType == null )
{
contentType = new ContentChannelType { Id = 0 };
}
string title = contentType.Id > 0 ?
ActionTitle.Edit( ContentChannelType.FriendlyTypeName ) :
ActionTitle.Add( ContentChannelType.FriendlyTypeName );
lTitle.Text = title.FormatAsHtmlTitle();
hfId.Value = contentType.Id.ToString();
tbName.Text = contentType.Name;
ddlDateRangeType.BindToEnum<ContentChannelDateType>();
ddlDateRangeType.SetValue( (int)contentType.DateRangeType );
cbIncludeTime.Checked = contentType.IncludeTime;
cbDisablePriority.Checked = contentType.DisablePriority;
// load attribute data
ChannelAttributesState = new List<Attribute>();
ItemAttributesState = new List<Attribute>();
AttributeService attributeService = new AttributeService( new RockContext() );
string qualifierValue = contentType.Id.ToString();
attributeService.GetByEntityTypeId( new ContentChannel().TypeId ).AsQueryable()
.Where( a =>
a.EntityTypeQualifierColumn.Equals( "ContentChannelTypeId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( qualifierValue ) )
.ToList()
.ForEach( a => ChannelAttributesState.Add( a ) );
BindChannelAttributesGrid();
attributeService.GetByEntityTypeId( new ContentChannelItem().TypeId ).AsQueryable()
.Where( a =>
a.EntityTypeQualifierColumn.Equals( "ContentChannelTypeId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( qualifierValue ) )
.ToList()
.ForEach( a => ItemAttributesState.Add( a ) );
BindItemAttributesGrid();
}
/// <summary>
/// Loads the Content Channel data.
/// </summary>
/// <param name="csvData">The CSV data.</param>
private int LoadContentChannel(CSVInstance csvData)
{
var lookupContext = new RockContext();
var contentChannelService = new ContentChannelService(lookupContext);
var contentChannelTypeService = new ContentChannelTypeService(lookupContext);
var groupService = new GroupService(lookupContext);
// Look for custom attributes in the Content Channel file
var allFields = csvData.TableNodes.FirstOrDefault().Children.Select((node, index) => new { node = node, index = index }).ToList();
var customAttributes = allFields
.Where(f => f.index > ContentChannelParentId)
.ToDictionary(f => f.index, f => f.node.Name);
var completed = 0;
var importedCount = 0;
var alreadyImportedCount = contentChannelService.Queryable().AsNoTracking().Count(c => c.ForeignKey != null);
ReportProgress(0, $"Starting Content Channel import ({alreadyImportedCount:N0} already exist).");
string[] row;
// Uses a look-ahead enumerator: this call will move to the next record immediately
while ((row = csvData.Database.FirstOrDefault()) != null)
{
var rowContentChannelName = row[ContentChannelName];
var rowContentChannelTypeName = row[ContentChannelTypeName];
var rowContentChannelDescription = row[ContentChannelDescription];
var rowContentChannelId = row[ContentChannelId];
var rowContentChannelRequiresApproval = row[ContentChannelRequiresApproval];
var rowContentChannelParentId = row[ContentChannelParentId];
var rowChannelId = rowContentChannelId.AsType <int?>();
var requiresApproval = ( bool )ParseBoolOrDefault(rowContentChannelRequiresApproval, false);
var contentChannelTypeId = 0;
if (contentChannelTypeService.Queryable().AsNoTracking().FirstOrDefault(t => t.Name.ToLower() == rowContentChannelTypeName.ToLower()) != null)
{
contentChannelTypeId = contentChannelTypeService.Queryable().AsNoTracking().FirstOrDefault(t => t.Name.ToLower() == rowContentChannelTypeName.ToLower()).Id;
}
//
// Verify the Content Channel Type Exists
//
if (contentChannelTypeId < 1)
{
var newConentChannelType = new ContentChannelType
{
Name = rowContentChannelTypeName,
DateRangeType = ContentChannelDateType.DateRange,
IncludeTime = true,
DisablePriority = true,
CreatedDateTime = ImportDateTime
};
lookupContext.ContentChannelTypes.Add(newConentChannelType);
lookupContext.SaveChanges(DisableAuditing);
contentChannelTypeId = lookupContext.ContentChannelTypes.FirstOrDefault(t => t.Name == rowContentChannelTypeName).Id;
}
//
// Check that this Content Channel doesn't already exist.
//
var exists = false;
if (alreadyImportedCount > 0)
{
exists = contentChannelService.Queryable().AsNoTracking().Any(c => c.ForeignKey == rowContentChannelId);
}
if (!exists)
{
//
// Create and populate the new Content Channel.
//
var contentChannel = new ContentChannel
{
Name = rowContentChannelName,
Description = rowContentChannelDescription,
ContentChannelTypeId = contentChannelTypeId,
ForeignKey = rowContentChannelId,
ForeignId = rowChannelId,
ContentControlType = ContentControlType.HtmlEditor,
RequiresApproval = requiresApproval
};
//
// Look for Parent Id and create appropriate objects.
//
if (!string.IsNullOrWhiteSpace(rowContentChannelParentId))
{
var ParentChannels = new List <ContentChannel>();
var parentChannel = contentChannelService.Queryable().FirstOrDefault(p => p.ForeignKey == rowContentChannelParentId);
if (parentChannel.ForeignKey == rowContentChannelParentId)
{
ParentChannels.Add(parentChannel);
contentChannel.ParentContentChannels = ParentChannels;
}
}
// Save changes for context
lookupContext.WrapTransaction(() =>
{
lookupContext.ContentChannels.Add(contentChannel);
lookupContext.SaveChanges(DisableAuditing);
});
// Set security if needed
if (contentChannel.RequiresApproval)
{
var rockAdmins = groupService.Get(Rock.SystemGuid.Group.GROUP_ADMINISTRATORS.AsGuid());
contentChannel.AllowSecurityRole(Authorization.APPROVE, rockAdmins, lookupContext);
var communicationAdmins = groupService.Get(Rock.SystemGuid.Group.GROUP_COMMUNICATION_ADMINISTRATORS.AsGuid());
contentChannel.AllowSecurityRole(Authorization.APPROVE, communicationAdmins, lookupContext);
// Save security changes
lookupContext.WrapTransaction(() =>
{
lookupContext.SaveChanges(DisableAuditing);
});
}
//
// Process Attributes for Content Channels
//
if (customAttributes.Any())
{
// create content channel attributes
foreach (var newAttributePair in customAttributes)
{
var pairs = newAttributePair.Value.Split('^');
var categoryName = string.Empty;
var attributeName = string.Empty;
var attributeTypeString = string.Empty;
var attributeForeignKey = string.Empty;
var definedValueForeignKey = string.Empty;
var fieldTypeId = TextFieldTypeId;
if (pairs.Length == 1)
{
attributeName = pairs[0];
}
else if (pairs.Length == 2)
{
attributeName = pairs[0];
attributeTypeString = pairs[1];
}
else if (pairs.Length >= 3)
{
categoryName = pairs[1];
attributeName = pairs[2];
if (pairs.Length >= 4)
{
attributeTypeString = pairs[3];
}
if (pairs.Length >= 5)
{
attributeForeignKey = pairs[4];
}
if (pairs.Length >= 6)
{
definedValueForeignKey = pairs[5];
}
}
var definedValueForeignId = definedValueForeignKey.AsType <int?>();
//
// Translate the provided attribute type into one we know about.
//
fieldTypeId = GetAttributeFieldType(attributeTypeString);
if (string.IsNullOrEmpty(attributeName))
{
LogException("Content Channel Type", $"Content Channel Type Channel Attribute Name cannot be blank '{newAttributePair.Value}'.");
}
else
{
var fk = string.Empty;
if (string.IsNullOrWhiteSpace(attributeForeignKey))
{
fk = $"Bulldozer_ContentChannelType_{contentChannelTypeId}_{categoryName.RemoveWhitespace()}_{attributeName.RemoveWhitespace()}".Left(100);
}
else
{
fk = attributeForeignKey;
}
AddEntityAttribute(lookupContext, contentChannel.TypeId, "ContentChannelTypeId", contentChannelTypeId.ToString(), fk, categoryName, attributeName, string.Empty, fieldTypeId, true, definedValueForeignId, definedValueForeignKey, attributeTypeString: attributeTypeString);
}
}
//
// Add any Content Channel attribute values
//
foreach (var attributePair in customAttributes)
{
var newValue = row[attributePair.Key];
if (!string.IsNullOrWhiteSpace(newValue))
{
var pairs = attributePair.Value.Split('^');
var categoryName = string.Empty;
var attributeName = string.Empty;
var attributeTypeString = string.Empty;
var attributeForeignKey = string.Empty;
var definedValueForeignKey = string.Empty;
if (pairs.Length == 1)
{
attributeName = pairs[0];
}
else if (pairs.Length == 2)
{
attributeName = pairs[0];
attributeTypeString = pairs[1];
}
else if (pairs.Length >= 3)
{
categoryName = pairs[1];
attributeName = pairs[2];
if (pairs.Length >= 4)
{
attributeTypeString = pairs[3];
}
if (pairs.Length >= 5)
{
attributeForeignKey = pairs[4];
}
if (pairs.Length >= 6)
{
definedValueForeignKey = pairs[5];
}
}
if (!string.IsNullOrEmpty(attributeName))
{
string fk = string.Empty;
if (string.IsNullOrWhiteSpace(attributeForeignKey))
{
fk = $"Bulldozer_ContentChannelType_{contentChannelTypeId}_{categoryName.RemoveWhitespace()}_{attributeName.RemoveWhitespace()}".Left(100);
}
else
{
fk = attributeForeignKey;
}
var attribute = FindEntityAttribute(lookupContext, categoryName, attributeName, contentChannel.TypeId, fk);
AddEntityAttributeValue(lookupContext, attribute, contentChannel, newValue, null, true);
}
}
}
}
importedCount++;
}
//
// Notify user of our status.
//
completed++;
if (completed % (ReportingNumber * 10) < 1)
{
ReportProgress(0, $"{completed:N0} Content Channel records processed, {importedCount:N0} imported.");
}
if (completed % ReportingNumber < 1)
{
lookupContext.SaveChanges();
ReportPartialProgress();
// Clear out variables
contentChannelService = new ContentChannelService(lookupContext);
}
}
//
// Save any other changes to existing items.
//
lookupContext.SaveChanges();
lookupContext.Dispose();
ReportProgress(0, $"Finished Content Channel import: {importedCount:N0} records added.");
return(completed);
}