private void ReportViewer_Load(object sender, EventArgs e) { NovaReceitaModel nrmodel = new NovaReceitaModel(); var dados = nrmodel.GetMonth(3, "2019"); var relatorioList = new List <DadosRelatorioReceitas>(); foreach (var d in dados) { var sValor = d.Valor.Substring(1, d.Valor.Length - 1); var sMesExtenso = "Março"; var sAno = "2019"; relatorioList.Add(new DadosRelatorioReceitas() { NumFatura = d.NumFatura, Data = d.Data, Cliente = d.Cliente, Valor = sValor, MesExtenso = sMesExtenso, Ano = sAno }); } var dataSource = new Microsoft.Reporting.WinForms.ReportDataSource("DataSetRelatorio", relatorioList); ReportViewer.LocalReport.DataSources.Add(dataSource); ReportViewer.LocalReport.ReportEmbeddedResource = "Controle_Financeiro.RelatorioReceitas.rdlc"; ReportViewer.RefreshReport(); }
public bool GerarRelatorioGeral(int Mes, string mesExtenso, string Ano, string RelatorioTitulo) { Document document = new Document(PageSize.A4); try { document.SetMargins(3, 2, 3, 2); string desktop = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); string receitasFolder = Path.Combine(desktop, RelatorioTitulo, Ano); if (!Directory.Exists(receitasFolder)) { Directory.CreateDirectory(receitasFolder); } string FilePath = Path.Combine(receitasFolder, mesExtenso + ".pdf"); PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(FilePath, FileMode.Create)); document.Open(); BaseColor preto = new BaseColor(0, 0, 0); BaseColor red = new BaseColor(255, 0, 0); BaseColor green = new BaseColor(0, 255, 0); Font fonte = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 14, Font.BOLD, preto); Font conteudo = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 16, Font.NORMAL, preto); Font titulo = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 16, Font.BOLD, preto); Font positivo = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 16, Font.BOLD, green); Font negativo = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 16, Font.BOLD, red); var contentByte = writer.DirectContent; var image = iTextSharp.text.Image.GetInstance(@"Resources\lovesnacks_logo.jpg"); image.ScaleToFit(120, 120); image.SetAbsolutePosition(50, 670); contentByte.AddImage(image); var paragraph = new iTextSharp.text.Paragraph(" " + RelatorioTitulo.ToUpper() + " - " + mesExtenso.ToUpper() + " " + Ano.ToUpper(), titulo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; var space = new iTextSharp.text.Paragraph(" ", fonte); document.Add(space); document.Add(space); document.Add(space); document.Add(space); document.Add(paragraph); document.Add(space); document.Add(space); document.Add(space); document.Add(space); NovaReceitaModel nrmodel = new NovaReceitaModel(); List <NovaReceitaModel> nrList = new List <NovaReceitaModel>(); nrList = nrmodel.GetMonth(Mes, Ano).ToList(); NovaDespesaModel ndmodel = new NovaDespesaModel(); List <NovaDespesaModel> ndList = new List <NovaDespesaModel>(); ndList = ndmodel.GetMonth(Mes, Ano).ToList(); string ValorSemCifrao = ""; double SomaValorReceita = 0; double SomaValorDespesa = 0; int i = 0; int y = 0; foreach (var l in nrList) { ValorSemCifrao = l.Valor.Substring(1, l.Valor.Length - 1); ValorSemCifrao = ValorSemCifrao.Replace(".", "/"); ValorSemCifrao = ValorSemCifrao.Replace(",", "*"); ValorSemCifrao = ValorSemCifrao.Replace("/", ","); ValorSemCifrao = ValorSemCifrao.Replace("*", "."); SomaValorReceita += Convert.ToDouble(ValorSemCifrao); i++; if (i == nrList.Count) { StringBuilder receitas = new StringBuilder(); receitas.Append("Total de Receitas para o mês de "); receitas.Append(mesExtenso); receitas.Append(": "); receitas.Append(SomaValorReceita.ToString("C", CultureInfo.CreateSpecificCulture("en-US"))); paragraph = new iTextSharp.text.Paragraph(receitas.ToString(), conteudo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(paragraph); } } foreach (var l in ndList) { ValorSemCifrao = l.Valor.Substring(1, l.Valor.Length - 1); ValorSemCifrao = ValorSemCifrao.Replace(".", "/"); ValorSemCifrao = ValorSemCifrao.Replace(",", "*"); ValorSemCifrao = ValorSemCifrao.Replace("/", ","); ValorSemCifrao = ValorSemCifrao.Replace("*", "."); SomaValorDespesa += Convert.ToDouble(ValorSemCifrao); y++; if (y == ndList.Count) { StringBuilder despesas = new StringBuilder(); despesas.Append("Total de Despesas para o mês de "); despesas.Append(mesExtenso); despesas.Append(": "); despesas.Append(SomaValorDespesa.ToString("C", CultureInfo.CreateSpecificCulture("en-US"))); paragraph = new iTextSharp.text.Paragraph(despesas.ToString(), conteudo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(paragraph); } } double lucro = SomaValorReceita - SomaValorDespesa; if (lucro > 0) { StringBuilder lucroMsg = new StringBuilder(); lucroMsg.Append("Você fechou o mês de "); lucroMsg.Append(mesExtenso.ToUpper()); paragraph = new iTextSharp.text.Paragraph(lucroMsg.ToString(), conteudo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(space); document.Add(space); document.Add(paragraph); string positivoMsg = "POSITIVO"; paragraph = new iTextSharp.text.Paragraph(positivoMsg, positivo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(paragraph); StringBuilder lucroMsg2 = new StringBuilder(); lucroMsg2.Append("em "); lucroMsg2.Append(lucro.ToString("C", CultureInfo.CreateSpecificCulture("en-US"))); paragraph = new iTextSharp.text.Paragraph(lucroMsg2.ToString(), conteudo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; if (document.Add(paragraph)) { System.Diagnostics.Process.Start(FilePath); return(true); } else { return(false); } } else { StringBuilder lucroMsg = new StringBuilder(); lucroMsg.Append("Você fechou o mês de "); lucroMsg.Append(mesExtenso.ToUpper()); paragraph = new iTextSharp.text.Paragraph(lucroMsg.ToString(), conteudo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(space); document.Add(space); document.Add(paragraph); string negativoMsg = "NEGATIVO"; paragraph = new iTextSharp.text.Paragraph(negativoMsg, negativo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(paragraph); StringBuilder lucroMsg2 = new StringBuilder(); lucroMsg2.Append("em "); lucroMsg2.Append(lucro.ToString("C", CultureInfo.CreateSpecificCulture("en-US"))); paragraph = new iTextSharp.text.Paragraph(lucroMsg2.ToString(), conteudo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; if (document.Add(paragraph)) { System.Diagnostics.Process.Start(FilePath); return(true); } else { return(false); } } } catch (Exception) { throw; } finally { document.Close(); } }
public bool GerarRelatorio(int Mes, string mesExtenso, string Ano, string RelatorioTitulo, int colunas) { Document document = new Document(PageSize.A4); try { document.SetMargins(3, 2, 3, 2); string desktop = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); string receitasFolder = Path.Combine(desktop, RelatorioTitulo, Ano); if (!Directory.Exists(receitasFolder)) { Directory.CreateDirectory(receitasFolder); } string FilePath = Path.Combine(receitasFolder, mesExtenso + ".pdf"); PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(FilePath, FileMode.Create)); document.Open(); BaseColor preto = new BaseColor(0, 0, 0); PdfPTable table = new PdfPTable(colunas); table.DefaultCell.Border = PdfPCell.BOTTOM_BORDER; table.DefaultCell.BorderColor = preto; table.DefaultCell.BorderColorBottom = new BaseColor(255, 255, 255); table.DefaultCell.Padding = 10; Font fonte = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 14, Font.BOLD, preto); Font conteudo = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 12, Font.NORMAL, preto); Font footer = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 12, Font.BOLD, preto); Font titulo = FontFactory.GetFont(BaseFont.TIMES_ROMAN, 16, Font.BOLD, preto); var contentByte = writer.DirectContent; var image = iTextSharp.text.Image.GetInstance(@"Resources\lovesnacks_logo.jpg"); image.ScaleToFit(120, 120); image.SetAbsolutePosition(50, 670); contentByte.AddImage(image); var paragraph = new iTextSharp.text.Paragraph(" " + RelatorioTitulo.ToUpper() + " - " + mesExtenso.ToUpper() + " " + Ano.ToUpper(), titulo); paragraph.Alignment = iTextSharp.text.Element.ALIGN_CENTER; var space = new iTextSharp.text.Paragraph(" ", fonte); document.Add(space); document.Add(space); document.Add(space); document.Add(space); document.Add(paragraph); document.Add(space); document.Add(space); document.Add(space); document.Add(space); if (RelatorioTitulo.Equals("Receitas")) { Paragraph coluna1 = new Paragraph("Nº Fatura", fonte); Paragraph coluna2 = new Paragraph("Data", fonte); Paragraph coluna3 = new Paragraph("Cliente", fonte); Paragraph coluna4 = new Paragraph("Valor", fonte); coluna1.Alignment = Element.ALIGN_CENTER; coluna2.Alignment = Element.ALIGN_CENTER; coluna3.Alignment = Element.ALIGN_CENTER; coluna4.Alignment = Element.ALIGN_CENTER; var cell1 = new PdfPCell(); var cell2 = new PdfPCell(); var cell3 = new PdfPCell(); var cell4 = new PdfPCell(); cell1.AddElement(coluna1); cell2.AddElement(coluna2); cell3.AddElement(coluna3); cell4.AddElement(coluna4); table.AddCell(cell1); table.AddCell(cell2); table.AddCell(cell3); table.AddCell(cell4); NovaReceitaModel nrmodel = new NovaReceitaModel(); List <NovaReceitaModel> nrList = new List <NovaReceitaModel>(); nrList = nrmodel.GetMonth(Mes, Ano).ToList(); PdfPCell cell; string ValorSemCifrao = ""; double SomaValor = 0; int i = 0; foreach (var l in nrList) { Phrase NumFatura = new Phrase(l.NumFatura.ToString().PadLeft(6, '0'), conteudo); cell = new PdfPCell(NumFatura); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Data = new Phrase(l.Data.ToShortDateString(), conteudo); cell = new PdfPCell(Data); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Cliente = new Phrase(l.Cliente, conteudo); cell = new PdfPCell(Cliente); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Valor = new Phrase(l.Valor, conteudo); cell = new PdfPCell(Valor); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); ValorSemCifrao = l.Valor.Substring(1, l.Valor.Length - 1); ValorSemCifrao = ValorSemCifrao.Replace(".", "/"); ValorSemCifrao = ValorSemCifrao.Replace(",", "*"); ValorSemCifrao = ValorSemCifrao.Replace("/", ","); ValorSemCifrao = ValorSemCifrao.Replace("*", "."); SomaValor += Convert.ToDouble(ValorSemCifrao); i++; if (i == nrList.Count) { Phrase w = new Phrase("-------------", footer); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Total = new Phrase("Total", footer); cell = new PdfPCell(Total); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase ValorTotal = new Phrase(SomaValor.ToString("C", CultureInfo.CreateSpecificCulture("en-US")), footer); cell = new PdfPCell(ValorTotal); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); } } } else { Paragraph coluna1 = new Paragraph("Nº Fatura", fonte); Paragraph coluna2 = new Paragraph("Data", fonte); Paragraph coluna3 = new Paragraph("Fornecedor", fonte); Paragraph coluna4 = new Paragraph("Descrição", fonte); Paragraph coluna5 = new Paragraph("Centro de Custo", fonte); Paragraph coluna6 = new Paragraph("Valor", fonte); coluna1.Alignment = Element.ALIGN_CENTER; coluna2.Alignment = Element.ALIGN_CENTER; coluna3.Alignment = Element.ALIGN_CENTER; coluna4.Alignment = Element.ALIGN_CENTER; coluna5.Alignment = Element.ALIGN_CENTER; coluna6.Alignment = Element.ALIGN_CENTER; var cell1 = new PdfPCell(); var cell2 = new PdfPCell(); var cell3 = new PdfPCell(); var cell4 = new PdfPCell(); var cell5 = new PdfPCell(); var cell6 = new PdfPCell(); cell1.AddElement(coluna1); cell2.AddElement(coluna2); cell3.AddElement(coluna3); cell4.AddElement(coluna4); cell5.AddElement(coluna5); cell6.AddElement(coluna6); table.AddCell(cell1); table.AddCell(cell2); table.AddCell(cell3); table.AddCell(cell4); table.AddCell(cell5); table.AddCell(cell6); NovaDespesaModel ndmodel = new NovaDespesaModel(); List <NovaDespesaModel> nrList = new List <NovaDespesaModel>(); nrList = ndmodel.GetMonth(Mes, Ano).ToList(); PdfPCell cell; string ValorSemCifrao = ""; double SomaValor = 0; int i = 0; foreach (var l in nrList) { Phrase NumFatura = new Phrase(l.NumFatura.ToString().PadLeft(6, '0'), conteudo); cell = new PdfPCell(NumFatura); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Data = new Phrase(l.Data.ToShortDateString(), conteudo); cell = new PdfPCell(Data); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Fornecedor = new Phrase(l.Fornecedor, conteudo); cell = new PdfPCell(Fornecedor); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Descricao = new Phrase(l.Descricao, conteudo); cell = new PdfPCell(Descricao); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase CentroCusto = new Phrase(l.CentroCusto, conteudo); cell = new PdfPCell(CentroCusto); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Valor = new Phrase(l.Valor, conteudo); cell = new PdfPCell(Valor); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); ValorSemCifrao = l.Valor.Substring(1, l.Valor.Length - 1); ValorSemCifrao = ValorSemCifrao.Replace(".", "/"); ValorSemCifrao = ValorSemCifrao.Replace(",", "*"); ValorSemCifrao = ValorSemCifrao.Replace("/", ","); ValorSemCifrao = ValorSemCifrao.Replace("*", "."); SomaValor += Convert.ToDouble(ValorSemCifrao); i++; if (i == nrList.Count) { Phrase w = new Phrase("-------------", footer); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase Total = new Phrase("Total", footer); cell = new PdfPCell(Total); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(w); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); Phrase ValorTotal = new Phrase(SomaValor.ToString("C", CultureInfo.CreateSpecificCulture("en-US")), footer); cell = new PdfPCell(ValorTotal); cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.AddCell(cell); } } } if (document.Add(table)) { System.Diagnostics.Process.Start(FilePath); return(true); } else { return(false); } } catch (Exception) { throw; } finally { document.Close(); } }
private void cmbMes_SelectionChanged(object sender, SelectionChangedEventArgs e) { Mes = cmbMes.SelectedIndex; dataGridReceitas.ItemsSource = nrmodel.GetMonth(Mes, Ano); }