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 Orders : System.Web.UI.Page
{
    decimal approvedOSTotal = 0;
    decimal budgetTotal = 0;
    decimal actualTotal = 0;
    decimal varianceTotal = 0;

    protected void Page_Load(object sender, EventArgs e)
    {
         if (!IsPostBack)
            {
                // Get the ProjectID from the QueryString
                int projectID = Convert.ToInt32(Request.QueryString["ProjectID"]);

                //Create dummy data
                DataTable dt = new DataTable();
                DataColumn dc = new DataColumn("Name");
                dt.Columns.Add(dc);
                DataRow dr = dt.NewRow();
                dr["Name"] = "Ivan";
                this.SqlDataSource1.SelectParameters.Add("ProjectId", "1");
                //this.SqlDataSource1.SelectParameters["ProjectId"].DefaultValue = Request.QueryString["ProjectId"];
                this.SqlDataSource1.SelectParameters["ProjectId"].DefaultValue = projectID.ToString();
                this.SqlDataSource1.SelectParameters.Add("BudgetTypeId", "1");
                this.SqlDataSource1.SelectParameters["BudgetTypeId"].DefaultValue = Request.QueryString["BudgetTypeId"];
                //GridView1.GridLines = GridLines.Vertical;

                // 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];

                // Enable/Disable controls based on role and status
                ReadWriteManager.SetBudgetDetailsPermissions(projectRow.PPStatus, form1);
            }

            //Recurses through the controls to show the naming of each individual control that is currently in the gridview

  //      Response.Write(Request.ServerVariables["LOGON_USER"] + "<br>");
  //      Response.Write("User Authenticated " + User.Identity.IsAuthenticated.ToString() + "<br>");

        String[] userNames;
        String userName;
        userNames = User.Identity.Name.Split('\\');

        ////Response.Write("validateUser " + Membership.ValidateUser(userNames[1], "<br>"));

        //if (Roles.IsUserInRole(userNames[1], "RoleAdmin"))
        //{
        //    GridView1.Visible = true;
        //    DetailsView1.Enabled = true;
        //    GridView1.Enabled = true;
        //    this.form1.Visible = true;
        //}
        //else
        //{
        //    this.form1.Visible = false;
        //    this.GridView1.Visible = false;
        //}

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

            this.SqlDataSource1.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure;
            this.SqlDataSource1.UpdateCommand = "mspBudgetUpdateByProjectID";

            //SqlDataSource2.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["cnPPDB"];
        OrderDB odb = new OrderDB();
    }


    protected void btnSearch_Click(object sender, EventArgs e)
    {
        //String sqlStr;
        //sqlStr = "SELECT [ID], [amount],[ZIP], [Description] FROM [tblZIP] where [ZIP] LIKE '%?%'";
        //GridView1.DataBind();
        //DataSet ds;
        //String strConnection;

        ////strConnection = "Data Source=(local);Initial Catalog=pubs;Integrated Security=SSPI;";
        //strConnection = "Server=abhalesha;Database=pubs;uid=sa;pwd=password123;";//Trusted_Connection=True;";

        //ds = SqlDataHelper.ExecuteDataset(strConnection, CommandType.Text, "select * from titles");

        //int i;
        //i = ds.Tables[0].Rows.Count;
        //Response.Write(i.ToString());
        
    }
    
    protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
    {
        if (e.Exception != null)
        {
            Response.Write("An error occured while entering this record.  Please verify you have entered data in the correct format.");
            e.ExceptionHandled = true;
        }
        GridView1.DataBind();
    }
    protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
    {
        GridView1.DataBind();

    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        int index = GridView1.SelectedIndex;
        int orderID;

        txtBudgetAccountId.Text = GridView1.DataKeys[index].Values[1].ToString();
        txtProjectId.Text = GridView1.DataKeys[index].Values[0].ToString();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int index = GridView1.SelectedIndex;
        if (index >= 0)
        {
            txtBudgetAccountId.Text = GridView1.DataKeys[index].Values[1].ToString();
            txtProjectId.Text = GridView1.DataKeys[index].Values[0].ToString();
        }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        int index = GridView1.SelectedIndex;
        if (index >= 0)
        {
            txtBudgetAccountId.Text = GridView1.DataKeys[index].Values[1].ToString();
            txtProjectId.Text = GridView1.DataKeys[index].Values[0].ToString();
        }
    }

    protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
        int index = GridView1.SelectedIndex;
        if (index >= 0)
        {
            txtBudgetAccountId.Text = GridView1.DataKeys[index].Values[1].ToString();
            txtProjectId.Text = GridView1.DataKeys[index].Values[0].ToString();
        }
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        bool b;
        if (e.Row.RowType == DataControlRowType.DataRow) 
        {
            try
            {            
                b = Convert.ToBoolean(DataBinder.Eval(e.Row.DataItem, "ParentWithChildren"));
                if (b == true)
                {
                    e.Row.Cells[9].Enabled = false;
                  //  e.Row.Cells[0].Text = "url";
                }

                // add to the running total variables
                if (DataBinder.Eval(e.Row.DataItem, "ApprovedBudget").ToString().Length > 0)
                    approvedOSTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "ApprovedBudget"));
                if(DataBinder.Eval(e.Row.DataItem, "Expected").ToString().Length>0)
                    budgetTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Expected"));
                if(DataBinder.Eval(e.Row.DataItem, "Actual").ToString().Length > 0)
                    actualTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Actual"));
                if(DataBinder.Eval(e.Row.DataItem, "Variance").ToString().Length > 0)
                    varianceTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Variance"));

           
                // Display integers for HR & Beneficiaries
                // Able to set to ints, but not editable
                //if (Convert.ToInt32(Request.QueryString["BudgetTypeID"]) > 2)
                //{
                //    DataRowView drv = e.Row.DataItem as DataRowView;
                //    Object ob = drv["ApprovedBudget"];
                //    if (!Convert.IsDBNull(ob))
                //    {
                //        Decimal iParsedValue = 0;
                //        if (Decimal.TryParse(ob.ToString(), out iParsedValue))
                //        {
                //            TableCell cell = e.Row.Cells[5];
                //            cell.Text = String.Format("{0:F0}", (Object)iParsedValue);
                //        }
                //    }

                //    ob = drv["Expected"];
                //    if (!Convert.IsDBNull(ob))
                //    {
                //        Decimal iParsedValue = 0;
                //        if (Decimal.TryParse(ob.ToString(), out iParsedValue))
                //        {
                //            TableCell cell = e.Row.Cells[6];
                //            cell.Text = String.Format("{0:F0}", (Object)iParsedValue);
                //        }
                //    }

                //    ob = drv["Actual"];
                //    if (!Convert.IsDBNull(ob))
                //    {
                //        Decimal iParsedValue = 0;
                //        if (Decimal.TryParse(ob.ToString(), out iParsedValue))
                //        {
                //            TableCell cell = e.Row.Cells[7];
                //            //cell.Text = String.Format("{0:#,###}", new object[] { iParsedValue });
                //            //cell.Text = String.Format("{0:F2}", new object[] { iParsedValue });
                //            cell.Text = String.Format("{0:F0}", (Object)iParsedValue);
                //        }
                //    }

                //    ob = drv["Variance"];
                //    if (!Convert.IsDBNull(ob))
                //    {
                //        Decimal iParsedValue = 0;
                //        if (Decimal.TryParse(ob.ToString(), out iParsedValue))
                //        {
                //            TableCell cell = e.Row.Cells[8];
                //            cell.Text = String.Format("{0:F0}", (Object)iParsedValue);
                //        }
                //    }
                //}
            
            
            }
            catch(Exception ex)
            {
                throw (ex);
                approvedOSTotal = approvedOSTotal;
                budgetTotal = budgetTotal;
                actualTotal = actualTotal;
                varianceTotal = varianceTotal;
            }
            if (b == true)
            {
                e.Row.Cells[9].Enabled = false;
                e.Row.Cells[9].Text = "";
                e.Row.Cells[10].Enabled = false;
                e.Row.Cells[10].Text = "";
                //e.Row.Cells[3].Text = "anchor";
            }

            // Determine if O&S details should be editable
            e.Row.Cells[5].Enabled = ReadWriteManager.GetOSBudgetEditPermissions();
        }//Determines the type of row it's a footer we will add running totals
        else if (e.Row.RowType == DataControlRowType.Footer)
        {
            //don't show totals for HR & Beneficiaries tabs
            // Hard coded, so this is bad!
            if (Convert.ToInt32(Request.QueryString["BudgetTypeID"]) < 3)
            {
                e.Row.Cells[3].Text = "Totals:";
                // for the Footer, display the running totals
                e.Row.Cells[5].Text = approvedOSTotal.ToString("c");
                e.Row.Cells[6].Text = budgetTotal.ToString("c");
                e.Row.Cells[7].Text = actualTotal.ToString("c");
                e.Row.Cells[8].Text = varianceTotal.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;
            }
        }

    }
    void RecurseControls(ControlCollection ctls)
       {
         foreach (Control ctl in ctls)
            {
               if (!ctl.HasControls())
                   Label1.Text += ctl.ClientID + " " + ctl.GetType().Name + "<br />";
             else
                 RecurseControls(ctl.Controls);
         }
     }

  protected void GridView1_RowCommand1(object sender, GridViewCommandEventArgs e)
     {
        if (e.CommandName == "EmptyInsert")
         {
            //handle insert here
            TextBox tbEmptyInsert =  GridView1.Controls[0].Controls[0].FindControl("tbEmptyInsert") as TextBox;
            Label1.Text = string.Format("You would have inserted the name : <b>{0}</b> from the emptydatatemplate",tbEmptyInsert.Text);
         }
         if (e.CommandName == "Insert")
         {
             //handle insert here
            TextBox tbInsert =  GridView1.FooterRow.FindControl("tbInsert") as TextBox;
             Label1.Text = string.Format("You would have inserted the name :  <b>{0}</b> from the footerrow", tbInsert.Text);
         }
      }



    
}