using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Proje
{

    public partial class _Default : Page
    {
        public DataTable dti;
        public void setDti(DataTable dtt)
        {
            this.dti=dtt;
        }
        public DataTable getDti()
        {
            return dti ;
        }

        protected void Page_Load(object sender, EventArgs e)
        {
           string nazwa = @User.Identity.Name;
           nazwa.Replace("INTERNAL\\","INTERNAL\\\\");
           Session.Add("nazwas",nazwa);



      // string exe =  SqlDataSource2.SelectCommand = "Select view_SQL from PSA_View WHERE ([ID] = @ID)";



           // SqlDataSource1.SelectParameters.Add("userId", userId.ToString());

           // SqlDataSource1.SelectCommand = "SELECT items.name, items.id FROM items INNER JOIN users_items ON items.id = users_items.id WHERE (users_items.user_id = @userId) ORDER BY users_items.date DESC"
        }



        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "ExecuteSQL")
            {



                string sql = e.CommandArgument.ToString();

                SqlConnection connection = new SqlConnection("Data Source=psqlwar02;Initial Catalog=PSADB;Persist Security Info=True;User ID=EccServiceUser;Password=n9t922");
                SqlCommand command = new SqlCommand(sql, connection);

                 //  command.Parameters.AddWithValue("@Parameter", someValue);
                    connection.Open();
              //      variable = (string)command.ExecuteScalar();
              //      Console.WriteLine(variable);
               //     Response.Write(variable);
                    SqlDataAdapter sda = new SqlDataAdapter(command);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                GridView2.DataSource = dt;
                    GridView2.DataBind();
             //       Session.Add("dataTable", dt);
                  setDti(dt);
                  DataSet ds = new DataSet();
                  ds.Tables.Add(dt);
                  ds.WriteXml("C:\\Users\\kswiderski\\Desktop\\proje\\proje\\pcos.xml");


            }


       }


  /*      protected void GridView2_Sorting(object sender, GridViewSortEventArgs e)
        {
           // DataTable datatable= Session["dataTable"];
          dti.DefaultView.Sort = e.SortExpression;

            GridView2.DataSource = dti;
            GridView2.DataBind();
        }
*/


        private string ConvertSortDirectionToSql(SortDirection sortDirection)
        {
            string newSortDirection = String.Empty;

            switch (sortDirection)
            {
                case SortDirection.Ascending:
                    newSortDirection = "ASC";
                    break;

                case SortDirection.Descending:
                    newSortDirection = "DESC";
                    break;
            }

            return newSortDirection;
        }

        protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
           // GridView2.PageIndex = e.NewPageIndex;
         //   Response.Write(e.NewPageIndex);
            //if (getDti() == null) { Response.Write("Gowno"); }
           // DataTable dtpaging = grid2dt();
           // Response.Write(dtpaging);
           // GridView2.DataSource = dtpaging.AsEnumerable().Skip(e.NewPageIndex * 25).Take(25);
           // GridView2.DataBind();


            DataSet ds2=new DataSet();
            ds2.ReadXml("C:\\Users\\kswiderski\\Desktop\\proje\\proje\\pcos.xml");
            DataTable dt2 = ds2.Tables[0];
            GridView2.DataSource = dt2;
            GridView2.PageIndex = e.NewPageIndex;
            GridView2.DataBind();

        }

        protected void gridView_Sorting(object sender, GridViewSortEventArgs e)
        {
            DataTable dataTable = GridView2.DataSource as DataTable;

            if (dataTable != null)
            {

                DataView dataView = new DataView();
                dataTable.DefaultView.Sort = "Preferance ASC";
                   DataTable sortedDT = dataView.ToTable();
              //  dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);

                GridView2.DataSource = dataView;
                GridView2.DataBind();
            }
        }



        protected DataTable grid2dt()
        {
            DataTable _datatable = new DataTable();
            for (int i = 0; i < GridView2.Columns.Count; i++)
            {
                _datatable.Columns.Add(GridView2.Columns[i].ToString());
            }
            foreach (GridViewRow row in GridView2.Rows)
            {
                DataRow dr = _datatable.NewRow();
                for (int j = 0; j < GridView2.Columns.Count; j++)
                {
                    if (!row.Cells[j].Text.Equals("&nbsp;"))
                        dr[GridView2.Columns[j].ToString()] = row.Cells[j].Text;
                }

                _datatable.Rows.Add(dr);
            }
            return(_datatable);
        }





    }



}