using System.Collections.Generic;
using System.Data;

namespace CapaDeNegocio
{
    public class CapaDeNegocio
    {
        public string commandText { get; set; }
        public Dictionary<string, object> dataCommand { get; set; }
        public DataTable ProcesarSolicitudes() {
            var settingClase = SettingsClase.GetInstance();
            CapaDeDatos.CapaDeDatos capaDatos = new CapaDeDatos.CapaDeDatos();
            capaDatos.Test = settingClase.Test;
            capaDatos.Remote = settingClase.Remote;
            capaDatos.commandText = commandText;
            if (dataCommand == null) dataCommand = new Dictionary<string, object>();
            capaDatos.dataCommand = dataCommand;
            var dt = capaDatos.GetDataTableCommands(); 
            
            if (commandText == "DescargarHojaCalidad")
            {
                capaDatos.commandText = commandText;
                capaDatos.dataCommand = dataCommand;
                dt = capaDatos.GetDataTableQuery();
            }
                return dt;
        }

        public DataTable GetDataTableQuery() {
            var settingClase = SettingsClase.GetInstance();
            CapaDeDatos.CapaDeDatos capaDatos = new CapaDeDatos.CapaDeDatos();
            capaDatos.Test = settingClase.Test;
            capaDatos.Remote = settingClase.Remote;
            capaDatos.commandText = commandText;
            if (dataCommand == null) dataCommand = new Dictionary<string, object>();
            capaDatos.dataCommand = dataCommand;
            return capaDatos.GetDataTableQuery();
        }


    }
}