private void btnExcluir_Click(object sender, EventArgs e) { if (aaa != null) { DataGridViewRow linhaAtualC = dataGridView1.CurrentRow; int indiceC = linhaAtualC.Index; CasoDAO cdao = new CasoDAO(); Caso cc = cdao.BuscaPorID(Convert.ToInt32(dataGridView1.Rows[indiceC].Cells["ID"].Value)); frmPedirCaso frm = new frmPedirCaso(cc); frm.ShowDialog(); if (frm.Del) { cc.Status = "Encerrado"; cdao.Atualizar(); } } else { DataGridViewRow linhaAtualC = dataGridView1.CurrentRow; int indiceC = linhaAtualC.Index; frmPedirCaso frm = new frmPedirCaso((int)dataGridView1.Rows[indiceC].Cells["ID"].Value, 1, true); frm.ShowDialog(); if (frm.Alt) { CustomMB.Show("Caso alterado!", CustomMB.CorFundo.Verde); } } }
private void btnSave_Click(object sender, EventArgs e) { if (!(txtNome.Text.Equals(string.Empty) || txtEnd.Text.Equals(string.Empty) || txtCPF.Text.Length != 14 || txtTel.Text.Length != 15 || txtEmail.Text.Equals(string.Empty) || !txtEmail.Text.Contains("@") || cboFormPag.SelectedIndex == -1 || fileName.Equals(string.Empty))) { ClienteDAO cdao = new ClienteDAO(); frmPedirSenha frm = new frmPedirSenha(); frm.ShowDialog(); Cliente nc = new Cliente() { Nome = txtNome.Text, Endereco = txtEnd.Text, CPF = txtCPF.Text, Telefone = txtTel.Text, Email = txtEmail.Text, FormaPagamento = cboFormPag.Text, Foto = copyImgToFolder(), User = frm.txtUser.Text, Pass = frm.txtPass.Text }; if (cdao.Confirmar(nc.User)) { CustomMB.Show("Já existe um cliente com esse nome de usuario cadastrado!", CustomMB.CorFundo.Vermelho); } else { cdao.Salvar(nc); CustomMB.Show("Cliente cadastrado com sucesso!", CustomMB.CorFundo.Verde); frmPedirCaso pc = new frmPedirCaso(); pc.ShowDialog(); CasoDAO casodao = new CasoDAO(); Caso caso = new Caso() { Status = "Andamento", Descricao = pc.txtCaso.Text, Cliente = nc }; casodao.Salvar(caso); btnClear_Click(sender, e); nc = null; } } else { CustomMB.Show("Alguns campos estão vazios!", CustomMB.CorFundo.Amarelo); } }
private void btnSave_Click(object sender, EventArgs e) { if (!(txtNome.Text.Equals(string.Empty) || txtEnd.Text.Equals(string.Empty) || txtCPF.Text.Length != 14 || txtTel.Text.Length != 15 || txtEmail.Text.Equals(string.Empty) || !txtEmail.Text.Contains("@") || cboArea.SelectedIndex == -1 || txtUser.Text.Equals(string.Empty) || txtPass.Text.Equals(string.Empty) || nudPrec.Value == 0)) { a.Nome = txtNome.Text; a.Endereco = txtEnd.Text; a.CPF = txtCPF.Text; a.Telefone = txtTel.Text; a.Email = txtEmail.Text; a.Nascimento = dateNasci.Text; a.Especializacao = cboArea.Text; try { a.Foto = copyImgToFolder(); } catch (Exception) { } a.PrecoPorHR = Convert.ToInt32(nudPrec.Value); a.QtdCasos = Convert.ToInt32(nudQtdC.Value); a.Pass = txtPass.Text; if (a.User.Equals(txtUser)) { a.User = txtUser.Text; if (adao.Confirmar(a.User)) { CustomMB.Show("Já existe um advogado com esse nome de usuario cadastrado!", CustomMB.CorFundo.Vermelho); } else { adao.Atualizar(); CustomMB.Show("Advogado atualizado com sucesso!", CustomMB.CorFundo.Verde); this.Dispose(); } } else { adao.Atualizar(); CustomMB.Show("Advogado atualizado com sucesso!", CustomMB.CorFundo.Verde); } } else { CustomMB.Show("Alguns campos estão vazios!", CustomMB.CorFundo.Amarelo); } }
private void btnSave_Click(object sender, EventArgs e) { if (!(txtNome.Text.Equals(string.Empty) || txtEnd.Text.Equals(string.Empty) || txtCPF.Text.Length != 14 || txtTel.Text.Length != 15 || txtEmail.Text.Equals(string.Empty) || !txtEmail.Text.Contains("@") || cboFormPag.SelectedIndex == -1 || txtUser.Text.Equals(string.Empty) || txtPass.Text.Equals(string.Empty))) { c.Nome = txtNome.Text; c.Endereco = txtEnd.Text; c.CPF = txtCPF.Text; c.Telefone = txtTel.Text; c.Email = txtEmail.Text; c.FormaPagamento = cboFormPag.Text; try { c.Foto = copyImgToFolder(); } catch (Exception) { } c.Pass = txtPass.Text; if (c.User.Equals(txtUser)) { c.User = txtUser.Text; if (cdao.Confirmar(c.User)) { CustomMB.Show("Já existe um cliente com esse nome de usuario cadastrado!", CustomMB.CorFundo.Vermelho); } else { cdao.Atualizar(); CustomMB.Show("Cliente atualizado com sucesso!", CustomMB.CorFundo.Verde); } } else { cdao.Atualizar(); CustomMB.Show("Cliente atualizado com sucesso!", CustomMB.CorFundo.Verde); } } else { CustomMB.Show("Alguns campos estão vazios!", CustomMB.CorFundo.Amarelo); } }
private void btnSave_Click(object sender, EventArgs e) { if (!(txtNome.Text.Equals(string.Empty) || txtEnd.Text.Equals(string.Empty) || txtCPF.Text.Length != 14 || txtTel.Text.Length != 15 || txtEmail.Text.Equals(string.Empty) || !txtEmail.Text.Contains("@") || cboArea.SelectedIndex == -1 || nudPrec.Value == 0 || fileName.Equals(string.Empty))) { AdvogadoDAO adao = new AdvogadoDAO(); frmPedirSenha frm = new frmPedirSenha(); frm.ShowDialog(); Advogado na = new Advogado() { Nome = txtNome.Text, Endereco = txtEnd.Text, CPF = txtCPF.Text, Telefone = txtTel.Text, Email = txtEmail.Text, Nascimento = dateNasci.Text, Especializacao = cboArea.Text, Foto = copyImgToFolder(), PrecoPorHR = Convert.ToInt32(nudPrec.Value), QtdCasos = Convert.ToInt32(nudQtdC.Value), User = frm.txtUser.Text, Pass = frm.txtPass.Text }; if (adao.Confirmar(na.User)) { CustomMB.Show("Já existe um advogado com esse nome de usuario cadastrado!", CustomMB.CorFundo.Vermelho); } else { adao.Salvar(na); CustomMB.Show("Advogado cadastrado com sucesso!", CustomMB.CorFundo.Verde); btnClear_Click(sender, e); na = null; } } else { CustomMB.Show("Alguns campos estão vazios!", CustomMB.CorFundo.Amarelo); } }
private void btnSearch_Click(object sender, EventArgs e) { if (cboTipoCon.SelectedIndex == -1) { CustomMB.Show("Selecione o tipo de consulta!", CustomMB.CorFundo.Amarelo); } else { if (txtNome.Text.Trim().Equals(string.Empty)) { switch (cboTipoCon.SelectedItem) { case TipoCon.Advogado: Visivel(); var buscaA = from a in contexto.Advogados select a; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Caso: Oculto(); var buscaC = from c in contexto.Casos select c; dataGridView1.DataSource = buscaC.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Cliente: Visivel(); var buscaCl = from c in contexto.Clientes select c; dataGridView1.DataSource = buscaCl.ToList(); dataGridView1.ClearSelection(); break; } } else { switch (cboTipoCon.SelectedItem) { case TipoCon.Advogado: Visivel(); var buscaA = from a in contexto.Advogados where a.Nome.Equals(txtNome.Text) select a; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Caso: Oculto(); var buscaC = from c in contexto.Casos select c; dataGridView1.DataSource = buscaC.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Cliente: Visivel(); var buscaCl = from c in contexto.Clientes where c.Nome.Equals(txtNome.Text) select c; dataGridView1.DataSource = buscaCl.ToList(); dataGridView1.ClearSelection(); break; } } } }
private void btnExcluir_Click(object sender, EventArgs e) { if (txtNome.Text.Trim().Equals(string.Empty)) { switch (cboTipoCon.SelectedItem) { case TipoCon.Advogado: Visivel(); DataGridViewRow linhaAtual = dataGridView1.CurrentRow; int indice = linhaAtual.Index; AdvogadoDAO adao = new AdvogadoDAO(); Advogado aa = adao.BuscaPorID(Convert.ToInt32(dataGridView1.Rows[indice].Cells["ID"].Value)); adao.Remover(aa); CustomMB.Show("Advogado removido com sucesso!", CustomMB.CorFundo.Verde); var buscaA = from a in contexto.Advogados select a; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Caso: Oculto(); var buscaC = from c in contexto.Casos select c; dataGridView1.DataSource = buscaC.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Cliente: Visivel(); DataGridViewRow linhaAtualC = dataGridView1.CurrentRow; int indiceC = linhaAtualC.Index; ClienteDAO cdao = new ClienteDAO(); Cliente cc = cdao.BuscaPorID(Convert.ToInt32(dataGridView1.Rows[indiceC].Cells["ID"].Value)); cdao.Remover(cc); CustomMB.Show("Cliente removido com sucesso!", CustomMB.CorFundo.Verde); var buscaCl = from c in contexto.Clientes select c; dataGridView1.DataSource = buscaCl.ToList(); dataGridView1.ClearSelection(); break; } } else { switch (cboTipoCon.SelectedItem) { case TipoCon.Advogado: Visivel(); DataGridViewRow linhaAtual = dataGridView1.CurrentRow; int indice = linhaAtual.Index; AdvogadoDAO adao = new AdvogadoDAO(); Advogado aa = adao.BuscaPorID(Convert.ToInt32(dataGridView1.Rows[indice].Cells["ID"].Value)); adao.Remover(aa); CustomMB.Show("Advogado removido com sucesso!", CustomMB.CorFundo.Verde); var buscaA = from a in contexto.Advogados where a.Nome.Equals(txtNome.Text) select a; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Caso: Oculto(); var buscaC = from c in contexto.Casos select c; dataGridView1.DataSource = buscaC.ToList(); dataGridView1.ClearSelection(); break; case TipoCon.Cliente: Visivel(); DataGridViewRow linhaAtualC = dataGridView1.CurrentRow; int indiceC = linhaAtualC.Index; ClienteDAO cdao = new ClienteDAO(); Cliente cc = cdao.BuscaPorID(Convert.ToInt32(dataGridView1.Rows[indiceC].Cells["ID"].Value)); cdao.Remover(cc); CustomMB.Show("Cliente removido com sucesso", CustomMB.CorFundo.Verde); var buscaCl = from c in contexto.Clientes where c.Nome.Equals(txtNome.Text) select c; dataGridView1.DataSource = buscaCl.ToList(); dataGridView1.ClearSelection(); break; } } }
private void btnSearch_Click(object sender, EventArgs e) { if (aaa != null) { if (cboTipoCon.Text.Equals("Meus casos")) { btnPegar.Visible = false; if (chbAnd.Checked == false && chbEnc.Checked == false) { CustomMB.Show("Marque uma opção!", CustomMB.CorFundo.Amarelo); } else { if (chbAnd.Checked && chbEnc.Checked) { if (txtNome.Text.Trim().Equals(string.Empty)) { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == aaa.ID select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } else { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == aaa.ID && cli.Nome.Contains(txtNome.Text) select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } } else { if (chbAnd.Checked) { if (txtNome.Text.Trim().Equals(string.Empty)) { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == aaa.ID && c.Status == "Andamento" select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } else { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == aaa.ID && c.Status == "Andamento" && cli.Nome.Contains(txtNome.Text) select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } } if (chbEnc.Checked) { if (txtNome.Text.Trim().Equals(string.Empty)) { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == aaa.ID && c.Status != "Andamento" select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } else { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == aaa.ID && c.Status != "Andamento" && cli.Nome.Contains(txtNome.Text) select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } } } } } else { chbAnd.Checked = false; chbEnc.Checked = false; btnPegar.Visible = true; if (txtNome.Text.Trim().Equals(string.Empty)) { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == null && c.Status == "Andamento" select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } else { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == null && c.Status == "Andamento" && cli.Nome.Contains(txtNome.Text) select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } } } else { if (cboAdv.Text.Equals("Possui advogado")) { if (chbAnd.Checked && chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID join a in contexto.Advogados on c.AdvogadoID equals a.ID where c.ClienteID == ccc.ID select new { c.ID, c.Status, a.Nome }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } else { if (chbAnd.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID join a in contexto.Advogados on c.AdvogadoID equals a.ID where c.ClienteID == ccc.ID && c.Status == "Andamento" select new { c.ID, c.Status, a.Nome }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } if (chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID join a in contexto.Advogados on c.AdvogadoID equals a.ID where c.ClienteID == ccc.ID && c.Status != "Andamento" select new { c.ID, c.Status, a.Nome }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } } } else { if (chbAnd.Checked && chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID where c.ClienteID == ccc.ID && c.AdvogadoID == null select new { c.ID, c.Status }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } else { if (chbAnd.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID where c.ClienteID == ccc.ID && c.AdvogadoID == null && c.Status == "Andamento" select new { c.ID, c.Status }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } if (chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID where c.ClienteID == ccc.ID && c.AdvogadoID == null && c.Status != "Andamento" select new { c.ID, c.Status }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } } } } }
private void btnPegar_Click(object sender, EventArgs e) { if (aaa != null) { DataGridViewRow linhaAtualC = dataGridView1.CurrentRow; int indiceC = linhaAtualC.Index; CasoDAO cdao = new CasoDAO(); Caso cc = cdao.BuscaPorID(Convert.ToInt32(dataGridView1.Rows[indiceC].Cells["ID"].Value)); cc.AdvogadoID = aaa.ID; cdao.Atualizar(); CustomMB.Show("Caso vinculado.", CustomMB.CorFundo.Verde); if (txtNome.Text.Trim().Equals(string.Empty)) { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == null && c.Status == "Andamento" select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } else { var buscaA = from cli in contexto.Clientes join c in contexto.Casos on cli.ID equals c.ClienteID where c.AdvogadoID == null && c.Status == "Andamento" && cli.Nome.Contains(txtNome.Text) select new { c.ID, c.Status, cli.Nome }; dataGridView1.DataSource = buscaA.ToList(); dataGridView1.ClearSelection(); } } else { frmPedirCaso pc = new frmPedirCaso(); pc.ShowDialog(); CasoDAO casodao = new CasoDAO(); Caso caso = new Caso() { Status = "Andamento", Descricao = pc.txtCaso.Text, Cliente = ccc }; casodao.Salvar(caso); CustomMB.Show("Caso cadastrado!", CustomMB.CorFundo.Verde); if (cboAdv.Text.Equals("Possui advogado")) { if (chbAnd.Checked && chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID join a in contexto.Advogados on c.AdvogadoID equals a.ID where c.ClienteID == ccc.ID select new { c.ID, c.Status, a.Nome }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } else { if (chbAnd.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID join a in contexto.Advogados on c.AdvogadoID equals a.ID where c.ClienteID == ccc.ID && c.Status == "Andamento" select new { c.ID, c.Status, a.Nome }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } if (chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID join a in contexto.Advogados on c.AdvogadoID equals a.ID where c.ClienteID == ccc.ID && c.Status != "Andamento" select new { c.ID, c.Status, a.Nome }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } } } else { if (chbAnd.Checked && chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID where c.ClienteID == ccc.ID && c.AdvogadoID == null select new { c.ID, c.Status }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } else { if (chbAnd.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID where c.ClienteID == ccc.ID && c.AdvogadoID == null && c.Status == "Andamento" select new { c.ID, c.Status }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } if (chbEnc.Checked) { var busca = from c in contexto.Casos join cli in contexto.Clientes on c.ClienteID equals cli.ID where c.ClienteID == ccc.ID && c.AdvogadoID == null && c.Status != "Andamento" select new { c.ID, c.Status }; dataGridView1.DataSource = busca.ToList(); dataGridView1.ClearSelection(); } } } } }