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);
}
}
public List <Caso> ListarCasosDeUso()
{
return(CasoDAO.Listar());
}
public CasoService()
{
_daoFactory = new DAOFactory();
_casoDao = (CasoDAO)_daoFactory.GetCasoDAO();
}
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();
}
}
}
}
}
