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