using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.Data.SqlClient;
using System.Xml;
using System.Net;

public partial class ProjectDetails : System.Web.UI.Page{
    protected void Page_Load(object sender, EventArgs e)
    {
        //currTimeStampLabel.Text = "Today is " + Utilities.GetFormattedDateTime();

        // TEMPORARY
        //coeRefNumTextBox.Text = "10000";

        //Add client side Javascript to refresh tree control when page is submitted
        Page.ClientScript.RegisterOnSubmitStatement(this.GetType(), "RefreshTree", "top.fraTree.document.location.reload();");

        if (!Page.IsPostBack)
        {
            // Get Windows ID of user
            string logonUserName = Utilities.GetLoggedInUserID(User.Identity.Name);

            //lblHeader.Text = "You are logged in as " + logonUserName;

            // Check if user is an authorized user of the system 
            MembershipUser user = Membership.GetUser(logonUserName);

            if (user != null)
            {
                if (Roles.IsUserInRole(logonUserName, "AdminFinance") || Roles.IsUserInRole(logonUserName, "ReadOnlyFull") || Roles.IsUserInRole(logonUserName, "WaitingRoleAssignment"))
                {
                    // Their account exists but not in role "AdminPlanning" or a Board/Portfolio, so redirect to homepage
                    //Response.Redirect("Default.html", true);
                    Server.Transfer("accessdenied.html", true);
                }
                else
                {

                    #region Populate Combos
                    //ASP.NET 2.0
                    SqlDataSource ds = new SqlDataSource();
                    ds.ConnectionString = ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
                    ds.DataSourceMode = SqlDataSourceMode.DataSet;

                    // Populate drop-downs
                    Utilities.populateCombo(ds, proposalStatusDropDown, "mspPPStatusGetAll", "PPStatusID", "PPStatus");

                    // Select the second item, which is "Pre-event Details", since "New" is not used
                    proposalStatusDropDown.SelectedIndex = 2;

                    Utilities.populateCombo(ds, categoryDropDown, "mspEventCategoryGetAll", "EventCategoryID", "EventCategory");
                    Utilities.populateCombo(ds, startHourDropDown, "mspHourGetAll", "HourID", "HourValue");
                    Utilities.populateCombo(ds, startMinuteDropDown, "mspMinuteGetAll", "MinuteID", "MinuteValue");
                    Utilities.populateCombo(ds, endHourDropDown, "mspHourGetAll", "HourID", "HourValue");
                    Utilities.populateCombo(ds, endMinuteDropDown, "mspMinuteGetAll", "MinuteID", "MinuteValue");
                    Utilities.populateCombo(ds, jkNameDropDown, "mspJKGetAll", "JKID", "JKName");
                    Utilities.populateCombo(ds, boardPortfolioDropDown, "mspBoardPortfolio", "BoardPortfolioID", "BoardPortfolioName");
                    Utilities.populateList(ds, keyPartnerListBox, "mspBoardPortfolio", "BoardPortfolioID", "BoardPortfolioName");
                    Utilities.populateCombo(ds, PrimaryTargetDropDown, "mspTargetSegmentGetAll", "TargetSegmentID", "TargetSegmentName");
                    Utilities.populateList(ds, SecondaryTargetListBox, "mspTargetSegmentGetAll", "TargetSegmentID", "TargetSegmentName");

                    startHourDropDown.Items.Remove("Select One");
                    startMinuteDropDown.Items.Remove("Select One");
                    endHourDropDown.Items.Remove("Select One");
                    endMinuteDropDown.Items.Remove("Select One");

                    jkNameDropDown.Items.Remove("Select One");
                    jkNameDropDown.Items.Insert(0, "Venue is not a JK");

                    #endregion

                    #region Set up calendar control
                    // Set up special dates
                    eventDateCalendar.AddSpecialDate(-1, 7, 11, "Immamat Day");
                    eventDateCalendar.AddSpecialDate(-1, 3, 21, "Navroz");
                    eventDateCalendar.AddSpecialDate(-1, 12, 13, "Shah Karim's B'day");

                    //To add dates programatically, do so in a loop
                    //eventDateCalendar.AddSpecialDate(Convert.ToDateTime(dateVenueRow.ProposedProjectDate.ToString()), projectRow.ProjectTitle);

                    // Set up calendar behavior
                    eventDateCalendar.DatePickerMode = true;

                    //These are set by ReadWriteManager.cs
                    //eventDateCalendar.AllowDeselect = true;
                    //eventDateCalendar.OnClientDateChanged = "onDateChange";
                    //eventDateCalendar.TextBoxId = proposedDateTextBox.ID;

                    eventDateCalendar.DateFormat = "MMM dd yyyy";

                    // Set Min date to today's date. GetFormattedDate() returns today's date in format MMM DD, YYYY
                    //eventDateCalendar.DateMin = Convert.ToDateTime(Utilities.GetFormattedDate());

                    // Set Min date to date specified in Web.config variable "MinCalendarDate"
                    eventDateCalendar.DateMin = Convert.ToDateTime(ConfigurationManager.AppSettings["MinCalendarDate"]);

                    // Set Max date to date specified in Web.config variable "MaxCalendarDate"
                    eventDateCalendar.DateMax = Convert.ToDateTime(ConfigurationManager.AppSettings["MaxCalendarDate"]);

                    eventDateCalendar.TitleText = "Today is " + DateTime.Now.ToString("dddd MMMM dd, yyyy") + " ";
                    eventDateCalendar.ShowYearSelector = false;
                    #endregion

                    #region Set up other controls

                    if (Roles.IsUserInRole(logonUserName, "AdminPlanning"))
                    {
                        sendEmailNotifCheckBox.Enabled = true;

                        // Remove statuses that don't make sense during PP creation
                        RemovePPStatus();
                        RemovePPStatus("Pre-event Review");
                    }
                    else //if (Roles.IsUserInRole(logonUserName, "ChairBoardPortfolio"))
                    {
                        // Remove statuses that don't make sense during PP creation
                        RemovePPStatus();
                        RemovePPStatus("Pre-event Review");

                        // Remove statuses that this role is not allowed to select
                        RemovePPStatus("New");
                        RemovePPStatus("Event Implementation");

                        // Set up board/portfolio of logged on user
                        SetBPDropDown(logonUserName);
                    }

                    // Finish setting proposalStatusDropDown
                    proposalStatusDropDown.Items.Remove("Select One");

                    // Set "Created By" label
                    CreatedByValueLabel.Text = logonUserName;

                    // Set the focus on the Project Title textbox
                    projectTitleTextBox.Focus();
                    #endregion
                }
            }
            else
            {
                // Their account doesn't exists, so redirect to homepage, which will redirect to "request access" page
                Response.Redirect("Default.html", true);
            }
        }
    }

