using System.Data;
using Kreta.Core;
using Kreta.DataAccess.Interfaces;
using Kreta.DataAccessManual.Interfaces;
using Kreta.DataAccessManual.Util;
using Kreta.Framework;
using Kreta.Framework.Util;
using SDA.Kreta.Entities;

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

        public NaploEllenorzesDAL(DalHandler handler, GridParameters parameters) : base(handler, parameters)
        {
        }

        public DataSet GetNaploEllenorzesek(int? feladatKategoriaId, int osztalyId, int? feladatEllatasiHelyId, int intezmenyId, int tanevId, int felhasznaloId)
        {
            using (SDA.DataProvider.SDACommand command = new SDA.DataProvider.SDACommand())
            {
                command.Connection = UserContext.Instance.SDAConnection;
                command.Transaction = UserContext.Instance.SDATransaction;
                command.CommandType = CommandType.StoredProcedure;

                command.CommandText = "uspGetNemMegtartottOrakSzamaPerHet";

                command.Parameters.Add("pOsztalyId", osztalyId);
                command.Parameters.Add("pIntezmenyId", intezmenyId);
                command.Parameters.Add("pTanevId", tanevId);
                command.Parameters.Add("pFelhasznaloId", felhasznaloId);
                if (feladatKategoriaId.IsEntityId())
                {
                    command.Parameters.Add("pFeladatKategoriaId", feladatKategoriaId);
                }
                if (feladatEllatasiHelyId.HasValue)
                {
                    command.Parameters.Add("pFeladatEllatasiHelyId", feladatEllatasiHelyId);
                }

                var dts = new DataSet();
                using (var adapter = new SDA.DataProvider.SDADataAdapter())
                {
                    adapter.SelectCommand = command;
                    adapter.Fill(dts);
                }

                DataTable dt = SortingAndPaging(dts.Tables[0], GridParameters);

                return dt.AsDataSet();
            }
        }

        public DataSet GetNaploEllenorzesTetelek(int? feladatKategoriaId, int osztalyId, int? feladatEllatasiHelyId, int hetSorszama, int intezmenyId, int tanevId)
        {
            using (SDA.DataProvider.SDACommand command = new SDA.DataProvider.SDACommand())
            {
                command.Connection = UserContext.Instance.SDAConnection;
                command.Transaction = UserContext.Instance.SDATransaction;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "uspGetNemMegtartottOrakSzamaByHet";

                command.Parameters.Add("pOsztalyId", osztalyId);
                command.Parameters.Add("pIntezmenyId", intezmenyId);
                command.Parameters.Add("pTanevId", tanevId);
                command.Parameters.Add("pHetSorszam", hetSorszama);
                if (feladatKategoriaId.IsEntityId())
                {
                    command.Parameters.Add("pFeladatKategoriaId", feladatKategoriaId);
                }
                if (feladatEllatasiHelyId.IsEntityId())
                {
                    command.Parameters.Add("pFeladatEllatasiHelyId", feladatEllatasiHelyId);
                }

                var dts = new DataSet();
                using (var adapter = new SDA.DataProvider.SDADataAdapter())
                {
                    adapter.SelectCommand = command;
                    adapter.Fill(dts);
                }

                SetDNAME(dts.Tables[0], "HetNapja");
                SetBoolFields(dts.Tables[0], "IsEgyediNap");

                DataTable dt = SortingAndPaging(dts.Tables[0], GridParameters);

                return dt.AsDataSet();
            }
        }

        public void FullUpdate(INaploEllenorzes dto)
        {
            var entity = dto as NaploEllenorzes;
            entity.FullUpdate(true);
            DalHelper.Commit();
        }

        public INaploEllenorzes Get()
        {
            return NaploEllenorzes.GiveAnInstance();
        }

        public INaploEllenorzes Get(int id)
        {
            var entity = NaploEllenorzes.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

        public void Insert(INaploEllenorzes dto)
        {
            var entity = dto as NaploEllenorzes;
            entity.Insert(true);

            dto.ID = entity.ID;
            DalHelper.Commit();
        }

        public void Update(INaploEllenorzes dto)
        {
            var entity = dto as NaploEllenorzes;
            entity.FullUpdate();
            DalHelper.Commit();
        }

        public void Delete(INaploEllenorzes dto)
        {
            ((NaploEllenorzes)dto).Delete();
            DalHelper.Commit();
        }

        public void Delete(int id)
        {
            var entity = NaploEllenorzes.GiveAnInstance();
            entity.LoadByID(id);

            entity.Delete();
            DalHelper.Commit();
        }
    }
}