// Constructor public Form_Chat(User currentuser, User otheruser) { InitializeComponent(); chathandler = new ChatHandler(); currentUser = currentuser; otherUser = otheruser; snd = new SoundPlayer(Properties.Resources.Notification); currentchat = OpenChat(currentUser, otherUser); Timer_Refresh.Start(); }
public static Chat GetChat(int chatid) { Chat returnchat = new Chat(chatid); List<Message> chatmessages = new List<Message>(); try { Connect(); cmd = new OracleCommand(); cmd.Connection = con; cmd.CommandText = "SELECT GESPREKID, BERICHTID, AFZENDER, DATUM, BERICHT FROM (SELECT GESPREKID, BERICHTID, AFZENDER, DATUM, BERICHT FROM TCHATBERICHT WHERE GESPREKID = " + chatid + " ORDER BY BERICHTID DESC) WHERE ROWNUM <= 10" ; cmd.CommandType = CommandType.Text; dr = cmd.ExecuteReader(); while (dr.Read()) { var id = dr.GetInt32(0); var messageid = dr.GetInt32(1); var authorid = dr.GetInt32(2); var date = dr.GetDateTime(3); var content = dr.GetString(4); chatmessages.Add(new Message(id, messageid, authorid, date, content)); } foreach (Message m in chatmessages) { m.Author = GetUser(m.AuthorID); } returnchat.Messages = chatmessages; return returnchat; } catch (Exception ex) { MessageBox.Show(ex.Message); return null; } finally { Disconnect(); } }