using CnasSynchronusIDAL;
using CnasSynchrousModel;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CnasSynchronusDAL
{
    public class ExcelDBService : IExcelService
    {
        public DataTable GetDataByTableName(ExcelOpenParams t, ConditionParams u)
        {
           return ExcelDAL.ReadExcelByNameToTable(
               t.StrPath,
               t.ExcelFileVersion,
               t.autoSql.ExcelViewName,
               t.autoSql.ExcelViewSql,
               u.TableName);
        }

        public Dictionary<string, DataTable> GetInstrumentData(ExcelOpenParams t)
        {
            return ExcelDAL.ReadExcelTableNameToTable(t.StrPath, t.ExcelFileVersion);
        }

        public DataTable GetInstrumentDataByDate(ExcelOpenParams t, ConditionParams u)
        {
            return ExcelDAL.ReadExcelTableNameToTableByDate(
                t.StrPath,
                t.ExcelFileVersion,
                t.autoSql.ExcelViewName,
                t.autoSql.ExcelViewSql,
                u.TableName, 
                u.DateColumn, 
                u.DateValue
                );
        }

        public DataTable GetInstrumentDataStruct(ExcelOpenParams t, ConditionParams u)
        {
            return ExcelDAL.ReadExcelTableStruct(
                t.StrPath, 
                t.ExcelFileVersion,
                t.autoSql.ExcelViewName,
                t.autoSql.ExcelViewSql,
                u.TableName);
        }
    }
}