kreta/Kreta.DataAccessManual/TeremElerhetosegDAL.cs

using System.Collections.Generic;
using System.Data;
using Kreta.DataAccess.Interfaces;
using Kreta.DataAccessManual.Interfaces;
using Kreta.DataAccessManual.Util;
using Kreta.Enums;
using Kreta.Framework.Util;
using SDA.Kreta.Entities;

namespace Kreta.DataAccessManual
{
    internal class TeremElerhetosegDal : DataAccessBase, ITeremElerhetosegDal
    {
        public TeremElerhetosegDal(DalHandler handler) : base(handler)
        {

        }

        public TeremElerhetosegDal(DalHandler handler, GridParameters parameters) : base(handler, parameters)
        {

        }

        public ITeremElerhetoseg Get()
        {
            return TeremElerhetoseg.GiveAnInstance();
        }

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

        public void Insert(ITeremElerhetoseg dto)
        {
            var entity = dto as TeremElerhetoseg;
            entity.Insert();

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

        public void FullUpdate(ITeremElerhetoseg dto)
        {
            var entity = dto as TeremElerhetoseg;
            entity.FullUpdate();
            DalHelper.Commit();
        }

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

        public void Delete(ITeremElerhetoseg dto)
        {
            var entity = dto as TeremElerhetoseg;
            entity.Delete();

            DalHelper.Commit();
        }

        public DataSet GetTeremBerbeadasIdopontjai(int intezmenyId, int tanevId, int teremId)
        {
            var parameters = new List<CommandParameter>
            {
                new CommandParameter(nameof(teremId), teremId),
                new CommandParameter(nameof(tanevId), tanevId),
                new CommandParameter(nameof(intezmenyId), intezmenyId),
                new CommandParameter("pHetnapjaiEnumNa", HetNapjaTipusEnum.na),
                new CommandParameter("pTipusId", (int)GeneratedAdatszotarTipusEnum.HetNapjaTipus)
            };

            var command = $@"
                SELECT
                   HetnapjaiDictionary.ID
                  ,TeremElerhetoseg.ID AS TeremElerhetosegId
                  ,COALESCE(TeremElerhetoseg.C_HETNAPJA, HetnapjaiDictionary.ID) AS C_HETNAPJA
                  ,LEFT(CAST(C_KEZDETE AS time),5) AS Kezdete
                  ,LEFT(CAST(C_VEGE AS time),5) AS Vege
                FROM T_DICTIONARYITEMBASE HetnapjaiDictionary
                LEFT JOIN T_TEREMELERHETOSEG TeremElerhetoseg ON TeremElerhetoseg.C_HETNAPJA = HetnapjaiDictionary.ID
                  AND TeremElerhetoseg.TOROLT = 'F'
                  AND TeremElerhetoseg.C_TEREMID = @{nameof(teremId)}
                WHERE HetnapjaiDictionary.C_TANEVID = @{nameof(tanevId)}
                  AND HetnapjaiDictionary.C_INTEZMENYID = @{nameof(intezmenyId)}
                  AND HetnapjaiDictionary.TOROLT = 'F'
                  AND HetnapjaiDictionary.C_DICTIONARYTYPEID = :pTipusId
                  AND HetnapjaiDictionary.ID <> :pHetnapjaiEnumNa
                ORDER BY HetnapjaiDictionary.C_ORDER";

            DataSet dataSet = GetData(
                command,
                parameters,
                dictionaryItemColumns: "C_HETNAPJA");

            return dataSet;
        }
    }
}