    protected void RemovePPStatus()
    {
        for (int x = proposalStatusDropDown.Items.Count - 1; x > 4; x--)
        {
            proposalStatusDropDown.Items.RemoveAt(x);
        }
    }

    protected void RemovePPStatus(string PPStatus)
    {
        string ppItemStr;
        for (int x = proposalStatusDropDown.Items.Count - 1; x > 0; x--)
        {
            ListItem ppItem = proposalStatusDropDown.Items[x];
            ppItemStr = ppItem.ToString();

            if (ppItemStr == PPStatus)
            {
                proposalStatusDropDown.Items.RemoveAt(x);
            }
        }
    }

    protected void SetBPDropDown(string logonUserName)
    {
        string boardPortfolioName = "";
        string[] rolesArray;
        rolesArray = Roles.GetRolesForUser(logonUserName);

        if (rolesArray.Length >= 1)
        {
            ArrayList boardPortfolioNameArrayList = new ArrayList();
            foreach (string str in rolesArray)
            {
                if (str != "ChairBoardPortfolio")
                {
                    boardPortfolioName = ReadWriteManager.GetUserBoardPortfolio(str);
                    //Response.Write("<br>User in role: " + boardPortfolioName);
                    boardPortfolioNameArrayList.Add(boardPortfolioName);
                }
            }

            bool keepItem;
            bool matchFound = false;
            string bpItemStr;
            for (int x = boardPortfolioDropDown.Items.Count - 1; x > 0; x--)
            {
                ListItem bpItem = boardPortfolioDropDown.Items[x];
                //Response.Write("<br>" + bpItem.ToString());
                bpItemStr = bpItem.ToString();
                keepItem = false;
                foreach (string bpName in boardPortfolioNameArrayList)
                {
                    //Response.Write("<br>" + bpName);
                    if ((bpItemStr == bpName) && (keepItem == false))
                    //if ((String.Compare(@bpItemStr, @bpName, true) == 0) && (keepItem == false))
                    {
                        keepItem = true;
                        matchFound = true;
                    }
                }

                if (keepItem == false)
                {
                    //Response.Write("<br>" + bpItemStr);

                    // Method "Remove" does NOT work for items bounded from DB. Use method "RemoveAt" instead
                    //boardPortfolioDropDown.Items.Remove(bpItemStr);
                    boardPortfolioDropDown.Items.RemoveAt(x);
                }
            }

            //if (matchFound == true)
            //{
            //    Response.Write("<br><br>Match found.");
            //}
            //else
            //{
            //    Response.Write("<br><br>Match NOT found.");
            //}

            // If they belong to only one board, set it for them
            // Need to check for 2 items b/c first item is "Select One"
            if (boardPortfolioDropDown.Items.Count == 2)
            {
                boardPortfolioDropDown.Items.Remove("Select One");
                boardPortfolioDropDown.Items.FindByText(boardPortfolioName.ToString()).Selected = true;
            }
        }
    }

