This project is designed to randomize text adds across 12 different text add banners.
The sequence of words can never repeat inside the same text ad, but a sequence of words can be used in another text add banner “IN THE FUTURE”.
• We have 12 different text add banners (A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12)
• We need to rotate the text on each banner daily
• A text add can never repeat itself inside the same text banner add
• But previously used banner ad in banner A1 can be used in another banner add (A2….A12), in the future
• Text adds are composed of 1 or multiple: Abbreviations, Words, Phrases, Sentences
Example: LOL, CAT, MY PENSION, NEW YORK, I LOVE YOU
• The only limitation to a text banner add is that can only hold 51 characters (includes spaces)
• We also don’t want text banner adds to have less than 30 characters
• Phrases or sentence have inner spaces
Example: MY PENSION, NEW YORK, I LOVE YOU
• When combining 2 or more Abbreviations, Words, Phrases, and Sentences they will replace a space with xxx
• But, spaces inside phrases and sentences will be left alone
Example: LOLXXXCATXXXMY PENSIONXXXNEW YORKXXXI LOVE YOU
• All text needs to be provided using uppercase
• The program will obtain all components for a banner ad from a sql table
• In order to avoid creating duplicates, each combination will be recorded into a log table
• Every time the program runs it will create 365 x 12 banner ads
• The log entry will record the created time, and the time that the banner add will appear in the future.
• Everyday of the calendar year will have 12 text banner add combination for all 12 banner ad spots.
• The code and tables are included in the sample project.
• You must use c# and SQL Server express to create this program.