using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace Saving.Applications.admin.w_sheet_grouppermiss_ctrl
{
    public partial class DsWin : DataSourceRepeater
    {
        public DataSet1.amsecwinsDataTable DATA { get; private set; }

        public void InitDsWin(PageWeb pw)
        {

            
            DataSet1 ds = new DataSet1(); //call object datasetที่สร้างขึ้น
            this.DATA = ds.amsecwins;
            this.EventItemChanged = "OnDsWinItemChanged";
            this.EventClicked = "OnDsWinClicked";
            this.InitDataSource(pw, Repeater2, this.DATA, "dsWin");
            this.Register();
        }
        public void RetrieveWin(string application, string user_name)
        {
            string sql = @"  SELECT AMSECWINS.WINDOW_ID, AMSECWINS.WIN_DESCRIPTION, AMSECWINS.WIN_TITLE , 
case when AMSECWINS.WINDOW_ID=
(select window_id from amsecpermiss where window_id=AMSECWINS.WINDOW_ID and save_status=1 and user_name = {1}) then 1 else 0 end as save_status,
case when AMSECWINS.WINDOW_ID=
(select window_id from amsecpermiss where window_id=AMSECWINS.WINDOW_ID and check_flag=1 and user_name = {1}) then 1 else 0 end as check_flag,
case when AMSECWINS.WINDOW_ID=
(select window_id from amsecpermiss where window_id=AMSECWINS.WINDOW_ID and apv_flag=1 and user_name = {1}) then 1 else 0 end as apv_flag

FROM AMSECWINS, AMSECWINSGROUP     
WHERE   ( AMSECWINS.GROUP_CODE = AMSECWINSGROUP.GROUP_CODE ) 
and          ( AMSECWINS.APPLICATION = AMSECWINSGROUP.APPLICATION ) 
and           ( AMSECWINS.APPLICATION = {0} ) 
and  ( AMSECWINS.USED_FLAG = 1 ) 
order by AMSECWINSGROUP.GROUP_ORDER asc,AMSECWINS.WIN_ORDER asc;";

            sql = WebUtil.SQLFormat(sql,application, user_name);
            DataTable dt = WebUtil.Query(sql);
            //ทำยังไงก็ได้ให้ได้ DataTable หรือ Xml String ที่มีข้อมูล แล้วนำมาใช้คำสั่ง ImportData
            this.ImportData(dt);
        }
    }
}