示例#1
0
        static void InsertRepoCsvToDB(string dbPath, string tableName, string repoCsvName)
        {
            var lines = CsvFile.ReadAllLines(repoCsvName, 2);

            System.Console.WriteLine($"Database: {dbPath}");
            System.Console.WriteLine($"Tabla: {tableName}");
            System.Console.WriteLine($"Insertando reporte: {repoCsvName}");
            System.Console.WriteLine("--------------------------------------------------------------");
            var dbRepo = new ElecRepository(dbPath);

            dbRepo.CreateSQLiteActasTable(tableName);
            foreach (var linea in lines)
            {
                Acta acta   = CsvFile.GetActa(linea, repoCsvName);
                long actaId = dbRepo.InsertActa(acta, tableName);
                System.Console.WriteLine($"Acta insertada: {actaId}");
            }
            System.Console.WriteLine();
        }