//FIM CUPONS
//RELATORIOS VENDAS
public static void relVendas()
{
CAMADAS.BLL.Vendas bllVendas = new CAMADAS.BLL.Vendas();
List <CAMADAS.MODEL.Vendas> lstVendas = new List <CAMADAS.MODEL.Vendas>();
lstVendas = bllVendas.SelectWithInnerJoin();
string pasta = Funcoes.deretorioPasta();
string arquivo = pasta + @"\RelVendas_" + 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.3.1/css/bootstrap.min.css' integrity='sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T' crossorigin='anonymous'>");
sw.WriteLine("</head>");
sw.WriteLine("<body>");
sw.WriteLine("<table class='table table-hover'>");
//Cabeçalho da tabela
sw.WriteLine("<thead class='thead-dark'>");
sw.WriteLine("<tr>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine("ID VENDA");
sw.WriteLine("</th>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine("DESCONTO");
sw.WriteLine("</th>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine("VALOR FINAL");
sw.WriteLine("</th>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine("DATA");
sw.WriteLine("</th>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine("CLIENTE");
sw.WriteLine("</th>");
sw.WriteLine("</th>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine("VENDEDOR");
sw.WriteLine("</th>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine("TOTAL ARRECADADO");
sw.WriteLine("</th>");
sw.WriteLine("</tr>");
sw.WriteLine("</thead>");
int cont = 0;
float soma = 0;
foreach (CAMADAS.MODEL.Vendas vendas in lstVendas)
{
sw.WriteLine("<tbody>");
sw.WriteLine("<tr>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine(vendas.id_venda);
sw.WriteLine("</td>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine(vendas.desconto);
sw.WriteLine("</td>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine(string.Format("{0:C2}", vendas.valor_final));
sw.WriteLine("</td>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine(vendas.data);
sw.WriteLine("</td>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine(vendas.desc_cliente);
sw.WriteLine("</td>");
sw.WriteLine("<th scope='col'>");
sw.WriteLine(vendas.desc_vendedor);
sw.WriteLine("</td>");
soma = soma + vendas.valor_final;
cont++;
sw.WriteLine("<th scope='col'>");
sw.WriteLine("VENDA " + cont + ": " + soma);
sw.WriteLine("</td>");
sw.WriteLine("</tr>");
}
sw.WriteLine("</tbody>");
sw.WriteLine("</table>");
sw.WriteLine("</body>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}
