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.Web.Configuration;

public partial class BudgetSummary : System.Web.UI.Page
{
    decimal approvedOSTotalRevenue = 0;
    decimal budgetTotalRevenue = 0;
    decimal actualTotalRevenue = 0;
    decimal varianceTotalRevenue = 0;

    decimal approvedOSTotalExpenses = 0;
    decimal budgetTotalExpenses = 0;
    decimal actualTotalExpenses = 0;
    decimal varianceTotalExpenses = 0;

    int RevenueBudgetTypeID = 1;
    int ExpensesBudgetTypeID = 2;
    int HRBudgetTypeID = 3;
    int BeneficiariesBudgetTypeID = 4;

    string eventBoardPortfolioName;
    int matchesFound;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            //string bodyOnloadJS = "SetValOfFormCtrlWithValOfParentCtrl('projectIDHiddenParent', 'projectIDHiddenChild');";
            //HtmlGenericControl body = (HtmlGenericControl)Page.FindControl("body");
            //body.Attributes.Add("onload", bodyOnloadJS);

            // Get the ProjectID from the QueryString
            int projectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
            
            // DEBUG
            //projectID = 508;

            // Check that Project ID belongs to this Board/Portfolio
            // Determine the Board/Portfolio the user belongs to
            string userBoardPortfolioName = ReadWriteManager.GetUserBoardPortfolio();

            // Get the Board/Portfolio to which event belongs from DB
            dsProjectTableAdapters.mspProjectCommitteeGetByProjectIDTableAdapter project_committeeTableAdapter = new dsProjectTableAdapters.mspProjectCommitteeGetByProjectIDTableAdapter();
            dsProject.mspProjectCommitteeGetByProjectIDDataTable dtProjectCommittee = new dsProject.mspProjectCommitteeGetByProjectIDDataTable();
            dtProjectCommittee = project_committeeTableAdapter.GetByProjectID(projectID);
            DataTableReader dtReader = new DataTableReader(dtProjectCommittee);

            // Loop through datatable to get the primary Board/Portfolio name
            while (dtReader.Read())
            {
                // If IsPrimaryOrganizerYN = 1, grab the value
                if (dtReader["IsPrimaryOrganizerYN"].ToString() == 1.ToString())
                {
                    boardPortfolioValueLabel.Text = eventBoardPortfolioName = dtReader["BoardPortfolioName"].ToString();

                    // Concatenate the committee name if available
                    if (dtReader["CommitteeName"].ToString().Length > 0)
                    {
                        boardPortfolioValueLabel.Text = boardPortfolioValueLabel.Text.ToString() + " (" + dtReader["CommitteeName"].ToString() + ")";
                    }
                }
            }

            // Determine if user's portfolio matches event organizer portfolio
            switch (userBoardPortfolioName)
            {
                case "AdminPlanning":
                case "AdminFinance":
                case "ReadOnlyFull":
                    matchesFound = 1;
                    break;
                default:
                    matchesFound = Utilities.CharCount(userBoardPortfolioName, eventBoardPortfolioName);
                    break;
            }

            // If the Board/Portfolio name do not match, redirect to error page
            if (matchesFound == 0)
            {
                Server.Transfer("accessdenied.html", false);
            }

            // If we got here then we're doing good
            // Get project details for this project from DB
            dsProjectTableAdapters.tblProjectTableAdapter projectTableAdapter = new dsProjectTableAdapters.tblProjectTableAdapter();
            dsProject.tblProjectDataTable dtProject = new dsProject.tblProjectDataTable();
            dsProject.tblProjectRow projectRow;
            dtProject = projectTableAdapter.GetByID(projectID);

            // We have a single row of data
            projectRow = (dsProject.tblProjectRow)dtProject.Rows[0];

            // Project Details
            coeRefNumValueLabel.Text = projectRow.COENumber;

            if (!projectRow.IsGLCodeNull())
            {
                glCodeValueLabel.Text = projectRow.GLCode.ToString();
            }
            else
            {
                glCodeValueLabel.Text = "None";
            }

            proposalStatusValueLabel.Text = projectRow.PPStatus;

            projectTitleValueLabel.Text = projectRow.ProjectTitle;

            //Get date/venue/eval details from DB for this project
            setDateVenueEvalControls(projectID, null);

            //Revenue
            this.RevenueSqlDataSource.SelectParameters.Add("ProjectId", "1");
            this.RevenueSqlDataSource.SelectParameters["ProjectId"].DefaultValue = projectID.ToString();

