using System;
using System.Data;
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;
using System.Drawing;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string logonUserName = Utilities.GetLoggedInUserID(User.Identity.Name);

        //switch (logonUserName)
        //{
        //    case "rgulamhussein":
        //    case "rizwang":
        //    case "sherinj":
        //    case "noreenk":
        //    case "mohamedj":
        //    case "nazimp":
        //    case "malikt":
        //        break;
        //    default:
        //        Server.Transfer("sitemaintenance.html");
        //        break;
        //}

        try
        {
            // Code to check if user exists in the ASPNET database
            MembershipUser user = Membership.GetUser(logonUserName);
            if (user == null)
            {
                // User's account does not exist, or user is not permitted access
                // Redirect to accout creation page
                Response.Redirect("CreateAccount.aspx", true);
            }
            else
            {
                // Update aspnet_Users.LastActivityDate
                // contemplating because code is executed every time node is expanded

                // If user is in role "WaitingRoleAssignment", redirect to "Permision not granted yet" page
                if (Roles.IsUserInRole(logonUserName, "WaitingRoleAssignment"))
                {
                    Response.Redirect("RoleNotAssigned.aspx", true);
                }
            }
        }
        catch
        {
            //Server.Transfer("error.html");
        }
    }

    protected void Node_Populate(object sender, TreeNodeEventArgs e)
    {
        if (e.Node.ChildNodes.Count == 0)
        {
            switch (e.Node.Depth)
            {
                case 0:
                    FillPortfolios(e.Node);
                    break;
                case 1:
                    FillEventsForPortfolios(e.Node);
                    break;
            }
        }
    }

    protected void FillPortfolios(TreeNode node)
    {
        // Determine the year of the node we are filling
        string valPath = node.ValuePath;
        int ppYear = Convert.ToInt32(valPath.Split('/')[0]);
        
        bool showProjectList = false;
        bool showCreatePPNode = false;

        string sqlSelectPortfolios = "select ";
        sqlSelectPortfolios += "bp.BoardPortfolioID, ";
        sqlSelectPortfolios += "bp.BoardPortfolioName +' (' + cast(count(pd.ProjectID) as nvarchar(4)) + ')' as BoardPortfolioName ";
        sqlSelectPortfolios += "from ";
        sqlSelectPortfolios += "tluBoardPortfolio bp ";
        sqlSelectPortfolios += "inner join tblProject_Committee pc ";
        sqlSelectPortfolios += "on pc.BoardPortfolioID = bp.BoardPortfolioID ";
        sqlSelectPortfolios += "left join tblProjectDate pd ";
        sqlSelectPortfolios += "on pd.ProjectID = pc.ProjectID ";
        sqlSelectPortfolios += "where ";
        sqlSelectPortfolios += "pc.IsPrimaryOrganizerYN = 1 ";
        sqlSelectPortfolios += "and pd.ProposedProjectDate/10000 = " + ppYear + " ";

        try
        {
            // Filter the tree if user is member of a Board/Portfolio
            string boardPortfolioName = ReadWriteManager.GetUserBoardPortfolio();

            switch (boardPortfolioName)
            {
                case "AdminPlanning":
                    showCreatePPNode = true;
                    showProjectList = true;
                    break;
                case "AdminFinance":
                    showProjectList = true;
                    break;
                case "ReadOnlyFull":
                    break;
                default:
                    showCreatePPNode = true;
                    sqlSelectPortfolios += " and BoardPortfolioName in ('" + boardPortfolioName + "')";
                    break;
            }

            sqlSelectPortfolios += "group by ";
            sqlSelectPortfolios += "bp.BoardPortfolioID, ";
            sqlSelectPortfolios += "bp.BoardPortfolioName";

            string connString = ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
            SqlConnection connection = new SqlConnection(connString);
            SqlCommand command = new SqlCommand(sqlSelectPortfolios, connection);
            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataSet portfolios = new DataSet();

            adapter.Fill(portfolios);
            if (portfolios.Tables.Count > 0)
            {
                // Show Project List node if permitted
                if (showProjectList == true)
                {
                    TreeNode projectListNode = new TreeNode(ppYear + " Project List", "", "", "ProjectList.aspx?projectyear=" + ppYear, "fraBody");
                    projectListNode.ToolTip = "View list of all projects for " + ppYear;
                    node.ChildNodes.Add(projectListNode);
                }

                // Show Create PP node if permitted
                if (showCreatePPNode == true)
                {
                    TreeNode createPPNode = new TreeNode("Create New Project", "", "","createnewproject.aspx", "fraBody");
                    createPPNode.ToolTip = "Create New Project";
                    node.ChildNodes.Add(createPPNode);
                }

                if (portfolios.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow row in portfolios.Tables[0].Rows)
                    {
                        TreeNode newNode =
                            new TreeNode(row["BoardPortfolioName"].ToString(),
                            row["BoardPortfolioID"].ToString());

                        newNode.PopulateOnDemand = true;
                        newNode.SelectAction = TreeNodeSelectAction.Expand;
                        newNode.ToolTip = row["BoardPortfolioName"].ToString();
                        node.ChildNodes.Add(newNode);
                    }
                }
                else
                {
                    string noDetailsFound = "No details for " + boardPortfolioName;
                    TreeNode newNode =
                        new TreeNode(noDetailsFound);

                    newNode.ToolTip = noDetailsFound;
                    node.ChildNodes.Add(newNode);
                }

                // Show Project List node if permitted
                // Moved to top
                //if (showProjectList == true)
                //{
                //    TreeNode projectListNode = new TreeNode(ppYear + " Project List", "", "", "ProjectList.aspx?projectyear=" + ppYear, "fraBody");
                //    projectListNode.ToolTip = "View list of all projects for " + ppYear;
                //    node.ChildNodes.Add(projectListNode);
                //}
            }
        }
        catch
        {
            Server.Transfer("error.html");
        }
    }

    protected void FillEventsForPortfolios(TreeNode node)
    {
        try
        {
            string portfolioID = node.Value;

            // Determine the year of the node we are filling
            string valPath = node.ValuePath;
            int ppYear = Convert.ToInt32(valPath.Split('/')[0]);
            string connString = ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
            SqlConnection connection = new SqlConnection(connString);

            SqlCommand command =
                new SqlCommand("select p.ProjectTitle, p.ProjectID, p.COENumber, s.PPStatus From tblProject p" +
                                " inner join tblProject_Committee pc" +
                                " on pc.ProjectID = p.ProjectID" +
                                " inner join tluPPStatus s" +
                                " on s.PPStatusID = p.PPStatusID" +
                                " left join tblProjectDate pd" +
                                " on pd.ProjectID = p.ProjectID" +
                                " where pc.BoardPortfolioID = '" + portfolioID + "'" +
                                " and pc.IsPrimaryOrganizerYN = 1" +
                                " and pd.ProposedProjectDate/10000 = " + ppYear + " " +
                                " order by p.COENumber", connection);

            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataSet eventsForPortfolios = new DataSet();
            adapter.Fill(eventsForPortfolios);
            if (eventsForPortfolios.Tables.Count > 0)
            {
                foreach (DataRow row in eventsForPortfolios.Tables[0].Rows)
                {
                    TreeNode newNode = new TreeNode(row["COENumber"].ToString() + " - " + row["ProjectTitle"].ToString() + " (" + row["PPStatus"].ToString() + ")", row["ProjectID"].ToString());
                    newNode.Text = " " + newNode.Text;
                    newNode.PopulateOnDemand = false;
                    //newNode.SelectAction = TreeNodeSelectAction.None;
                    //newNode.SelectAction = TreeNodeSelectAction.Select;
                    newNode.SelectAction = TreeNodeSelectAction.Expand;
                    newNode.ToolTip = row["COENumber"].ToString() + " - " + row["ProjectTitle"].ToString() + " (" + row["PPStatus"].ToString() + ")";

                    newNode.ImageUrl = PPSUtilities.GetPPStatusImage(row["PPStatus"].ToString());

                    node.ChildNodes.Add(newNode);

                    //add 3 child nodes
                    //Project Details
                    TreeNode detailsNode = new TreeNode();
                    detailsNode.Text = " Details";
                    detailsNode.ImageUrl = "images/form.png";
                    detailsNode.NavigateUrl = "projectdetails.aspx?ProjectID=" + row["ProjectID"].ToString();
                    detailsNode.Target = "fraBody";
                    newNode.ChildNodes.Add(detailsNode);

                    //Budget Details
                    //Display to be controlled by project state
                    TreeNode budgetNode = new TreeNode();
                    budgetNode.Text = " Budget";
                    budgetNode.ImageUrl = "images/dollar2.jpg";
                    budgetNode.NavigateUrl = "tabs.aspx?ProjectID=" + row["ProjectID"].ToString();
                    budgetNode.Target = "fraBody";
                    newNode.ChildNodes.Add(budgetNode);

                    //Eval Details
                    //Display to be controlled by project state
                    TreeNode evalNode = new TreeNode();
                    evalNode.Text = " Evaluation";
                    evalNode.ImageUrl = "images/check_red.gif";
                    evalNode.NavigateUrl = "eval.aspx?ProjectID=" + row["ProjectID"].ToString();
                    evalNode.Target = "fraBody";
                    newNode.ChildNodes.Add(evalNode);
                }
            }
        }
        catch
        {
            Server.Transfer("error.html");
        }
    }
}