//Get benefits of all sponsors for Sponsors section of the website (web content)
public SponsorInterfaceBenefits getAllSponsorBenefits()
{
try
{
var sponsors = new SponsorInterfaceBenefits();
using (conferenceadminContext context = new conferenceadminContext())
{
var diamond = (from s in context.sponsortypes
where s.name == "Diamond"
select s).FirstOrDefault();
if (diamond != null)
{
sponsors.diamondAmount = diamond.amount;
SponsorBenefitsQuery benefits = new SponsorBenefitsQuery();
benefits.benefit1 = diamond.benefit1;
benefits.benefit2 = diamond.benefit2;
benefits.benefit3 = diamond.benefit3;
benefits.benefit4 = diamond.benefit4;
benefits.benefit5 = diamond.benefit5;
benefits.benefit6 = diamond.benefit6;
benefits.benefit7 = diamond.benefit7;
benefits.benefit8 = diamond.benefit8;
benefits.benefit9 = diamond.benefit9;
benefits.benefit10 = diamond.benefit10;
sponsors.diamondBenefits = benefits;
}
var platinum = (from s in context.sponsortypes
where s.name == "Platinum"
select s).FirstOrDefault();
if (platinum != null)
{
sponsors.platinumAmount = platinum.amount;
SponsorBenefitsQuery benefits = new SponsorBenefitsQuery();
benefits.benefit1 = platinum.benefit1;
benefits.benefit2 = platinum.benefit2;
benefits.benefit3 = platinum.benefit3;
benefits.benefit4 = platinum.benefit4;
benefits.benefit5 = platinum.benefit5;
benefits.benefit6 = platinum.benefit6;
benefits.benefit7 = platinum.benefit7;
benefits.benefit8 = platinum.benefit8;
benefits.benefit9 = platinum.benefit9;
benefits.benefit10 = platinum.benefit10;
sponsors.platinumBenefits = benefits;
}
var gold = (from s in context.sponsortypes
where s.name == "Gold"
select s).FirstOrDefault();
if (gold != null)
{
sponsors.goldAmount = gold.amount;
SponsorBenefitsQuery benefits = new SponsorBenefitsQuery();
benefits.benefit1 = gold.benefit1;
benefits.benefit2 = gold.benefit2;
benefits.benefit3 = gold.benefit3;
benefits.benefit4 = gold.benefit4;
benefits.benefit5 = gold.benefit5;
benefits.benefit6 = gold.benefit6;
benefits.benefit7 = gold.benefit7;
benefits.benefit8 = gold.benefit8;
benefits.benefit9 = gold.benefit9;
benefits.benefit10 = gold.benefit10;
sponsors.goldBenefits = benefits;
}
var silver = (from s in context.sponsortypes
where s.name == "Silver"
select s).FirstOrDefault();
if (silver != null)
{
sponsors.silverAmount = silver.amount;
SponsorBenefitsQuery benefits = new SponsorBenefitsQuery();
benefits.benefit1 = silver.benefit1;
benefits.benefit2 = silver.benefit2;
benefits.benefit3 = silver.benefit3;
benefits.benefit4 = silver.benefit4;
benefits.benefit5 = silver.benefit5;
benefits.benefit6 = silver.benefit6;
benefits.benefit7 = silver.benefit7;
benefits.benefit8 = silver.benefit8;
benefits.benefit9 = silver.benefit9;
benefits.benefit10 = silver.benefit10;
sponsors.silverBenefits = benefits;
}
var bronze = (from s in context.sponsortypes
where s.name == "Bronze"
select s).FirstOrDefault();
if (bronze != null)
{
sponsors.bronzeAmount = bronze.amount;
SponsorBenefitsQuery benefits = new SponsorBenefitsQuery();
benefits.benefit1 = bronze.benefit1;
benefits.benefit2 = bronze.benefit2;
benefits.benefit3 = bronze.benefit3;
benefits.benefit4 = bronze.benefit4;
benefits.benefit5 = bronze.benefit5;
benefits.benefit6 = bronze.benefit6;
benefits.benefit7 = bronze.benefit7;
benefits.benefit8 = bronze.benefit8;
benefits.benefit9 = bronze.benefit9;
benefits.benefit10 = bronze.benefit10;
sponsors.bronzeBenefits = benefits;
}
}
return sponsors;
}
catch (Exception ex)
{
Console.Write("WebManager.getAllSponsorBenefits error " + ex);
return null;
}
}
//Update text found in the Sponsor section of the website
public bool saveInstructions(SponsorInterfaceBenefits info)
{
try
{
using (conferenceadminContext context = new conferenceadminContext())
{
this.saveInterfaceElement("sponsorInstructions", info.instructions);
return true;
}
}
catch (Exception ex)
{
Console.Write("WebManger.saveInstructions error " + ex);
return false;
}
}