    protected void createProjectButton_Click(object sender, EventArgs e)
    {
        Page.Validate("eventDetails");

        bool result;
        string successFailureMsg;

        // Get project details from form
        string coeRefNum = "";
        int ppStatusID;
        result = Int32.TryParse(proposalStatusDropDown.SelectedValue, out ppStatusID);
        string ppStatus = proposalStatusDropDown.SelectedItem.ToString();

        string projectTitle = projectTitleTextBox.Text;
        string projectDescription = descriptionTextBox.Text;

        int eventCategoryID;
        result = Int32.TryParse(categoryDropDown.SelectedValue, out eventCategoryID);

        DateTime proposedProjectDate;
        result = DateTime.TryParse(proposedDateTextBox.Text, out proposedProjectDate);

        DateTime proposedStartTime;
        result = DateTime.TryParse(startHourDropDown.SelectedItem + ":" + startMinuteDropDown.SelectedItem, out proposedStartTime);

        DateTime proposedEndTime;
        result = DateTime.TryParse(endHourDropDown.SelectedItem + ":" + endMinuteDropDown.SelectedItem, out proposedEndTime);

        int jkID = -1;
        result = Int32.TryParse(jkNameDropDown.SelectedValue, out jkID);

        Int16 expectedParticipants;
        result = Int16.TryParse(expectedParticipantsTextBox.Text, out expectedParticipants);

        int boardPortfolioID;
        result = Int32.TryParse(boardPortfolioDropDown.SelectedValue, out boardPortfolioID);
        string boardPortfolioName = boardPortfolioDropDown.SelectedItem.Text;

        //key partners
        string keyPartners = "";
        for (int i = 1; i <= keyPartnerListBox.Items.Count - 1; i++ )
        {
            if (keyPartnerListBox.Items[i].Selected == true)
            {
                keyPartners += keyPartnerListBox.Items[i].Value + ";";
            }
        }

        int primaryTargetSegmentID; // = Convert.ToInt32(PrimaryTargetDropDown.SelectedValue);
        result = Int32.TryParse(PrimaryTargetDropDown.SelectedValue, out primaryTargetSegmentID);

        //secondary target segments
        string secondaryTargetSegments = "";
        for (int i = 1; i <= SecondaryTargetListBox.Items.Count - 1; i++)
        {
            if (SecondaryTargetListBox.Items[i].Selected == true)
            {
                secondaryTargetSegments += SecondaryTargetListBox.Items[i].Value + ";";
            }
        }

        string projectNotes = projectNotesTextBox.Text;
        string createdBy = CreatedByValueLabel.Text;
        string modifiedBy = CreatedByValueLabel.Text;

        //create vars needed for email notification
        string startDateForEmail = proposedDateTextBox.Text;
        string startTimeForEmail = startHourDropDown.SelectedItem + ":" + startMinuteDropDown.SelectedItem;
        string endTimeForEmail = endHourDropDown.SelectedItem + ":" + endMinuteDropDown.SelectedItem;
        bool sendEmailNotif = sendEmailNotifCheckBox.Checked;

        //call method that will handle the creation of the new PP
        successFailureMsg = Project.CreateNewPP(projectTitle, coeRefNum, eventCategoryID, projectDescription,
            projectNotes, createdBy, modifiedBy, boardPortfolioID, boardPortfolioName, keyPartners,
            primaryTargetSegmentID, secondaryTargetSegments, expectedParticipants, proposedProjectDate,
            startDateForEmail, proposedStartTime, startTimeForEmail, proposedProjectDate, proposedEndTime,
            endTimeForEmail, jkID, ppStatusID, ppStatus, sendEmailNotif);

        // Display message for user
        saveResultLabel.Text = saveResultLabel2.Text = successFailureMsg + "<br>"; // top and bottom of page

        // Clear all fields
        ClearForm();

        // set the focus in the project title field
        projectTitleTextBox.Focus();
    }

    protected void clearFormButton_Click(object sender, EventArgs e)
    {
        ClearForm();
    }

    protected void ClearForm()
    {
        // clear all the fields
        projectTitleTextBox.Text = "";
        descriptionTextBox.Text = "";
        categoryDropDown.SelectedIndex = 0;

        // NOTE: Both steps below required to clear the textbox
        // clear the date textbox
        proposedDateTextBox.Text = "";

        // blank the selected date in the calendar
        DateTime proposedProjectDate;
        bool result = DateTime.TryParse("", out proposedProjectDate);
        eventDateCalendar.SelectedDate = proposedProjectDate;

        startHourDropDown.SelectedIndex = 0;
        startMinuteDropDown.SelectedIndex = 0;
        endHourDropDown.SelectedIndex = 0;
        endMinuteDropDown.SelectedIndex = 0;
        jkNameDropDown.SelectedIndex = 0;
        expectedParticipantsTextBox.Text = "";
        boardPortfolioDropDown.SelectedIndex = 0;
        keyPartnerListBox.SelectedIndex = 0;
        PrimaryTargetDropDown.SelectedIndex = 0;
        SecondaryTargetListBox.SelectedIndex = 0;
        projectNotesTextBox.Text = "";
        CreatedByValueLabel.Text = "";

        // set the focus in the project title field
        projectTitleTextBox.Focus();
    }
}