using OTSModelSharp.DTLBase;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace OTSModelSharp
{
  public  class CFieldDB : CSQLiteDB
    {
        public CFieldDB(IDBStoreBase _conStr, CSQLiteTable _table) : base(_conStr, _table)
        {

        }
        public void SaveAField(int fieldId,System.Drawing.Point fldPos,System.Drawing.Point OTSPos)
        {
            var tableInfoPtr = GetTableInfo();

            if (tableInfoPtr == null)
            {
                return ;
            }
            var datastorePtr = GetDatastore();


            string sInsertFormat = tableInfoPtr.GetInsertCommandFormatString(true);
            string sSQLCommand;


            sSQLCommand = string.Format(sInsertFormat, fieldId, fldPos.X, fldPos.Y,OTSPos.X,OTSPos.Y);
            if (!datastorePtr.RunCommand(sSQLCommand))
            {

                return ;
            }


            return ;
        }
        public string GetSavingAFieldcmd(int fieldId, System.Drawing.Point OTSPos,System.Drawing.Point SemPos)
        {
           
            var tableInfoPtr = GetTableInfo();

            if (tableInfoPtr == null)
            {
                return "";
            }
           


            string sInsertFormat = tableInfoPtr.GetInsertCommandFormatString(true);
            string sSQLCommand;

           

            sSQLCommand = string.Format(sInsertFormat, fieldId, OTSPos.X, OTSPos.Y,SemPos.X,SemPos.Y);
         
           

            return sSQLCommand;
        }
        public KeyValuePair<string, SQLiteParameter[]> GetSavingAFieldcmdObj(int fieldId, System.Drawing.PointF OTSPos, System.Drawing.PointF SemPos)
        {

            var tableInfoPtr = GetTableInfo();

            //var datastorePtr = GetDatastore();


            var sInsertCmd = tableInfoPtr.GetInsertCommand(true);
     
            var paras = sInsertCmd.Value;
           
            paras[0].Value= fieldId;
            paras[1].Value= OTSPos.X;
            paras[2].Value= OTSPos.Y;
            paras[3].Value= SemPos.X;
            paras[4].Value= SemPos.Y;

            return new KeyValuePair<string,SQLiteParameter[]>(sInsertCmd.Key, paras.ToArray());
        }

        public void DeleteDataByFieldNo(int fieldStartNo)
        {
            string sSQLCommand;

            var datastorePtr = GetDatastore();
            sSQLCommand = "delete from Field where fieldId>="+fieldStartNo.ToString();
            if (!datastorePtr.RunCommand(sSQLCommand))
            {

                return;
            }
        }
    }
}