using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using CMS.CMSHelper;
using CMS.UIControls;
using CMS.TreeEngine;
using CMS.IDataConnectionLibrary;
using CMS.GlobalHelper;

/// <summary>
/// News Page.
/// Author: Tom Miller.
/// </summary>
public partial class CMSTemplates_BringOnRetirement_NewsPage : TemplatePage
{
    protected void Page_Load(object sender, EventArgs e)
    {

        if (CMSContext.CurrentDocument.DocumentName != "News")
        {
            int thisDocumentID = CMS.CMSHelper.CMSContext.CurrentDocument.DocumentID;
            string nextDocumentAliasPath = string.Empty;
            nextDocumentAliasPath = NextDocumentAliasPath(thisDocumentID);
            if (!(string.IsNullOrEmpty(nextDocumentAliasPath)))
            {
                buttonNext.Visible = true;
                ViewState["NextDocumentAliasPath"] = nextDocumentAliasPath;
            }
            string previousDocumentAliasPath = string.Empty;
            previousDocumentAliasPath = PreviousDocumentAliasPath(thisDocumentID);
            if (!(string.IsNullOrEmpty(previousDocumentAliasPath)))
            {
                buttonPrevious.Visible = true;
                ViewState["PreviousDocumentAliasPath"] = previousDocumentAliasPath;
            }
        }
        else
        {
            buttonNext.Visible = false;
            buttonPrevious.Visible = false;
        }

        buttonNext.Click += new EventHandler(buttonNext_Click);
        buttonPrevious.Click += new EventHandler(buttonPrevious_Click);
    }

    protected void buttonNext_Click(object sender, EventArgs e)
    {
        string nextDocumentAliasPath = ViewState["NextDocumentAliasPath"].ToString();
        if (!(String.IsNullOrEmpty(nextDocumentAliasPath)))
        {
            Response.Redirect("~" + nextDocumentAliasPath + ".aspx");
        }
    }

    protected void buttonPrevious_Click(object sender, EventArgs e)
    {
        string previousDocumentAliasPath = ViewState["PreviousDocumentAliasPath"].ToString();
        if (!(String.IsNullOrEmpty(previousDocumentAliasPath)))
        {
            Response.Redirect("~" + previousDocumentAliasPath + ".aspx");
        }
    }

    private string NextDocumentAliasPath(int documentId)
    {
        TreeProvider provider = new TreeProvider();
        DataSet ds = provider.Connection.ExecuteQuery
            (string.Format("select top 1 * from View_CONTENT_news_Joined where DocumentID<{0} order by documentid desc",
            ValidationHelper.GetInteger(documentId, 0)), 
            null, QueryTypeEnum.SQLQuery, 
            false);

        if (ds.Tables[0].Rows.Count > 0)
        {
            string nextDocumentAliasPath = ds.Tables[0].Rows[0]["NodeAliasPath"].ToString();
            return nextDocumentAliasPath;
        }
        return string.Empty;
    }

    private static string PreviousDocumentAliasPath(int documentId)
    {
        TreeProvider provider = new TreeProvider();
        DataSet ds = provider.Connection.ExecuteQuery
            (string.Format("select top 1 * from View_CONTENT_news_Joined where DocumentID>{0} order by documentid",
            ValidationHelper.GetInteger(documentId, 0)),
            null, QueryTypeEnum.SQLQuery,
            false);

        if (ds.Tables[0].Rows.Count > 0)
        {
            string previousDocumentAliasPath = ds.Tables[0].Rows[0]["NodeAliasPath"].ToString();
            return previousDocumentAliasPath;
        }
        return string.Empty;
    }
}