using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace Aktywator
{
    class Setting
    {
        public string name;
        public string type;
        public string defaultStr;
        public string table;
        public CheckBox field;
        private Bws bws;
        public Version bcsV;
        public Version fwV;

        public Setting(string name, CheckBox field, Bws bws, Version bcsVersion, Version firmwareVersion)
        {
            this.name = name;
            this.field = field;
            this.bws = bws;
            this.bcsV = bcsVersion;
            this.fwV = firmwareVersion;
        }

        public void load(string section = null)
        {
            StringBuilder str = new StringBuilder();
            str.Append("SELECT ");
            str.Append(this.name);
            str.Append(" FROM Settings");
            if (section != null)
            {
                str.Append(" WHERE `Section` = ");
                str.Append(section);
            }
            field.Checked = false;
            string a = bws.sql.selectOne(str.ToString());
            field.Checked = a.ToUpper() == "TRUE" ? true : false;
        }

        public static string load(string name, Bws bws, StringBuilder errors, string section = null, string table = "Settings", string sectionField = "`Section`")
        {
            StringBuilder str = new StringBuilder();
            str.Append("SELECT ");
            str.Append(name);
            str.Append(" FROM ");
            str.Append(table);
            if (section != null)
            {
                str.Append(" WHERE ");
                str.Append(sectionField);
                str.Append(" = ");
                str.Append(section);
            }
            try
            {
                return bws.sql.selectOne(str.ToString());
            }
            catch (OleDbException)
            {
                if (errors.Length > 0) errors.Append(", ");
                errors.Append(name);
                return "";
            }
        }

        public void save(string section = null)
        {
            StringBuilder str = new StringBuilder();
            str.Append("UPDATE Settings SET ");
            str.Append(this.name);
            if (field.Checked) str.Append("=true");
            else str.Append("=false");
            if (section != null)
            {
                str.Append(" WHERE `Section` = ");
                str.Append(section);
            }
            bws.sql.query(str.ToString());
        }

        public static void save(string name, string value, Bws bws, StringBuilder errors, string section = null)
        {
            StringBuilder str = new StringBuilder();
            str.Append("UPDATE Settings SET ");
            str.Append(name);
            str.Append("=");
            str.Append(value);
            if (section != null)
            {
                str.Append(" WHERE `Section` = ");
                str.Append(section);
            }
            try
            {
                bws.sql.query(str.ToString());
            }
            catch (OleDbException)
            {
                if (errors.Length > 0) errors.Append(", ");
                errors.Append(name);
            }
        }

        public Setting(string name, string type)
        {
            this.name = name;
            this.type = type;
            this.defaultStr = "";
            this.table = "Settings";
        }

        public Setting(string name, string type, string defaultStr)
        {
            this.name = name;
            this.type = type;
            this.defaultStr = defaultStr;
            this.table = "Settings";
        }

        public Setting(string name, string type, string defaultStr, string table)
        {
            this.name = name;
            this.type = type;
            this.defaultStr = defaultStr;
            this.table = table;
        }

        public string getAddColumnSql()
        {
            StringBuilder str = new StringBuilder();
            str.Append("ALTER TABLE ");
            str.Append(this.table);
            str.Append(" ADD COLUMN ");
            str.Append(this.name);
            str.Append(" ");
            str.Append(this.type);
            str.Append(";");
            return str.ToString();
        }

        public string getSetDefaultSql()
        {
            StringBuilder str = new StringBuilder();
            if (defaultStr.Length > 0)
            {
                str.Append("UPDATE ");
                str.Append(this.table);
                str.Append(" SET ");
                str.Append(this.name);
                str.Append("=");
                str.Append(this.defaultStr);
                str.Append(";");
            }
            return str.ToString();
        }

        public void createField(Sql sql, bool setDefault = true)
        {
            try
            {
                sql.query(this.getAddColumnSql());
                if (setDefault)
                {
                    sql.query(this.getSetDefaultSql());
                }
            }
            catch (OleDbException)
            {
            }
        }

        public static void saveScoringType(Sql sql, int value, string section)
        {
            StringBuilder sb = new StringBuilder("UPDATE `Section` SET `ScoringType` = ");
            sb.Append(value);
            if (section != null)
            {
                sb.Append(" WHERE `ID` = ");
                sb.Append(section);
            }
            sb.Append(";");
            sql.query(sb.ToString());
        }

        public static void saveSectionGroups(Sql sql, bool value, int teamTableOffset = 0)
        {
            if (teamTableOffset == 0)
            {
                StringBuilder sb = new StringBuilder("UPDATE Tables SET `Group` = ");
                sb.Append(value ? "1" : "`Section`");
                sb.Append(";");
                sql.query(sb.ToString());
            }
            else
            {
                int group = 1;
                StringBuilder tablesQuery = new StringBuilder("SELECT `Section`, (`Table` MOD ");
                tablesQuery.Append(teamTableOffset);
                tablesQuery.Append(") FROM `Tables` GROUP BY `Section`, (`Table` MOD ");
                tablesQuery.Append(teamTableOffset);
                tablesQuery.Append(");");
                OleDbDataReader tables = sql.select(tablesQuery.ToString());
                List<string> queries = new List<string>();
                while (tables.Read())
                {
                    StringBuilder sb = new StringBuilder("UPDATE `Tables` SET `Group` = ");
                    sb.Append(group++);
                    sb.Append(" WHERE `Section` = ");
                    sb.Append(Bws.bwsNumber(tables, 0));
                    sb.Append(" AND (`Table` MOD ");
                    sb.Append(teamTableOffset);
                    sb.Append(") = ");
                    sb.Append(Bws.bwsNumber(tables, 1));
                    sb.Append(";");
                    queries.Add(sb.ToString());
                }
                foreach (string query in queries)
                {
                    sql.query(query);
                }
            }
        }
    }
}