forked from GamaGustavo/PDF_Table_Extrator
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathProgram.cs
More file actions
121 lines (92 loc) · 3.91 KB
/
Program.cs
File metadata and controls
121 lines (92 loc) · 3.91 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
using System;
using System.Linq;
using System.IO;
using iText.Kernel.Pdf;
using iText.Kernel.Pdf.Canvas.Parser;
using iText.Kernel.Pdf.Canvas.Parser.Listener;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using System.Configuration;
using System.Threading.Tasks;
using System.Threading;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using EntityFramework.Exceptions.Common;
using EntityFramework.Exceptions.SqlServer;
namespace PDF_Table_Extrator
{
public class Program
{
// public IConfiguration Configuration { get; }
public static void Main(string[] args)
{
using var host = CreateHostBuilder(args).Build();
var programa = host.Services.GetRequiredService<CarregarHistoricoServices>();
try
{
var exemplo = programa.CarregarArquivoExemplo();
PrintTableAluno(exemplo);
programa.GravarNoBancoDados(exemplo);
var notas = programa.ObterNotasAcimaDe(95, exemplo.AlunoId);
Console.WriteLine("Success");
}
catch (Exception ex)
{
Console.WriteLine($"Error Occured: {ex}");
}
host.Run();
}
public static IHostBuilder CreateHostBuilder(string[] args)
{
return Host.CreateDefaultBuilder(args)
.ConfigureServices((hostContext, services) =>
{
var configuration = hostContext.Configuration;
var provider = configuration.GetValue("Provider", "SqlServer");
services.AddScoped<CarregarHistoricoServices>();
services.AddTransient<Program>();
//options.UseSqlServer(hostContext.Configuration.GetConnectionString("DefaultConnection"))
//options.UseInMemoryDatabase(databaseName: "HistoricoAluno"));
services.AddDbContext<HistoricoDBContext>(
//https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/providers?tabs=dotnet-core-cli
options => _ = provider switch
{
"SqlServer" => options.UseSqlServer(
configuration.GetConnectionString("DefaultConnection")).UseExceptionProcessor(),
_ => options.UseInMemoryDatabase(databaseName: "HistoricoAluno")
});
}).UseConsoleLifetime();
}
public Program()
{
}
private static void PrintTableAluno(HistoricoAluno historico)
{
Console.WriteLine($"Histórico de {historico.Aluno.Nome} ({historico.Aluno.Matricula})");
PrintTableDisciplinas(historico.Disciplinas.ToArray());
}
private static void ExibirNotasAcimaDe(IEnumerable<DisciplinaAluno> disciplinasDoAluno)
{
Console.WriteLine($"A quantidade encontrada foi de {disciplinasDoAluno.Count()}");
PrintTableDisciplinas(disciplinasDoAluno.ToArray());
}
public static void PrintTableDisciplinas(params DisciplinaAluno[] disciplinasAluno)
{
foreach (var item in disciplinasAluno)
{
if (item == null)
break;
string linha = null, temp = item.ToString();
for (int i = 0; i < temp.Length; i++)
{
linha += "-";
}
Console.WriteLine("-".PadLeft(temp.Length, '-'));
Console.WriteLine();
Console.WriteLine(temp);
}
Console.WriteLine("-".PadLeft(150, '-'));
}
}
}