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;

public partial class Admin_StartGroup : System.Web.UI.Page
{
    DBAccess.DBAccess ClSqlCmd;
    public void Page_Load(object sender, EventArgs e)
    {
        
        

        ClSqlCmd = new DBAccess.DBAccess(System.Configuration.ConfigurationSettings.AppSettings["SE_ConnectionString"]);
        
        ///////////////////////////////////////////////////////////////////////////


        if (!Page.IsPostBack)
        {
            Load_Groups();
            GetData();
        }
    }

    void Load_Groups()
    {
        DataSet DS = ClSqlCmd.DataSetSel(@"
                                SELECT     
                                    Group_ID, 
                                    GroupName 
                                FROM  dbo.__StandardEngine_T_Groups
                                where 
                                    Active=1 
                                     and [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]+@"
                                Order by 
                                    [Order] asc");

        ddl_Start_Group_ID.DataSource = DS;
        ddl_Start_Group_ID.DataTextField = "GroupName";
        ddl_Start_Group_ID.DataValueField = "Group_ID";

        ddl_Start_Group_ID.DataBind();
    }

    void GetData()
    {
        DataSet DS = ClSqlCmd.DataSetSel(@"
                                SELECT 
                                       [ModuleStyle_ID]
                                      ,[Start_Group_ID]
                                FROM [dbo].[__StandardEngine_T_ModuleStyles]
                                where 
                                    [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]);

        if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
        {
            if (DS.Tables[0].Rows[0]["Start_Group_ID"] != Convert.DBNull)
            {
                ddl_Start_Group_ID.SelectedValue = DS.Tables[0].Rows[0]["Start_Group_ID"].ToString();
                /////////////////////////
                lbl_msg_NoData.Visible=false;
            }
            else
            {
                lbl_msg_NoData.Visible=true;
            }
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        DataSet DS = ClSqlCmd.DataSetSel(@"
                                SELECT 
                                       [ModuleStyle_ID]
                                FROM [dbo].[__StandardEngine_T_ModuleStyles]
                                where 
                                    [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]);

        if (DS.Tables.Count < 0 || DS.Tables[0].Rows.Count <= 0)
        {
            #region Insert New ModuleStyles
            ClSqlCmd.CommandExc(@"
                                    Insert into [dbo].[__StandardEngine_T_ModuleStyles]
                                        (   
                                            [ModuleStyle_ID]
                                            ,[Module_ID]
                                        )
                                    values 
                                        (
                                            dbo.__StandardEngine_F_MaxID_ModuleStyles()+1
                                            ," + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"] + @"
                                        )");
            #endregion
        }
        else
        {
        }

        #region Variables
        string str_Start_Group_ID;
        #endregion


        #region update current ModuleStyles

        str_Start_Group_ID=ddl_Start_Group_ID.SelectedValue;
        ClSqlCmd.CommandExc(@"
                                update [dbo].[__StandardEngine_T_ModuleStyles]
                                set 
                                       [Start_Group_ID]=" + str_Start_Group_ID + @" 
                                where 
                                    [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]);
        #endregion



        ///////////////////////////////////////////////////////////////////////
        if (Request.Params["retP"] != null && Request.Params["retP"] != "")
        {
            Response.Redirect(Server.UrlDecode(Request.Params["retP"]));
        }
    }
}