示例#1
0
        static int Main(string[] args)
        {
            Console.WriteLine($"Goodson Dataimporter Version: {Assembly.GetEntryAssembly().GetName().Version}");

            // TODO: Code Position: #1
            var importDataPath = args[0];

            // Instantiate a new Database Handler
            var  dataBase = new SQLiteDatabaseHandler();
            bool ok       = dataBase.InitDatabase(); // Will create a fresh database, when ok all things are set to start import

            if (ok)
            {
                // Import CSV Data
                var csvImporter = new CSVData.Importer(importDataPath);
                ok = csvImporter.Import(dataBase);
                if (!ok)
                {
                    return(1);
                }

                // TODO: Code Position: #3
                // Folgende Felder der Articles Tabelle: ArticleNumberId, ArticleNumber, Name, Description, DeliveryStateId
                // Folgende Felder der DeliveryStates Tabelle: DeliveryStatesId, Name
                var rows = dataBase.QueryData("SELECT * FROM ???");
                PrintToConsole(rows);
            }
            else
            {
                return(1);
            }

            return(0); // this application uses CLI return codes
        }