static void Main() { // initialize data if no data exists List <int> soundIDList = ProductDB.GetSoundIDList(); List <int> imageIDList = ProductDB.GetImageIDList(); Console.WriteLine("Uploading Images."); if (imageIDList.Count == 0) { // upload images ProductDB.WriteImage(1, "Avatars/Avatar1.png", "boyAvatar1"); //1 ProductDB.WriteImage(1, "Avatars/Avatar2.png", "girlAvatar1"); //2 ProductDB.WriteImage(1, "Avatars/Avatar3.png", "boyAvatar2"); //3 ProductDB.WriteImage(1, "Avatars/Avatar4.png", "girAvatar2"); //4 ProductDB.WriteImage(1, "Avatars/Avatar5.png", "boyAvatar3"); //5 ProductDB.WriteImage(1, "Avatars/Avatar6.png", "girlAvatar3"); //6 // 6 profiles ProductDB.WriteImage(2, "Animals/elephant.png", "elephant"); //7 ProductDB.WriteImage(2, "Animals/giraffe.png", "giraffe"); //8 ProductDB.WriteImage(2, "Animals/hippo.png", "hippo"); //9 ProductDB.WriteImage(2, "Animals/monkey.png", "monkey"); //10 ProductDB.WriteImage(2, "Animals/panda.png", "panda"); //11 ProductDB.WriteImage(2, "Animals/parrot.png", "parrot"); //12 ProductDB.WriteImage(2, "Animals/penguin.png", "penguin"); //13 ProductDB.WriteImage(2, "Animals/pig.png", "pig"); //14 ProductDB.WriteImage(2, "Animals/rabbit.png", "rabbit"); //15 ProductDB.WriteImage(2, "ShinyAnimals/snake.png", "snake"); //16 // 10 animals ProductDB.WriteImage(2, "ShinyAnimals/elephant.png", "elephant"); //17 ProductDB.WriteImage(2, "ShinyAnimals/giraffe.png", "giraffe"); //18 ProductDB.WriteImage(2, "ShinyAnimals/hippo.png", "hippo"); //19 ProductDB.WriteImage(2, "ShinyAnimals/monkey.png", "monkey"); //20 ProductDB.WriteImage(2, "ShinyAnimals/panda.png", "panda"); //21 ProductDB.WriteImage(2, "ShinyAnimals/parrot.png", "parrot"); //22 ProductDB.WriteImage(2, "ShinyAnimals/penguin.png", "penguin"); //23 ProductDB.WriteImage(2, "ShinyAnimals/pig.png", "pig"); //24 ProductDB.WriteImage(2, "ShinyAnimals/rabbit.png", "rabbit"); //25 ProductDB.WriteImage(2, "ShinyAnimals/snake.png", "snake"); //26 //10 shiny animals ProductDB.WriteImage(3, "Maps/Plains.png", "plains"); //27 ProductDB.WriteImage(3, "Maps/Beach.png", "beach"); //28 // 2 maps. ProductDB.WriteImage(2, "Animals/BearNormal.png", "bear"); //29 ProductDB.WriteImage(2, "Animals/ClownFishNormal.png", "clown fish"); //30 ProductDB.WriteImage(2, "Animals/DogNormal.png", "dog"); //31 ProductDB.WriteImage(2, "Animals/KillerWhaleNormal.png", "killer whale"); //32 ProductDB.WriteImage(2, "Animals/CatNormal.png", "cat"); //33 ProductDB.WriteImage(2, "Animals/PolarBearNormal.png", "polar bear"); //34 ProductDB.WriteImage(2, "ShinyAnimals/BearShiny.png", "bear"); //35 ProductDB.WriteImage(2, "ShinyAnimals/ClownFishShiny.png", "clown fish"); //36 ProductDB.WriteImage(2, "ShinyAnimals/DogShiny.png", "dog"); //37 ProductDB.WriteImage(2, "ShinyAnimals/KillerWhaleShiny.png", "killer whale");; //38 ProductDB.WriteImage(2, "ShinyAnimals/CatShiny.png", "cat"); //39 ProductDB.WriteImage(2, "ShinyAnimals/PolarBearShiny.png", "polar bear"); //40 ProductDB.WriteImage(2, "Animals/NormalRhino.png", "rhino"); //41 ProductDB.WriteImage(2, "Animals/CrabNormal.png", "crab"); //42 ProductDB.WriteImage(2, "Animals/ButterflyNormal.png", "butterfly"); //43 ProductDB.WriteImage(2, "Animals/LionNormal.png", "lion"); //44 ProductDB.WriteImage(2, "Animals/SquirrelNormal.png", "squirrel"); //45 ProductDB.WriteImage(2, "Animals/MeerkatNormal.png", "meerkat"); //46 ProductDB.WriteImage(2, "Animals/CowNormal.png", "cow"); //47 ProductDB.WriteImage(2, "Animals/FrogNormal.png", "frog"); //48 ProductDB.WriteImage(2, "ShinyAnimals/RhinoShiny.png", "rhino"); //49 ProductDB.WriteImage(2, "ShinyAnimals/CrabShiny.png", "crab"); //50 ProductDB.WriteImage(2, "ShinyAnimals/ButterflyShiny.png", "butterfly"); //51 ProductDB.WriteImage(2, "ShinyAnimals/LionShiny.png", "lion"); //52 ProductDB.WriteImage(2, "ShinyAnimals/SquirrelShiny.png", "squirrel"); //53 ProductDB.WriteImage(2, "ShinyAnimals/MeerkatShiny.png", "meerkat"); //54 ProductDB.WriteImage(2, "ShinyAnimals/CowShiny.png", "cow"); //55 ProductDB.WriteImage(2, "ShinyAnimals/FrogShiny.png", "frog"); //56 ProductDB.WriteImage(3, "Maps/Ocean.png", "ocean"); //57, ProductDB.WriteImage(3, "Maps/RainForest.jpg", "rainforest"); //58, ProductDB.WriteImage(3, "Maps/Mountain.png", "mountain"); //59, } if (soundIDList.Count == 0) { //Lake's animal sounds string[] soundArray = new string[] { "bear", //1 "cat", //2 "dog", //3 "elephant", //4 "fish", //5 "giraffe", //6 "hippo", //7 "monkey", //8 "panda", //9 "parrot", //10 "penguin", //11 "pig", //12 "polarBear", //13 "rabbit", //14 "snake", //15 "whale", //16 "butterfly", //17 "cow", //18 "crab", //19 "frog", //20 "lion", //21 "meercat", //22 "rhino", //23 "squirrel" //24 }; for (int i = 0; i < soundArray.Length; i++) { ProductDB.WriteSound(1, "AnimalSounds/" + soundArray[i] + ".m4a", soundArray[i]); } //ProductDB.WriteSound(1, "cat.mp3", "cat"); //ProductDB.WriteSound(1, "chipmunk.mp3", "chipmunk"); //ProductDB.WriteSound(1, "cow.mp3", "cow"); //ProductDB.WriteSound(1, "dog.mp3", "dog"); //ProductDB.WriteSound(1, "frog.mp3", "frog"); //ProductDB.WriteSound(1, "horse.mp3", "horse"); ProductDB.WriteSound(1, "TaDa.mp3", "tada"); //25 //ProductDB.WriteSound(1, "lion.mp3", "lion"); //ProductDB.WriteSound(1, "monkey.mp3", "monkey"); //ProductDB.WriteSound(1, "rooster.mp3", "rooster"); ProductDB.WriteSound(2, "MapAudio/plains.mp3", "plains"); //26 ProductDB.WriteSound(2, "MapAudio/beach.mp3", "beach"); //27 ProductDB.WriteSound(2, "MapAudio/ocean.mp3", "ocean"); //28 ProductDB.WriteSound(2, "MapAudio/rainforest.mp3", "rainforest"); //29 ProductDB.WriteSound(2, "MapAudio/mountain.mp3", "mountain"); //30 } string path; //users Console.WriteLine("Uploading Users."); path = Path.Combine(Environment.CurrentDirectory, "AspNetUsers.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //profiles Console.WriteLine("Uploading Profiles."); path = Path.Combine(Environment.CurrentDirectory, "Profiles.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //maps Console.WriteLine("Uploading Maps."); path = Path.Combine(Environment.CurrentDirectory, "Maps.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //nodes Console.WriteLine("Uploading Nodes."); path = Path.Combine(Environment.CurrentDirectory, "Nodes.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); string file_path1 = "../../MiniGames/"; string file_path2 = "/javascript/"; //Write Mini Games ProductDB.WriteMiniGames(2, file_path1 + "AdditionMiniGame" + file_path2 + "AdditionMiniGame.js", "AdditionMiniGame", 3, 4); ProductDB.WriteMiniGames(1, file_path1 + "Alphabet_BubblePop" + file_path2 + "bubble.js", "AlphabetBubblePop", 1, 2); ProductDB.WriteMiniGames(1, file_path1 + "Alphabet_Tracing" + file_path2 + "alphabet_tracing.js", "AlphabetTracing", 1, 2); ProductDB.WriteMiniGames(1, file_path1 + "BeginningLetterSounds_Racing" + file_path2 + "racing.js", "BeginningLetterSoundsRacing", 3, 4); ProductDB.WriteMiniGames(1, file_path1 + "ColorSortingGame" + file_path2 + "ColorSortingGame.js", "ColorSortingGame", 1, 2); ProductDB.WriteMiniGames(2, file_path1 + "IdentifyShapeGame" + file_path2 + "IdentifyShapeGame.js", "IdentifyShapeGame", 1, 2); ProductDB.WriteMiniGames(1, file_path1 + "MosquitoSwat_LetterSounds" + file_path2 + "mosquitoswat.js", "MosquitoSwatLetterSounds", 3, 4); ProductDB.WriteMiniGames(2, file_path1 + "Number_Comparison" + file_path2 + "Number_Comparison.js", "NumberComparison", 3, 4); ProductDB.WriteMiniGames(2, file_path1 + "Number_ComparisonEZ" + file_path2 + "Number_ComparisonEZ.js", "NumberComparisonEZ", 2, 2); ProductDB.WriteMiniGames(2, file_path1 + "Number_Tracing" + file_path2 + "number_tracing.js", "NumberTracing", 1, 2); ProductDB.WriteMiniGames(2, file_path1 + "Shape_ColoringBook" + file_path2 + "colorbook.js", "ShapeColoringBook", 1, 2); ProductDB.WriteMiniGames(2, file_path1 + "SubtractionMiniGame" + file_path2 + "SubtractionMiniGame.js", "SubtractionMiniGame", 3, 4); ProductDB.WriteMiniGames(1, file_path1 + "Alphabet_Matching" + file_path2 + "Alphabet_Matching.js", "AlphabetMatching", 2, 3); ProductDB.WriteMiniGames(1, file_path1 + "Alphabet_Matching2" + file_path2 + "Alphabet_Matching2.js", "AlphabetMatching", 2, 3); ProductDB.WriteMiniGames(1, file_path1 + "Dino_SightWords" + file_path2 + "dino_sightwords.js", "DinoSightWords", 3, 3); ProductDB.WriteMiniGames(1, file_path1 + "RhymingMatch" + file_path2 + "rhyming_match.js", "RhymingMatch", 4, 4); ProductDB.WriteMiniGames(2, file_path1 + "Supah_Counting" + file_path2 + "supahcounting.js", "SupahCounting", 1, 2); ProductDB.WriteMiniGames(1, file_path1 + "TypingGame" + file_path2 + "TypingGame.js", "Typing", 2, 2); ProductDB.WriteMiniGames(2, file_path1 + "TangramGame" + file_path2 + "TangramGame.js", "Tangram", 3, 4); ProductDB.WriteMiniGames(2, file_path1 + "Position_Vocabulary" + file_path2 + "positionvocabulary.js", "PositionVocabulary", 4, 4); ProductDB.WriteMiniGames(1, file_path1 + "SightWord_Maze" + file_path2 + "sightword_maze.js", "SightWordMaze", 4, 4); ProductDB.WriteMiniGames(1, file_path1 + "AlphabetSortingGame" + file_path2 + "AlphabetSortingGame.js", "AlphabetMatching", 1, 2); ProductDB.WriteMiniGames(1, file_path1 + "Opposites_Matching" + file_path2 + "opposites_matching.js", "OppositesMatching", 4, 4); ProductDB.WriteMiniGames(1, file_path1 + "Pairs_Matching" + file_path2 + "pairs_matching.js", "PairsMatching", 3, 4); ProductDB.WriteMiniGames(1, file_path1 + "Simon" + file_path2 + "Simon.js", "Simon", 3, 4); ProductDB.WriteMiniGames(1, file_path1 + "ISpyGame" + file_path2 + "ISpyGame.js", "ISpy", 1, 2); ProductDB.WriteMiniGames(2, file_path1 + "FishCounting" + file_path2 + "FishCounting.js", "FishCounting", 1, 2); ProductDB.WriteMiniGames(2, file_path1 + "PizzaCounting" + file_path2 + "PizzaCounting.js", "PizzaCounting", 2, 4); ProductDB.WriteMiniGames(1, file_path1 + "BeeLetterMatching" + file_path2 + "BeeLetterMatching.js", "UpperLowerLetterMatching", 2, 3); ProductDB.WriteMiniGames(1, file_path1 + "Supah_Letters" + file_path2 + "supahletters.js", "SupahLetters", 1, 2); ProductDB.WriteMiniGames(1, file_path1 + "PatternCompletion" + file_path2 + "PatternCompletion.js", "PatternCompletion", 2, 4); //Animals Console.WriteLine("Uploading Animals."); path = Path.Combine(Environment.CurrentDirectory, "Animals.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //ProfileProgress Console.WriteLine("Uploading ProfileProgress."); path = Path.Combine(Environment.CurrentDirectory, "ProfileProgress.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); Console.WriteLine("-----Done!-----"); }
static void Main() { // initialize data if no data exists List <int> soundIDList = ProductDB.GetSoundIDList(); List <int> imageIDList = ProductDB.GetImageIDList(); List <int> dataImageIDList = ProductDB.GetDataImageIDList(); Console.WriteLine("Uploading Images."); if (imageIDList.Count == 0) { // upload images ProductDB.WriteImage(1, "avatar1.jpg", "boyAvatar1"); ProductDB.WriteImage(1, "avatar2.jpg", "girlAvatar1"); ProductDB.WriteImage(1, "avatar3.jpg", "boyAvatar2"); ProductDB.WriteImage(1, "avatar4.jpg", "girAvatar2"); ProductDB.WriteImage(1, "avatar5.jpg", "boyAvatar3"); ProductDB.WriteImage(1, "avatar6.jpg", "girlAvatar3"); ProductDB.WriteImage(2, "animal1.jpg", "frog"); ProductDB.WriteImage(2, "animal2.jpg", "elephant"); ProductDB.WriteImage(2, "animal3.jpg", "dog"); ProductDB.WriteImage(2, "animal4.jpg", "crab"); ProductDB.WriteImage(2, "animal5.jpg", "joke"); ProductDB.WriteImage(2, "animal6.jpg", "fish"); ProductDB.WriteImage(2, "animal7.jpg", "cheetah"); ProductDB.WriteImage(2, "animal8.jpg", "monkey"); ProductDB.WriteImage(2, "animal9.jpg", "cow"); ProductDB.WriteImage(2, "animal10.jpg", "zebra"); ProductDB.WriteImage(2, "animal11.jpg", "rhino"); ProductDB.WriteImage(2, "animal12.jpg", "hibbo"); ProductDB.WriteImage(2, "animal13.jpg", "deer"); ProductDB.WriteImage(2, "animal14.jpg", "polar_bear"); ProductDB.WriteImage(2, "animal15.jpg", "mouse"); ProductDB.WriteImage(2, "animal16.jpg", "badger"); ProductDB.WriteImage(2, "animal17.jpg", "horse"); ProductDB.WriteImage(2, "animal18.jpg", "seal"); ProductDB.WriteImage(2, "animal19.jpg", "penguin"); ProductDB.WriteImage(2, "animal20.jpg", "squid"); ProductDB.WriteImage(3, "map1.jpg", "farm"); ProductDB.WriteImage(3, "map2.jpg", "castle"); ProductDB.WriteImage(3, "map3.jpg", "snow"); ProductDB.WriteImage(3, "map4.jpg", "river"); ProductDB.WriteImage(3, "map5.jpg", "beach"); ProductDB.WriteImage(3, "map6.jpg", "desert"); ProductDB.WriteImage(3, "map7.jpg", "pyramid"); } if (soundIDList.Count == 0) { // upload images ProductDB.WriteSound(1, "cat.mp3", "cat"); ProductDB.WriteSound(1, "chipmunk.mp3", "chipmunk"); ProductDB.WriteSound(1, "cow.mp3", "cow"); ProductDB.WriteSound(1, "dog.mp3", "dog"); ProductDB.WriteSound(1, "frog.mp3", "frog"); ProductDB.WriteSound(1, "horse.mp3", "horse"); ProductDB.WriteSound(1, "joke.mp3", "joke"); ProductDB.WriteSound(1, "lion.mp3", "lion"); ProductDB.WriteSound(1, "monkey.mp3", "monkey"); ProductDB.WriteSound(1, "rooster.mp3", "rooster"); ProductDB.WriteSound(2, "background1.mp3", "background1"); ProductDB.WriteSound(2, "background2.mp3", "background2"); ProductDB.WriteSound(2, "background3.mp3", "background3"); ProductDB.WriteSound(2, "background4.mp3", "background4"); ProductDB.WriteSound(2, "background5.mp3", "background5"); } string path; //users Console.WriteLine("Uploading Users."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.Users.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //profiles Console.WriteLine("Uploading Profiles."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.Profiles.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //maps Console.WriteLine("Uploading Maps."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.Maps.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //nodes Console.WriteLine("Uploading Nodes."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.Nodes.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //gamecategories Console.WriteLine("Uploading GameCategories."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.GameCategories.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //minigames Console.WriteLine("Uploading Minigames."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.Minigames.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); Console.WriteLine("Uploading Minigamemedia."); if (dataImageIDList.Count == 0) { ProductDB.WriteMiniGameMedia(10, "circle.jpg", 0); ProductDB.WriteMiniGameMedia(10, "triangle.jpg", 0); ProductDB.WriteMiniGameMedia(10, "rectangle.jpg", 0); ProductDB.WriteMiniGameMedia(10, "octagon.jpg", 0); ProductDB.WriteMiniGameMedia(10, "rectangle.jpg", 0); ProductDB.WriteMiniGameMedia(10, "star.jpg", 0); ProductDB.WriteMiniGameMedia(10, "diamond.jpg", 0); ProductDB.WriteMiniGameMedia(10, "shaperecog_shapehunt.jpg", 0); ProductDB.WriteMiniGameMedia(10, "shush_shapehunt.mp3", 0); ProductDB.WriteMiniGameMedia(12, "sortingBear1.jpg", 2); ProductDB.WriteMiniGameMedia(12, "sortingBear2.jpg", 2); ProductDB.WriteMiniGameMedia(12, "sortingBear3.jpg", 2); ProductDB.WriteMiniGameMedia(12, "sortingBear4.jpg", 2); ProductDB.WriteMiniGameMedia(12, "TaDa.mp3", 0); ProductDB.WriteMiniGameMedia(1, "bubble.jpg", 1); ProductDB.WriteMiniGameMedia(1, "bubbles.jpg", 1); ProductDB.WriteMiniGameMedia(1, "bubblepop_underthesea.jpg", 0); ProductDB.WriteMiniGameMedia(1, "bubblepop.mp3", 0); } //Animals Console.WriteLine("Uploading Animals."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.Animals.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //ProfileAnimals Console.WriteLine("Uploading ProfileAnimals."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.ProfileAnimals.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //ProfileProgress Console.WriteLine("Uploading ProfileProgress."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.ProfileProgress.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); //ProfileProgressHistory Console.WriteLine("Uploading ProfileProgressHistory."); path = Path.Combine(Environment.CurrentDirectory, "CST324_Lake_Robert.ProfileProgressHistory.sql"); Console.WriteLine(path); ProductDB.WriteSQL(path); Console.WriteLine("-----Done!-----"); }