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 AvatarClick(object sender, RoutedEventArgs e)
{
if (Controller.UserIsLoggedIn)
{
CustomMB mb = new CustomMB("Die Datei darf nicht über 1MB groß sein !");
mb.Owner = System.Windows.Application.Current.MainWindow;
OpenFileDialog op = new OpenFileDialog
{
Title = "Wähle ein Bild als Avatar aus",
Filter = "Alle Bilder| *.jpg;*.jpeg;*.png|" +
"JPEG (*.jpg;*.jpeg)|*.jpg;*.jpeg|" +
"Portable Network Graphic (*.png)|*.png"
};
if (op.ShowDialog() == true)
{
FileInfo fi = new FileInfo(op.FileName);
if (fi.Length > 1000000)
{
mb.ShowDialog();
AvatarClick(sender, e);
}
else
{
using (BinaryReader br = new BinaryReader(File.Open(op.FileName, FileMode.Open))) // liest das Bild ein in bytes
{ Controller.UpdateAvatarImg(br, fi.Length); } // updatet die User Daten
Avatar.Source = Controller.LoadImage(Convert.FromBase64String(Controller.user.avatarImg)); // liest die updatete avatarImg Property wieder aus und updatet das icon
}
}
}
GC.Collect();
}
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();
}
}
}
}
}
