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 AccessDBService: IAccessService
    {
        public Dictionary<string, DataTable> GetInstrumentData(CnasSynchrousModel.AccessOpenParams t)
        {
            return MdbDAL.ReadAccessTables(
                t.StrPath, 
                t.StrPwd,
                t.AccessVersionInfo
                );
        }
        public DataTable GetInstrumentDataByDate(CnasSynchrousModel.AccessOpenParams t, ConditionParams u)
        {
            return MdbDAL.ReadAccessTablesByDate(
                t.StrPath,
                t.StrPwd,
                u.TableName,
                u.DateColumn,
                u.DateValue,
                t.AccessVersionInfo,
                t.AccessSpecialDateFormat,
                t.autoSql.AccessViewName,
                t.autoSql.AccessViewSql
                );
        }

        public DataTable GetInstrumentDataStruct(AccessOpenParams t, ConditionParams u)
        {            
            return MdbDAL.ReadAccessTableStruct(
                t.StrPath, 
                t.StrPwd, 
                t.AccessVersionInfo,
                t.autoSql.AccessViewName,
                t.autoSql.AccessViewSql,
                u.TableName
                );
        }
    }
}