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