using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using DataLibrary;

namespace CoreSavingLibrary
{
    public class MenuSubReport
    {
        private String application;
        private String groupid;
        private String reportid;
        private String reportname;
        private String criteriaobject;
        private String creatorobject;
        private String datawindowobject;
        private String reporttype;
        private String pageLink;

        public String Application
        {
            get { return application; }
            set { application = value; }
        }
        public String PageLink
        {
            get { return pageLink; }
            set { pageLink = value; }
        }
        public String GroupId
        {
            get { return groupid; }
            set { groupid = value; }
        }
        public String ReportId
        {
            get { return reportid; }
            set { reportid = value; }
        }
        public String ReportName
        {
            get { return reportname; }
            set { reportname = value; }
        }
        public String CriteriaObject
        {
            get { return criteriaobject; }
            set { criteriaobject = value; }
        }
        public String CreatorObject
        {
            get { return creatorobject; }
            set { creatorobject = value; }
        }
        public String DatawindowObject
        {
            get { return datawindowobject; }
            set { datawindowobject = value; }
        }
        public String ReportType
        {
            get { return reporttype; }
            set { reporttype = value; }
        }

        public List<MenuSubReport> GetMenuSubReport(String appl, String gid)
        {
            List<MenuSubReport> menu = new List<MenuSubReport>();
            try
            {
                string coreUrl = WebUtil.GetSavingUrlCore();
                string currUrl = WebUtil.GetSavingUrl();

                WebState state = new WebState();
                String sql = "";
                sql = @"
                    SELECT 
	                    REPORT_ID,
	                    REPORT_NAME,
	                    REPORT_CRIOBJECT,
	                    REPORT_CREOBJECT,
	                    OPEN_TYPE,
	                    CORE_FLAG
                    FROM WEBREPORTDETAIL  
                    WHERE 
	                    GROUP_ID =  {0} AND 
	                    USED_FLAG >= 1 AND 
	                    REPORT_ID in (select REPORT_ID from amsecreportpermiss where coop_id = {1} and user_name = {2} and check_flag = 1)
                    ORDER BY REPORT_ID, REPORT_NAME
                ";
                sql = WebUtil.SQLFormat(sql, gid, state.SsCoopId, state.SsUsername);
                Sdt dt = WebUtil.QuerySdt(sql);
                while (dt.Next())
                {
                    MenuSubReport m = new MenuSubReport();
                    m.CriteriaObject = dt.GetString("REPORT_CRIOBJECT");
                    int openType = 1;
                    string ireport = "";
                    try
                    {
                        if (dt.GetInt32("open_type") == 2)
                        {
                            openType = 2;
                            ireport = "IReport";
                            m.CriteriaObject += "/" + dt.GetString("REPORT_CREOBJECT");
                        }
                    }
                    catch { }

                    m.Application = state.SsApplication;
                    m.GroupId = gid;
                    m.ReportId = dt.GetString("REPORT_ID");
                    m.ReportName = dt.GetString("REPORT_NAME");
                    string afterSavingUrl = String.Format("Criteria{5}/{0}.aspx?app={1}&setApp={1}&gid={2}&rid={3}&openType={4}", m.CriteriaObject, m.Application, m.GroupId, m.ReportId, openType, ireport);
                    m.PageLink = (dt.GetInt32("core_flag") == 1 ? coreUrl : currUrl) + afterSavingUrl;
                    menu.Add(m);
                }
            }
            catch 
            {
            }
            return menu;
        }
    }
}