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

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

public partial class Admin_Groups_Hidden : System.Web.UI.Page
{
    DBAccess.DBAccess ClSqlCmd = new DBAccess.DBAccess(System.Configuration.ConfigurationSettings.AppSettings["SE_ConnectionString"]);
    private void Page_Load(object sender, System.EventArgs e)
    {

        if (!Page.IsPostBack)
        {
            load();
        }
    }

    public void load()
    {
        DataSet DS = ClSqlCmd.DataSetSel(@" SELECT 
                                                [Group_ID]
                                                ,[GroupName]
                                            FROM [dbo].[__StandardEngine_T_Groups]
                                            where 
                                                [Active]=0 and 
                                                [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"] + @"
                                            order by 
                                                [Order] asc,
                                                [Group_ID] asc"
                                        );
        DataGrid1.DataSource = DS;
        DataGrid1.DataBind();
        #region Adding the con firm delete
        //if (this.DataGrid1.Controls.Count > 0 && this.DataGrid1.Controls[0].Controls.Count > 2)
        //{
        //    for (int i = 1; i < this.DataGrid1.Controls[0].Controls.Count - 1; i++)
        //    {
        //        LinkButton lnkB = (LinkButton)this.DataGrid1.Controls[0].Controls[i].FindControl("Linkbutton3");
        //        lnkB.Attributes["onclick"] = "javascript:return confirm('Confirm data deletion');";
        //    }
        //}
        #endregion
        if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
        {
            lbl_msg_NoCats.Visible = false;
            DataGrid1.Visible = true;
        }
        else
        {
            lbl_msg_NoCats.Visible = true;
            DataGrid1.Visible = false;
        }
    }

    protected void DataGrid1_ItemCommand1(object source, DataGridCommandEventArgs e)
    {
        switch (e.CommandName)
        {
            case "Edit":
                ClSqlCmd.CommandExc(@"
                                update [dbo].[__StandardEngine_T_Groups]
                                set 
                                    [Active]=1  
                                where 
                                    [Group_ID]=" + e.CommandArgument.ToString());
                ///////////////////////////////////////////////////////////////////
                Response.Redirect(Server.UrlDecode(Request.Params["retP"]));
                break;
            case "Delete":
//                ClSqlCmd.CommandExc(@"Delete from [dbo].[__OLHTMLE_SkeletonSite_T_Groups]
//                                     where 
//                                        [Group_ID]=" + e.CommandArgument.ToString()
//                                    );
//                load();
                break;
        }
    }
}