using customTypes;
using HotelPms.Data.Common;
using HotelPms.Data.Common.Interface.Access;
using HotelPms.DataAccessGrpc.Client;
using HotelPms.Share.Util;
using HotelPms.Share.Windows.Component;
using HotelPms.Share.Windows.Util;
using HotelPms.WinForm.Common;
using HotelPms.WinForm.Common.Interface;
using HotelPms.WinForm.Common.Util;
using System.Data;

namespace HotelPms.WinForm.Master
{
    public partial class Demo : MasterBase, IMasterCtrl
    {
        #region  ★★★★★　Declartions　★★★★★

        private IDemo? demoAccess;

        #endregion

        #region  ★★★★★　Property　★★★★★
        #endregion

        #region  ★★★★★　Class Event　★★★★★

        public Demo(IDemo access)
        {
            InitializeComponent();
            demoAccess = access;
            MasterCtrl = this;
            dgvData.Visible = false;
        }

        private void Form_Load(object sender, EventArgs e)
        {
            Cursor = Cursors.WaitCursor;
            MasterCtrl.ShowData();
            System.Diagnostics.Debug.WriteLine(dgvData.Rows.Count);
            if (dgvData.Rows.Count == 0)
            {
                SetNewMode();
            }
            dgvData.Visible = true;
            Cursor = Cursors.Default;
        }

        #endregion

        #region  ★★★★★　Control Event　★★★★★
        #endregion

        #region  ★★★★★　Private Function　★★★★★
        #endregion

        #region  ★★★★★　Public  Function　★★★★★

