//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; } }