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"); } }