            this.RevenueSqlDataSource.SelectParameters.Add("BudgetTypeID", "1");
            this.RevenueSqlDataSource.SelectParameters["BudgetTypeID"].DefaultValue = RevenueBudgetTypeID.ToString();
            //RevenueGridView.GridLines = GridLines.Horizontal;
            //RevenueGridView.GridLines = GridLines.Vertical;

            //Expenses
            this.ExpensesSqlDataSource.SelectParameters.Add("ProjectId", "1");
            this.ExpensesSqlDataSource.SelectParameters["ProjectId"].DefaultValue = projectID.ToString();

            this.ExpensesSqlDataSource.SelectParameters.Add("BudgetTypeID", "1");
            this.ExpensesSqlDataSource.SelectParameters["BudgetTypeID"].DefaultValue = ExpensesBudgetTypeID.ToString();
            //ExpensesGridView.GridLines = GridLines.Horizontal;
            //ExpensesGridView.GridLines = GridLines.Vertical;

            //HR
            this.HRSqlDataSource.SelectParameters.Add("ProjectId", "1");
            this.HRSqlDataSource.SelectParameters["ProjectId"].DefaultValue = projectID.ToString();

            this.HRSqlDataSource.SelectParameters.Add("BudgetTypeID", "1");
            this.HRSqlDataSource.SelectParameters["BudgetTypeID"].DefaultValue = HRBudgetTypeID.ToString();
            //HRGridView.GridLines = GridLines.Horizontal;
            //HRGridView.GridLines = GridLines.Vertical;

            //Beneficiaries
            this.BeneficiariesSqlDataSource.SelectParameters.Add("ProjectId", "1");
            this.BeneficiariesSqlDataSource.SelectParameters["ProjectId"].DefaultValue = projectID.ToString();

