static void ListAllActas(string dbPath, string tableName)
{
var dbRepo = new ElecRepository(dbPath);
System.Console.WriteLine($"Database: {dbPath}");
System.Console.WriteLine($"Tabla: {tableName}");
System.Console.WriteLine($"Lista de Actas");
System.Console.WriteLine("--------------------------------------------------------------");
var actas = dbRepo.GetAllActas(tableName);
foreach (var acta in actas)
{
System.Console.WriteLine(acta);
System.Console.WriteLine();
}
}
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();
}
