using System.Collections.Generic;
using System.Data;
using System.Text;
using Kreta.DataAccessManual.Interfaces;
using Kreta.DataAccessManual.Util;

namespace Kreta.DataAccessManual
{
    internal class IntezmenyConfigDAL : DataAccessBase, IIntezmenyConfigDAL
    {
        public IntezmenyConfigDAL(DalHandler handler) : base(handler)
        {
        }

        public string GetIntezmenyConfig(int intezmenyId, string modulName, string configName)
        {
            var paramsList = new List<CommandParameter>();
            paramsList.Add(new CommandParameter("pModulName", modulName));
            paramsList.Add(new CommandParameter("pConfigName", configName));
            paramsList.Add(new CommandParameter("pIntezmenyId", intezmenyId));

            var command = new StringBuilder(@"
                select
                  ic.C_ERTEK as [Value]
                from
                  T_INTEZMENYCONFIG ic
                join T_CONFIGTIPUS ct on ct.ID = ic.C_CONFIGTIPUSID
                where
                  ct.C_MODUL = :pModulName and ct.C_CONFIG = :pConfigName and ct.TOROLT = 'F'
                    and ic.C_INTEZMENYID = :pIntezmenyId
            ");

            return this.GetData(command.ToString(), paramsList).Tables[0].Rows[0].Field<string>("Value");
        }
    }
}