using System.Collections.Generic;
using System.Data;
using System.Xml.Linq;
using Kreta.DataAccess.Interfaces;
using Kreta.DataAccessManual.Interfaces;
using Kreta.DataAccessManual.Util;
using Kreta.Framework;
using Kreta.Framework.Util;
using SDA.DataProvider;
using SDA.Kreta.Entities;

namespace Kreta.DataAccessManual
{
    internal class TanuloTanugyiAdatokDal : DataAccessBase, ITanuloTanugyiAdatokDal
    {
        public TanuloTanugyiAdatokDal(DalHandler handler, GridParameters parameters)
            : base(handler, parameters)
        {

        }

        public TanuloTanugyiAdatokDal(DalHandler handler) : base(handler)
        {

        }

        public ITanuloTanugyiAdatok Get()
        {
            return TanuloTanugyiAdatok.GiveAnInstance();
        }

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

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

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

        public void Insert(ITanuloTanugyiAdatok dto)
        {
            var entity = dto as TanuloTanugyiAdatok;
            entity.Insert(true);

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

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

            Delete(entity);
        }

        public void Delete(ITanuloTanugyiAdatok dto)
        {
            var entity = dto as TanuloTanugyiAdatok;
            entity.Delete();

            DalHelper.Commit();
        }

        public void UpdateNaplosorszamListGroup(List<int> osztalyIdList)
        {
            var xmlDoc = new XDocument(new XElement("osztalyIdList"));
            foreach (int osztalyId in osztalyIdList)
            {
                xmlDoc.Root?.Add(new XElement("osztalyId", osztalyId));
            }
            var osztalyIdListXml = xmlDoc.ToString();

            using (var sdaCommand = new SDACommand())
            {
                sdaCommand.Connection = UserContext.Instance.SDAConnection;
                sdaCommand.Transaction = UserContext.Instance.SDATransaction;
                sdaCommand.CommandType = CommandType.StoredProcedure;
                sdaCommand.CommandText = "uspUpdateNaplosorszamListGroup";

                sdaCommand.Parameters.Add("pOsztalyIdList", SDADBType.String).Value = osztalyIdListXml;

                sdaCommand.ExecuteNonQuery();

                DalHelper.Commit();
            }
        }
    }
}