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); } }
public List <Database.Entities.tb_client> Consultar(Database.Entities.tb_client client) { List <Database.Entities.tb_client> list = new List <Database.Entities.tb_client>(); if (client.nm_firstName != null && client.nr_rg == " , , -" && client.ds_sex == null) { list = db.ConsultarPorNome(client); } else if (client.nm_firstName == null || client.nm_firstName == string.Empty && client.nr_rg != " , , -" && client.ds_sex == null) { list = db.ConsultarPorRG(client); } else if (client.nm_firstName == null || client.nm_firstName == string.Empty && client.nr_rg == " , , -" && client.ds_sex != null) { list = db.ConsultarPorSexo(client); } else if (client.nm_firstName != null && client.nr_rg != " , , -" && client.ds_sex == null) { list = db.ConsultarPorNomeRG(client); } else if (client.nm_firstName != null && client.nr_rg == " , , -" && client.ds_sex != null) { list = db.ConsultarPorNomeSexo(client); } else if (client.nm_firstName == null || client.nm_firstName == string.Empty && client.nr_rg != " , , -" && client.ds_sex != null) { list = db.ConsultarPorRGSexo(client); } else if (client.nm_firstName != null && client.nr_rg != " , , -" && client.ds_sex != null) { list = db.ConsultarPorNomeRGSexo(client); } return(list); }
public void Inserir(Database.Entities.tb_client client) { if (client.nm_firstName == string.Empty) { throw new ArgumentException("O campo nome deve ser preenchido"); } if (client.nm_lastName == string.Empty) { throw new ArgumentException("O campo sobrenome deve ser preenchido"); } if (client.nr_rg == string.Empty) { throw new ArgumentException("O campo RG deve ser preenchido"); } if (client.nr_cpf == string.Empty) { throw new ArgumentException("O campo CPF deve ser preenchido"); } if (client.ds_sex == string.Empty) { throw new ArgumentException("O campo sexo deve ser preenchido"); } if (client.ds_sex == "Masculino") { client.ds_sex = "M"; } else { client.ds_sex = "F"; } if (client.ds_state == string.Empty) { throw new ArgumentException("O campo Estado deve ser preenchido"); } if (client.nr_cep == string.Empty) { throw new ArgumentException("O campo CEP deve ser preenchido"); } if (client.nr_cellphone == string.Empty && client.nr_tellphone == string.Empty) { throw new ArgumentException("Celular ou Telefone devem ser preenchidos"); } if (client.ds_email == string.Empty) { throw new ArgumentException("E-mail devem ser preenchidos"); } Regex regex = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$"); Match match = regex.Match(client.ds_email); if (match.Success == false) { throw new ArgumentException(client.ds_email + " é um e-mail inválido!"); } db.Inserir(client); }
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; }
public Database.Entities.tb_client ConsultarPorID(int id) { Database.Entities.tb_client client = db.ConsultaPorID(id); return(client); }