using Kreta.DataAccess.Interfaces;
using Kreta.DataAccessManual.Interfaces;
using Kreta.DataAccessManual.Util;
using Kreta.Framework.Util;
using SDA.Kreta.Entities;

namespace Kreta.DataAccessManual
{
    internal class KKVegzettsegDal : DataAccessBase, IKKVegzettsegDal
    {
        public KKVegzettsegDal(DalHandler handler, GridParameters parameters) : base(handler, parameters) { }

        public KKVegzettsegDal(DalHandler handler) : base(handler) { }

        #region KKTanitoVezgettseg
        public IKKTanitoVezgettseg GetKKTanitoVezgettseg()
        {
            return KKTanitoVezgettseg.GiveAnInstance();
        }

        public IKKTanitoVezgettseg GetKKTanitoVezgettseg(int id)
        {
            var entity = KKTanitoVezgettseg.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

        public void FullUpdate(IKKTanitoVezgettseg dto)
        {
            var entity = dto as KKTanitoVezgettseg;
            entity.FullUpdate(true);
            FollowUp(entity);
            DalHelper.Commit();
        }

        public void Insert(IKKTanitoVezgettseg dto)
        {
            var entity = dto as KKTanitoVezgettseg;
            entity.Insert(true);
            FollowUp(entity);
            dto.ID = entity.ID;
            DalHelper.Commit();
        }

        public void DeleteKKTanitoVezgettseg(int id)
        {
            var entity = KKTanitoVezgettseg.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion

        #region KKGyogypedVegzettseg
        public IKKGyogypedVegzettseg GetKKGyogypedVegzettseg()
        {
            return KKGyogypedVegzettseg.GiveAnInstance();
        }

        public IKKGyogypedVegzettseg GetKKGyogypedVegzettseg(int id)
        {
            var entity = KKGyogypedVegzettseg.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

        public void FullUpdate(IKKGyogypedVegzettseg dto)
        {
            var entity = dto as KKGyogypedVegzettseg;
            entity.FullUpdate(true);
            FollowUp(entity);
            DalHelper.Commit();
        }

        public void Update(IKKGyogypedVegzettseg dto)
        {
            var entity = dto as KKGyogypedVegzettseg;
            entity.FullUpdate();
            FollowUp(entity);
            DalHelper.Commit();
        }

        public void Insert(IKKGyogypedVegzettseg dto)
        {
            var entity = dto as KKGyogypedVegzettseg;
            entity.Insert(true);
            FollowUp(entity);
            dto.ID = entity.ID;
            DalHelper.Commit();
        }

        public void DeleteKKGyogypedVegzettseg(int id)
        {
            var entity = KKGyogypedVegzettseg.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion

        #region KKTanarVegzettseg
        public IKKTanarVegzettseg GetKKTanarVegzettseg()
        {
            return KKTanarVegzettseg.GiveAnInstance();
        }

        public IKKTanarVegzettseg GetKKTanarVegzettseg(int id)
        {
            var entity = KKTanarVegzettseg.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

        public void FullUpdate(IKKTanarVegzettseg dto)
        {
            var entity = dto as KKTanarVegzettseg;
            entity.FullUpdate(true);
            FollowUp(entity);
            DalHelper.Commit();
        }

        public void Update(IKKTanarVegzettseg dto)
        {
            var entity = dto as KKTanarVegzettseg;
            entity.FullUpdate();
            FollowUp(entity);
            DalHelper.Commit();
        }

        public void Insert(IKKTanarVegzettseg dto)
        {
            var entity = dto as KKTanarVegzettseg;
            entity.Insert(true);
            FollowUp(entity);
            dto.ID = entity.ID;
            DalHelper.Commit();
        }

        public void DeleteKKTanarVegzettseg(int id)
        {
            var entity = KKTanarVegzettseg.GiveAnInstance();
            entity.LoadByID(id);
            entity.KKTantargyKategoria.DeleteAll();

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

        #endregion

        #region KKAMIVegzettseg
        public IKKAMIVegzettseg GetKKAMIVegzettseg()
        {
            return KKAMIVegzettseg.GiveAnInstance();
        }

        public IKKAMIVegzettseg GetKKAMIVegzettseg(int id)
        {
            var entity = KKAMIVegzettseg.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

        public void FullUpdate(IKKAMIVegzettseg dto)
        {
            var entity = dto as KKAMIVegzettseg;
            entity.FullUpdate(true);
            FollowUp(entity);
            DalHelper.Commit();
        }

        public void Update(IKKAMIVegzettseg dto)
        {
            var entity = dto as KKAMIVegzettseg;
            entity.FullUpdate();
            FollowUp(entity);
            DalHelper.Commit();
        }

        public void Insert(IKKAMIVegzettseg dto)
        {
            var entity = dto as KKAMIVegzettseg;
            entity.Insert(true);
            FollowUp(entity);
            dto.ID = entity.ID;
            DalHelper.Commit();
        }

        public void DeleteKKAMIVegzettseg(int id)
        {
            var entity = KKAMIVegzettseg.GiveAnInstance();
            entity.LoadByID(id);
            entity.KKTerulet.DeleteAll();
            entity.KKJazzZene.DeleteAll();
            entity.KKKlasszikusZene.DeleteAll();
            entity.KKNepzene.DeleteAll();
            entity.KKElektroakuZene.DeleteAll();
            entity.Delete();
            DalHelper.Commit();
        }

        #endregion

        #region KKTantargyKategoria
        public IKKTantargyKategoria GetKKTantargyKategoria()
        {
            return KKTantargyKategoria.GiveAnInstance();
        }

        public IKKTantargyKategoria GetKKTantargyKategoria(int id)
        {
            var entity = KKTantargyKategoria.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

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

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

        public void Insert(IKKTantargyKategoria dto)
        {
            var entity = dto as KKTantargyKategoria;
            entity.Insert(true);

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

        public void DeleteKKTantargyKategoria(int id)
        {
            var entity = KKTantargyKategoria.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion

        #region KKElektroakuZene
        public IKKElektroakuZene GetKKElektroakuZene()
        {
            return KKElektroakuZene.GiveAnInstance();
        }

        public IKKElektroakuZene GetKKElektroakuZene(int id)
        {
            var entity = KKElektroakuZene.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

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

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

        public void Insert(IKKElektroakuZene dto)
        {
            var entity = dto as KKElektroakuZene;
            entity.Insert(true);

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

        public void DeleteKKElektroakuZene(int id)
        {
            var entity = KKElektroakuZene.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion

        #region KKJazzZene
        public IKKJazzZene GetKKJazzZene()
        {
            return KKJazzZene.GiveAnInstance();
        }

        public IKKJazzZene GetKKJazzZene(int id)
        {
            var entity = KKJazzZene.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

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

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

        public void Insert(IKKJazzZene dto)
        {
            var entity = dto as KKJazzZene;
            entity.Insert(true);

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

        public void DeleteKKJazzZene(int id)
        {
            var entity = KKJazzZene.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion

        #region KKNepzene
        public IKKNepzene GetKKNepzene()
        {
            return KKNepzene.GiveAnInstance();
        }

        public IKKNepzene GetKKNepzene(int id)
        {
            var entity = KKNepzene.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

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

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

        public void Insert(IKKNepzene dto)
        {
            var entity = dto as KKNepzene;
            entity.Insert(true);

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

        public void DeleteKKNepzene(int id)
        {
            var entity = KKNepzene.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion

        #region KKKlasszikusZene
        public IKKKlasszikusZene GetKKKlasszikusZene()
        {
            return KKKlasszikusZene.GiveAnInstance();
        }

        public IKKKlasszikusZene GetKKKlasszikusZene(int id)
        {
            var entity = KKKlasszikusZene.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

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

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

        public void Insert(IKKKlasszikusZene dto)
        {
            var entity = dto as KKKlasszikusZene;
            entity.Insert(true);

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

        public void DeleteKKKlasszikusZene(int id)
        {
            var entity = KKKlasszikusZene.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion

        #region KKTerulet
        public IKKTerulet GetKKTerulet()
        {
            return KKTerulet.GiveAnInstance();
        }

        public IKKTerulet GetKKTerulet(int id)
        {
            var entity = KKTerulet.GiveAnInstance();
            entity.LoadByID(id);
            return entity;
        }

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

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

        public void Insert(IKKTerulet dto)
        {
            var entity = dto as KKTerulet;
            entity.Insert(true);

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

        public void DeleteKKTerulet(int id)
        {
            var entity = KKTerulet.GiveAnInstance();
            entity.LoadByID(id);

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

        #endregion
    }
}