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 Gdimas;

public partial class KillSession : System.Web.UI.Page
{
    DataSet localDs;

    protected void Page_Load(object sender, EventArgs e)
    {
        localDs = new DataSet();

        if (!IsPostBack)
        {
            // daca s-a facut autentificarea
            if (Convert.ToBoolean(Session["UserConnectionStatus"]) == true)
            {
                lblDataSource.Text = Session["DataSource"].ToString().ToUpper(); ;

                using (DbAccess db = new DbAccess())
                {
                    try
                    {
                        db.Connect(Session["Username"].ToString(), Session["Password"].ToString(), Session["DataSource"].ToString());
                    }                    
                    catch
                    {
                    }

                    if (db.isConnected == true)
                    {
                        try
                        {
                            localDs = db.FillDataSet(localDs, "select * from gda_v$session", "Sessions");                                                       
                            
                            Session["dataset"] = localDs;

                            gridView.DataSource = (DataSet)Session["dataset"];                  
                            gridView.DataBind();

                        }
                        catch (Exception ex)
                        {
                            lblError.Text = ex.Message;
                        }
                        finally
                        {
                            db.Disconnect();
                            localDs.Dispose();
                        }
                    }
                }
            }
            else
                Response.Redirect("Errors.aspx");            
        }
    }
    // end Page_Load


    protected void btnCheckUncheck_Click(object sender, EventArgs e)
    {
       for (int i =  0 ; i < gridView.Rows.Count; i++)
        {
           GridViewRow row = gridView.Rows[i];
           CheckBox chkBox = ((CheckBox)row.FindControl("chkGridViewItem"));

           if (chkBox.Checked == false)
               chkBox.Checked = true;
           else
               chkBox.Checked = false;
        }    
        
    }
    // end btnCheckUncheck_Click

    protected void gridView_Sorting(object sender, GridViewSortEventArgs e)
    {
        DataView dv = new DataView();

        try
        {
            dv.Table = ((DataSet)Session["dataset"]).Tables[ 0 ];
            dv.Sort = string.Format("{0} {1}", e.SortExpression, GetSortDirection());
            gridView.DataSource = dv;
            gridView.DataBind();
        }
        catch (Exception ex)
        {
            lblError.Text = ex.Message;
        }
        finally
        {
            dv.Dispose();
        }
    }
    // end gridView_Sorting

    private string GridViewSortDirection
    {
        get { return ViewState["SortDirection"] as string ?? "ASC"; }
        set { ViewState["SortDirection"] = value; }
    }
    // end GridViewSortDirection


    private string GridViewSortExpression
    {
        get { return ViewState["SortExpression"] as string ?? string.Empty; }
        set { ViewState["SortExpression"] = value; }
    }
    // end GridViewSortDirection

    private string GetSortDirection()
    {
        switch (GridViewSortDirection)
        {
            case "ASC":
                GridViewSortDirection = "DESC";
                break;

            case "DESC":
                GridViewSortDirection = "ASC";
                break;
        }

        return GridViewSortDirection;
    }
    // end GridViewSortDirection


}

Session["dataset"] = localDs;

localDs = db.FillDataSet(localDs, "select * from gda_v$session", "Sessions");