private void frmClientes_Load(object sender, EventArgs e)
{
CAMADAS.BLL.Clientes bllClientes = new CAMADAS.BLL.Clientes();
dgvClientes.DataSource = bllClientes.Select();
habilitaBotoes(true);
habilitaControles(false);
}
private void rdbTodos_CheckedChanged(object sender, EventArgs e)
{
lblFiltrar.Visible = false;
txtFiltro.Visible = false;
CAMADAS.BLL.Clientes bllClientes = new CAMADAS.BLL.Clientes();
List <CAMADAS.MODEL.Clientes> lstClientes = new List <CAMADAS.MODEL.Clientes>();
lstClientes = bllClientes.Select();
dgvClientes.DataSource = "";
dgvClientes.DataSource = lstClientes;
}
private void btnGravar_Click(object sender, EventArgs e)
{
CAMADAS.BLL.Clientes bllCli = new CAMADAS.BLL.Clientes();
string msg = "";
if (lblID.Text == "0")
{
msg = "Deseja inserir um novo cliente?";
}
else
{
msg = "Deseja alterar o cliente atual?";
}
DialogResult resposta = MessageBox.Show(msg, "Gravar", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (resposta == DialogResult.Yes)
{
CAMADAS.MODEL.Clientes clientes = new CAMADAS.MODEL.Clientes();
clientes.nome = txtNome.Text;
clientes.telefone = txtTelefone.Text;
clientes.cidade = txtCidade.Text;
clientes.estado = txtEstado.Text;
clientes.endereco = txtEndereco.Text;
clientes.numero = txtNumero.Text;
if (lblID.Text == "0")
{
bllCli.Insert(clientes);
}
else
{
bllCli.Update(clientes);
}
MessageBox.Show("Dados Gravados", "Gravar", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Dados Não Gravados", "Gravar", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
dgvClientes.DataSource = "";
dgvClientes.DataSource = bllCli.Select();
limparControle();
habilitaControles(false);
habilitaBotoes(true);
}
private void btnFiltrar_Click(object sender, EventArgs e)
{
CAMADAS.BLL.Clientes bllClientes = new CAMADAS.BLL.Clientes();
List <CAMADAS.MODEL.Clientes> lstCli = new List <CAMADAS.MODEL.Clientes>();
if (rdbTodos.Checked)
{
lstCli = bllClientes.Select();
}
else if (rdbNome.Checked)
{
lstCli.Add(bllClientes.SelectByNome(txtFiltro.Text));
}
else
{
int id = Convert.ToInt32(txtFiltro.Text);
lstCli.Add(bllClientes.SelectByID(id));
}
dgvClientes.DataSource = "";
dgvClientes.DataSource = lstCli;
}
private void btnRemover_Click(object sender, EventArgs e)
{
CAMADAS.BLL.Clientes bllClientes = new CAMADAS.BLL.Clientes();
if (lblID.Text != "0")
{
string msg = "Deseja remover o atual fornecedor?";
DialogResult resposta = MessageBox.Show(msg, "Remover", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2);
if (resposta == DialogResult.Yes)
{
int idFornecedor = Convert.ToInt32(lblID.Text);
bllClientes.Delete(idFornecedor);
}
}
else
{
MessageBox.Show("Não há dados para remover", "Remover", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
dgvClientes.DataSource = "";
dgvClientes.DataSource = bllClientes.Select();
limparControle();
}
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 relCliente()
{
CAMADAS.BLL.Clientes bllCliente = new CAMADAS.BLL.Clientes();
List <CAMADAS.MODEL.Clientes> lstCliente = new List <CAMADAS.MODEL.Clientes>();
lstCliente = bllCliente.Select().OrderBy(o => o.nome).ToList();
string pasta = Funcoes.diretorioPasta();
string arquivo = pasta + @"\RelatorioClientes.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='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>");
sw.WriteLine("</head>");
sw.WriteLine("<body>");
sw.WriteLine("<h1> <center>Relatório de Clientes <center> </h1>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("</br>");
sw.WriteLine("<table class='table table - dark'>");
sw.WriteLine("<tr align='right'>");
sw.WriteLine("<th align='right' width='40px'>");
sw.WriteLine("ID");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='250px'>");
sw.WriteLine("NOME");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("CPF");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("RG");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("ENDERECO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("CIDADE");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("UF");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("TELEFONE");
sw.WriteLine("</th>");
sw.WriteLine("<tr>");
int cont = 0;
foreach (CAMADAS.MODEL.Clientes cliente in lstCliente)
{
sw.WriteLine("<tr>");
sw.WriteLine("<td align='right' width='40px'>");
sw.WriteLine(cliente.id);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='250px'>");
sw.WriteLine(cliente.nome);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='300px'>");
sw.WriteLine(cliente.cpf);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='200px'>");
sw.WriteLine(cliente.rg);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(cliente.endereco);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='250px'>");
sw.WriteLine(cliente.cidade);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='250px'>");
sw.WriteLine(cliente.uf);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='250px'>");
sw.WriteLine(cliente.telefone);
sw.WriteLine("</td>");
sw.WriteLine("<tr>");
cont++;
}
sw.WriteLine("</table>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("<h3>Numero de Clientes: {0}", cont);
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("</body>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}
public static void RelProduto()
{
CAMADAS.BLL.Clientes clientes = new CAMADAS.BLL.Clientes();
List <CAMADAS.MODEL.Clientes> LstCli = new List <MODEL.Clientes>();
LstCli = clientes.Select();
string pasta = Funcoes.DiretorioPasta();
string arquivo = pasta + @"\RelClientes_" + 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>");
//Título da tabela
sw.WriteLine("<body>");
sw.WriteLine("<p>");
sw.WriteLine("<font size '30' face='Georgia'>");
sw.WriteLine("<h1>Relatório de Clientes</h1>");
sw.WriteLine("</font>");
sw.WriteLine("</p>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("<table class='table table-striped'>");
//Cabeçalho da tabela
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("NOME");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("CURSO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("DIAS");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("MULTA");
sw.WriteLine("</th>");
int cont = 0;
float soma = 0;
foreach (CAMADAS.MODEL.Clientes cliente in LstCli.OrderBy(o => o.NOME))
{
//Completando a tabela com os itens do banco
sw.WriteLine("<tr>");
sw.WriteLine("<td align='right' width='30px'>");
sw.WriteLine(cliente.ID);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(cliente.NOME);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(cliente.CURSO);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(cliente.DIAS);
sw.WriteLine("</td>");
sw.WriteLine("<td align='right' width='150px'>");
sw.WriteLine(string.Format("{0:C2}", cliente.MULTA));
sw.WriteLine("</td>");
soma = soma + cliente.MULTA;
cont++;
}
//Rodapé
sw.WriteLine("</table>");
sw.WriteLine("<hr align='left' border:'5px' />");
sw.WriteLine("<h3>");
sw.WriteLine("<p>");
sw.WriteLine("<font size '30' face='Georgia'>");
sw.WriteLine("Total de Clientes Cadastrados: " + cont.ToString());
sw.WriteLine("</br>");
sw.WriteLine("Valor total das Multas R$: " + string.Format("{0:#.#,0}", soma));
sw.WriteLine("</font>");
sw.WriteLine("</p>");
sw.WriteLine("</body>");
sw.WriteLine("</h3>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}
public static void relClientes()
{
CAMADAS.BLL.Clientes bllClientes = new CAMADAS.BLL.Clientes();
List <CAMADAS.MODEL.Clientes> lstClientes = new List <CAMADAS.MODEL.Clientes>();
lstClientes = bllClientes.Select();
string pasta = Funcoes.deretorioPasta();
string arquivo = pasta + @"\ReClientes_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".html";
StreamWriter ws = new StreamWriter(arquivo);
using (ws)
{
ws.WriteLine("<html>");
ws.WriteLine("<head>");
ws.WriteLine("<meta http-equiv='Content-Type' " +
"content='text/html; charset=utf-8'/>");
ws.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'>");
ws.WriteLine("</head>");
ws.WriteLine("<body>");
ws.WriteLine("<h1>Relatório de Clientes</h1>");
ws.WriteLine("<hr align='left' border:'5px' />");
ws.WriteLine("<table class='table table-striped'>");
//Cabeçalho da tabela
ws.WriteLine("<tr align='right'>");
ws.WriteLine("<th align='right' width='30px'>");
ws.WriteLine("ID");
ws.WriteLine("</th>");
ws.WriteLine("<th align='right' width='250px'>");
ws.WriteLine("NOME");
ws.WriteLine("</th>");
ws.WriteLine("<th align='right' width='150px'>");
ws.WriteLine("CPF");
ws.WriteLine("</th>");
ws.WriteLine("<th align='right' width='150px'>");
ws.WriteLine("SEXO");
ws.WriteLine("</th>");
ws.WriteLine("</tr>");
int cont = 0;
float soma = 0;
foreach (CAMADAS.MODEL.Clientes Clientes in lstClientes.OrderBy(o => o.id).ThenBy(t => t.id).ThenBy(w => w.nome))
{
ws.WriteLine("<tr>");
ws.WriteLine("<td align='right' width='30px'>");
ws.WriteLine(Clientes.id);
ws.WriteLine("</td>");
ws.WriteLine("<td align='right' width='250px'>");
ws.WriteLine(Clientes.nome);
ws.WriteLine("</td>");
ws.WriteLine("<td align='right' width='150px'>");
ws.WriteLine(Clientes.cpf);
ws.WriteLine("</td>");
ws.WriteLine("<td align='right' width='150px'>");
ws.WriteLine(Clientes.sexo);
ws.WriteLine("</td>");
cont++;
}
ws.WriteLine("");
ws.WriteLine("");
ws.WriteLine("</table>");
ws.WriteLine("<hr align='left' border:'5px' />");
ws.WriteLine("<h2>");
ws.WriteLine("Total de Registros Impressos: " + cont.ToString());
ws.WriteLine("</br>");
ws.WriteLine("Total de clientes " + cont.ToString());
ws.WriteLine("</body>");
ws.WriteLine("</h2>");
ws.WriteLine("</html>");
}
}
public static void relClientes()
{
CAMADAS.BLL.Clientes bllClientes = new CAMADAS.BLL.Clientes();
List <CAMADAS.MODEL.Clientes> lstClientes = new List <CAMADAS.MODEL.Clientes>();
lstClientes = bllClientes.Select().OrderBy(o => o.nome).ToList();
string pasta = Funcoes.deretorioPasta();
string arquivo = pasta + @"\RelClientes.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.4.1/css/bootstrap.min.css' integrity='sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh' crossorigin= 'anonymous'>");
sw.WriteLine("</head>");
sw.WriteLine("<body>");
sw.WriteLine("<h1> Relatorio Clientes</h1>");
sw.WriteLine("<hr align= 'left' border:'5px' />");
sw.WriteLine("</br>");
sw.WriteLine("<table class='table table-hover'>");
sw.WriteLine("<tr>");
sw.WriteLine("<th align='right' width='30px'>");
sw.WriteLine("CODIGO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='250px'>");
sw.WriteLine("NOME");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("CPF");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("CELULAR");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("MUNICIPIO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("ENDERECO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='right' width='150px'>");
sw.WriteLine("CEP");
sw.WriteLine("</th>");
sw.WriteLine("</tr>");
int cont = 0;
foreach (CAMADAS.MODEL.Clientes clientes in lstClientes)
{
sw.WriteLine("<tr>");
sw.WriteLine("<td align='left' width='30px'>");
sw.WriteLine(clientes.codigo);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='250px'>");
sw.WriteLine(clientes.nome);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='150px'>");
sw.WriteLine(clientes.cpf);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='150px'>");
sw.WriteLine(clientes.celular);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='150px'>");
sw.WriteLine(clientes.municipio);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='150px'>");
sw.WriteLine(clientes.endereco);
sw.WriteLine("</td>");
sw.WriteLine("<td align='left' width='150px'>");
sw.WriteLine(clientes.cep);
sw.WriteLine("</td>");
sw.WriteLine("</tr>");
cont++;
}
sw.WriteLine("</table>");
sw.WriteLine("<hr align= 'left' border:'5px' />");
sw.WriteLine("<h2> Total De Clientes {0} Cadastrados", cont);
sw.WriteLine("</body>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}
