private void btnAlterar_Click(object sender, EventArgs e)
{
try
{
Database.Entities.tb_client client = new Database.Entities.tb_client();
client.id_client = Convert.ToInt32(nudID.Value);
client.nm_firstName = txtNome.Text.Trim();
client.nm_lastName = txtSobrenome.Text.Trim();
client.nr_rg = mtxtRG.Text.Trim();
client.nr_cpf = mtxtCPF.Text.Trim();
client.ds_sex = cboSexo.Text;
client.dt_birth = dtpNascimento.Value.ToShortDateString();
client.ds_state = cboEstado.Text;
client.nr_cep = mtxtCEP.Text.Trim();
client.ds_address = txtEndereço.Text.Trim();
client.ds_note = txtComplemento.Text.Trim();
client.nr_cellphone = mtxtCelular.Text.Trim();
client.nr_tellphone = mtxtTelefone.Text.Trim();
client.ds_email = txtEmail.Text.Trim();
Business.ClientBusiness busclient = new Business.ClientBusiness();
busclient.Alterar(client);
MessageBox.Show("Cliente alterado com sucesso", "Alterado", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnConsultar_Click(object sender, EventArgs e)
{
Business.ClientBusiness busclient = new Business.ClientBusiness();
List <Database.Entities.tb_client> clientlista = busclient.ConsultarTodos();
dgvConsultarCliente.DataSource = clientlista;
}
private void btnDeletar_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(nudID.Value);
Business.ClientBusiness busclient = new Business.ClientBusiness();
busclient.Remover(id);
MessageBox.Show("Cliente deletado com sucesso", "Deletado", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
private void btnDeletar_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(nudId.Value);
Business.ClientBusiness busclient = new Business.ClientBusiness();
busclient.Remover(id);
MessageBox.Show("Cliente deletado com sucesso");
}
private void nudID_ValueChanged(object sender, EventArgs e)
{
int id = Convert.ToInt32(nudID.Value);
Business.ClientBusiness busclient = new Business.ClientBusiness();
Database.Entities.tb_client client = busclient.ConsultarPorID(id);
if (client == null)
{
txtNome.Text = string.Empty;
txtSobrenome.Text = string.Empty;
mtxtRG.Text = string.Empty;
mtxtCPF.Text = string.Empty;
cboSexo.Text = null;
dtpNascimento.Value = DateTime.Now;
cboEstado.Text = null;
txtEndereço.Text = string.Empty;
mtxtCEP.Text = string.Empty;
txtComplemento.Text = string.Empty;
mtxtCelular.Text = string.Empty;
mtxtTelefone.Text = string.Empty;
txtEmail.Text = string.Empty;
}
else
{
txtNome.Text = client.nm_firstName;
txtSobrenome.Text = client.nm_lastName;
mtxtRG.Text = client.nr_rg;
mtxtCPF.Text = client.nr_cpf;
if (client.ds_sex == "M")
{
cboSexo.Text = "Masculino";
}
else
{
cboEstado.Text = "Feminino";
}
dtpNascimento.Value = Convert.ToDateTime(client.dt_birth);
cboEstado.Text = client.ds_state;
mtxtCEP.Text = client.nr_cep;
txtEndereço.Text = client.ds_address;
txtComplemento.Text = client.ds_note;
mtxtCelular.Text = client.nr_cellphone;
mtxtTelefone.Text = client.nr_tellphone;
txtEmail.Text = client.ds_email;
}
}
private void Consulta()
{
Database.Entities.tb_client client = new Database.Entities.tb_client();
client.nm_firstName = txtNome.Text.Trim();
client.nr_rg = mtxtRG.Text;
if (cboSexo.Text == "Masculino")
{
client.ds_sex = "M";
}
if (cboSexo.Text == "Feminino")
{
client.ds_sex = "F";
}
Business.ClientBusiness busclient = new Business.ClientBusiness();
List <Database.Entities.tb_client> clientlista = busclient.Consultar(client);
dgvConsultarCliente.DataSource = clientlista;
}
