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(); }