using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Reflection;
using System.Windows.Forms;

namespace SHARP_CLAS_UI.Screen
{
    public partial class Form_Parameter_Alarm_Setting : Form
    {
        Form_Frame _Parent;

        public System.Net.IPAddress _DBip = System.Net.IPAddress.Parse("127.0.0.1");
        public string _DBid = "sa";
        public string _DBPassword = "1234";

        List<AlarmInfo> AlarmList = new List<AlarmInfo>();

        List<Alarm> alarms = new List<Alarm>();
        List<int> defferentList = new List<int>();
        public Form_Parameter_Alarm_Setting(Form_Frame _Parent)
        {
            InitializeComponent();
            this._Parent = _Parent;

            Init_DataGridView1();
        }
        
        public void Set_Language()
        {
            try
            {
                if (dgv_Alarm_list != null)
                {
                    //dgv_Alarm_list.Columns[0].HeaderText = resLanguage.Code;
                    dgv_Alarm_list.Columns[1].HeaderText = resLanguage.DESCRIPTION;
                    //dgv_Alarm_list.Columns[2].HeaderText = resLanguage.Heavy;
                    //dgv_Alarm_list.Columns[3].HeaderText = resLanguage.Light;
                    dgv_Alarm_list.Columns[4].HeaderText = resLanguage.USE;
                }
            }
            catch(Exception ex)
            {

            }
        }

        public void Init_DataGridView()
        {
            string connection_str = $"Server = {_DBip}; uid = {_DBid}; pwd = {_DBPassword}; database = SHARP_CLAS";
            using (SqlConnection sqlcon = new SqlConnection(connection_str))
            {
                try
                {
                    sqlcon.Open();

                    SqlCommand scom = new SqlCommand();
                    scom.Connection = sqlcon;

                    scom.CommandText = "Select * from Alarm";

                    AlarmList.Clear();

                    using (SqlDataReader sdr = scom.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            AlarmList.Add(new AlarmInfo((int)sdr["Code"], (string)sdr["Name"], (string)sdr["Description"], (bool)sdr["Heavy"], (bool)sdr["Unused"]));
                        }
                        sdr.Close();
                    }

                    dgv_Alarm_list.DataSource = AlarmList;

                    int i = 0;
                    foreach (DataGridViewColumn dgvc in dgv_Alarm_list.Columns)
                    {
                        if (i == 0)
                            dgvc.Width = 100;
                        else if (i == 1)
                            dgvc.Width = 300;
                        else if (i == 2)
                            dgvc.Width = 1030;
                        else if (i == 3)
                            dgvc.Width = 100;
                        else if (i == 4)
                            dgvc.Width = 100;
                        else if (i == 5)
                            dgvc.Width = 100;

                        i++;
                    }

                    foreach (DataGridViewColumn column in dgv_Alarm_list.Columns)
                    {
                        column.SortMode = DataGridViewColumnSortMode.NotSortable;
                    }
                }
                catch (Exception ex)
                {
                    dgv_Alarm_list.DataSource = AlarmList;

                    int i = 0;
                    foreach (DataGridViewColumn dgvc in dgv_Alarm_list.Columns)
                    {
                        if (i == 0)
                            dgvc.Width = 100;
                        else if (i == 1)
                            dgvc.Width = 300;
                        else if (i == 2)
                            dgvc.Width = 1030;
                        else if (i == 3)
                            dgvc.Width = 100;
                        else if (i == 4)
                            dgvc.Width = 100;
                        else if (i == 5)
                            dgvc.Width = 100;

                        i++;
                    }

                    foreach (DataGridViewColumn column in dgv_Alarm_list.Columns)
                    {
                        column.SortMode = DataGridViewColumnSortMode.NotSortable;
                    }

                    Console.WriteLine(ex.Message);
                }
                finally
                {
                    sqlcon.Close();
                }
            }
        }

