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 btnEdit_Click(object sender, EventArgs e) { DataGridViewRow linhaAtualC = dataGridView1.CurrentRow; int indiceC = linhaAtualC.Index; frmPedirCaso frm = new frmPedirCaso((int)dataGridView1.Rows[indiceC].Cells["ID"].Value, true); frm.ShowDialog(); }
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 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(); } } } } }