            this.BeneficiariesSqlDataSource.SelectParameters.Add("BudgetTypeID", "1");
            this.BeneficiariesSqlDataSource.SelectParameters["BudgetTypeID"].DefaultValue = BeneficiariesBudgetTypeID.ToString();
            //BeneficiariesGridView.GridLines = GridLines.Horizontal;
            //BeneficiariesGridView.GridLines = GridLines.Vertical;
        }


        // This approach allows you to dynamically assign connection string and sp to the SqlDataSource
        // UI also contains binding in a form
        this.RevenueSqlDataSource.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
        this.RevenueSqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
        this.RevenueSqlDataSource.SelectCommand = "mspBudgetGetByProjectID";

        this.ExpensesSqlDataSource.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
        this.ExpensesSqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
        this.ExpensesSqlDataSource.SelectCommand = "mspBudgetGetByProjectID";

        this.HRSqlDataSource.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
        this.HRSqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
        this.HRSqlDataSource.SelectCommand = "mspBudgetGetByProjectID";

        this.BeneficiariesSqlDataSource.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cnPPDB"].ToString();
        this.BeneficiariesSqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
        this.BeneficiariesSqlDataSource.SelectCommand = "mspBudgetGetByProjectID";
    }

    // Rather than overloading, chose to use int? so method accepts null for ProjectDateID
    protected void setDateVenueEvalControls(int projectID, int? ProjectDateID)
    {
        //Get date/venue details from DB for this project
        dsProjectTableAdapters.mspProjectDateGetByIDTableAdapter dateVenueAdapter = new dsProjectTableAdapters.mspProjectDateGetByIDTableAdapter();
        dsProject.mspProjectDateGetByIDDataTable dtDateVenue = new dsProject.mspProjectDateGetByIDDataTable();
        dsProject.mspProjectDateGetByIDRow dateVenueRow;
        dtDateVenue = dateVenueAdapter.GetByID(projectID, ProjectDateID);

        if (dtDateVenue.Rows.Count > 0)
        {
            dateVenueRow = (dsProject.mspProjectDateGetByIDRow)dtDateVenue.Rows[0];

            eventDateValueLabel.Visible = true;
            eventDateValueLabel.Text = dateVenueRow.ProposedProjectDate.ToString() + ", " + dateVenueRow.formattedStartTime.ToString() + " - " + dateVenueRow.formattedEndTime.ToString() + " at " + dateVenueRow.AbsoluteVenueName.ToString();

            if (dateVenueRow.IsJKIDNull())
            {
                if (!dateVenueRow.IsCityNameNull())
                {
                    eventDateValueLabel.Text = eventDateValueLabel.Text.ToString() + ", " + dateVenueRow.CityName.ToString();
                }
            }

            if (!dateVenueRow.IsProvinceAbbrevNull())
            {
                eventDateValueLabel.Text = eventDateValueLabel.Text.ToString() + ", " + dateVenueRow.ProvinceAbbrev.ToString();
            }
        }
    }
    
    protected void RevenueGridView_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow) 
        {
            try
            {
                if (DataBinder.Eval(e.Row.DataItem, "ApprovedBudget").ToString().Length > 0)
                    approvedOSTotalRevenue += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "ApprovedBudget"));
                
                if(DataBinder.Eval(e.Row.DataItem, "Expected").ToString().Length>0)
                    budgetTotalRevenue += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Expected"));
                
                if(DataBinder.Eval(e.Row.DataItem, "Actual").ToString().Length > 0)
                    actualTotalRevenue += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Actual"));
                
                if(DataBinder.Eval(e.Row.DataItem, "Variance").ToString().Length > 0)
                    varianceTotalRevenue += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Variance"));
            }
            catch(Exception ex)
            {
                throw (ex);
            }

        } //Determines the type of row it's a footer we will add running totals
        else if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[3].Text = "Totals:";
            // for the Footer, display the running totals
            e.Row.Cells[5].Text = approvedOSTotalRevenue.ToString("c");
            e.Row.Cells[6].Text = budgetTotalRevenue.ToString("c");
            e.Row.Cells[7].Text = actualTotalRevenue.ToString("c");
            e.Row.Cells[8].Text = varianceTotalRevenue.ToString("c");
            e.Row.Cells[5].HorizontalAlign = e.Row.Cells[6].HorizontalAlign = e.Row.Cells[7].HorizontalAlign = e.Row.Cells[8].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Font.Bold = true;
        }
    }

    //Expenses
    protected void ExpensesGridView_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            try
            {
                if (DataBinder.Eval(e.Row.DataItem, "ApprovedBudget").ToString().Length > 0)
                    approvedOSTotalExpenses += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "ApprovedBudget"));

                if (DataBinder.Eval(e.Row.DataItem, "Expected").ToString().Length > 0)
                    budgetTotalExpenses += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Expected"));

                if (DataBinder.Eval(e.Row.DataItem, "Actual").ToString().Length > 0)
                    actualTotalExpenses += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Actual"));

                if (DataBinder.Eval(e.Row.DataItem, "Variance").ToString().Length > 0)
                    varianceTotalExpenses += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Variance"));
            }
            catch (Exception ex)
            {
                throw (ex);
            }

        } //Determines the type of row it's a footer we will add running totals
        else if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[3].Text = "Totals:";
            // for the Footer, display the running totals
            e.Row.Cells[5].Text = approvedOSTotalExpenses.ToString("c");
            e.Row.Cells[6].Text = budgetTotalExpenses.ToString("c");
            e.Row.Cells[7].Text = actualTotalExpenses.ToString("c");
            e.Row.Cells[8].Text = varianceTotalExpenses.ToString("c");
            e.Row.Cells[5].HorizontalAlign = e.Row.Cells[6].HorizontalAlign = e.Row.Cells[7].HorizontalAlign = e.Row.Cells[8].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Font.Bold = true;
        }
    }

    protected void NetIncomeLossGridView_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //do not display the row. Using the data source of revenue to force gridview to render
            //but we are just interested in the footer to show revenue minus expenses
            e.Row.Visible = false;
        } 
        else if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[3].Text = " ";
            // for the Footer, display revenue - expenses
            e.Row.Cells[5].Text = (approvedOSTotalRevenue-approvedOSTotalExpenses).ToString("c");
            e.Row.Cells[6].Text = (budgetTotalRevenue-budgetTotalExpenses).ToString("c");
            e.Row.Cells[7].Text = (actualTotalRevenue-actualTotalExpenses).ToString("c");
            e.Row.Cells[8].Text = (varianceTotalRevenue-varianceTotalExpenses).ToString("c");
            e.Row.Cells[5].HorizontalAlign = e.Row.Cells[6].HorizontalAlign = e.Row.Cells[7].HorizontalAlign = e.Row.Cells[8].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Font.Bold = true;
        }
    }
}