// Select all messages between a student and tutor
public List<MessageDetails> selectMessages(string _studentid, string _tutorid)
{
MessageDetails _message = null;
List<MessageDetails> _messageList = new List<MessageDetails>();
string selectMessageQuery = "SELECT * FROM MessageDetails WHERE SenderID = @student AND RecipientID = @tutor " +
"UNION " +
"SELECT * FROM MessageDetails WHERE SenderID = @tutor AND RecipientID = @student " +
"ORDER BY Date DESC, Time DESC;";
conn = new SqlConnection(DBConnection.ConnectionString);
using (conn)
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
try
{
cmd.CommandText = selectMessageQuery;
cmd.Prepare();
cmd.Parameters.AddWithValue("@student", _studentid);
cmd.Parameters.AddWithValue("@tutor", _tutorid);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
long _messageid = long.Parse(rdr["MessageID"].ToString());
string _senderid = rdr["SenderID"].ToString();
string _recipientid = rdr["RecipientID"].ToString();
DateTime _date = DateTime.Parse(rdr["Date"].ToString());
DateTime _time = DateTime.Parse(rdr["Time"].ToString());
string _subject = rdr["Subject"].ToString();
string _messageContent = rdr["MessageContent"].ToString();
_message = new MessageDetails(_messageid, _senderid, _recipientid, _date, _time, _subject, _messageContent);
_messageList.Add(_message);
}
return _messageList;
}
catch (Exception e)
{
Console.WriteLine("Error: " + e);
return null;
}
finally
{
conn.Close();
}
}
}
}
public string getLastInteraction()
{
return(MessageDetails.getLatestSentMessageDateOfUser(userID));
}