private static OneTableExcelConfigurationBuilder <ScenarioCampaignFailureExportModel> CreateExcelConfigurationBuilder(string[] weekDays, DayOfWeek tenantStartDayOfWeek)
{
var confBuilder = new OneTableExcelConfigurationBuilder <ScenarioCampaignFailureExportModel>()
.SetDefaultStyles();
return(confBuilder
.OrderMembersAsDescribed()
.IgnoreNotDescribed()
.ForMember(m => m.ExternalCampaignId, o => o.Width(20))
.ForMember(m => m.CampaignName, o => o.Width(25))
.ForMember(m => m.SalesAreaGroupName, o => o.Width(25))
.ForMember(m => m.SalesAreaName, o => o.Width(25))
.ForMember(m => m.DurationSecs, o => o.Width(15))
.ForMember(m => m.MultipartNo, o => o.Width(13))
.ForMember(m => m.MultipartNo, o => o.Width(13))
.ForMember(m => m.StrikeWeightStartDate, o => o.Formatter(ReportFormatter.ConvertToShortDate).Header("StrikeWeight Start Date").Width(25))
.ForMember(m => m.StrikeWeightEndDate, o => o.Formatter(ReportFormatter.ConvertToShortDate).Header("StrikeWeight End Date").Width(25))
.ForMember(m => m.DayPartStartTime,
o => o.Formatter(ReportFormatter.ConvertToTime).Header("Daypart Start Time").Width(18))
.ForMember(m => m.DayPartEndTime, o => o.Formatter(ReportFormatter.ConvertToTime).Header("Daypart End Time").Width(18))
.ForMember(m => m.DayPartDays,
o => o.Header("Daypart Days")
.Formatter(m => DaypartDayFormattingUtilities.FormatWeekDays(weekDays, ((string)m), tenantStartDayOfWeek)).Width(15))
.ForMember(m => m.FailureTypeName, o => o.Width(25))
.ForMember(m => m.FailureCount, o => o.Width(15))
.ForMember(m => m.PassesEncounteringFailure, o => o.Header("Pass(s) Encountering Failure").Width(30)));
}
public static OneTableExcelConfigurationBuilder <TEntity> SetDefaultStyles <TEntity>(this OneTableExcelConfigurationBuilder <TEntity> builder)
where TEntity : class
{
builder.DefaultStyle(GamePlanReportStyles.DataCellStyle.Name)
.HeaderStyle(GamePlanReportStyles.HeaderStyle.Name)
.AlternateBackgroundColors(GamePlanReportStyles.AlternateBackgroundColors);
return(builder);
}
/// <summary>Creates the excel configuration builder.</summary>
/// <returns></returns>
private static OneTableExcelConfigurationBuilder <RecommendationExtendedModel> CreateExcelConfigurationBuilder()
{
var confBuilder = new OneTableExcelConfigurationBuilder <RecommendationExtendedModel>()
.SetDefaultStyles();
return(confBuilder
.OrderMembersAsDescribed()
.IgnoreNotDescribed()
.ForMember(r => r.SalesAreaGroupName, builder => builder.Width(21))
.ForMember(r => r.DemographicName, builder => builder.Width(18))
.ForMember(r => r.ClientName, builder => builder.Width(18))
.ForMember(r => r.ParentClashName, builder => builder.Width(32))
.ForMember(r => r.ClashName, builder => builder.Width(30))
.ForMember(r => r.ProductName, builder => builder.Width(72))
.ForMember(r => r.ScenarioId, builder => builder.Width(38))
.ForMember(r => r.ExternalSpotRef, builder => builder.Width(16))
.ForMember(r => r.ExternalCampaignNumber, builder => builder.Width(24))
.ForMember(r => r.SpotLengthInSec, builder => builder.Width(12).Header("Spot Length"))
.ForMember(r => r.Product, builder => builder.Width(10))
.ForMember(r => r.Demographic, builder => builder.Width(14))
.ForMember(r => r.BreakBookingPosition, builder => builder.Width(20))
.ForMember(r => r.SalesArea, builder => builder.Width(10))
.ForMember(r => r.ExternalProgrammeReference,
builder => builder.Width(10).Header("Programme External Reference"))
.ForMember(r => r.ProgrammeNo, builder => builder.Width(14))
.ForMember(r => r.ProgrammeName, builder => builder.Width(72))
.ForMember(r => r.StartDateTime, builder => builder.Width(22).Formatter(ReportFormatter.ConvertToDateTime))
.ForMember(r => r.StartDate, builder => builder.Width(12).Formatter(ReportFormatter.ConvertToShortDate))
.ForMember(r => r.StartTime, builder => builder.Width(12).Formatter(ReportFormatter.ConvertToTime))
.ForMember(r => r.DayPart, builder => builder.Width(12).Header("DayPart"))
.ForMember(r => r.WeekCommencingDate, builder => builder.Width(12).Formatter(ReportFormatter.ConvertToShortDate))
.ForMember(r => r.StartDayOfWeek, builder => builder.Width(10))
.ForMember(r => r.EndDateTime, builder => builder.Width(22).Formatter(ReportFormatter.ConvertToDateTime))
.ForMember(r => r.EndDate, builder => builder.Width(12).Formatter(ReportFormatter.ConvertToShortDate))
.ForMember(r => r.EndTime, builder => builder.Width(12).Formatter(ReportFormatter.ConvertToTime))
.ForMember(r => r.BreakType, builder => builder.Width(10))
.ForMember(r => r.SpotRating, builder => builder.Width(12))
.ForMember(r => r.SpotEfficiency, builder => builder.Width(14))
.ForMember(r => r.RatingPoints, builder => builder.Width(14))
.ForMember(r => r.Action, builder => builder.Width(10))
.ForMember(r => r.Processor, builder => builder.Width(12))
.ForMember(r => r.ProcessorDateTime,
builder => builder.Width(22).Formatter(ReportFormatter.ConvertToDateTime))
.ForMember(r => r.GroupCode, builder => builder.Width(12))
.ForMember(r => r.ClientPicked, builder => builder.Width(12))
.ForMember(r => r.MultipartSpot, builder => builder.Width(14))
.ForMember(r => r.MultipartSpotPosition, builder => builder.Width(22))
.ForMember(r => r.MultipartSpotRef, builder => builder.Width(18))
.ForMember(r => r.RequestedPositionInBreak, builder => builder.Width(26))
.ForMember(r => r.ActualPositionInBreak, builder => builder.Width(22))
.ForMember(r => r.ExternalBreakNo, builder => builder.Width(18))
.ForMember(r => r.Filler, builder => builder.Width(10))
.ForMember(r => r.Sponsored, builder => builder.Width(12))
.ForMember(r => r.Preemptable, builder => builder.Width(14))
.ForMember(r => r.Preemptlevel, builder => builder.Width(14).Header("Preempt Level"))
.ForMember(r => r.PassSequence, builder => builder.Width(14))
.ForMember(r => r.PassIterationSequence, builder => builder.Width(22))
.ForMember(r => r.PassName, builder => builder.Width(40))
.ForMember(r => r.OptimiserPassSequenceNumber, builder => builder.Width(32))
.ForMember(r => r.CampaignPassPriority, builder => builder.Width(22))
.ForMember(r => r.RankOfEfficiency, builder => builder.Width(18))
.ForMember(r => r.RankOfCampaign, builder => builder.Width(18))
.ForMember(r => r.CampaignWeighting, builder => builder.Width(20))
.ForMember(r => r.SpotSequenceNumber, builder => builder.Width(22)));
}
