public void PopulateReplacementsList()
{
var key = string.Empty;
var value = string.Empty;
var temp = new List <string>();
ReplacementsList.Clear();
key = "Flightdates";
value = FlightDates;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = "Advertiser - Decisionmaker";
value = String.Format("{0} - {1}", Advertiser, DecisionMaker);
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = "Flightdates - Advertiser - Decisionmaker";
value = String.Format("{0} - {1} - {2}", FlightDates, Advertiser, DecisionMaker);
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
if (!String.IsNullOrEmpty(Quarter))
{
key = "Program";
value = String.Format(ShowProgram ?
"Program ({0})" :
"Day-Time ({0})",
Quarter);
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
else if (!ShowProgram)
{
key = "Program";
value = "Day-Time";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (!ShowLength && SpotsPerSlide < 24)
{
key = "Lgth";
value = "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if ((!ShowDay || !ShowProgram) && SpotsPerSlide < 20)
{
key = "Day";
value = "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if ((!ShowTime || !ShowProgram) && SpotsPerSlide < 20)
{
key = "Time";
value = "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (!ShowRates)
{
key = "Rate";
value = "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (!ShowTotalSpots)
{
key = "Total Spots";
value = "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (!ShowCost)
{
key = "Total Cost";
value = "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (SpotsPerSlide < 15)
{
key = "Rtg";
value = ShowRating ? RtgHeaderTitle : "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (SpotsPerSlide < 14)
{
key = "Total Points";
value = ShowGRP ? GRPHeaderTitle : "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = "CPP";
value = ShowCPP ? CPPHeaderTitle : "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (!(ShowSpots || ShowTotalSpots || ShowCPP || ShowGRP || ShowCost))
{
key = "Total";
value = "Delete Row";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
key = "tspot";
value = TotalSpot;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = "tcost";
value = TotalCost;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
if (SpotsPerSlide < 14)
{
key = "totalpts";
value = TotalGRP;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = "cppavg";
value = TotalCPP;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
var totalCount = Totals.Count;
for (var i = 0; i < 3; i++)
{
var firsrtTagIndex = i * 2;
var secondTagIndex = firsrtTagIndex + 1;
key = String.Format("[info{0}] [info{1}]", firsrtTagIndex + 1, secondTagIndex + 1);
var firsrtDataIndex = i * 4;
var secondDataIndex = firsrtDataIndex + 1;
var thirdDataIndex = firsrtDataIndex + 2;
var forthDataIndex = firsrtDataIndex + 3;
temp.Clear();
if (firsrtDataIndex < totalCount)
{
temp.Add(String.Format("[{0} {1}]", Totals.ElementAt(firsrtDataIndex).Key, Totals.ElementAt(firsrtDataIndex).Value));
}
if (secondDataIndex < totalCount)
{
temp.Add(String.Format("[{0} {1}]", Totals.ElementAt(secondDataIndex).Key, Totals.ElementAt(secondDataIndex).Value));
}
if (thirdDataIndex < totalCount)
{
temp.Add(String.Format("[{0} {1}]", Totals.ElementAt(thirdDataIndex).Key, Totals.ElementAt(thirdDataIndex).Value));
}
if (forthDataIndex < totalCount)
{
temp.Add(String.Format("[{0} {1}]", Totals.ElementAt(forthDataIndex).Key, Totals.ElementAt(forthDataIndex).Value));
}
value = temp.Any() ? String.Join(" ", temp) : "Delete Row";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
{
key = "[info1] [info2] [info3] [info4] [info5] [info6] [info7] [info8]";
temp.Clear();
if (Totals.Any())
{
temp.Add(String.Join(" ", Totals.Select(pair => String.Format("[{0} {1}]", pair.Key, pair.Value))));
}
if (!String.IsNullOrEmpty(DigitalInfo.SummaryInfo))
{
temp.Add(DigitalInfo.SummaryInfo);
}
value = String.Join(String.Format("{0}", (char)13), temp);
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
var totalSpotsCount = TotalSpots.Count;
for (var i = 0; i < SpotsPerSlide; i++)
{
key = string.Format("MO {0}", (i + 1).ToString("00"));
if (i < totalSpotsCount && ShowSpots)
{
if (_parent.UseGenericDateColumns)
{
value = string.Format("{0}{2}{1}", _parent.SpotType == SpotType.Week ? "wk" : "mo", (i + 1), (char)13);
}
else if (_parent.SpotType == SpotType.Week)
{
value = TotalSpots[i].Month + (char)13 + TotalSpots[i].Day;
}
else if (_parent.SpotType == SpotType.Month)
{
value = TotalSpots[i].Month;
}
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = string.Format("t{0}", i + 1);
value = TotalSpots[i].Value;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
else
{
value = "Delete Column";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
Application.DoEvents();
}
var progarmsCount = Programs.Count;
for (var i = 0; i < ProgramsPerSlide; i++)
{
key = String.Format("[Station{0}] Program{0}", i + 1);
if (i < progarmsCount)
{
var program = Programs[i];
temp.Clear();
if (ShowStation)
{
temp.Add(ShowStationInBrackets ? String.Format("[{0}]", program.Station) : String.Format("{0} ", program.Station));
}
temp.Add(ShowProgram ?
program.Name :
String.Format("{0} {1}", program.Days, program.Time));
value = String.Join(" ", temp);
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = String.Format("{0}", (i + 1).ToString("00"));
value = program.LineID;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
if (SpotsPerSlide >= 24)
{
key = String.Format("len{0} day{0} time{0} rtg{0} pts{0} cpp{0}", i + 1);
temp.Clear();
if (ShowLength)
{
temp.Add(String.Format("{0}", program.Length));
}
if (ShowDay && ShowProgram)
{
temp.Add(String.Format("{0}", program.Days));
}
if (ShowTime && ShowProgram)
{
temp.Add(String.Format("{0}", program.Time));
}
if (ShowRating)
{
temp.Add(String.Format("{0}: {1}", RtgHeaderTitle.Replace(((char)13).ToString(), " "), program.Rating));
}
if (ShowGRP)
{
temp.Add(String.Format("{0}: {1}", GRPHeaderTitle, program.GRP));
}
if (ShowCPP)
{
temp.Add(String.Format("{0}: {1}", CPPHeaderTitle, program.CPP));
}
value = String.Format(" {0}", String.Join(" ", temp));
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (SpotsPerSlide < 24)
{
key = String.Format("len{0}", (i + 1));
value = ShowLength ? program.Length : String.Empty;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
if (SpotsPerSlide >= 20)
{
key = String.Format("day{0} time{0} rtg{0} pts{0} cpp{0}", i + 1);
temp.Clear();
if (ShowDay && ShowProgram)
{
temp.Add(String.Format("{0}", program.Days));
}
if (ShowTime && ShowProgram)
{
temp.Add(String.Format("{0}", program.Time));
}
if (ShowRating)
{
temp.Add(String.Format("{0}: {1}", RtgHeaderTitle.Replace(((char)13).ToString(), " "), program.Rating));
}
if (ShowGRP)
{
temp.Add(String.Format("{0}: {1}", GRPHeaderTitle, program.GRP));
}
if (ShowCPP)
{
temp.Add(String.Format("{0}: {1}", CPPHeaderTitle, program.CPP));
}
value = String.Format(" {0}", String.Join(" ", temp));
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
}
if (SpotsPerSlide < 20)
{
key = String.Format("day{0}", (i + 1));
value = ShowDay && ShowProgram ? program.Days : String.Empty;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = String.Format("time{0}", (i + 1));
value = ShowTime && ShowProgram ? program.Time : String.Empty;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
if (SpotsPerSlide >= 15)
{
key = String.Format("rtg{0} pts{0} cpp{0}", i + 1);
temp.Clear();
if (ShowRating)
{
temp.Add(String.Format("{0}: {1}", RtgHeaderTitle.Replace(((char)13).ToString(), " "), program.Rating));
}
if (ShowGRP)
{
temp.Add(String.Format("{0}: {1}", GRPHeaderTitle, program.GRP));
}
if (ShowCPP)
{
temp.Add(String.Format("{0}: {1}", CPPHeaderTitle, program.CPP));
}
value = String.Format(" {0}", String.Join(" ", temp));
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
}
if (SpotsPerSlide < 15)
{
key = String.Format("rtg{0}", (i + 1));
value = ShowRating ? program.Rating : String.Empty;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
if (SpotsPerSlide >= 14)
{
key = String.Format("pts{0} cpp{0}", i + 1);
temp.Clear();
if (ShowGRP)
{
temp.Add(String.Format("{0}: {1}", GRPHeaderTitle, program.GRP));
}
if (ShowCPP)
{
temp.Add(String.Format("{0}: {1}", CPPHeaderTitle, program.CPP));
}
value = String.Format(" {0}", String.Join(" ", temp));
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
}
if (SpotsPerSlide < 14)
{
key = String.Format("pts{0}", (i + 1));
value = ShowGRP ? program.GRP : String.Empty;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
key = String.Format("cpp{0}", (i + 1));
value = ShowCPP ? program.CPP : String.Empty;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (ShowRates)
{
key = String.Format("rt{0}", (i + 1));
value = program.Rate;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (ShowTotalSpots)
{
key = String.Format("sp{0}", (i + 1));
value = program.TotalSpots;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (ShowCost)
{
key = String.Format("cs{0}", (i + 1));
value = program.TotalRate;
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
if (ShowSpots)
{
var spotsCount = program.Spots.Count;
for (int j = 0; j < SpotsPerSlide; j++)
{
if (j < spotsCount)
{
var spotSuffix = "a";
switch (j)
{
case 0:
spotSuffix = "a";
break;
case 1:
spotSuffix = "b";
break;
case 2:
spotSuffix = "c";
break;
case 3:
spotSuffix = "d";
break;
case 4:
spotSuffix = "e";
break;
case 5:
spotSuffix = "f";
break;
case 6:
spotSuffix = "g";
break;
case 7:
spotSuffix = "h";
break;
case 8:
spotSuffix = "i";
break;
case 9:
spotSuffix = "j";
break;
case 10:
spotSuffix = "k";
break;
case 11:
spotSuffix = "l";
break;
case 12:
spotSuffix = "m";
break;
case 13:
spotSuffix = "n";
break;
case 14:
spotSuffix = "o";
break;
case 15:
spotSuffix = "p";
break;
case 16:
spotSuffix = "q";
break;
case 17:
spotSuffix = "r";
break;
case 18:
spotSuffix = "s";
break;
case 19:
spotSuffix = "t";
break;
case 20:
spotSuffix = "u";
break;
case 21:
spotSuffix = "v";
break;
case 22:
spotSuffix = "w";
break;
case 23:
spotSuffix = "x";
break;
case 24:
spotSuffix = "y";
break;
case 25:
spotSuffix = "z";
break;
}
key = string.Format("{0}{1}", (i + 1), spotSuffix);
value = program.Spots[j];
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
Application.DoEvents();
}
else
{
break;
}
}
}
Application.DoEvents();
}
else
{
value = "Delete Row";
if (!ReplacementsList.Keys.Contains(key))
{
ReplacementsList.Add(key, value);
}
}
}
DigitalInfo.PopulateReplacementsList();
foreach (var digitalInfoReplacementRecord in DigitalInfo.ReplacementsList)
{
if (!ReplacementsList.ContainsKey(digitalInfoReplacementRecord.Key))
{
ReplacementsList.Add(digitalInfoReplacementRecord.Key, digitalInfoReplacementRecord.Value);
}
}
}
