using HMI.Core.Util;
using HMI.UI.DpUtil;
using HMI.UI.Util;
using Panuon.WPF.UI;
using Plugin.ModelManage.Entity;
using System.ComponentModel;

namespace Plugin.ModelManage
{
    /// <summary>
    /// ModalWindow.xaml 的交互逻辑
    /// </summary>
    public partial class DataModal : WindowX
    {
        public DataModal()
        {
            this.DataContext = this;
            InitializeComponent();
        }
        public ModelData Data { get; set; }

        private SqliteHelper sqliteHelper;
        private bool _isProcessing;

        protected override void OnClosing(CancelEventArgs e)
        {
            //Press Continue Button
            if (DialogResult == true)
            {
                if (_isProcessing)
                {
                    e.Cancel = true;
                    return;
                }
                var okButton = WindowXModalDialog.GetOKButton(this);
                try
                {
                    _isProcessing = true;
                    ButtonHelper.SetIsPending(okButton, true);
                    if (!ValidateForm())
                    {
                        e.Cancel = true;
                        return;
                    }

                    SaveOrUpdateData();
                }
                catch (Exception ex)
                {
                    ToastHelper.Error(this, $"Error！{ex.Message}");
                    e.Cancel = true;
                    return;
                }
                finally
                {
                    _isProcessing = false;
                    ButtonHelper.SetIsPending(okButton, false);
                }
            }
            base.OnClosing(e);
        }

        private bool ValidateModel(object value, out string err)
        {
            err = null;
            string segment = string.IsNullOrEmpty(Data.Id) ? ";" : $"AND Id != {Data.Id};";
            var sql = $"SELECT 1 FROM ModelData WHERE Model = '{value}' {segment}";
            if (sqliteHelper.HasData(sql))
            {
                err = "型号不能重复";
                return false;
            }
            return true;
        }

        private bool ValidateFixcode(object value, out string err)
        {
            err = null;
            string segment = string.IsNullOrEmpty(Data.Id) ? ";" : $"AND Id != {Data.Id};";
            var sql = $"SELECT 1 FROM ModelData WHERE Fixcode = '{value}' {segment}";
            if (sqliteHelper.HasData(sql))
            {
                err = "固定码不能重复";
                return false;
            }
            return true;
        }

        private bool ValidateForm()
        {
            bool flag = FormGroupHelper.ValidateForm(formPanel);
            if (flag)
            {
                Data.Model = TbModel.Text;
                Data.CodeLength = (int)NiCodeLength.Value;
                Data.StartIndex = (int)NiStartIndex.Value;
                //Data.Length = (int)NiLength.Value;
                Data.Fixcode = TbFixcode.Text;
            }
            return flag;
        }

        public bool? Open(ModelData data, SqliteHelper sqliteHelper)
        {
            Data = data;
            this.sqliteHelper = sqliteHelper;

            TbModel.Text = Data.Model;
            NiCodeLength.Value = Data.CodeLength;
            NiStartIndex.Value = Data.StartIndex;
            //NiLength.Value = Data.Length;
            TbFixcode.Text = Data.Fixcode;
            return this.ShowDialog();
        }

        private void SaveOrUpdateData()
        {
            if (string.IsNullOrEmpty(Data.Id))
            {
                InsertData(Data);
            }
            else
            {
                UpdateData(Data);
            }
        }

        public void InsertData(ModelData data)
        {
            var sql = $@"INSERT INTO ModelData (Model, CodeLength, StartIndex, Length, Fixcode) 
VALUES ('{data.Model}', {data.CodeLength}, {data.StartIndex}, {data.Length}, '{data.Fixcode}');";
            sqliteHelper.ExecuteSql(sql);
        }

        public void UpdateData(ModelData data)
        {
            var sql = $@"UPDATE ModelData SET Model='{data.Model}', CodeLength={data.CodeLength}, StartIndex={data.StartIndex},
Length={data.Length}, Fixcode='{data.Fixcode}' WHERE Id={data.Id}";
            sqliteHelper.ExecuteSql(sql);
        }
    }
}