public void Notificacao()
{
tela_conversa tela = new tela_conversa();
MySqlDataReader dr;
Conexao con = new Conexao();
MySqlCommand cmd = new MySqlCommand("SELECt * FROM tb_notificacao where destinatario=@usuario or remetente =@usuario and lido = 'n' ORDER BY id_notificacao DESC LIMIT 1 ", con.ConectarBD());
cmd.Parameters.Add("@usuario", MySqlDbType.VarChar).Value = Variaveis_globais.usuario;
dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
id_notificacao = dr[0].ToString();
if (id_notificacao != Variaveis_globais.mensagem)
{
notifyIcon1.ShowBalloonTip(10, "Nova mensagem", dr[3].ToString(), ToolTipIcon.None);
Variaveis_globais.mensagem = id_notificacao;
}
else
{
}
}
}
conexao.DesconectarBD();
}
private void chamarPrivadoToolStripMenuItem_Click(object sender, EventArgs e)
{
tela_conversa tela = new tela_conversa();
LeConversa();
tela.Show();
tela.cbbDesti.Text = msg;
}
public void LeConversa()
{
tela_conversa tela = new tela_conversa();
MySqlDataReader dr;
Conexao con = new Conexao();
MySqlCommand cmd = new MySqlCommand("select * from tb_conversa where destinatario = @destinatario and lido ='n' and remetente =@remetente or destinatario=@remetente and remetente=@destinatario and lido='n'", con.ConectarBD());
cmd.Parameters.Add("@destinatario", MySqlDbType.VarChar).Value = Variaveis_globais.usuario;
cmd.Parameters.Add("@remetente", MySqlDbType.VarChar).Value = msg;
dr = cmd.ExecuteReader();
string remet;
if (dr.HasRows == false)
{
MessageBox.Show("Erro ao buscar !");
}
else
{
tela.Show();
while (dr.Read())
{
remet = dr[1].ToString();
if (Variaveis_globais.usuario == remet)
{
tela.cbbDesti.Text = dr[1].ToString();
tela.richTextBox1.Text = dr[3].ToString();
}
else if (Variaveis_globais.usuario != remet)
{
tela.cbbDesti.Text = dr[2].ToString();
tela.richTextBox1.Text = dr[3].ToString();
}
}
con.DesconectarBD();
con.ConectarBD();
con.DesconectarBD();
}
Conexao co = new Conexao();
MySqlCommand cm = new MySqlCommand("update tb_conversa set lido='s' where destinatario = @destinatario and lido ='n' and remetente =@remetente or destinatario=@remetente and remetente=@destinatario; update tb_notificacao set lido='s' where destinatario = @destinatario and lido ='n' and remetente =@remetente or destinatario=@remetente and remetente=@destinatario", co.ConectarBD());
cm.Parameters.Add("@destinatario", MySqlDbType.VarChar).Value = Variaveis_globais.usuario;
cm.Parameters.Add("@remetente", MySqlDbType.VarChar).Value = msg;
try
{
cm.ExecuteNonQuery();
MessageBox.Show("LIDO COM SUCESSO !");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void novaConversaToolStripMenuItem_Click(object sender, EventArgs e)
{
tela_conversa tela = new tela_conversa();
tela.Show();
}
