public static void relClientes()
{
CAMADAS.BLL.Clientes bllCli = new CAMADAS.BLL.Clientes();
List <CAMADAS.MODEL.Clientes> lstCli = new List <CAMADAS.MODEL.Clientes>();
lstCli = bllCli.Select();
string pasta = Funcoes.diretorioPasta();
string arquivo = pasta + @"\RelCliente_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".html";
StreamWriter sw = new StreamWriter(arquivo);
using (sw)
{
sw.WriteLine("<html>");
sw.WriteLine("<head>");
sw.WriteLine("<meta http-equiv='Content-Type' " +
"content='text/html; charset=utf-8'/>");
sw.WriteLine(@"<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='ha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>");
sw.WriteLine("</head>");
sw.WriteLine("<body>");
sw.WriteLine("<h1>Relatório de Produtos</h1>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("<table class='table table-striped'>");
//Cabeçalho da tabela
sw.WriteLine("<tr>");
sw.WriteLine("<th align='right' width='180px'>");
sw.WriteLine("ID");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='180px'>");
sw.WriteLine("NOME");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='180px'>");
sw.WriteLine("TELEFONE");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='180px'>");
sw.WriteLine("ESTADO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='180px'>");
sw.WriteLine("CIDADE");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='180px'>");
sw.WriteLine("ENDERECO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='180px'>");
sw.WriteLine("NUMERO");
sw.WriteLine("</th>");
sw.WriteLine("</tr>");
int cont = 0;
foreach (CAMADAS.MODEL.Clientes cliente in lstCli.OrderBy(o => o.id))
{
sw.WriteLine("<tr>");
sw.WriteLine("<td align='left' width='180px'>");
sw.WriteLine(cliente.id);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='180px'>");
sw.WriteLine(cliente.nome);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='180px'>");
sw.WriteLine(cliente.telefone);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='180px'>");
sw.WriteLine(cliente.estado);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='180px'>");
sw.WriteLine(cliente.cidade);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='180px'>");
sw.WriteLine(cliente.endereco);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='300px'>");
sw.WriteLine(cliente.numero);
sw.WriteLine("</td>");
sw.WriteLine("</tr>");
cont++;
}
sw.WriteLine("</table>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("<h3>");
sw.WriteLine("Total de Clientes Cadastrados: " + cont.ToString());
sw.WriteLine("</h3>");
sw.WriteLine("</body>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}
public static void relPedido()
{
CAMADAS.BLL.Pedidos bllPed = new CAMADAS.BLL.Pedidos();
List <CAMADAS.MODEL.Pedidos> lstPed = new List <CAMADAS.MODEL.Pedidos>();
lstPed = bllPed.Select();
string pasta = Funcoes.diretorioPasta();
string arquivo = pasta + @"\RelPedidos_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".html";
string arquivoPDF = pasta + @"\RelPedidos_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".pdf";
StreamWriter sw = new StreamWriter(arquivo);
using (sw)
{
sw.WriteLine("<html>");
sw.WriteLine("<head>");
sw.WriteLine("<meta http-equiv='Content-Type' " +
"content='text/html; charset=utf-8'/>");
sw.WriteLine("<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' integrity='sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T' crossorigin='anonymous'>");
sw.WriteLine("</head>");
sw.WriteLine("<body>");
sw.WriteLine("<h1>Relatório de Pedidos</h1>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("<table class='table table-striped'>");
sw.WriteLine("<tr align='right'>");
sw.WriteLine("<th align='right' width='30px'>");
sw.WriteLine("ID");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='250px'>");
sw.WriteLine("DESCRIÇÃO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("PEDIDO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("BEBIDA");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("ENDEREÇO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='60px'>");
sw.WriteLine("VALOR");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='60px'>");
sw.WriteLine("QUANTIDADE");
sw.WriteLine("</tr>");
sw.WriteLine("</tr>");
int cont = 0;
float soma = 0;
foreach (CAMADAS.MODEL.Pedidos pedido in lstPed.OrderBy(o => o.quantidade))
{
sw.WriteLine("<tr>");
sw.WriteLine("<td align='right' width='30px'>");
sw.WriteLine(pedido.id);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='250px'>");
sw.WriteLine(pedido.descricao);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(pedido.pedido);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(pedido.bebidas);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(pedido.endereco);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(string.Format("{0:C2}", pedido.valor));
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(string.Format("{0:C2}", pedido.quantidade));
sw.WriteLine("</td>");
sw.WriteLine("</tr>");
soma = soma + pedido.valor;
cont++;
}
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("</table>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("<h2>");
sw.WriteLine("Total de Registros Impressos: " + cont.ToString());
sw.WriteLine("</br>");
sw.WriteLine("Valor total dos Pedidos R$: " + string.Format("{0:#.#,00}", soma));
sw.WriteLine("</body>");
sw.WriteLine("</h2>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}