예제 #1
0
        public static string Builder()
        {
            //Find movie folder path
            string movieDir = BuildDB.MovieDirPath();

            //Create MovieTable
            Console.WriteLine("\n  Creating MovieMetaDataBase . . . .");
            SQLiteConnection mDBconn = DBCommands.CreateConnection();
            object           mDBcmd  = DBCommands.CreateNewMovieTable(mDBconn);

            Console.WriteLine("\n\n  Database created.  You should now populate it.");
            return(movieDir);
        }
예제 #2
0
 private static bool AddMovie2Database(ResponseStrings OMDBResponse2, string movieDir)
 {
     //bool confirmed = false;
     //while (!confirmed)
     {
         Console.WriteLine("\n  Add Movie metadata to MovieTable? Y or N ");
         string YorN = Console.ReadKey().Key.ToString().ToUpper();
         if (YorN == "Y")
         {
             DBCommands.InsertOBDMData(DBCommands.CreateConnection(), OMDBResponse2); return(true);
         }                                                                                                          // dynamically update table with omdResponse values
         else
         {
             Console.WriteLine("\n|n  OK, on to next movie . . .\n"); return(false);
         }
     }
 }