        public void Init_DataGridView1()
        {
            try
            {
                //Datagridview Double Buffer 사용.
                Type dgvType = dgv_Alarm_list.GetType();
                PropertyInfo pi = dgvType.GetProperty("DoubleBuffered",
                      BindingFlags.Instance | BindingFlags.NonPublic);
                pi.SetValue(dgv_Alarm_list, true, null);
                //================================

                alarms.Clear();
                List<Alarm> alarm_datas = new List<Alarm>(Alarm_Manager.Instance.Clone().Values);
                foreach (Alarm alarm in alarm_datas)
                {
                    alarms.Add(alarm);
                }

                dgv_Alarm_list.DataSource = alarms;

                int i = 0;
                foreach (DataGridViewColumn dgvc in dgv_Alarm_list.Columns)
                {
                    if (i == 0)
                        dgvc.Width = 500;
                    else if (i == 1)
                        dgvc.Width = 930;
                    else if (i == 2)
                        dgvc.Width = 100;
                    else if (i == 3)
                        dgvc.Width = 100;
                    else if (i == 4)
                        dgvc.Width = 100;

                    i++;
                }

                foreach (DataGridViewColumn column in dgv_Alarm_list.Columns)
                {
                    column.SortMode = DataGridViewColumnSortMode.NotSortable;
                }
            }
            catch (Exception ex)
            {
                dgv_Alarm_list.DataSource = alarms;

                int i = 0;
                foreach (DataGridViewColumn dgvc in dgv_Alarm_list.Columns)
                {
                    if (i == 0)
                        dgvc.Width = 500;
                    else if (i == 1)
                        dgvc.Width = 930;
                    else if (i == 2)
                        dgvc.Width = 100;
                    else if (i == 3)
                        dgvc.Width = 100;
                    else if (i == 4)
                        dgvc.Width = 100;

                    i++;
                }

                foreach (DataGridViewColumn column in dgv_Alarm_list.Columns)
                {
                    column.SortMode = DataGridViewColumnSortMode.NotSortable;
                }

                Console.WriteLine(ex.Message);
            }
        }

        private void dgv_Alarm_list_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            switch (e.ColumnIndex)
            {
                case 1:
                    {
                        break;
                    }
                case 2:
                    {
                        alarms[e.RowIndex].Set_Heavy(!alarms[e.RowIndex].Heavy);
                        break;
                    }
                case 3:
                    {
                        alarms[e.RowIndex].Set_Light(!alarms[e.RowIndex].Light);
                        break;
                    }
                case 4:
                    {
                        alarms[e.RowIndex].Set_Use(!alarms[e.RowIndex].Use);
                        break;
                    }
            }

            if (!alarms[e.RowIndex].Equal(Alarm_Manager.Instance.Alarm_List[alarms[e.RowIndex].Code]))
            {
                dgv_Alarm_list.Rows[e.RowIndex].DefaultCellStyle.BackColor = System.Drawing.Color.Red;
                if(!defferentList.Contains(e.RowIndex))
                    defferentList.Add(e.RowIndex);
            }
            else
            {
                dgv_Alarm_list.Rows[e.RowIndex].DefaultCellStyle.BackColor = System.Drawing.Color.Empty;
                defferentList.Remove(e.RowIndex);
            }

            dgv_Alarm_list.Refresh();
        }

        private void btn_Save_Click(object sender, EventArgs e)
        {
            DateTime dt = DateTime.Now;

            foreach(Alarm alarm in alarms)
            {
                if(!Alarm_Manager.Instance.Alarm_List[alarm.Code].Equal(alarm))
                {
                    Alarm_Manager.Instance.Alarm_List[alarm.Code] = alarm.Clone();
                }
            }

            Alarm_Manager.Instance.Save_Alarm_List();
            
            dgv_Alarm_list_Refresh();

            TimeSpan ts = DateTime.Now - dt;
        }

        private void btn_Reset_Click(object sender, EventArgs e)
        {
            foreach (int defferent in defferentList)
            {
                if(!alarms[defferent].Equal(Alarm_Manager.Instance.Alarm_List[alarms[defferent].Code]))
                {
                    alarms[defferent] = Alarm_Manager.Instance.Alarm_List[alarms[defferent].Code].Clone();
                    dgv_Alarm_list.Rows[defferent].DefaultCellStyle.BackColor = System.Drawing.Color.Empty;
                }
            }
            
            dgv_Alarm_list_Refresh();
        }

        private void dgv_Alarm_list_Refresh()
        {
            if (dgv_Alarm_list.FirstDisplayedCell == null) return;
            int rowindex = dgv_Alarm_list.FirstDisplayedCell.RowIndex;
            int code = (int)dgv_Alarm_list.SelectedRows[0].Cells[0].Value;

            foreach (int defferent in defferentList)
            {
                if (!alarms[defferent].Equal(Alarm_Manager.Instance.Alarm_List[alarms[defferent].Code]))
                {
                    dgv_Alarm_list.Rows[defferent].DefaultCellStyle.BackColor = System.Drawing.Color.Red;
                }
                else
                {
                    dgv_Alarm_list.Rows[defferent].DefaultCellStyle.BackColor = System.Drawing.Color.Empty;
                }
            }

            defferentList.Clear();
            DateTime dt = DateTime.Now;
            dgv_Alarm_list.Refresh();

            TimeSpan ts = (DateTime.Now - dt);
            dgv_Alarm_list.Rows[code].Selected = true;
            dgv_Alarm_list.FirstDisplayedScrollingRowIndex = rowindex;
        }
    }
}