        public bool Delete()
        {
            int orgIndex = dgvData.CurrentRow.Index;
            int pID = CConvert.ToInt(GetCellValue("ID"));
            if (MessageBox.Show(string.Format(DelMsg + Environment.NewLine + "ID = {0}", pID),
                Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.No) { return false; }


            //排他チェック
            if (demoAccess.GetUpdateID(pID) != CConvert.ToInt(GetCellValue("UpdateID")))
            {
                if (MessageBox.Show(LockMsg, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                {
                    MasterCtrl.ShowData(pID);
                    m_ValueChangeListener.SetUpdateFormMode(UpdateFormMode.Normal);
                }
                return false;
            }

            Data.DataResult dataResult = demoAccess.Remove($"ID = {pID}");
            if (dataResult.ErrNo != 0)
            {
                MessageBox.Show("削除に失敗しました。" + Environment.NewLine + $"{dataResult.ErrNo}.{dataResult.ErrData}", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                return false;
            }

            ShowData(orgIndex < dgvData.RowCount ? orgIndex : dgvData.RowCount - 1);
            if (dgvData.Rows.Count == 0) { SetNewMode(); }
            return true;
        }

        public bool IsCorrectEtc(object sender, bool isCheckAll, bool isShowErrMsg)
        {
            if (sender.Equals(txtID) && m_ValueChangeListener.CurUpdateMode == UpdateFormMode.Inputting)
            {
                if (demoAccess.Exists(CConvert.ToInt(txtID.Text)))
                {
                    MessageBox.Show(ExistsMsg, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    txtID.Focus();
                    return false;
                }
            }

            return true;
        }

        public bool Save()
        {
            if (m_ValueChangeListener.CurUpdateMode != UpdateFormMode.Inputting && m_ValueChangeListener.CurUpdateMode != UpdateFormMode.Edit) { return true; }

            //ソートがあるため、index正しくない
            int id = (dgvData.CurrentRow == null) ? 0 : CConvert.ToInt(GetCellValue("ID"));
            bool isNew = false;
            HotelPms.Data.Master.Demo item = null;
            UpdateFormMode orgMode = m_ValueChangeListener.CurUpdateMode;
            if (orgMode == UpdateFormMode.Edit) 
            { 
                item = demoAccess.GetItem(CConvert.ToInt(txtID.Text)); 
                
                //排他チェック
                if(item.UpdateID != CConvert.ToInt(GetCellValue("UpdateID")))
                {
                    if(MessageBox.Show(LockMsg, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
                    {
                        MasterCtrl.ShowData(id);
                        m_ValueChangeListener.SetUpdateFormMode(UpdateFormMode.Normal);
                    }
                    return false;
                }
            }
            if (item == null)
            {
                item = new HotelPms.Data.Master.Demo();
                isNew = true;
            }
            item.ID = CConvert.ToInt(txtID.Text);
            item.Name = txtName.Text;
            item.FInt = CConvert.ToInt(txtFInt.Text);
            item.FTinyInt = CConvert.ToInt(txtFTinyInt.Text);
            item.FSmallInt = CConvert.ToInt(txtFSmallInt.Text);
            item.FBit = CConvert.ToBool(txtFBit.Text);
            item.FFloat = CConvert.ToFloat(txtFFloat.Text);
            item.FDecimal = CConvert.ToDecimal(txtFDecimal.Text);
            item.FDate = new Date(CConvert.ToDateInt(txtFDate.Text));
            item.UpdateDate = CConvert.ToTimestamp(CConvert.ToDateTime(txtUpdateDate.Text));
            item.UpdateID++;
            Data.DataResult dataResult = isNew ? demoAccess.Add(item) : demoAccess.Update(item);

            MasterCtrl.ShowData(id);
            if (orgMode == UpdateFormMode.Inputting) { SetNewMode(); }
            m_ValueChangeListener.SetUpdateFormMode(orgMode == UpdateFormMode.Edit ? UpdateFormMode.Normal : UpdateFormMode.New);
            return dataResult.ErrNo == 0;
        }

        public void SetDispName(CTextBox sender)
        {
            if (sender.Equals(txtFBit))
            {
                sender.MstNameCtrl.Text = CConvert.GetEnumDescription<EVisible>(CConvert.ToInt(sender.Text));
            }
        }

        public void ShowData()
        {
            ShowData(0);
        }

        private int FindRowIndex(int id)
        {
            for (int i = 0; i < m_Data.Rows.Count; i++)
            {
                if (id == CConvert.ToInt(m_Data.Rows[i]["ID"])) { return i; }
            }
            return 0;
        }

        public void ShowData(int id)
        {
            try
            {
                m_DisableSelectionChanged = true;
                DataTable orgData = m_Data;
                string where = string.Empty;
                if (txtSearchKey.Text.Trim().Length > 0)
                {
                    where += string.Format(" A.Name LIKE '%{0}%' ", txtSearchKey.Text);
                }

                m_Data = demoAccess.GetMasterGridData(where);  //同期実行
                dgvData.DataSource = m_Data;
                SetGridColNameDict();
                SetGridStyle();
                if (dgvData.Rows.Count > 0)
                {
                    SetCellFocus(FindRowIndex(id), 0, true);
                    ShowDetail();
                }
                if (orgData != null) { orgData.Dispose(); orgData = null; }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                m_DisableSelectionChanged = false;
            }
        }

        private void SetGridStyle()
        {
            DataGridViewColumn col = null;
            col = dgvData.Columns["ID"];
            col.HeaderText = "ID";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            col = dgvData.Columns["Name"];
            col.HeaderText = "名称";
            col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            col.Width = 100;
            col = dgvData.Columns["FInt"];
            col.HeaderText = "FInt";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            col = dgvData.Columns["FTinyInt"];
            col.HeaderText = "FTinyInt";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            col = dgvData.Columns["FSmallInt"];
            col.HeaderText = "FSmallInt";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            col = dgvData.Columns["FFloat"];
            col.HeaderText = "FFloat";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            col = dgvData.Columns["FBit"];
            col.HeaderText = "FBit";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            col = dgvData.Columns["FDecimal"];
            col.HeaderText = "FDecimal";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            col = dgvData.Columns["FDate"];
            col.HeaderText = "FDate";
            col.Width = 100;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;

            col = dgvData.Columns["UpdateDate"];
            col.Visible = false;
            col = dgvData.Columns["UpdateID"];
            col.Visible = false;
        }

        public void ShowDetail()
        {
            if (dgvData.CurrentRow == null) { return; }
            tbArray.DisbleValidating = true;
            int index = dgvData.CurrentRow.Index;
            txtName.Text = CConvert.ToString(GetCellValue("Name"));
            this.ActiveControl = txtName;
            tbArray.PerformEnter(txtName, null);
            txtID.Enabled = false;
            txtID.Text = GeneralSub.ToFormText(CConvert.ToInt(GetCellValue("ID")));
            txtFInt.Text = GeneralSub.ToFormText(CConvert.ToInt(GetCellValue("FInt")));
            txtFTinyInt.Text = GeneralSub.ToFormText(CConvert.ToInt(GetCellValue("FTinyInt")));
            txtFSmallInt.Text = GeneralSub.ToFormText(CConvert.ToInt(GetCellValue("FSmallInt")));
            txtFFloat.Text = CConvert.ToFloat(GetCellValue("FFloat")).ToString();
            txtFBit.Text = CConvert.ToBool(GetCellValue("FBit")) ? "1" : "0";
            SetDispName(txtFBit);
            txtFDecimal.Text = CConvert.ToDecimal(GetCellValue("FDecimal")).ToString();
            txtFDate.Text = CConvert.ToDateString(GetCellValue("FDate"));
            txtUpdateDate.Text = GetCellValue("UpdateDate").ToString();

            m_ValueChangeListener.SetUpdateFormMode(UpdateFormMode.Normal);
            tbArray.DisbleValidating = false;
        }

        public void ShowList(CTextBox sender)
        {
            DataTable data = null;

            if (sender.Equals(txtFBit)) { data = CConvert.GetEnumTypeList<EVisible>(); }

            if (data == null) { return; }
            string ret = HotelPms.Share.Windows.Tool.DataSelector.Execute(sender, data, new Size(250, 120), string.Empty, string.Empty, null, HotelPms.Share.Windows.Tool.DataSelector.Style.HideBottom);
            if (ret.Length == 0) { return; }
            sender.Text = ret;
            tbArray.PerformKeyDown(sender, new KeyEventArgs(Keys.Enter));
        }


        #endregion
    }
}