using System.Linq;
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 KepesitesDal : DataAccessBase, IKepesitesDal
    {
        public KepesitesDal(DalHandler handler, GridParameters parameters) : base(handler, parameters)
        {
        }

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

        public void RemoveAll(IVegzettseg vegzettseg)
        {
            var entity = vegzettseg as Vegzettseg;
            entity.Kepesites.RemoveAll();
        }
        public IKepesites Get(int kepesitesTipusId, int tanevId)
        {
            return Kepesites.LoadWithFilter(string.Format(" AND TOROLT = 'F' AND C_KEPESITESTIPUSID = {0} AND C_TANEVID = {1} ", kepesitesTipusId, tanevId)).SingleOrDefault();
        }

        public void AddvegzettsegKepesites(IVegzettseg vegzettseg, IKepesites kepesites)
        {
            ((Vegzettseg)vegzettseg).Kepesites.Add((Kepesites)kepesites);
        }

    }
}