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