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