using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace CoreSavingLibrary
{
    public class ReportUtil
    {
        public static string Spliter1 = ";";
        public static string Spliter2 = "!";
        public static string GT = ">";
        public static string LT = "<";

        /// <summary>
        /// คืนค่า depttype แบบ aray 0 = min 1 = max
        /// </summary>
        /// <returns></returns>
        public static string[] GetMinMaxDepttype()
        {
            DataTable dt = WebUtil.Query("select min(depttype_code) as min, max(depttype_code) as max from dpdepttype ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxLoantype()
        {
            DataTable dt = WebUtil.Query("select min(loantype_code) as min, max(loantype_code) as max from lnloantype ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxMembgroup()
        {
            DataTable dt = WebUtil.Query("select min(membgroup_code) as min, max(membgroup_code) as max from mbucfmembgroup ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxMembgroupCoopid(string coop_id)
        {
            DataTable dt = WebUtil.Query("select min(membgroup_code) as min, max(membgroup_code) as max from mbucfmembgroup where coop_id ='" + coop_id + "' and membgroup_level =2");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxRappaytype()
        {
            DataTable dt = WebUtil.Query("select min(recppaytype_code) as min, max(recppaytype_code) as max from dpucfrecppaytype ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxUsertype()
        {
            DataTable dt = WebUtil.Query("select min(user_name) as min, max(user_name) as max from amsecusers ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }
        public static string[] GetMinMaxMembgroupCtrl()
        {
            DataTable dt = WebUtil.Query("select min(membgroup_control) as min, max(membgroup_control) as max from mbucfmembgroup ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }
        public static string[] GetMinMaxMembno()
        {
            DataTable dt = WebUtil.Query("select min(member_no) as min, max(member_no) as max from mbmembmaster ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxMembsubgroup()
        {
            DataTable dt = WebUtil.Query("select min(subgroup_code) as min, max(subgroup_code) as max from mbucfmbsubgroup ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static DateTime[] GetAdtmBeginYear(string start_date)
        {
            DataTable dt = WebUtil.Query("select max(Accstart_Date) as max_begin from cmaccountyear where Accstart_Date <= to_date('" + start_date + "','dd/mm/yyyy')");
            if (dt.Rows.Count > 0)
            {
                return new DateTime[1] { Convert.ToDateTime(dt.Rows[0][0]) };

            }
            else { return null; }
        }

        public static string[] GetMinMaxMembloanobjective()
        {
            DataTable dt = WebUtil.Query("select min(loanobjective_code) as min, max(loanobjective_code) as max from lnucfloanobjective ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxMembentryid()
        {
            DataTable dt = WebUtil.Query("select min(user_name) as min, max(user_name) as max from amsecusers ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        //mai 
        public static string[] GetMinMaxAgentSeqno()
        {
            DataTable dt = WebUtil.Query("select min(agentrequest_no) as min, max(agentrequest_no) as max from agmembagent ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        //mai 
        public static string[] GetMinMaxAccountId()
        {
            DataTable dt = WebUtil.Query("select min(account_id) as min, max(account_id) as max from accmaster ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        //mai 
        public static string[] GetMinMaxEmpType()
        {
            DataTable dt = WebUtil.Query("select min(emp_type) as min, max(emp_type) as max from mbucfemployee ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }

        public static string[] GetMinMaxMembType()
        {
            DataTable dt = WebUtil.Query("select min(membtype_code) as min, max(membtype_code) as max from mbucfmembtype ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }
        //SCHL
        public static string[] GetMinMaxLevelClass()
        {
            DataTable dt = WebUtil.Query("select min(level_code) as min, max(level_code) as max from mbucflevelschool ");
            if (dt.Rows.Count > 0)
            {
                return new string[2] { Convert.ToString(dt.Rows[0][0]), Convert.ToString(dt.Rows[0][1]) };
            }
            else { return null; }
        }
    }
}