using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class messages : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        switch (Request.QueryString["box"])
        {
            case "inbox":
            default:
                SDSMessages.SelectCommand = "SELECT messaging.messageID, messaging.messageSubject, messaging.messageDate, messaging.messageStatus, accounts.accountUsername, accounts.accountFirstName, accounts.accountLastName FROM messaging INNER JOIN accounts ON messaging.accountID = accounts.accountID WHERE (messaging.messageStatus = '0') AND (messaging.messageRecipentID = '" + Session["id"] + "') ORDER BY messaging.messageID DESC";
                GVMail.Caption = "Inbox";
                GVMail.EmptyDataText = "No messages in Inbox.";
                break;
            case "trash":
                SDSMessages.SelectCommand = "SELECT messaging.messageID, messaging.messageSubject, messaging.messageDate, messaging.messageStatus, accounts.accountUsername, accounts.accountFirstName, accounts.accountLastName FROM messaging INNER JOIN accounts ON messaging.accountID = accounts.accountID WHERE (messaging.messageStatus = '1') AND (messaging.messageRecipentID = '" + Session["id"] + "') ORDER BY messaging.messageID DESC";
                GVMail.Caption = "Trash";
                GVMail.EmptyDataText = "No messages in Trash.";
                break;
            case "sent":
                SDSMessages.SelectCommand = "SELECT messaging.messageID, messaging.messageSubject, messaging.messageDate, messaging.messageStatus, accounts.accountUsername, accounts.accountFirstName, accounts.accountLastName FROM messaging INNER JOIN accounts ON messaging.accountID = accounts.accountID WHERE (messaging.accountID = '" + Session["id"] + "') ORDER BY messaging.messageID DESC";
                GVMail.Caption = "Sent";
                GVMail.EmptyDataText = "No messages in Sent.";
                break;
        }
    }

    protected void SDSMessages_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {

    }
    protected void GVInbox_SelectedIndexChanged(object sender, EventArgs e)
    {
    }
}