public static string PopulateRow(string body)
{
body = body.Replace("###Title###", "Entry Form");
body = body.Replace("###Logo###", WebURL + "images/logo-apaceffie-high.png");
body = body.Replace("###HeaderLogo###", WebURL + "images/Header-logo-pdf.png");
body = body.Replace("###IconList###", WebURL + "images/icon-list.png");
body = body.Replace("###DesTotalOfCountries###", entryForm.DesTotalOfCountries);
body = body.Replace("###Product###", entry.ProductClassification);
body = body.Replace("###BrandName###", entry.Brand);
body = body.Replace("###ProductServiceClassification###", entry.Client);
body = body.Replace("###EntryTitle###", entry.Campaign);
/////////////////////////////////
body = body.Replace("###ComparedOtherCompetitorsCheck###", GetMoreLess(entryForm.ComparedOtherCompetitorsCheck));
body = body.Replace("###ComparedOverallSpendCheck###", GetMoreLess(entryForm.ComparedOverallSpendCheck));
/////////////////////////////////
body = body.Replace("###SectionD###", GeneralFunctionEntryForm.CheckTextfield(entryForm.ListAndExplainOtherMarketingText));
if (entryForm.ComparedOtherCompetitorsCheck != "" && entryForm.ComparedOtherCompetitorsCheck != null)
{
string[] ComparedOtherCompetitorsCheck = entryForm.ComparedOtherCompetitorsCheck.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (ComparedOtherCompetitorsCheck.Length != 0)
{
try
{
body = body.Replace("###CompareATitleA###", ((ComparedOtherCompetitorsCheck[0].Replace(" ", "") == "True") ? check() : "" + " "));
body = body.Replace("###CompareATitleB###", ((ComparedOtherCompetitorsCheck[1].Replace(" ", "") == "True") ? check() : "" + " "));
body = body.Replace("###CompareATitleC###", ((ComparedOtherCompetitorsCheck[2].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareATitleD###", ((ComparedOtherCompetitorsCheck[3].Replace(" ", "") == "True") ? check("center") : "" + " "));
}
catch { }
}
}
if (entryForm.PaidMediaExpendituresCheck != "" && entryForm.PaidMediaExpendituresCheck != null)
{
string[] PME = entryForm.PaidMediaExpendituresCheck.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (PME.Length != 0)
{
//body = body.Replace("###PaidMediaExpendituresCurrent###", "<p style=\"color: #fff;\">-</p>");
//body = body.Replace("###PaidMediaExpendituresPrior###", "<p style=\"color: #fff;\">-</p>");
try
{
body = body.Replace("###CurrentYear###", PME[0].Replace(" ", ""));
body = body.Replace("###YearPrior###", PME[1].Replace(" ", ""));
body = body.Replace("###PaidMediaExpendituresCurrent###", PME[2].Replace(" ", ""));
body = body.Replace("###PaidMediaExpendituresPrior###", PME[3].Replace(" ", ""));
}
catch
{
}
}
}
if (entryForm.ComparedOverallSpendCheck != "" && entryForm.ComparedOverallSpendCheck != null)
{
string[] ComparedOverallSpendCheck = entryForm.ComparedOverallSpendCheck.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (ComparedOverallSpendCheck.Length != 0)
{
try
{
body = body.Replace("###CompareBTitleA###", ((ComparedOverallSpendCheck[0].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareBTitleB###", ((ComparedOverallSpendCheck[1].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareBTitleC###", ((ComparedOverallSpendCheck[2].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareBTitleD###", ((ComparedOverallSpendCheck[3].Replace(" ", "") == "True") ? check("center") : "" + " "));
}
catch { }
}
}
body = body.Replace("###EntryTitle###", entry.Brand);
body = body.Replace("###EntryID###", entry.Serial);
body = body.Replace("###YouEnteringInto###", Data.GetCategoryMarket(entry.CategoryMarket));
body = body.Replace("###EntryCategory###", entry.CategoryPSDetail);
body = body.Replace("###CountryHeader###", entry.Effectiveness);
body = body.Replace("###StartDate###", entry.DateCampaignStart.ToString("dd MMM yyyy"));
body = body.Replace("###EndDate###", entry.DateCampaignEnd.ToString("dd MMM yyyy"));
try
{
string countries = "";
foreach (string country in entry.CaseData.Split('|'))
{
countries += country + ", ";
}
body = body.Replace("###Totalnumber###", (entry.CaseData.Split('|').Count() - 1).ToString());
body = body.Replace("###CountriesList###", countries.Substring(0, countries.Length - 4) + ".");
}
catch
{
body = body.Replace("###Totalnumber###", "0");
body = body.Replace("###CountriesList###", "No Country Selected.");
}
body = body.Replace("###ExecutiveSummary###", GeneralFunctionEntryForm.CheckTextfield(entryForm.ExecutiveSummary));
body = body.Replace("###DescribeMarketBackground###", GeneralFunctionEntryForm.CheckTextfield(entryForm.DescribeMarket));
if (entryForm.StrategicChallengeObjectives != "" && entryForm.StrategicChallengeObjectives != null)
{
string[] StrategicChallengeObjectivesList = entryForm.StrategicChallengeObjectives.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (StrategicChallengeObjectivesList.Length != 0)
{
try
{
body = body.Replace("###StrategicChallengeObjectivesA###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[0]));
body = body.Replace("###StrategicChallengeObjectivesB###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[1]));
body = body.Replace("###StrategicChallengeObjectivesC###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[2]));
body = body.Replace("###StrategicChallengeObjectivesD###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[3]));
body = body.Replace("###StrategicChallengeObjectivesE###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[4]));
body = body.Replace("###StrategicChallengeObjectivesF###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[5]));
}
catch { }
}
}
if (entryForm.Ideas != "" && entryForm.Ideas != null)
{
string[] IdeasList = entryForm.Ideas.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (IdeasList.Length != 0)
{
try {
body = body.Replace("###IdeaA###", GeneralFunctionEntryForm.CheckTextfield(IdeasList[0]));
body = body.Replace("###IdeaB###", GeneralFunctionEntryForm.CheckTextfield(IdeasList[1]));
body = body.Replace("###IdeaC###", GeneralFunctionEntryForm.CheckTextfield(IdeasList[2]));
}
catch { }
}
}
body = body.Replace("###BringIdeaA###", GeneralFunctionEntryForm.CheckTextfield(entryForm.BringingIdea));
body = body.Replace("###ExplainSelected###", GeneralFunctionEntryForm.CheckTextfield(entryForm.Other));
body = body.Replace("###Elaborate###", GeneralFunctionEntryForm.CheckTextfield(entryForm.PaidMediaExpendituresText));
body = body.Replace("###OwnedMedia###", GeneralFunctionEntryForm.CheckTextfield(entryForm.OwnedMedia));
body = body.Replace("###Sponsorship###", GeneralFunctionEntryForm.CheckTextfield(entryForm.Sponsorship));
if (entryForm.ExplainWorked != "" && entryForm.ExplainWorked != null)
{
string[] ExplainWorked = entryForm.ExplainWorked.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (ExplainWorked.Length != 0)
{
try
{
body = body.Replace("###HowWorkedA###", GeneralFunctionEntryForm.CheckTextfield(ExplainWorked[0]));
body = body.Replace("###HowWorkedB###", GeneralFunctionEntryForm.CheckTextfield(ExplainWorked[1]));
body = body.Replace("###HowWorkedC###", GeneralFunctionEntryForm.CheckTextfield(ExplainWorked[2]));
}
catch { }
}
}
body = body.Replace("###Anything###", GeneralFunctionEntryForm.CheckTextfield(entryForm.Anything));
body = PopulateRowPTC(body);
body = PopulateRowEOM(body);
body = PopulateImages(body);
return(body);
}
public static string PopulateRow(string body)
{
body = body.Replace("###Title###", "Entry Form");
body = body.Replace("###Logo###", WebURL + "images/logo-apaceffie-high.png");
body = body.Replace("###HeaderLogo###", WebURL + "images/Header-logo-pdf.png");
body = body.Replace("###IconList###", WebURL + "images/icon-list.png");
body = body.Replace("###DesTotalOfCountries###", entryForm.DesTotalOfCountries);
body = body.Replace("###Product###", entry.ProductClassification);
body = body.Replace("###BrandName###", entry.Brand);
body = body.Replace("###ProductServiceClassification###", entry.Client);
body = body.Replace("###EntryTitle###", entry.Campaign);
body = body.Replace("###EntryID###", entry.Serial);
body = body.Replace("###ExecutiveSummary###", GeneralFunctionEntryForm.CheckTextfield(entryForm.ExecutiveSummary));
body = body.Replace("###DescribeMarket###", GeneralFunctionEntryForm.CheckTextfield(entryForm.DescribeMarket));
body = body.Replace("###ExplainListOtherMarketing###", GeneralFunctionEntryForm.CheckTextfield(entryForm.Other));
body = body.Replace("###PaidMediaExpendituresText###", GeneralFunctionEntryForm.CheckTextfield(entryForm.PaidMediaExpendituresText));
body = body.Replace("###ExplainCriteria###", GeneralFunctionEntryForm.CheckTextfield(entryForm.ExplainCriteria));
body = body.Replace("###BrandName###", entry.Campaign);
body = body.Replace("###ProductServiceClassification###", entry.Client);
body = body.Replace("###EntryTitle###", entry.Brand);
body = body.Replace("###YouEnteringInto###", Data.GetCategoryMarket(entry.CategoryMarket));
body = body.Replace("###EntryCategory###", entry.CategoryPSDetail);
try
{
string countries = "";
foreach (string country in entry.Effectiveness.Split('|'))
{
countries += country + ", ";
}
body = body.Replace("###CountryHeader###", countries.Substring(0, countries.Length - 4) + ".");
body = body.Replace("###PMECountryA###", entry.Effectiveness.Split('|')[0].ToString());
body = body.Replace("###PMECountryB###", entry.Effectiveness.Split('|')[1].ToString());
body = body.Replace("###PMECountryC###", entry.Effectiveness.Split('|')[2].ToString());
body = body.Replace("###MCCountryA###", entry.Effectiveness.Split('|')[0].ToString());
body = body.Replace("###MCCountryB###", entry.Effectiveness.Split('|')[1].ToString());
body = body.Replace("###MCCountryC###", entry.Effectiveness.Split('|')[2].ToString());
body = body.Replace("###Country1###", entry.Effectiveness.Split('|')[0].ToString());
body = body.Replace("###Country2###", entry.Effectiveness.Split('|')[1].ToString());
body = body.Replace("###Country3###", entry.Effectiveness.Split('|')[2].ToString());
}
catch
{
body = body.Replace("###CountryHeader###", "No Country Selected.");
}
body = body.Replace("###StartDate###", entry.DateCampaignStart.ToString("dd MMM yyyy"));
body = body.Replace("###EndDate###", entry.DateCampaignEnd.ToString("dd MMM yyyy"));
body = body.Replace("###Elaborate###", GeneralFunctionEntryForm.CheckTextfield(entryForm.PaidMediaExpendituresText));
body = body.Replace("###OwnedMedia###", GeneralFunctionEntryForm.CheckTextfield(entryForm.OwnedMedia));
body = body.Replace("###Sponsorship###", GeneralFunctionEntryForm.CheckTextfield(entryForm.Sponsorship));
if (entryForm.BringingIdea != "" && entryForm.BringingIdea != null)
{
string[] BringingIdea = entryForm.BringingIdea.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (BringingIdea.Length != 0)
{
try {
body = body.Replace("###BringingIdeaA###", GeneralFunctionEntryForm.CheckTextfield(BringingIdea[0]));
body = body.Replace("###BringingIdeaB###", GeneralFunctionEntryForm.CheckTextfield(BringingIdea[1]));
}
catch { }
}
}
body = body.Replace("###BudgetElaboration###", GeneralFunctionEntryForm.CheckTextfield(entryForm.PaidMediaExpendituresIndicate));
if (entryForm.PaidMediaExpendituresAstimates != "" && entryForm.PaidMediaExpendituresAstimates != null)
{
string[] PaidMediaExpendituresAstimates = entryForm.PaidMediaExpendituresAstimates.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (PaidMediaExpendituresAstimates.Length != 0)
{
try {
body = body.Replace("###MediaBudgetA###", GeneralFunctionEntryForm.CheckTextfield(PaidMediaExpendituresAstimates[0]));
body = body.Replace("###MediaBudgetB###", GeneralFunctionEntryForm.CheckTextfield(PaidMediaExpendituresAstimates[1]));
body = body.Replace("###MediaBudgetC###", GeneralFunctionEntryForm.CheckTextfield(PaidMediaExpendituresAstimates[2]));
}
catch { }
}
}
if (entryForm.PaidMediaExpendituresAveregeAnnual != "" && entryForm.PaidMediaExpendituresAveregeAnnual != null)
{
string[] PaidMediaExpendituresAveregeAnnual = entryForm.PaidMediaExpendituresAveregeAnnual.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (PaidMediaExpendituresAveregeAnnual.Length != 0)
{
try {
body = body.Replace("###AnualBadgeA###", string.IsNullOrEmpty(PaidMediaExpendituresAveregeAnnual[0]) ? "" : PaidMediaExpendituresAveregeAnnual[0]);
body = body.Replace("###AnualBadgeB###", string.IsNullOrEmpty(PaidMediaExpendituresAveregeAnnual[1]) ? "" : PaidMediaExpendituresAveregeAnnual[1]);
body = body.Replace("###AnualBadgeC###", string.IsNullOrEmpty(PaidMediaExpendituresAveregeAnnual[2]) ? "" : PaidMediaExpendituresAveregeAnnual[2]);
}
catch { }
}
}
if (entryForm.PaidMediaExpendituresTotalBudget != "" && entryForm.PaidMediaExpendituresTotalBudget != null)
{
string[] PaidMediaExpendituresTotalBudget = entryForm.PaidMediaExpendituresTotalBudget.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (PaidMediaExpendituresTotalBudget.Length != 0)
{
try {
body = body.Replace("###ApproximateBudgetA###", GeneralFunctionEntryForm.CheckTextfield(PaidMediaExpendituresTotalBudget[0]));
body = body.Replace("###ApproximateBudgetB###", GeneralFunctionEntryForm.CheckTextfield(PaidMediaExpendituresTotalBudget[1]));
body = body.Replace("###ApproximateBudgetC###", GeneralFunctionEntryForm.CheckTextfield(PaidMediaExpendituresTotalBudget[2]));
}
catch { }
}
}
try
{
string countries = "";
foreach (string country in entry.CaseData.Split('|'))
{
countries += country + ", ";
}
body = body.Replace("###Totalnumber###", (entry.CaseData.Split('|').Count() - 1).ToString());
body = body.Replace("###CountriesList###", countries.Substring(0, countries.Length - 4) + ".");
}
catch
{
body = body.Replace("###Totalnumber###", "0");
body = body.Replace("###CountriesList###", "No Country Selected.");
}
if (entryForm.StrategicChallengeObjectives != "" && entryForm.StrategicChallengeObjectives != null)
{
string[] StrategicChallengeObjectivesList = entryForm.StrategicChallengeObjectives.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (StrategicChallengeObjectivesList.Length != 0)
{
try
{
body = body.Replace("###StrategicChallengeObjectivesA###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[0]));
body = body.Replace("###StrategicChallengeObjectivesB###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[1]));
body = body.Replace("###StrategicChallengeObjectivesC###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[2]));
body = body.Replace("###StrategicChallengeObjectivesD###", GeneralFunctionEntryForm.CheckTextfield(StrategicChallengeObjectivesList[3]));
}
catch { }
}
}
if (entryForm.Ideas != "" && entryForm.Ideas != null)
{
string[] IdeasList = entryForm.Ideas.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (IdeasList.Length != 0)
{
try
{
body = body.Replace("###IdeasA###", GeneralFunctionEntryForm.CheckTextfield(IdeasList[0]));
body = body.Replace("###IdeasB###", GeneralFunctionEntryForm.CheckTextfield(IdeasList[1]));
body = body.Replace("###IdeasC###", GeneralFunctionEntryForm.CheckTextfield(IdeasList[2]));
body = body.Replace("###IdeasD###", GeneralFunctionEntryForm.CheckTextfield(IdeasList[3]));
}
catch { }
}
}
if (entryForm.ComparedOtherCompetitorsCheck != "" && entryForm.ComparedOtherCompetitorsCheck != null)
{
string[] ComparedOtherCompetitorsCheck = entryForm.ComparedOtherCompetitorsCheck.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (ComparedOtherCompetitorsCheck.Length != 0)
{
try
{
body = body.Replace("###CompareATitleA###", ((ComparedOtherCompetitorsCheck[0].Replace(" ", "") == "True") ? check() : "" + " "));
body = body.Replace("###CompareATitleB###", ((ComparedOtherCompetitorsCheck[1].Replace(" ", "") == "True") ? check() : "" + " "));
body = body.Replace("###CompareATitleC###", ((ComparedOtherCompetitorsCheck[2].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareATitleD###", ((ComparedOtherCompetitorsCheck[3].Replace(" ", "") == "True") ? check("center") : "" + " "));
}
catch { }
}
}
if (entryForm.ComparedOverallSpendCheck != "" && entryForm.ComparedOverallSpendCheck != null)
{
string[] ComparedOverallSpendCheck = entryForm.ComparedOverallSpendCheck.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (ComparedOverallSpendCheck.Length != 0)
{
try {
body = body.Replace("###CompareBTitleA###", ((ComparedOverallSpendCheck[0].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareBTitleB###", ((ComparedOverallSpendCheck[1].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareBTitleC###", ((ComparedOverallSpendCheck[2].Replace(" ", "") == "True") ? check("center") : "" + " "));
body = body.Replace("###CompareBTitleD###", ((ComparedOverallSpendCheck[3].Replace(" ", "") == "True") ? check("center") : "" + " "));
}
catch { }
}
}
if (entryForm.ExplainWorked != "" && entryForm.ExplainWorked != null)
{
string[] ExplainWorked = entryForm.ExplainWorked.Split(new string[] { Delimiter[0] }, System.StringSplitOptions.RemoveEmptyEntries);
if (ExplainWorked.Length != 0)
{
try
{
body = body.Replace("###HowWorkedA###", GeneralFunctionEntryForm.CheckTextfield(ExplainWorked[0]));
body = body.Replace("###HowWorkedB###", GeneralFunctionEntryForm.CheckTextfield(ExplainWorked[1]));
body = body.Replace("###HowWorkedC###", GeneralFunctionEntryForm.CheckTextfield(ExplainWorked[2]));
body = body.Replace("###HowWorkedD###", GeneralFunctionEntryForm.CheckTextfield(ExplainWorked[3]));
}
catch { }
}
}
body = body.Replace("###Anything###", GeneralFunctionEntryForm.CheckTextfield(entryForm.Anything));
body = PopulateRowPTC(body);
body = PopulateRowEOM(body);
body = PopulateRowPME(body);
body = PopulateImages(body);
return(body);
}