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