using System.Data;
using System.Linq;
using Kreta.DataAccess.Interfaces;
using Kreta.DataAccessManual.Interfaces;
using Kreta.DataAccessManual.Util;
using Kreta.Enums;
using Kreta.Framework;
using Kreta.Framework.Util;
using Kreta.Resources;
using SDA.DataProvider;
using SDA.Kreta.Entities;

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

        }

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

        }

        public IErtekelesMondatbank Get()
        {
            return ErtekelesMondatbank.GiveAnInstance();
        }

        public IErtekelesMondatbank Get(int id)
        {
            var entity = Get() as ErtekelesMondatbank;
            entity.LoadByID(id);
            return entity;
        }

        public IErtekelesMondatbankNyelv GetNyelv()
        {
            return ErtekelesMondatbankNyelv.GiveAnInstance();
        }

        public void Insert(IErtekelesMondatbank dto)
        {
            var entity = dto as ErtekelesMondatbank;
            entity.Importalt = false;
            entity.Insert(true);
            dto.ID = entity.ID;
            DalHelper.Commit();
        }

        public void FullUpdate(IErtekelesMondatbank dto)
        {
            var entity = dto as ErtekelesMondatbank;
            entity.Importalt = false;
            entity.FullUpdate(true);
            DalHelper.Commit();
        }

        public void InsertNyelv(IErtekelesMondatbankNyelv dto)
        {
            var entity = dto as ErtekelesMondatbankNyelv;
            entity.Insert(true);
            dto.ID = entity.ID;
            DalHelper.Commit();
        }

        public void FullUpdateNyelv(IErtekelesMondatbankNyelv dto)
        {
            var entity = dto as ErtekelesMondatbankNyelv;
            entity.FullUpdate(true);
            DalHelper.Commit();
        }

        public void DeleteNyelv(IErtekelesMondatbankNyelv dto)
        {
            var entity = dto as ErtekelesMondatbankNyelv;
            entity.Delete();
            DalHelper.Commit();
        }

        public void Update(IErtekelesMondatbank dto)
        {
            var entity = dto as ErtekelesMondatbank;
            entity.Importalt = false;
            entity.FullUpdate();
            DalHelper.Commit();
        }

        public void Delete(int id)
        {
            var entity = Get() as ErtekelesMondatbank;
            entity.LoadByID(id);
            entity.ErtekelesMondatbankNyelv.DeleteAll();
            entity.Importalt = false;
            entity.Delete();
            DalHelper.Commit();
        }

        public DataSet GetTanuloErtekelesMondatbankData(int? tanevId, int? tanuloErtekelesTipusId = null, int? tipusId = null, int? tantargyId = null, int? evfolyamTipusId = null)
        {
            using (var sdaCommand = new SDACommand())
            {
                sdaCommand.Connection = UserContext.Instance.SDAConnection;
                sdaCommand.Transaction = UserContext.Instance.SDATransaction;
                sdaCommand.CommandType = CommandType.StoredProcedure;
                sdaCommand.CommandText = "uspGetTanuloErtekelesMondatbankData";

                sdaCommand.Parameters.Add("pTanevId", SDADBType.Int).Value = tanevId;
                sdaCommand.Parameters.Add("pTanuloErtekelesTipusId", SDADBType.Int).Value = tanuloErtekelesTipusId;
                sdaCommand.Parameters.Add("pTipusId", SDADBType.Int).Value = tipusId;
                sdaCommand.Parameters.Add("pTantargyId", SDADBType.Int).Value = tantargyId;
                sdaCommand.Parameters.Add("pEvfolyamTipusId", SDADBType.Int).Value = evfolyamTipusId;
                sdaCommand.Parameters.Add("pEvfolyamTipusNaId", SDADBType.Int).Value = (int)EvfolyamTipusEnum.na;

                var dataSet = new DataSet();
                using (var adapter = new SDADataAdapter())
                {
                    adapter.SelectCommand = sdaCommand;
                    adapter.Fill(dataSet);
                }

                DataTable dataTable = dataSet.Tables[0];
                SetDNAME(dataTable, "TanuloErtekelesTipusId,TipusId,EvfolyamTipusId,NyelvId");
                var result = SortingAndPaging(dataTable, GridParameters);

                return result.AsDataSet();
            }
        }

        public DataSet GetTanuloErtekelesMondatbankSzuresData(int? tanevId, string evfolyamTipusIds = null, string tanuloErtekelesTipusIds = null, string tantargyTipusIdJSON = null, string rovidNev = null, string szoveg = null)
        {
            using (var sdaCommand = new SDACommand())
            {
                sdaCommand.Connection = UserContext.Instance.SDAConnection;
                sdaCommand.Transaction = UserContext.Instance.SDATransaction;
                sdaCommand.CommandType = CommandType.StoredProcedure;
                sdaCommand.CommandText = "uspGetTanuloErtekelesMondatbankSzuresData";

                sdaCommand.Parameters.Add("pTanevId", SDADBType.Int).Value = tanevId;
                sdaCommand.Parameters.Add("pEvfolyamTipusIdList", SDADBType.String).Value = evfolyamTipusIds;
                sdaCommand.Parameters.Add("pTantargyTipusIdJSON", SDADBType.String).Value = tantargyTipusIdJSON;
                sdaCommand.Parameters.Add("pTanuloErtekelesTipusIdList", SDADBType.String).Value = tanuloErtekelesTipusIds;
                sdaCommand.Parameters.Add("pRovidNev", SDADBType.String, 3).Value = rovidNev;
                sdaCommand.Parameters.Add("pSzoveg", SDADBType.String, 4000).Value = szoveg;

                var dataSet = new DataSet();
                using (var adapter = new SDADataAdapter())
                {
                    adapter.SelectCommand = sdaCommand;
                    adapter.Fill(dataSet);
                }

                DataTable dataTable = dataSet.Tables[0];
                SetDNAME(dataTable, "TanuloErtekelesTipusId,EvfolyamTipusId,TipusId");

                foreach (DataRow dataRow in dataTable.Rows.Cast<DataRow>().ToList())
                {
                    if (string.IsNullOrWhiteSpace(dataRow.Field<string>("TanuloErtekelesTipusId_DNAME")))
                    {
                        dataRow["TanuloErtekelesTipusId_DNAME"] = CommonResource.Mind;
                    }

                    if (string.IsNullOrWhiteSpace(dataRow.Field<string>("EvfolyamTipusId_DNAME")))
                    {
                        dataRow["EvfolyamTipusId_DNAME"] = CommonResource.Mind;
                    }
                }

                var result = SortingAndPaging(dataTable, GridParameters);

                return result.AsDataSet();
            }
        }
    }
}