public void GerarPlanilha()
{
var filmes = new ServicoFilm().Listar().ToList();
var aba1 = new Aba("filmes");
aba1.AdicionarDados("film_id", "title", "description", "release_year", "language_id", "original_language_id", "rental_duration", "rental_rate", "length", "replacement_cost", "rating", "special_features", "last_update");
filmes.ForEach(f =>
{
aba1.AdicionarDados(f.film_id, f.title, f.description, f.release_year, f.language_id, f.original_language_id, f.rental_duration, f.rental_rate, f.length, f.replacement_cost, f.rating, f.special_features, f.last_update);
});
var aba2 = new Aba("fabio");
aba2.AdicionarDados("film_id", "title", "description", "release_year", "language_id", "original_language_id", "rental_duration", "rental_rate", "length", "replacement_cost", "rating", "special_features", "last_update");
filmes.ForEach(f =>
{
aba2.AdicionarDados(f.film_id, f.title, f.description, f.release_year, f.language_id, f.original_language_id, f.rental_duration, f.rental_rate, f.length, f.replacement_cost, f.rating, f.special_features, f.last_update);
});
var abas = new Aba[] {
aba1, aba2
};
var planilha = new Planilha(abas);
var arquivo = planilha.Arquivo;
planilha.GerarArquivo(@"d:\temp", $"teste-{DateTime.Now:yyyyMMddHHmmss}.xlsx");
Assert.IsTrue(arquivo != null, "Os dados não foram gerados.");
}
// GET: Film
public IActionResult Index()
{
var filmeServico = new ServicoFilm();
var fillmes = filmeServico.Listar();
return View(fillmes);
}
private film Obter(int id)
{
var filmService = new ServicoFilm();
film filme = filmService.Obter(id);
return filme;
}
public void TestarListarFilmes()
{
var films = new ServicoFilm().Listar();
Assert.IsTrue(true);
}
