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