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

namespace CnasSynchronusDAL
{
    public class SqlServerDBService : ISqlServerService
    {
        public Dictionary<string, DataTable> GetInstrumentData(SqlServerOpenParams t)
        {
            SqlServerDAL.CreateConnection(t);
            return SqlServerDAL.GetAllTableNameAndStructure();
        }

        public DataTable GetInstrumentDataByDate(SqlServerOpenParams t, ConditionParams u)
        {
            SqlServerDAL.CreateConnection(t);
            return SqlServerDAL.GetDataByDateColumn(
                t.autoSql.SqlServerViewName,
                t.autoSql.SqlServerViewSql,
                u.TableName, 
                u.DateColumn, 
                u.DateValue);
        }

        public DataTable GetInstrumentDataStruct(SqlServerOpenParams t, ConditionParams u)
        {
            SqlServerDAL.CreateConnection(t);
            return SqlServerDAL.GetDataStruct(
                t.autoSql.SqlServerViewName,
                t.autoSql.SqlServerViewSql,
                u.TableName);
        }

        public bool TestConnect(SqlServerOpenParams t)
        {
            SqlServerDAL.CreateConnection(t);
            return SqlServerDAL.TestSQLServerLink();
        }
    }
}