using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using Telerik.Web.UI;
using System.Data;

namespace GestaoStocksFap
{

    public partial class ArmEstruturas : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void FillGrid()
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["GestaoStocksFap"].ConnectionString);
            con.Open();

            Label query = (Label)LoginView1.FindControl("query");


            string GetDadosTabela = query.Text;

            SqlDataAdapter busca = new SqlDataAdapter(GetDadosTabela, con);

            try
            {

                GridView GridView1 = (GridView)LoginView1.FindControl("GridView1");

                DataSet ds = new DataSet();
                busca.Fill(ds);
                con.Close();

                GridView1.DataSource = ds;
                GridView1.DataBind();

            }
            catch (Exception erro)
            {
                Response.Write(erro.Message);
            }
        }


        protected void RadButton1_Click(object sender, EventArgs e)
        {
            RadWindow RadWindow1 = new RadWindow();
            RadWindow1 = (RadWindow)LoginView1.FindControl("RadWindow1");

            string script = "function f(){$find(\\"" + RadWindow1.ClientID + "\\").show(); Sys.Application.remove_load(f);} Sys.Application.add_load(f);";
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
        }


        protected void Button1_Click(object sender, EventArgs e)
        {
            Button Button1 = (Button)LoginView1.FindControl("Button1");
            Button BtnComp = (Button)LoginView1.FindControl("BtnComp");
            Button BtnEst = (Button)LoginView1.FindControl("BtnEst");
            Button BtnPrat = (Button)LoginView1.FindControl("BtnPrat");
            Button BtnCol = (Button)LoginView1.FindControl("BtnCol");
            HiddenField h1 = (HiddenField)LoginView1.FindControl("switch");


            if (h1.Value == "On")
            {
                Button1.Text = "Adicionar estruturas";
                BtnComp.Visible = false;
                BtnEst.Visible = false;
                BtnPrat.Visible = false;
                BtnCol.Visible = false;
                h1.Value = "Off";
            }
            else
            {
                Button1.Text = "Fechar";
                BtnComp.Visible = true;
                BtnEst.Visible = true;
                BtnPrat.Visible = true;
                BtnCol.Visible = true;
                h1.Value = "On";
            }
        }

        protected void BtnEst_Click(object sender, EventArgs e)
        {
            RadWindow RadWindow2 = new RadWindow();
            RadWindow2 = (RadWindow)LoginView1.FindControl("RadWindow2");

            string script = "function f(){$find(\\"" + RadWindow2.ClientID + "\\").show(); Sys.Application.remove_load(f);} Sys.Application.add_load(f);";
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
        }

        protected void BtnPrat_Click(object sender, EventArgs e)
        {
            RadWindow RadWindow3 = new RadWindow();
            RadWindow3 = (RadWindow)LoginView1.FindControl("RadWindow3");

            string script = "function f(){$find(\\"" + RadWindow3.ClientID + "\\").show(); Sys.Application.remove_load(f);} Sys.Application.add_load(f);";
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
        }

        protected void BtnCol_Click(object sender, EventArgs e)
        {
            RadWindow RadWindow4 = new RadWindow();
            RadWindow4 = (RadWindow)LoginView1.FindControl("RadWindow4");

            string script = "function f(){$find(\\"" + RadWindow4.ClientID + "\\").show(); Sys.Application.remove_load(f);} Sys.Application.add_load(f);";
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            Label LblHeader = (Label)LoginView1.FindControl("LblHeader");
            DropDownList DropDownList1 = (DropDownList)LoginView1.FindControl("DropDownList1");
            GridView GridView1 = (GridView)LoginView1.FindControl("GridView1");

            LblHeader.Text = DropDownList1.SelectedValue;

            if (DropDownList1.SelectedValue == "Escolher")
            {
                GridView1.Visible = false;
            }

            if (DropDownList1.SelectedValue == "Compartimento")
            {
                GridView1.Visible = true;

                Label query = (Label)LoginView1.FindControl("query");
                Label ddl = (Label)LoginView1.FindControl("ddl");
                Label update = (Label)LoginView1.FindControl("update");
                Label delete = (Label)LoginView1.FindControl("delete");

                query.Text = "SELECT distinct Compartimento.CompId AS IdA, Compartimento.DesigArm, Compartimento.Descricao, Armazem.Designacao AS DesigFk FROM Compartimento,Armazem WHERE Compartimento.ArmazemId = Armazem.ArmazemId";

                ddl.Text = "SELECT distinct Armazem.ArmazemId AS Id, Armazem.Designacao FROM Armazem";

                update.Text = "UPDATE Compartimento SET DesigArm=@DesigArm, Descricao=@Descricao, ArmazemId=@DesigFk WHERE CompId=@CompId";

                FillGrid();
            }
        }

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GridView GridView1 = (GridView)LoginView1.FindControl("GridView1");
            GridView1.PageIndex = e.NewPageIndex;
            FillGrid();
        }

        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            GridView GridView1 = (GridView)LoginView1.FindControl("GridView1");
            GridView1.EditIndex = -1;
            FillGrid();
        }

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {

            if (e.Row.RowState == DataControlRowState.Edit)
            {
                DropDownList DdlFk = (DropDownList)e.Row.FindControl("DdlFk");

                //encher a droplist

                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["GestaoStocksFap"].ConnectionString);
                con.Open();

                Label ddl = (Label)LoginView1.FindControl("ddl");

                SqlDataAdapter busca = new SqlDataAdapter(ddl.Text, con);

                try
                {
                    DataTable dt = new DataTable();
                    busca.Fill(dt);
                    con.Close();

                    //DdlFk.Items.Clear();
                    DdlFk.DataSource = dt;
                    DdlFk.DataBind();

                }
                catch (Exception erro)
                {
                    Response.Write(erro.Message);
                }
            }
        }

        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {

        }

        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            GridView GridView1 = (GridView)LoginView1.FindControl("GridView1");
            GridView1.EditIndex = e.NewEditIndex;

            FillGrid();
        }

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridView GridView1 = (GridView)LoginView1.FindControl("GridView1");
            string Id = GridView1.DataKeys[e.RowIndex].Value.ToString();
            TextBox txtDesig = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDesig");
            TextBox txtDesc = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDesc");
            DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DdlFk");

            Label update = (Label)LoginView1.FindControl("update");

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["GestaoStocksFap"].ConnectionString);
            con.Open();

            string upd = update.Text;
            SqlCommand updBd = new SqlCommand(upd, con);
            updBd.Parameters.Add("@DesigArm", SqlDbType.NVarChar).Value = txtDesig.Text;
            updBd.Parameters.Add("@Descricao", SqlDbType.NVarChar).Value = txtDesc.Text;
            updBd.Parameters.Add("@DesigFk", SqlDbType.NVarChar).Value = ddl.SelectedValue;
            updBd.Parameters.Add("@CompId", SqlDbType.NVarChar).Value = Convert.ToInt32(Id);

            updBd.ExecuteNonQuery();
            con.Close();
            GridView1.EditIndex = -1;
            FillGrid();
        }

        protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
        {
            //string[] strSortExpression = ViewState["SortExpression"].ToString().Split(' ');

            //if (strSortExpression[0] == e.SortExpression)
            //{
            //    if (strSortExpression[1]=="ASC")
            //    {
            //        ViewState["SortExpression"] = e.SortExpression + " " + "DESC";
            //    }
            //    else
            //    {
            //        ViewState["SortExpression"] = e.SortExpression + " " + "ASC";
            //    }
            //}
            //else
            //{
            //    ViewState["SortExpression"] = e.SortExpression + " " + "ASC";
            //}

            //FillGrid();
        }

    }
}