public List <chat> viewMessage(string recipient)
{
List <chat> allMessages = new List <chat>();
SqlConnection conn = null;
SqlCommand cmd = null;
SqlDataReader reader = null;
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["vetoTours"].ToString());
conn.Open();
string query = "SELECT * FROM chat WHERE recipient='" + recipient + "';";
cmd = new SqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
chat temp = new chat(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetDateTime(5));
allMessages.Add(temp);
}
reader.Close();
conn.Close();
return(allMessages);
}
protected void sendMsgController(object sender, EventArgs e)
{
inboxErrorHandler inboxHandler = new inboxErrorHandler();
if (sendTo.Text == "")
{
inboxHandler.emptyUserField();
}
if (msgSubject.Text == "")
{
inboxHandler.emptySubjectField();
}
if (msgField.Text == "")
{
inboxHandler.emptyMessageField();
}
user targetUser = fetchUserObject(sendTo.Text);
if (targetUser == null)
{
inboxHandler.noSuchUser();
}
if (inboxHandler.error == "")
{
chat newChat = new chat(currUser.getUserID(), sendTo.Text, msgSubject.Text, msgField.Text);
newChat.sendMessage();
Session["success"] = "msgSent";
general_dialog.Visible = false;
Response.Redirect("main.aspx");
}
else
{
general_dialog.InnerHtml = inboxHandler.error;
general_dialog.Visible = true;
}
}
