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;
using DataLibrary;


namespace Saving.Applications.shrlon.w_sheetmarkconference_ctrl
{
    public partial class DsConference : DataSourceRepeater
    {
        public DataSet1.DataConfereneDataTable DATA { get; set; }
        
        public void InitDs(PageWeb pw)
        {
            css1.Visible = false;

            DataSet1 ds = new DataSet1();
            this.DATA = ds.DataConferene;
            this.InitDataSource(pw, Repeater1, this.DATA, "DsConference");
            this.EventItemChanged = "OnDsListItemChanged";
            this.Register();
        }

        public void RetrieveConference()
        {
           // String sql = @"SELECT  MBUCFPRENAME.PRENAME_DESC||MBMEMBMASTER.MEMB_NAME||'  '|| MBMEMBMASTER.MEMB_SURNAME  as memb_name ,TRIM(MBMEMBMASTER.MEMBGROUP_CODE) ||' '|| MBUCFMEMBGROUP.MEMBGROUP_DESC  as membgroup_code  ,   MBMARKCONFERENCE.CONFERENCE_DATE as conference_date  ,  MBMARKCONFERENCE.CONFERENCE_MARK as  conference_mark,  MBMARKCONFERENCE.MEMBER_NO as member_no ,  MBMARKCONFERENCE.SEQ_NO as seq_no,  MBMARKCONFERENCE.ACCOUNT_YEAR as account_year FROM MBMARKCONFERENCE ,  MBMEMBMASTER ,  MBUCFPRENAME , MBUCFMEMBGROUP  WHERE ( MBMEMBMASTER.MEMBER_NO = MBMARKCONFERENCE.MEMBER_NO (+)) and ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) and  ( MBUCFMEMBGROUP.MEMBGROUP_CODE = MBMEMBMASTER.MEMBGROUP_CODE ) and  ( ( MBMARKCONFERENCE.ACCOUNT_YEAR = '2559' ) and ( MBMARKCONFERENCE.SEQ_NO = 1 ) and ( MBMARKCONFERENCE.CONFERENCE_DATE = to_date('27122016','dd/mm/yyyy') ) and   ( MBMEMBMASTER.MEMBGROUP_CODE like '%%'  )  and MBMARKCONFERENCE.member_no  like '%%' ) ";
           // sql = WebUtil.SQLFormat(sql);
           // DataTable dt = WebUtil.Query(sql);
           // this.ImportData(dt);

            //Sdt dt = WebUtil.QuerySdt(sql);

        }

        protected void Search_Click(object sender, EventArgs e)
        {
            string account_year = year_text.Text;
            string conference_date = date_text.Text;// +" " + "00:00:00.00";
           // string conference_date = date.("dd/MM/") + account_year.ToString;
            //DateTime conference_date = Convert.ToDateTime(date_txt.ToString());
            string seq_no = seq_no_txt.Text;
            //string seq_no2 = Convert.ToInt32(seq_no_txt.Text);
            string membgroup_code = membgroup_code_txt.Text;
            string member_no = member_no_txt.Text;

            String sql = @"SELECT  MBUCFPRENAME.PRENAME_DESC||MBMEMBMASTER.MEMB_NAME||'  '|| MBMEMBMASTER.MEMB_SURNAME  as memb_name "
            +",TRIM(MBMEMBMASTER.MEMBGROUP_CODE) ||' '|| MBUCFMEMBGROUP.MEMBGROUP_DESC  as membgroup_code "
            + ", TO_CHAR(MBMARKCONFERENCE.CONFERENCE_DATE,'dd/mm/yyyy','NLS_CALENDAR=''THAI BUDDHA'' NLS_DATE_LANGUAGE=THAI') as conference_date  "
            +", MBMARKCONFERENCE.CONFERENCE_MARK as  conference_mark"
            +", MBMARKCONFERENCE.MEMBER_NO as member_no "
            +", MBMARKCONFERENCE.SEQ_NO as seq_no"
            +", MBMARKCONFERENCE.ACCOUNT_YEAR as account_year FROM MBMARKCONFERENCE "
            +", MBMEMBMASTER "
            +", MBUCFPRENAME "
            +", MBUCFMEMBGROUP " 
            +"WHERE ( MBMEMBMASTER.MEMBER_NO = MBMARKCONFERENCE.MEMBER_NO (+)) and ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE )" 
            +"and  ( MBUCFMEMBGROUP.MEMBGROUP_CODE = MBMEMBMASTER.MEMBGROUP_CODE ) and  ( ( MBMARKCONFERENCE.ACCOUNT_YEAR = '"+account_year+"' )" 
            +"and ( MBMARKCONFERENCE.SEQ_NO = '"+seq_no+"' ) "
            + "and ( MBMARKCONFERENCE.CONFERENCE_DATE = to_date('" + conference_date + "','dd/mm/yyyy','NLS_CALENDAR=''THAI BUDDHA'' NLS_DATE_LANGUAGE=THAI') ) "
            +"and   ( MBMEMBMASTER.MEMBGROUP_CODE like '%"+membgroup_code+"%'  )  "
            +"and MBMARKCONFERENCE.member_no  like '%"+member_no+"%' ) ";
            sql = WebUtil.SQLFormat(sql);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
            date_text.Text = Convert.ToString(conference_date);
            year_text.Text = account_year;
            seq_no_txt.Text = seq_no;
            membgroup_code_txt.Text = membgroup_code;
            member_no_txt.Text = member_no;

        }
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }
}