private void Button1_Click(object sender, EventArgs e)
{
try
{
aluguel_bancoEntities3 bd = new aluguel_bancoEntities3();
using (var doc = new PdfSharp.Pdf.PdfDocument())
{
int distancia = 150;
var page = doc.AddPage();
var graphicx = PdfSharp.Drawing.XGraphics.FromPdfPage(page);
var textFormatter = new PdfSharp.Drawing.Layout.XTextFormatter(graphicx);
var fontTitulo = new PdfSharp.Drawing.XFont("Arial", 16);
var font = new PdfSharp.Drawing.XFont("Arial", 12);
textFormatter.Alignment = PdfSharp.Drawing.Layout.XParagraphAlignment.Center;
textFormatter.DrawString("Relatório Geral\n \n \n", fontTitulo, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(0, 70, page.Width, page.Height));
textFormatter.Alignment = PdfSharp.Drawing.Layout.XParagraphAlignment.Justify;
textFormatter.DrawString(" Descrição", font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(50, 120, 250, 145));
textFormatter.DrawString(" Data", font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(255, 120, 320, 145));
textFormatter.DrawString(" Valor Pago", font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(345, 120, 420, 145));
textFormatter.DrawString(" Saldo do Devedor", font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(445, 120, 590, 145));
bd.apartamentos_tabela.ToList().ForEach(ap =>
{
textFormatter.DrawString(ap.descricao, font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(50, distancia, 250, distancia + 25));
textFormatter.DrawString(Convert.ToString(ap.data_compra.Value.ToString("dd/MM/yyyy")), font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(255, distancia, 320, distancia + 25));
textFormatter.DrawString("R$" + Convert.ToString(Math.Round(ap.valor_pago_reais, 2)), font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(345, distancia, 420, distancia + 25));
textFormatter.DrawString("R$" + Convert.ToString(Math.Round(Convert.ToDouble(ap.saldo_devedor_cub) * valorCub, 2)), font, PdfSharp.Drawing.XBrushes.Black, new PdfSharp.Drawing.XRect(445, distancia, 590, distancia + 25));
distancia += 30;
});
graphicx.DrawLine(PdfSharp.Drawing.XPens.Black, 250, 130, 250, distancia);
graphicx.DrawLine(PdfSharp.Drawing.XPens.Black, 340, 130, 340, distancia);
graphicx.DrawLine(PdfSharp.Drawing.XPens.Black, 440, 130, 440, distancia);
doc.Save("arquivo.pdf");
System.Diagnostics.Process.Start("arquivo.pdf");
}
}
catch
{
MessageBox.Show("Erro ao gerar PDF");
}
}
public void montarTabelaApartamentos()
{
aluguel_bancoEntities3 bd = new aluguel_bancoEntities3();
try
{
tblAlugueisTelaPrincipal.Rows.Clear();
bd.apartamentos_tabela.ToList().ForEach(m =>
{
if ((checkBox1.Checked && m.saldo_devedor_cub != 0) || !checkBox1.Checked)
{
tblAlugueisTelaPrincipal.Rows.Add(m.id, m.descricao, m.data_compra.Value.ToString("dd/MM/yyyy"), "R$ " + Math.Round(m.valor_pago_reais, 2), "R$ " + Math.Round(Convert.ToDouble(m.saldo_devedor_cub) * valorCub, 2));
}
});
}
catch
{
MessageBox.Show("Erro na conexão com o banco de dados");
}
}
