public void CarregarTela() { ClienteDatabase db = new ClienteDatabase(); List <ClienteDTO> c = db.Listar(); gvConsulta.DataSource = c; }
private void Button1_Click(object sender, EventArgs e) { DTO.ClienteDTO trab = new DTO.ClienteDTO(); trab.Nome = txtnome.Text; trab.Telefone = mskPhone.Text; trab.Celular = mskCellphone.Text; trab.Estado = textuf.Text; trab.Email = txtEmail.Text; trab.Cep = mskCep.Text; trab.Cpf = mskCPF.Text; ClienteDatabase coursedatabase = new ClienteDatabase(); coursedatabase.Salvar(trab); MessageBox.Show("Cadastro realizado com sucesso.", "Simone Ribeiro", MessageBoxButtons.OK, MessageBoxIcon.Information); txtnome.Text = ""; mskPhone.Text = ""; mskCellphone.Text = ""; textuf.Text = ""; txtEmail.Text = ""; mskCep.Text = ""; mskCPF.Text = ""; }
private void CarregarClientes() { ClienteDatabase db = new ClienteDatabase(); ClienteDTO dto = new ClienteDTO(); cboCli.DisplayMember = nameof(ClienteDTO.nome); cboCli.ValueMember = nameof(ClienteDTO.idCliente); cboCli.DataSource = db.ListarClientes(""); }
private void button1_Click(object sender, EventArgs e) { string nome = txtNome.Text; string cpf = txtCpf.Text; ClienteDatabase cliente = new ClienteDatabase(); List <ClienteDTO> clientes = cliente.Filtrar(nome, cpf); gvConsulta.DataSource = clientes; }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { DTO.ClienteDTO trab = new DTO.ClienteDTO(); trab.Nome = txtnome.Text; trab.Telefone = mskPhone.Text; trab.Celular = mskCellphone.Text; trab.Estado = textuf.Text; trab.Email = txtEmail.Text; trab.Cep = mskCep.Text; trab.Cpf = mskCPF.Text; ClienteDatabase db = new ClienteDatabase(); db.Alterar(dto); MessageBox.Show("Alteraçôes salvas com sucesso.", "RRAN - Alterar Cliente", MessageBoxButtons.OK, MessageBoxIcon.Information); Hide(); }
private void bunifuImageButton1_Click(object sender, EventArgs e) { DTOUser trab = new DTOUser(); trab.Nome = txtnome.Text; trab.Cpf = maskedTextBox1.Text; trab.Email = txtemail.Text; trab.Valor = maskedTextBox2.Text; trab.Data = dateTimePicker1.Value; ClienteDatabase coursedatabase = new ClienteDatabase(); coursedatabase.Salvar(trab); MessageBox.Show("Cadastro realizado com sucesso.", "RRAN - Planilha.", MessageBoxButtons.OK, MessageBoxIcon.Information); txtnome.Text = ""; maskedTextBox1.Text = ""; txtemail.Text = ""; maskedTextBox2.Text = ""; }
private void gvConsulta_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 8) { ClienteDTO dto = gvConsulta.Rows[e.RowIndex].DataBoundItem as ClienteDTO; frmEditarCliente frm = new frmEditarCliente(); frm.Carregar(dto); frm.ShowDialog(); } if (e.ColumnIndex == 9) { ClienteDTO dto = gvConsulta.Rows[e.RowIndex].DataBoundItem as ClienteDTO; ClienteDatabase db = new ClienteDatabase(); db.Remover(dto.Id); MessageBox.Show("Cliente removido com sucesso.", "Simone Ribeiro", MessageBoxButtons.OK, MessageBoxIcon.Information); List <ClienteDTO> list = db.Listar(); gvConsulta.DataSource = list; } }