2864 lines
130 KiB
C#
2864 lines
130 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using Kreta.Framework;
|
|
using Kreta.Framework.Collections;
|
|
using Kreta.Framework.Collections.Generic;
|
|
using Kreta.Framework.Entities;
|
|
using Kreta.Framework.Entities.Associations;
|
|
using Kreta.Framework.Entities.Generic;
|
|
|
|
namespace SDA.Kreta.Entities
|
|
{
|
|
internal sealed class TanitasiOraDBHelper : EntityDBHelper<TanitasiOra>
|
|
{
|
|
private Dictionary<string, string> dynamicColumns = new Dictionary<string, string>()
|
|
{
|
|
{ "BejegyzesIdeje", "T_TANITASIORA_OSSZES.C_BEJEGYZESIDEJE" },
|
|
{ "Bontott", "T_TANITASIORA_OSSZES.C_BONTOTT" },
|
|
{ "Datum", "T_TANITASIORA_OSSZES.C_DATUM" },
|
|
{ "HelyettesitesOka", "T_TANITASIORA_OSSZES.C_HELYETTESITESOKA" },
|
|
{ "HelyettesitesTipusa", "T_TANITASIORA_OSSZES.C_HELYETTESITESTIPUSA" },
|
|
{ "HetNapja", "T_TANITASIORA_OSSZES.C_HETNAPJA" },
|
|
{ "HetSorszama", "T_TANITASIORA_OSSZES.C_HETSORSZAMA" },
|
|
{ "IKTTanora", "T_TANITASIORA_OSSZES.C_IKTTANORA" },
|
|
{ "Megjegyzes", "T_TANITASIORA_OSSZES.C_MEGJEGYZES" },
|
|
{ "Megtartott", "T_TANITASIORA_OSSZES.C_MEGTARTOTT" },
|
|
{ "NapSorszama", "T_TANITASIORA_OSSZES.C_NAPSORSZAMA" },
|
|
{ "NemSzakrendszeruOra", "T_TANITASIORA_OSSZES.C_NEMSZAKRENDSZERUORA" },
|
|
{ "OraKezdete", "T_TANITASIORA_OSSZES.C_ORAKEZDETE" },
|
|
{ "Oraszam", "T_TANITASIORA_OSSZES.C_ORASZAM" },
|
|
{ "OraVege", "T_TANITASIORA_OSSZES.C_ORAVEGE" },
|
|
{ "Sorszamozando", "T_TANITASIORA_OSSZES.C_SORSZAMOZANDO" },
|
|
{ "TAMOPOra", "T_TANITASIORA_OSSZES.C_TAMOPORA" },
|
|
{ "Tema", "T_TANITASIORA_OSSZES.C_TEMA" },
|
|
{ "Tulora", "T_TANITASIORA_OSSZES.C_TULORA" },
|
|
{ "Osztalyfonoki", "T_TANITASIORA_OSSZES.C_OSZTALYFONOKI" },
|
|
{ "HaziFeladat", "T_TANITASIORA_OSSZES.C_HAZIFELADAT" },
|
|
{ "Differencialt", "T_TANITASIORA_OSSZES.C_DIFFERENCIALT" },
|
|
{ "Drama", "T_TANITASIORA_OSSZES.C_DRAMA" },
|
|
{ "IPRTanora", "T_TANITASIORA_OSSZES.C_IPRTANORA" },
|
|
{ "Kooperativ", "T_TANITASIORA_OSSZES.C_KOOPERATIV" },
|
|
{ "Meres", "T_TANITASIORA_OSSZES.C_MERES" },
|
|
{ "MindennaposTestneveles", "T_TANITASIORA_OSSZES.C_MINDENNAPOSTESTNEVELES" },
|
|
{ "NemzetisegiOra", "T_TANITASIORA_OSSZES.C_NEMZETISEGIORA" },
|
|
{ "ParhuzamosOra", "T_TANITASIORA_OSSZES.C_PARHUZAMOSORA" },
|
|
{ "TIOP12", "T_TANITASIORA_OSSZES.C_TIOP12" },
|
|
{ "AdminAltalKiirt", "T_TANITASIORA_OSSZES.C_ADMINALTALKIIRT" },
|
|
{ "CsengetesirendId", "T_TANITASIORA_OSSZES.C_CSENGETESIRENDID" },
|
|
{ "CsengetesirendOraId", "T_TANITASIORA_OSSZES.C_CSENGETESIRENDORAID" },
|
|
{ "OrarendiOraGroupId", "T_TANITASIORA_OSSZES.C_ORARENDIORAGROUPID" },
|
|
{ "MobilNaplozott", "T_TANITASIORA_OSSZES.C_MOBILNAPLOZOTT" },
|
|
{ "EFOP32317", "T_TANITASIORA_OSSZES.C_EFOP32317" },
|
|
{ "MultikulturalisOra", "T_TANITASIORA_OSSZES.C_MULTIKULTURALISORA" },
|
|
{ "KomplexOra", "T_TANITASIORA_OSSZES.C_KOMPLEXORA" },
|
|
{ "KIPOra", "T_TANITASIORA_OSSZES.C_KIPORA" },
|
|
{ "VEKOP73317", "T_TANITASIORA_OSSZES.C_VEKOP73317" },
|
|
{ "KAPOra", "T_TANITASIORA_OSSZES.C_KAPORA" },
|
|
{ "GINOP623", "T_TANITASIORA_OSSZES.C_GINOP623" },
|
|
{ "EFOP31716", "T_TANITASIORA_OSSZES.C_EFOP31716" },
|
|
{ "EFOP33717", "T_TANITASIORA_OSSZES.C_EFOP33717" },
|
|
{ "TIOP1111212012001", "T_TANITASIORA_OSSZES.C_TIOP1111212012001" },
|
|
{ "EgyediNap", "T_TANITASIORA_OSSZES.C_EGYEDINAP" },
|
|
{ "IsDfhtkipOra", "T_TANITASIORA_OSSZES.C_ISDFHTKIPORA" },
|
|
{ "IsDfhtOra", "T_TANITASIORA_OSSZES.C_ISDFHTORA" },
|
|
{ "IsDigitalisAlapuAlprogram", "T_TANITASIORA_OSSZES.C_ISDIGITALISALAPUALPROGRAM" },
|
|
{ "IsEletgyakorlatAlapuAlprogram", "T_TANITASIORA_OSSZES.C_ISELETGYAKORLATALAPUALPROGRA" },
|
|
{ "IsLogikaAlapuAlprogram", "T_TANITASIORA_OSSZES.C_ISLOGIKAALAPUALPROGRAM" },
|
|
{ "IsMuveszetAlapuAlprogram", "T_TANITASIORA_OSSZES.C_ISMUVESZETALAPUALPROGRAM" },
|
|
{ "IsRahangolodas", "T_TANITASIORA_OSSZES.C_ISRAHANGOLODAS" },
|
|
{ "IsTeorad", "T_TANITASIORA_OSSZES.C_ISTEORAD" },
|
|
{ "IsTestmozgasAlapuAlprogram", "T_TANITASIORA_OSSZES.C_ISTESTMOZGASALAPUALPROGRAM" },
|
|
{ "IsFelnottoktatasiSzerzodes", "T_TANITASIORA_OSSZES.C_ISFELNOTTOKTATASISZERZODES" },
|
|
{ "EFOP23517", "T_TANITASIORA_OSSZES.C_EFOP23517" },
|
|
{ "DigEszkozTipusId", "T_TANITASIORA_OSSZES.C_DIGESZKOZTIPUSID" },
|
|
{ "DigPlatformTipusId", "T_TANITASIORA_OSSZES.C_DIGPLATFORMTIPUSID" },
|
|
{ "OraEvesSorszama", "T_TANITASIORA_OSSZES.C_ORAEVESSORSZAMA" },
|
|
};
|
|
|
|
private const string dynamicQueryCommandText =
|
|
"select " +
|
|
"T_TANITASIORA_OSSZES.ID, " +
|
|
"{COLUMNS}" +
|
|
// TanitasiOra betöltése
|
|
// TanitasiOra kapcsoló mezői
|
|
"T_TANITASIORA_OSSZES.C_TANMENETID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANTARGYID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_NAPTARINAPID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_ORARENDIORAID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_FOGLALKOZASID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_HELYETTESITOTANARID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANARID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TEREMID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_OSZTALYCSOPORTID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_ORATULAJDONOSID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANULASIEGYSEGID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_INTEZMENYID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANEVID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.TOROLT, " +
|
|
"T_TANITASIORA_OSSZES.SERIAL, " +
|
|
"T_TANITASIORA_OSSZES.CREATED, " +
|
|
"T_TANITASIORA_OSSZES.CREATOR, " +
|
|
"T_TANITASIORA_OSSZES.LASTCHANGED, " +
|
|
"T_TANITASIORA_OSSZES.MODIFIER " +
|
|
"from " +
|
|
"T_TANITASIORA_OSSZES " +
|
|
"where " +
|
|
"(1 = 1) ";
|
|
|
|
private const string emptyQueryCommandText =
|
|
"select " +
|
|
"T_TANITASIORA_OSSZES.ID, " +
|
|
// TanitasiOra betöltése
|
|
// TanitasiOra mezői
|
|
"T_TANITASIORA_OSSZES.C_BEJEGYZESIDEJE, " +
|
|
"T_TANITASIORA_OSSZES.C_BONTOTT, " +
|
|
"T_TANITASIORA_OSSZES.C_DATUM, " +
|
|
"T_TANITASIORA_OSSZES.C_HELYETTESITESOKA, " +
|
|
"T_TANITASIORA_OSSZES.C_HELYETTESITESTIPUSA, " +
|
|
"T_TANITASIORA_OSSZES.C_HETNAPJA, " +
|
|
"T_TANITASIORA_OSSZES.C_HETSORSZAMA, " +
|
|
"T_TANITASIORA_OSSZES.C_IKTTANORA, " +
|
|
"T_TANITASIORA_OSSZES.C_MEGJEGYZES, " +
|
|
"T_TANITASIORA_OSSZES.C_MEGTARTOTT, " +
|
|
"T_TANITASIORA_OSSZES.C_NAPSORSZAMA, " +
|
|
"T_TANITASIORA_OSSZES.C_NEMSZAKRENDSZERUORA, " +
|
|
"T_TANITASIORA_OSSZES.C_ORAKEZDETE, " +
|
|
"T_TANITASIORA_OSSZES.C_ORASZAM, " +
|
|
"T_TANITASIORA_OSSZES.C_ORAVEGE, " +
|
|
"T_TANITASIORA_OSSZES.C_SORSZAMOZANDO, " +
|
|
"T_TANITASIORA_OSSZES.C_TAMOPORA, " +
|
|
"T_TANITASIORA_OSSZES.C_TEMA, " +
|
|
"T_TANITASIORA_OSSZES.C_TULORA, " +
|
|
"T_TANITASIORA_OSSZES.C_OSZTALYFONOKI, " +
|
|
"T_TANITASIORA_OSSZES.C_HAZIFELADAT, " +
|
|
"T_TANITASIORA_OSSZES.C_DIFFERENCIALT, " +
|
|
"T_TANITASIORA_OSSZES.C_DRAMA, " +
|
|
"T_TANITASIORA_OSSZES.C_IPRTANORA, " +
|
|
"T_TANITASIORA_OSSZES.C_KOOPERATIV, " +
|
|
"T_TANITASIORA_OSSZES.C_MERES, " +
|
|
"T_TANITASIORA_OSSZES.C_MINDENNAPOSTESTNEVELES, " +
|
|
"T_TANITASIORA_OSSZES.C_NEMZETISEGIORA, " +
|
|
"T_TANITASIORA_OSSZES.C_PARHUZAMOSORA, " +
|
|
"T_TANITASIORA_OSSZES.C_TIOP12, " +
|
|
"T_TANITASIORA_OSSZES.C_ADMINALTALKIIRT, " +
|
|
"T_TANITASIORA_OSSZES.C_CSENGETESIRENDID, " +
|
|
"T_TANITASIORA_OSSZES.C_CSENGETESIRENDORAID, " +
|
|
"T_TANITASIORA_OSSZES.C_ORARENDIORAGROUPID, " +
|
|
"T_TANITASIORA_OSSZES.C_MOBILNAPLOZOTT, " +
|
|
"T_TANITASIORA_OSSZES.C_EFOP32317, " +
|
|
"T_TANITASIORA_OSSZES.C_MULTIKULTURALISORA, " +
|
|
"T_TANITASIORA_OSSZES.C_KOMPLEXORA, " +
|
|
"T_TANITASIORA_OSSZES.C_KIPORA, " +
|
|
"T_TANITASIORA_OSSZES.C_VEKOP73317, " +
|
|
"T_TANITASIORA_OSSZES.C_KAPORA, " +
|
|
"T_TANITASIORA_OSSZES.C_GINOP623, " +
|
|
"T_TANITASIORA_OSSZES.C_EFOP31716, " +
|
|
"T_TANITASIORA_OSSZES.C_EFOP33717, " +
|
|
"T_TANITASIORA_OSSZES.C_TIOP1111212012001, " +
|
|
"T_TANITASIORA_OSSZES.C_EGYEDINAP, " +
|
|
"T_TANITASIORA_OSSZES.C_ISDFHTKIPORA, " +
|
|
"T_TANITASIORA_OSSZES.C_ISDFHTORA, " +
|
|
"T_TANITASIORA_OSSZES.C_ISDIGITALISALAPUALPROGRAM, " +
|
|
"T_TANITASIORA_OSSZES.C_ISELETGYAKORLATALAPUALPROGRA, " +
|
|
"T_TANITASIORA_OSSZES.C_ISLOGIKAALAPUALPROGRAM, " +
|
|
"T_TANITASIORA_OSSZES.C_ISMUVESZETALAPUALPROGRAM, " +
|
|
"T_TANITASIORA_OSSZES.C_ISRAHANGOLODAS, " +
|
|
"T_TANITASIORA_OSSZES.C_ISTEORAD, " +
|
|
"T_TANITASIORA_OSSZES.C_ISTESTMOZGASALAPUALPROGRAM, " +
|
|
"T_TANITASIORA_OSSZES.C_ISFELNOTTOKTATASISZERZODES, " +
|
|
"T_TANITASIORA_OSSZES.C_EFOP23517, " +
|
|
"T_TANITASIORA_OSSZES.C_DIGESZKOZTIPUSID, " +
|
|
"T_TANITASIORA_OSSZES.C_DIGPLATFORMTIPUSID, " +
|
|
"T_TANITASIORA_OSSZES.C_ORAEVESSORSZAMA, " +
|
|
// TanitasiOra kapcsoló mezői
|
|
"T_TANITASIORA_OSSZES.C_TANMENETID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANTARGYID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_NAPTARINAPID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_ORARENDIORAID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_FOGLALKOZASID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_HELYETTESITOTANARID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANARID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TEREMID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_OSZTALYCSOPORTID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_ORATULAJDONOSID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANULASIEGYSEGID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_INTEZMENYID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.C_TANEVID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_TANITASIORA_OSSZES.TOROLT, " +
|
|
"T_TANITASIORA_OSSZES.SERIAL, " +
|
|
"T_TANITASIORA_OSSZES.CREATED, " +
|
|
"T_TANITASIORA_OSSZES.CREATOR, " +
|
|
"T_TANITASIORA_OSSZES.LASTCHANGED, " +
|
|
"T_TANITASIORA_OSSZES.MODIFIER " +
|
|
"from " +
|
|
"T_TANITASIORA_OSSZES " +
|
|
"where " +
|
|
"(1 = 1) ";
|
|
|
|
public override string EmptyQueryCommandText
|
|
{
|
|
get
|
|
{
|
|
return emptyQueryCommandText;
|
|
}
|
|
}
|
|
|
|
public override string DynamicQueryCommandText
|
|
{
|
|
get
|
|
{
|
|
return dynamicQueryCommandText;
|
|
}
|
|
}
|
|
|
|
public override IDictionary<string, string> DynamicColumns
|
|
{
|
|
get
|
|
{
|
|
return dynamicColumns;
|
|
}
|
|
}
|
|
|
|
protected override TanitasiOra CreateEntityInstance()
|
|
{
|
|
return TanitasiOra.GiveAnInstance();
|
|
}
|
|
|
|
#region Lekérdezés
|
|
|
|
public override void LoadEntityFields(TanitasiOra entity, SDA.DataProvider.SDADataReader reader)
|
|
{
|
|
// TanitasiOra betöltése
|
|
// TanitasiOra mezői
|
|
|
|
entity.m_BejegyzesIdeje = DAUtil.ReadDateTimeAttribute(reader, 1, DateTime.Now /* XXX DateTime */);
|
|
|
|
|
|
entity.m_Bontott = DAUtil.ReadBooleanAttribute(reader, 2, false);
|
|
|
|
|
|
entity.m_Datum = DAUtil.ReadDateTimeAttribute(reader, 3, DateTime.Now /* XXX DateTime */);
|
|
|
|
|
|
entity.m_HelyettesitesOka = DAUtil.ReadStringAttribute(reader, 4);
|
|
|
|
|
|
entity.m_HelyettesitesTipusa = DAUtil.ReadIntegerAttribute(reader, 5);
|
|
|
|
|
|
entity.m_HetNapja = DAUtil.ReadIntegerAttribute(reader, 6, -1);
|
|
|
|
|
|
entity.m_HetSorszama = DAUtil.ReadIntegerAttribute(reader, 7, -1);
|
|
|
|
|
|
entity.m_IKTTanora = DAUtil.ReadBooleanAttribute(reader, 8, false);
|
|
|
|
|
|
entity.m_Megjegyzes = DAUtil.ReadStringAttribute(reader, 9);
|
|
|
|
|
|
entity.m_Megtartott = DAUtil.ReadBooleanAttribute(reader, 10, true);
|
|
|
|
|
|
entity.m_NapSorszama = DAUtil.ReadIntegerAttribute(reader, 11, -1);
|
|
|
|
|
|
entity.m_NemSzakrendszeruOra = DAUtil.ReadBooleanAttribute(reader, 12, false);
|
|
|
|
|
|
entity.m_OraKezdete = DAUtil.ReadDateTimeAttribute(reader, 13, DateTime.Now /* XXX DateTime */);
|
|
|
|
|
|
entity.m_Oraszam = DAUtil.ReadIntegerAttribute(reader, 14);
|
|
|
|
|
|
entity.m_OraVege = DAUtil.ReadDateTimeAttribute(reader, 15, DateTime.Now /* XXX DateTime */);
|
|
|
|
|
|
entity.m_Sorszamozando = DAUtil.ReadBooleanAttribute(reader, 16, true);
|
|
|
|
|
|
entity.m_TAMOPOra = DAUtil.ReadBooleanAttribute(reader, 17, false);
|
|
|
|
|
|
entity.m_Tema = DAUtil.ReadStringAttribute(reader, 18);
|
|
|
|
|
|
entity.m_Tulora = DAUtil.ReadBooleanAttribute(reader, 19, false);
|
|
|
|
|
|
entity.m_Osztalyfonoki = DAUtil.ReadBooleanAttribute(reader, 20, false);
|
|
|
|
|
|
entity.m_HaziFeladat = DAUtil.ReadStringAttribute(reader, 21);
|
|
|
|
|
|
entity.m_Differencialt = DAUtil.ReadBooleanAttribute(reader, 22, false);
|
|
|
|
|
|
entity.m_Drama = DAUtil.ReadBooleanAttribute(reader, 23, false);
|
|
|
|
|
|
entity.m_IPRTanora = DAUtil.ReadBooleanAttribute(reader, 24, false);
|
|
|
|
|
|
entity.m_Kooperativ = DAUtil.ReadBooleanAttribute(reader, 25, false);
|
|
|
|
|
|
entity.m_Meres = DAUtil.ReadBooleanAttribute(reader, 26, false);
|
|
|
|
|
|
entity.m_MindennaposTestneveles = DAUtil.ReadBooleanAttribute(reader, 27, false);
|
|
|
|
|
|
entity.m_NemzetisegiOra = DAUtil.ReadBooleanAttribute(reader, 28, false);
|
|
|
|
|
|
entity.m_ParhuzamosOra = DAUtil.ReadBooleanAttribute(reader, 29, false);
|
|
|
|
|
|
entity.m_TIOP12 = DAUtil.ReadBooleanAttribute(reader, 30, false);
|
|
|
|
|
|
entity.m_AdminAltalKiirt = DAUtil.ReadBooleanAttribute(reader, 31, false);
|
|
|
|
|
|
entity.m_CsengetesirendId = DAUtil.ReadIntegerAttribute(reader, 32);
|
|
|
|
|
|
entity.m_CsengetesirendOraId = DAUtil.ReadIntegerAttribute(reader, 33);
|
|
|
|
|
|
entity.m_OrarendiOraGroupId = DAUtil.ReadIntegerAttribute(reader, 34);
|
|
|
|
|
|
entity.m_MobilNaplozott = DAUtil.ReadBooleanAttribute(reader, 35, false);
|
|
|
|
|
|
entity.m_EFOP32317 = DAUtil.ReadBooleanAttribute(reader, 36, false);
|
|
|
|
|
|
entity.m_MultikulturalisOra = DAUtil.ReadBooleanAttribute(reader, 37, false);
|
|
|
|
|
|
entity.m_KomplexOra = DAUtil.ReadBooleanAttribute(reader, 38, false);
|
|
|
|
|
|
entity.m_KIPOra = DAUtil.ReadBooleanAttribute(reader, 39, false);
|
|
|
|
|
|
entity.m_VEKOP73317 = DAUtil.ReadBooleanAttribute(reader, 40, false);
|
|
|
|
|
|
entity.m_KAPOra = DAUtil.ReadBooleanAttribute(reader, 41, false);
|
|
|
|
|
|
entity.m_GINOP623 = DAUtil.ReadBooleanAttribute(reader, 42, false);
|
|
|
|
|
|
entity.m_EFOP31716 = DAUtil.ReadBooleanAttribute(reader, 43, false);
|
|
|
|
|
|
entity.m_EFOP33717 = DAUtil.ReadBooleanAttribute(reader, 44, false);
|
|
|
|
|
|
entity.m_TIOP1111212012001 = DAUtil.ReadBooleanAttribute(reader, 45, false);
|
|
|
|
|
|
entity.m_EgyediNap = DAUtil.ReadBooleanAttribute(reader, 46, false);
|
|
|
|
|
|
entity.m_IsDfhtkipOra = DAUtil.ReadBooleanAttribute(reader, 47, false);
|
|
|
|
|
|
entity.m_IsDfhtOra = DAUtil.ReadBooleanAttribute(reader, 48, false);
|
|
|
|
|
|
entity.m_IsDigitalisAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 49, false);
|
|
|
|
|
|
entity.m_IsEletgyakorlatAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 50, false);
|
|
|
|
|
|
entity.m_IsLogikaAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 51, false);
|
|
|
|
|
|
entity.m_IsMuveszetAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 52, false);
|
|
|
|
|
|
entity.m_IsRahangolodas = DAUtil.ReadBooleanAttribute(reader, 53, false);
|
|
|
|
|
|
entity.m_IsTeorad = DAUtil.ReadBooleanAttribute(reader, 54, false);
|
|
|
|
|
|
entity.m_IsTestmozgasAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 55, false);
|
|
|
|
|
|
entity.m_IsFelnottoktatasiSzerzodes = DAUtil.ReadBooleanAttribute(reader, 56, false);
|
|
|
|
|
|
entity.m_EFOP23517 = DAUtil.ReadBooleanAttribute(reader, 57, false);
|
|
|
|
|
|
entity.m_DigEszkozTipusId = DAUtil.ReadIntegerAttribute(reader, 58);
|
|
|
|
|
|
entity.m_DigPlatformTipusId = DAUtil.ReadIntegerAttribute(reader, 59);
|
|
|
|
|
|
entity.m_OraEvesSorszama = DAUtil.ReadIntegerAttribute(reader, 60);
|
|
|
|
// TanitasiOra kapcsoló mezői
|
|
DAUtil.ReadIDAttribute(reader, 61, ref entity.m_TanmenetId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 62, ref entity.m_TantargyId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 63, ref entity.m_NaptariNapId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 64, ref entity.m_OrarendiOraId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 65, ref entity.m_FoglalkozasId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 66, ref entity.m_HelyettesitoTanarId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 67, ref entity.m_TanarId, 0);
|
|
DAUtil.ReadIDAttribute(reader, 68, ref entity.m_TeremId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 69, ref entity.m_OsztalyCsoportId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 70, ref entity.m_OraTulajdonosId, 0);
|
|
DAUtil.ReadIDAttribute(reader, 71, ref entity.m_TanulasiEgysegId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 72, ref entity.m_IntezmenyId, 0);
|
|
DAUtil.ReadIDAttribute(reader, 73, ref entity.m_TanevId, 0);
|
|
}
|
|
|
|
public override void LoadEntityFields(TanitasiOra entity, SDA.DataProvider.SDADataReader reader, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
|
|
{
|
|
int index = 1;
|
|
if (columns == null)
|
|
{
|
|
columns = new List<string>(index);
|
|
}
|
|
// TanitasiOra betöltése
|
|
// TanitasiOra mezői
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("BejegyzesIdeje"))))
|
|
{
|
|
entity.m_BejegyzesIdeje = DAUtil.ReadDateTimeAttribute(reader, index++, DateTime.Now /* XXX DateTime */);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Bontott"))))
|
|
{
|
|
entity.m_Bontott = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Datum"))))
|
|
{
|
|
entity.m_Datum = DAUtil.ReadDateTimeAttribute(reader, index++, DateTime.Now /* XXX DateTime */);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("HelyettesitesOka"))))
|
|
{
|
|
entity.m_HelyettesitesOka = DAUtil.ReadStringAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("HelyettesitesTipusa"))))
|
|
{
|
|
entity.m_HelyettesitesTipusa = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("HetNapja"))))
|
|
{
|
|
entity.m_HetNapja = DAUtil.ReadIntegerAttribute(reader, index++, -1);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("HetSorszama"))))
|
|
{
|
|
entity.m_HetSorszama = DAUtil.ReadIntegerAttribute(reader, index++, -1);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IKTTanora"))))
|
|
{
|
|
entity.m_IKTTanora = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Megjegyzes"))))
|
|
{
|
|
entity.m_Megjegyzes = DAUtil.ReadStringAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Megtartott"))))
|
|
{
|
|
entity.m_Megtartott = DAUtil.ReadBooleanAttribute(reader, index++, true);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("NapSorszama"))))
|
|
{
|
|
entity.m_NapSorszama = DAUtil.ReadIntegerAttribute(reader, index++, -1);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("NemSzakrendszeruOra"))))
|
|
{
|
|
entity.m_NemSzakrendszeruOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("OraKezdete"))))
|
|
{
|
|
entity.m_OraKezdete = DAUtil.ReadDateTimeAttribute(reader, index++, DateTime.Now /* XXX DateTime */);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Oraszam"))))
|
|
{
|
|
entity.m_Oraszam = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("OraVege"))))
|
|
{
|
|
entity.m_OraVege = DAUtil.ReadDateTimeAttribute(reader, index++, DateTime.Now /* XXX DateTime */);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Sorszamozando"))))
|
|
{
|
|
entity.m_Sorszamozando = DAUtil.ReadBooleanAttribute(reader, index++, true);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("TAMOPOra"))))
|
|
{
|
|
entity.m_TAMOPOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Tema"))))
|
|
{
|
|
entity.m_Tema = DAUtil.ReadStringAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Tulora"))))
|
|
{
|
|
entity.m_Tulora = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Osztalyfonoki"))))
|
|
{
|
|
entity.m_Osztalyfonoki = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("HaziFeladat"))))
|
|
{
|
|
entity.m_HaziFeladat = DAUtil.ReadStringAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Differencialt"))))
|
|
{
|
|
entity.m_Differencialt = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Drama"))))
|
|
{
|
|
entity.m_Drama = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IPRTanora"))))
|
|
{
|
|
entity.m_IPRTanora = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Kooperativ"))))
|
|
{
|
|
entity.m_Kooperativ = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Meres"))))
|
|
{
|
|
entity.m_Meres = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("MindennaposTestneveles"))))
|
|
{
|
|
entity.m_MindennaposTestneveles = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("NemzetisegiOra"))))
|
|
{
|
|
entity.m_NemzetisegiOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("ParhuzamosOra"))))
|
|
{
|
|
entity.m_ParhuzamosOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("TIOP12"))))
|
|
{
|
|
entity.m_TIOP12 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("AdminAltalKiirt"))))
|
|
{
|
|
entity.m_AdminAltalKiirt = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("CsengetesirendId"))))
|
|
{
|
|
entity.m_CsengetesirendId = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("CsengetesirendOraId"))))
|
|
{
|
|
entity.m_CsengetesirendOraId = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("OrarendiOraGroupId"))))
|
|
{
|
|
entity.m_OrarendiOraGroupId = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("MobilNaplozott"))))
|
|
{
|
|
entity.m_MobilNaplozott = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("EFOP32317"))))
|
|
{
|
|
entity.m_EFOP32317 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("MultikulturalisOra"))))
|
|
{
|
|
entity.m_MultikulturalisOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("KomplexOra"))))
|
|
{
|
|
entity.m_KomplexOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("KIPOra"))))
|
|
{
|
|
entity.m_KIPOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("VEKOP73317"))))
|
|
{
|
|
entity.m_VEKOP73317 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("KAPOra"))))
|
|
{
|
|
entity.m_KAPOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("GINOP623"))))
|
|
{
|
|
entity.m_GINOP623 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("EFOP31716"))))
|
|
{
|
|
entity.m_EFOP31716 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("EFOP33717"))))
|
|
{
|
|
entity.m_EFOP33717 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("TIOP1111212012001"))))
|
|
{
|
|
entity.m_TIOP1111212012001 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("EgyediNap"))))
|
|
{
|
|
entity.m_EgyediNap = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsDfhtkipOra"))))
|
|
{
|
|
entity.m_IsDfhtkipOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsDfhtOra"))))
|
|
{
|
|
entity.m_IsDfhtOra = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsDigitalisAlapuAlprogram"))))
|
|
{
|
|
entity.m_IsDigitalisAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsEletgyakorlatAlapuAlprogram"))))
|
|
{
|
|
entity.m_IsEletgyakorlatAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsLogikaAlapuAlprogram"))))
|
|
{
|
|
entity.m_IsLogikaAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsMuveszetAlapuAlprogram"))))
|
|
{
|
|
entity.m_IsMuveszetAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsRahangolodas"))))
|
|
{
|
|
entity.m_IsRahangolodas = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsTeorad"))))
|
|
{
|
|
entity.m_IsTeorad = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsTestmozgasAlapuAlprogram"))))
|
|
{
|
|
entity.m_IsTestmozgasAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsFelnottoktatasiSzerzodes"))))
|
|
{
|
|
entity.m_IsFelnottoktatasiSzerzodes = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("EFOP23517"))))
|
|
{
|
|
entity.m_EFOP23517 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("DigEszkozTipusId"))))
|
|
{
|
|
entity.m_DigEszkozTipusId = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("DigPlatformTipusId"))))
|
|
{
|
|
entity.m_DigPlatformTipusId = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("OraEvesSorszama"))))
|
|
{
|
|
entity.m_OraEvesSorszama = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
// TanitasiOra kapcsoló mezői
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TanmenetId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TantargyId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_NaptariNapId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_OrarendiOraId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_FoglalkozasId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_HelyettesitoTanarId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TanarId, 0);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TeremId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_OsztalyCsoportId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_OraTulajdonosId, 0);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TanulasiEgysegId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_IntezmenyId, 0);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TanevId, 0);
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region Paraméter kötés
|
|
|
|
public override void BindAttributes(TanitasiOra entity, SDA.DataProvider.SDACommand command)
|
|
{
|
|
DAUtil.BindParameter(command, "pBEJEGYZESIDEJE", SDA.DataProvider.SDADBType.DateTime, entity.m_BejegyzesIdeje, false);
|
|
|
|
DAUtil.BindParameter(command, "pBONTOTT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Bontott, false);
|
|
|
|
DAUtil.BindParameter(command, "pDATUM", SDA.DataProvider.SDADBType.DateTime, entity.m_Datum, false);
|
|
|
|
DAUtil.BindParameter(command, "pHELYETTESITESOKA", SDA.DataProvider.SDADBType.String, 500, entity.m_HelyettesitesOka, entity.m_HelyettesitesOka == null);
|
|
|
|
DAUtil.BindParameter(command, "pHELYETTESITESTIPUSA", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_HelyettesitesTipusa, entity.m_HelyettesitesTipusa == null);
|
|
|
|
DAUtil.BindParameter(command, "pHETNAPJA", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_HetNapja, false);
|
|
|
|
DAUtil.BindParameter(command, "pHETSORSZAMA", SDA.DataProvider.SDADBType.Int, entity.m_HetSorszama, false);
|
|
|
|
DAUtil.BindParameter(command, "pIKTTANORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IKTTanora, false);
|
|
|
|
DAUtil.BindParameter(command, "pMEGJEGYZES", SDA.DataProvider.SDADBType.String, 255, entity.m_Megjegyzes, entity.m_Megjegyzes == null);
|
|
|
|
DAUtil.BindParameter(command, "pMEGTARTOTT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Megtartott, false);
|
|
|
|
DAUtil.BindParameter(command, "pNAPSORSZAMA", SDA.DataProvider.SDADBType.Int, entity.m_NapSorszama, false);
|
|
|
|
DAUtil.BindParameter(command, "pNEMSZAKRENDSZERUORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_NemSzakrendszeruOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pORAKEZDETE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraKezdete, false);
|
|
|
|
DAUtil.BindParameter(command, "pORASZAM", SDA.DataProvider.SDADBType.Int, entity.m_Oraszam, entity.m_Oraszam == null);
|
|
|
|
DAUtil.BindParameter(command, "pORAVEGE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraVege, false);
|
|
|
|
DAUtil.BindParameter(command, "pSORSZAMOZANDO", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Sorszamozando, false);
|
|
|
|
DAUtil.BindParameter(command, "pTAMOPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_TAMOPOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pTEMA", SDA.DataProvider.SDADBType.String, 1000, entity.m_Tema, entity.m_Tema == null);
|
|
|
|
DAUtil.BindParameter(command, "pTULORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Tulora, false);
|
|
|
|
DAUtil.BindParameter(command, "pOSZTALYFONOKI", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Osztalyfonoki, false);
|
|
|
|
DAUtil.BindParameter(command, "pHAZIFELADAT", SDA.DataProvider.SDADBType.LongString, 2147483647, entity.m_HaziFeladat, entity.m_HaziFeladat == null);
|
|
|
|
DAUtil.BindParameter(command, "pDIFFERENCIALT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Differencialt, false);
|
|
|
|
DAUtil.BindParameter(command, "pDRAMA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Drama, false);
|
|
|
|
DAUtil.BindParameter(command, "pIPRTANORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IPRTanora, false);
|
|
|
|
DAUtil.BindParameter(command, "pKOOPERATIV", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Kooperativ, false);
|
|
|
|
DAUtil.BindParameter(command, "pMERES", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Meres, false);
|
|
|
|
DAUtil.BindParameter(command, "pMINDENNAPOSTESTNEVELES", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_MindennaposTestneveles, false);
|
|
|
|
DAUtil.BindParameter(command, "pNEMZETISEGIORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_NemzetisegiOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pPARHUZAMOSORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_ParhuzamosOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pTIOP12", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_TIOP12, false);
|
|
|
|
DAUtil.BindParameter(command, "pADMINALTALKIIRT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_AdminAltalKiirt, false);
|
|
|
|
DAUtil.BindParameter(command, "pCSENGETESIRENDID", SDA.DataProvider.SDADBType.Int, entity.m_CsengetesirendId, entity.m_CsengetesirendId == null);
|
|
|
|
DAUtil.BindParameter(command, "pCSENGETESIRENDORAID", SDA.DataProvider.SDADBType.Int, entity.m_CsengetesirendOraId, entity.m_CsengetesirendOraId == null);
|
|
|
|
DAUtil.BindParameter(command, "pORARENDIORAGROUPID", SDA.DataProvider.SDADBType.Int, entity.m_OrarendiOraGroupId, entity.m_OrarendiOraGroupId == null);
|
|
|
|
DAUtil.BindParameter(command, "pMOBILNAPLOZOTT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_MobilNaplozott, false);
|
|
|
|
DAUtil.BindParameter(command, "pEFOP32317", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP32317, false);
|
|
|
|
DAUtil.BindParameter(command, "pMULTIKULTURALISORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_MultikulturalisOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pKOMPLEXORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_KomplexOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pKIPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_KIPOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pVEKOP73317", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_VEKOP73317, false);
|
|
|
|
DAUtil.BindParameter(command, "pKAPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_KAPOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pGINOP623", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_GINOP623, false);
|
|
|
|
DAUtil.BindParameter(command, "pEFOP31716", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP31716, false);
|
|
|
|
DAUtil.BindParameter(command, "pEFOP33717", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP33717, false);
|
|
|
|
DAUtil.BindParameter(command, "pTIOP1111212012001", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_TIOP1111212012001, false);
|
|
|
|
DAUtil.BindParameter(command, "pEGYEDINAP", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EgyediNap, false);
|
|
|
|
DAUtil.BindParameter(command, "pISDFHTKIPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsDfhtkipOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pISDFHTORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsDfhtOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pISDIGITALISALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsDigitalisAlapuAlprogram, false);
|
|
|
|
DAUtil.BindParameter(command, "pISELETGYAKORLATALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsEletgyakorlatAlapuAlprogram, false);
|
|
|
|
DAUtil.BindParameter(command, "pISLOGIKAALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsLogikaAlapuAlprogram, false);
|
|
|
|
DAUtil.BindParameter(command, "pISMUVESZETALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsMuveszetAlapuAlprogram, false);
|
|
|
|
DAUtil.BindParameter(command, "pISRAHANGOLODAS", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsRahangolodas, false);
|
|
|
|
DAUtil.BindParameter(command, "pISTEORAD", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsTeorad, false);
|
|
|
|
DAUtil.BindParameter(command, "pISTESTMOZGASALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsTestmozgasAlapuAlprogram, false);
|
|
|
|
DAUtil.BindParameter(command, "pISFELNOTTOKTATASISZERZODES", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsFelnottoktatasiSzerzodes, false);
|
|
|
|
DAUtil.BindParameter(command, "pEFOP23517", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP23517, false);
|
|
|
|
DAUtil.BindParameter(command, "pDIGESZKOZTIPUSID", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_DigEszkozTipusId, entity.m_DigEszkozTipusId == null);
|
|
|
|
DAUtil.BindParameter(command, "pDIGPLATFORMTIPUSID", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_DigPlatformTipusId, entity.m_DigPlatformTipusId == null);
|
|
|
|
DAUtil.BindParameter(command, "pORAEVESSORSZAMA", SDA.DataProvider.SDADBType.Int, entity.m_OraEvesSorszama, entity.m_OraEvesSorszama == null);
|
|
}
|
|
|
|
public override void DynamicBindAttributes(TanitasiOra entity, SDA.DataProvider.SDACommand command)
|
|
{
|
|
System.Text.StringBuilder sb = new System.Text.StringBuilder();
|
|
if (entity.HasChanged("BejegyzesIdeje"))
|
|
{
|
|
sb.Append("C_BEJEGYZESIDEJE = :pBEJEGYZESIDEJE,");
|
|
|
|
DAUtil.BindParameter(command, "pBEJEGYZESIDEJE", SDA.DataProvider.SDADBType.DateTime, entity.m_BejegyzesIdeje, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Bontott"))
|
|
{
|
|
sb.Append("C_BONTOTT = :pBONTOTT,");
|
|
|
|
DAUtil.BindParameter(command, "pBONTOTT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Bontott, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Datum"))
|
|
{
|
|
sb.Append("C_DATUM = :pDATUM,");
|
|
|
|
DAUtil.BindParameter(command, "pDATUM", SDA.DataProvider.SDADBType.DateTime, entity.m_Datum, false);
|
|
|
|
}
|
|
if (entity.HasChanged("HelyettesitesOka"))
|
|
{
|
|
sb.Append("C_HELYETTESITESOKA = :pHELYETTESITESOKA,");
|
|
|
|
DAUtil.BindParameter(command, "pHELYETTESITESOKA", SDA.DataProvider.SDADBType.String, 500, entity.m_HelyettesitesOka, entity.m_HelyettesitesOka == null);
|
|
|
|
}
|
|
if (entity.HasChanged("HelyettesitesTipusa"))
|
|
{
|
|
sb.Append("C_HELYETTESITESTIPUSA = :pHELYETTESITESTIPUSA,");
|
|
|
|
DAUtil.BindParameter(command, "pHELYETTESITESTIPUSA", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_HelyettesitesTipusa, entity.m_HelyettesitesTipusa == null);
|
|
|
|
}
|
|
if (entity.HasChanged("HetNapja"))
|
|
{
|
|
sb.Append("C_HETNAPJA = :pHETNAPJA,");
|
|
|
|
DAUtil.BindParameter(command, "pHETNAPJA", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_HetNapja, false);
|
|
|
|
}
|
|
if (entity.HasChanged("HetSorszama"))
|
|
{
|
|
sb.Append("C_HETSORSZAMA = :pHETSORSZAMA,");
|
|
|
|
DAUtil.BindParameter(command, "pHETSORSZAMA", SDA.DataProvider.SDADBType.Int, entity.m_HetSorszama, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IKTTanora"))
|
|
{
|
|
sb.Append("C_IKTTANORA = :pIKTTANORA,");
|
|
|
|
DAUtil.BindParameter(command, "pIKTTANORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IKTTanora, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Megjegyzes"))
|
|
{
|
|
sb.Append("C_MEGJEGYZES = :pMEGJEGYZES,");
|
|
|
|
DAUtil.BindParameter(command, "pMEGJEGYZES", SDA.DataProvider.SDADBType.String, 255, entity.m_Megjegyzes, entity.m_Megjegyzes == null);
|
|
|
|
}
|
|
if (entity.HasChanged("Megtartott"))
|
|
{
|
|
sb.Append("C_MEGTARTOTT = :pMEGTARTOTT,");
|
|
|
|
DAUtil.BindParameter(command, "pMEGTARTOTT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Megtartott, false);
|
|
|
|
}
|
|
if (entity.HasChanged("NapSorszama"))
|
|
{
|
|
sb.Append("C_NAPSORSZAMA = :pNAPSORSZAMA,");
|
|
|
|
DAUtil.BindParameter(command, "pNAPSORSZAMA", SDA.DataProvider.SDADBType.Int, entity.m_NapSorszama, false);
|
|
|
|
}
|
|
if (entity.HasChanged("NemSzakrendszeruOra"))
|
|
{
|
|
sb.Append("C_NEMSZAKRENDSZERUORA = :pNEMSZAKRENDSZERUORA,");
|
|
|
|
DAUtil.BindParameter(command, "pNEMSZAKRENDSZERUORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_NemSzakrendszeruOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("OraKezdete"))
|
|
{
|
|
sb.Append("C_ORAKEZDETE = :pORAKEZDETE,");
|
|
|
|
DAUtil.BindParameter(command, "pORAKEZDETE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraKezdete, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Oraszam"))
|
|
{
|
|
sb.Append("C_ORASZAM = :pORASZAM,");
|
|
|
|
DAUtil.BindParameter(command, "pORASZAM", SDA.DataProvider.SDADBType.Int, entity.m_Oraszam, entity.m_Oraszam == null);
|
|
|
|
}
|
|
if (entity.HasChanged("OraVege"))
|
|
{
|
|
sb.Append("C_ORAVEGE = :pORAVEGE,");
|
|
|
|
DAUtil.BindParameter(command, "pORAVEGE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraVege, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Sorszamozando"))
|
|
{
|
|
sb.Append("C_SORSZAMOZANDO = :pSORSZAMOZANDO,");
|
|
|
|
DAUtil.BindParameter(command, "pSORSZAMOZANDO", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Sorszamozando, false);
|
|
|
|
}
|
|
if (entity.HasChanged("TAMOPOra"))
|
|
{
|
|
sb.Append("C_TAMOPORA = :pTAMOPORA,");
|
|
|
|
DAUtil.BindParameter(command, "pTAMOPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_TAMOPOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Tema"))
|
|
{
|
|
sb.Append("C_TEMA = :pTEMA,");
|
|
|
|
DAUtil.BindParameter(command, "pTEMA", SDA.DataProvider.SDADBType.String, 1000, entity.m_Tema, entity.m_Tema == null);
|
|
|
|
}
|
|
if (entity.HasChanged("Tulora"))
|
|
{
|
|
sb.Append("C_TULORA = :pTULORA,");
|
|
|
|
DAUtil.BindParameter(command, "pTULORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Tulora, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Osztalyfonoki"))
|
|
{
|
|
sb.Append("C_OSZTALYFONOKI = :pOSZTALYFONOKI,");
|
|
|
|
DAUtil.BindParameter(command, "pOSZTALYFONOKI", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Osztalyfonoki, false);
|
|
|
|
}
|
|
if (entity.HasChanged("HaziFeladat"))
|
|
{
|
|
sb.Append("C_HAZIFELADAT = :pHAZIFELADAT,");
|
|
|
|
DAUtil.BindParameter(command, "pHAZIFELADAT", SDA.DataProvider.SDADBType.LongString, 2147483647, entity.m_HaziFeladat, entity.m_HaziFeladat == null);
|
|
|
|
}
|
|
if (entity.HasChanged("Differencialt"))
|
|
{
|
|
sb.Append("C_DIFFERENCIALT = :pDIFFERENCIALT,");
|
|
|
|
DAUtil.BindParameter(command, "pDIFFERENCIALT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Differencialt, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Drama"))
|
|
{
|
|
sb.Append("C_DRAMA = :pDRAMA,");
|
|
|
|
DAUtil.BindParameter(command, "pDRAMA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Drama, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IPRTanora"))
|
|
{
|
|
sb.Append("C_IPRTANORA = :pIPRTANORA,");
|
|
|
|
DAUtil.BindParameter(command, "pIPRTANORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IPRTanora, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Kooperativ"))
|
|
{
|
|
sb.Append("C_KOOPERATIV = :pKOOPERATIV,");
|
|
|
|
DAUtil.BindParameter(command, "pKOOPERATIV", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Kooperativ, false);
|
|
|
|
}
|
|
if (entity.HasChanged("Meres"))
|
|
{
|
|
sb.Append("C_MERES = :pMERES,");
|
|
|
|
DAUtil.BindParameter(command, "pMERES", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Meres, false);
|
|
|
|
}
|
|
if (entity.HasChanged("MindennaposTestneveles"))
|
|
{
|
|
sb.Append("C_MINDENNAPOSTESTNEVELES = :pMINDENNAPOSTESTNEVELES,");
|
|
|
|
DAUtil.BindParameter(command, "pMINDENNAPOSTESTNEVELES", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_MindennaposTestneveles, false);
|
|
|
|
}
|
|
if (entity.HasChanged("NemzetisegiOra"))
|
|
{
|
|
sb.Append("C_NEMZETISEGIORA = :pNEMZETISEGIORA,");
|
|
|
|
DAUtil.BindParameter(command, "pNEMZETISEGIORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_NemzetisegiOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("ParhuzamosOra"))
|
|
{
|
|
sb.Append("C_PARHUZAMOSORA = :pPARHUZAMOSORA,");
|
|
|
|
DAUtil.BindParameter(command, "pPARHUZAMOSORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_ParhuzamosOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("TIOP12"))
|
|
{
|
|
sb.Append("C_TIOP12 = :pTIOP12,");
|
|
|
|
DAUtil.BindParameter(command, "pTIOP12", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_TIOP12, false);
|
|
|
|
}
|
|
if (entity.HasChanged("AdminAltalKiirt"))
|
|
{
|
|
sb.Append("C_ADMINALTALKIIRT = :pADMINALTALKIIRT,");
|
|
|
|
DAUtil.BindParameter(command, "pADMINALTALKIIRT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_AdminAltalKiirt, false);
|
|
|
|
}
|
|
if (entity.HasChanged("CsengetesirendId"))
|
|
{
|
|
sb.Append("C_CSENGETESIRENDID = :pCSENGETESIRENDID,");
|
|
|
|
DAUtil.BindParameter(command, "pCSENGETESIRENDID", SDA.DataProvider.SDADBType.Int, entity.m_CsengetesirendId, entity.m_CsengetesirendId == null);
|
|
|
|
}
|
|
if (entity.HasChanged("CsengetesirendOraId"))
|
|
{
|
|
sb.Append("C_CSENGETESIRENDORAID = :pCSENGETESIRENDORAID,");
|
|
|
|
DAUtil.BindParameter(command, "pCSENGETESIRENDORAID", SDA.DataProvider.SDADBType.Int, entity.m_CsengetesirendOraId, entity.m_CsengetesirendOraId == null);
|
|
|
|
}
|
|
if (entity.HasChanged("OrarendiOraGroupId"))
|
|
{
|
|
sb.Append("C_ORARENDIORAGROUPID = :pORARENDIORAGROUPID,");
|
|
|
|
DAUtil.BindParameter(command, "pORARENDIORAGROUPID", SDA.DataProvider.SDADBType.Int, entity.m_OrarendiOraGroupId, entity.m_OrarendiOraGroupId == null);
|
|
|
|
}
|
|
if (entity.HasChanged("MobilNaplozott"))
|
|
{
|
|
sb.Append("C_MOBILNAPLOZOTT = :pMOBILNAPLOZOTT,");
|
|
|
|
DAUtil.BindParameter(command, "pMOBILNAPLOZOTT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_MobilNaplozott, false);
|
|
|
|
}
|
|
if (entity.HasChanged("EFOP32317"))
|
|
{
|
|
sb.Append("C_EFOP32317 = :pEFOP32317,");
|
|
|
|
DAUtil.BindParameter(command, "pEFOP32317", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP32317, false);
|
|
|
|
}
|
|
if (entity.HasChanged("MultikulturalisOra"))
|
|
{
|
|
sb.Append("C_MULTIKULTURALISORA = :pMULTIKULTURALISORA,");
|
|
|
|
DAUtil.BindParameter(command, "pMULTIKULTURALISORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_MultikulturalisOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("KomplexOra"))
|
|
{
|
|
sb.Append("C_KOMPLEXORA = :pKOMPLEXORA,");
|
|
|
|
DAUtil.BindParameter(command, "pKOMPLEXORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_KomplexOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("KIPOra"))
|
|
{
|
|
sb.Append("C_KIPORA = :pKIPORA,");
|
|
|
|
DAUtil.BindParameter(command, "pKIPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_KIPOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("VEKOP73317"))
|
|
{
|
|
sb.Append("C_VEKOP73317 = :pVEKOP73317,");
|
|
|
|
DAUtil.BindParameter(command, "pVEKOP73317", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_VEKOP73317, false);
|
|
|
|
}
|
|
if (entity.HasChanged("KAPOra"))
|
|
{
|
|
sb.Append("C_KAPORA = :pKAPORA,");
|
|
|
|
DAUtil.BindParameter(command, "pKAPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_KAPOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("GINOP623"))
|
|
{
|
|
sb.Append("C_GINOP623 = :pGINOP623,");
|
|
|
|
DAUtil.BindParameter(command, "pGINOP623", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_GINOP623, false);
|
|
|
|
}
|
|
if (entity.HasChanged("EFOP31716"))
|
|
{
|
|
sb.Append("C_EFOP31716 = :pEFOP31716,");
|
|
|
|
DAUtil.BindParameter(command, "pEFOP31716", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP31716, false);
|
|
|
|
}
|
|
if (entity.HasChanged("EFOP33717"))
|
|
{
|
|
sb.Append("C_EFOP33717 = :pEFOP33717,");
|
|
|
|
DAUtil.BindParameter(command, "pEFOP33717", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP33717, false);
|
|
|
|
}
|
|
if (entity.HasChanged("TIOP1111212012001"))
|
|
{
|
|
sb.Append("C_TIOP1111212012001 = :pTIOP1111212012001,");
|
|
|
|
DAUtil.BindParameter(command, "pTIOP1111212012001", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_TIOP1111212012001, false);
|
|
|
|
}
|
|
if (entity.HasChanged("EgyediNap"))
|
|
{
|
|
sb.Append("C_EGYEDINAP = :pEGYEDINAP,");
|
|
|
|
DAUtil.BindParameter(command, "pEGYEDINAP", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EgyediNap, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsDfhtkipOra"))
|
|
{
|
|
sb.Append("C_ISDFHTKIPORA = :pISDFHTKIPORA,");
|
|
|
|
DAUtil.BindParameter(command, "pISDFHTKIPORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsDfhtkipOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsDfhtOra"))
|
|
{
|
|
sb.Append("C_ISDFHTORA = :pISDFHTORA,");
|
|
|
|
DAUtil.BindParameter(command, "pISDFHTORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsDfhtOra, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsDigitalisAlapuAlprogram"))
|
|
{
|
|
sb.Append("C_ISDIGITALISALAPUALPROGRAM = :pISDIGITALISALAPUALPROGRAM,");
|
|
|
|
DAUtil.BindParameter(command, "pISDIGITALISALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsDigitalisAlapuAlprogram, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsEletgyakorlatAlapuAlprogram"))
|
|
{
|
|
sb.Append("C_ISELETGYAKORLATALAPUALPROGRA = :pISELETGYAKORLATALAPUALPROGRAM,");
|
|
|
|
DAUtil.BindParameter(command, "pISELETGYAKORLATALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsEletgyakorlatAlapuAlprogram, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsLogikaAlapuAlprogram"))
|
|
{
|
|
sb.Append("C_ISLOGIKAALAPUALPROGRAM = :pISLOGIKAALAPUALPROGRAM,");
|
|
|
|
DAUtil.BindParameter(command, "pISLOGIKAALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsLogikaAlapuAlprogram, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsMuveszetAlapuAlprogram"))
|
|
{
|
|
sb.Append("C_ISMUVESZETALAPUALPROGRAM = :pISMUVESZETALAPUALPROGRAM,");
|
|
|
|
DAUtil.BindParameter(command, "pISMUVESZETALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsMuveszetAlapuAlprogram, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsRahangolodas"))
|
|
{
|
|
sb.Append("C_ISRAHANGOLODAS = :pISRAHANGOLODAS,");
|
|
|
|
DAUtil.BindParameter(command, "pISRAHANGOLODAS", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsRahangolodas, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsTeorad"))
|
|
{
|
|
sb.Append("C_ISTEORAD = :pISTEORAD,");
|
|
|
|
DAUtil.BindParameter(command, "pISTEORAD", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsTeorad, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsTestmozgasAlapuAlprogram"))
|
|
{
|
|
sb.Append("C_ISTESTMOZGASALAPUALPROGRAM = :pISTESTMOZGASALAPUALPROGRAM,");
|
|
|
|
DAUtil.BindParameter(command, "pISTESTMOZGASALAPUALPROGRAM", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsTestmozgasAlapuAlprogram, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsFelnottoktatasiSzerzodes"))
|
|
{
|
|
sb.Append("C_ISFELNOTTOKTATASISZERZODES = :pISFELNOTTOKTATASISZERZODES,");
|
|
|
|
DAUtil.BindParameter(command, "pISFELNOTTOKTATASISZERZODES", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsFelnottoktatasiSzerzodes, false);
|
|
|
|
}
|
|
if (entity.HasChanged("EFOP23517"))
|
|
{
|
|
sb.Append("C_EFOP23517 = :pEFOP23517,");
|
|
|
|
DAUtil.BindParameter(command, "pEFOP23517", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP23517, false);
|
|
|
|
}
|
|
if (entity.HasChanged("DigEszkozTipusId"))
|
|
{
|
|
sb.Append("C_DIGESZKOZTIPUSID = :pDIGESZKOZTIPUSID,");
|
|
|
|
DAUtil.BindParameter(command, "pDIGESZKOZTIPUSID", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_DigEszkozTipusId, entity.m_DigEszkozTipusId == null);
|
|
|
|
}
|
|
if (entity.HasChanged("DigPlatformTipusId"))
|
|
{
|
|
sb.Append("C_DIGPLATFORMTIPUSID = :pDIGPLATFORMTIPUSID,");
|
|
|
|
DAUtil.BindParameter(command, "pDIGPLATFORMTIPUSID", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_DigPlatformTipusId, entity.m_DigPlatformTipusId == null);
|
|
|
|
}
|
|
if (entity.HasChanged("OraEvesSorszama"))
|
|
{
|
|
sb.Append("C_ORAEVESSORSZAMA = :pORAEVESSORSZAMA,");
|
|
|
|
DAUtil.BindParameter(command, "pORAEVESSORSZAMA", SDA.DataProvider.SDADBType.Int, entity.m_OraEvesSorszama, entity.m_OraEvesSorszama == null);
|
|
|
|
}
|
|
command.CommandText = command.CommandText.Replace("{COLUMNS}", sb.ToString());
|
|
}
|
|
|
|
public override void BindAssociations(TanitasiOra entity, SDA.DataProvider.SDACommand command)
|
|
{
|
|
DAUtil.BindIdParameter(command, "pTANMENETID", entity.InternalTanmenetId);
|
|
DAUtil.BindIdParameter(command, "pTANTARGYID", entity.InternalTantargyId);
|
|
DAUtil.BindIdParameter(command, "pNAPTARINAPID", entity.InternalNaptariNapId);
|
|
DAUtil.BindIdParameter(command, "pORARENDIORAID", entity.InternalOrarendiOraId);
|
|
DAUtil.BindIdParameter(command, "pFOGLALKOZASID", entity.InternalFoglalkozasId);
|
|
DAUtil.BindIdParameter(command, "pHELYETTESITOTANARID", entity.InternalHelyettesitoTanarId);
|
|
DAUtil.BindIdParameter(command, "pTANARID", entity.InternalTanarId);
|
|
DAUtil.BindIdParameter(command, "pTEREMID", entity.InternalTeremId);
|
|
DAUtil.BindIdParameter(command, "pOSZTALYCSOPORTID", entity.InternalOsztalyCsoportId);
|
|
DAUtil.BindIdParameter(command, "pORATULAJDONOSID", entity.InternalOraTulajdonosId);
|
|
DAUtil.BindIdParameter(command, "pTANULASIEGYSEGID", entity.InternalTanulasiEgysegId);
|
|
DAUtil.BindIdParameter(command, "pINTEZMENYID", entity.InternalIntezmenyId);
|
|
DAUtil.BindIdParameter(command, "pTANEVID", entity.InternalTanevId);
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
|
|
internal class TanitasiOraDA : EntityDataAccessor<TanitasiOra>
|
|
{
|
|
private static TanitasiOraDBHelper m_dbhelper = new TanitasiOraDBHelper();
|
|
|
|
protected override IEntityDBHelper<TanitasiOra> dbhelper
|
|
{
|
|
get { return m_dbhelper; }
|
|
}
|
|
|
|
#region Load
|
|
|
|
public override bool LoadEntity(TanitasiOra entity, int entityId)
|
|
{
|
|
return LoadById(entity, entityId);
|
|
}
|
|
|
|
public override bool FilteredLoadEntity(TanitasiOra entity, int entityId, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
|
|
{
|
|
return LoadById(entity, entityId, columnFilterMode, columns);
|
|
}
|
|
|
|
public bool LoadById(TanitasiOra entity, int entityId)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = dbhelper.CreateEmptyQueryCommand())
|
|
{
|
|
command.CommandText += " and (T_TANITASIORA_OSSZES.ID = :pID) ";
|
|
command.Parameters.Add("pID", SDA.DataProvider.SDADBType.Int).Value = entityId;
|
|
return dbhelper.LoadSingleEntity(entity, command);
|
|
}
|
|
}
|
|
|
|
public bool LoadById(TanitasiOra entity, int entityId, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = dbhelper.CreateDynamicQueryCommand(columnFilterMode, columns))
|
|
{
|
|
command.CommandText += " and (T_TANITASIORA_OSSZES.ID = :pID) ";
|
|
command.Parameters.Add("pID", SDA.DataProvider.SDADBType.Int).Value = entityId;
|
|
return dbhelper.LoadSingleEntity(entity, command, columnFilterMode, columns);
|
|
}
|
|
}
|
|
|
|
[Obsolete("Ezt ne használjátok, mert mindenhova bele kellene fogalmazni a tanév szűrést is! Meg fog majd szűnni!")]
|
|
public override void LoadWithFilter(IEntityCollection<TanitasiOra> collection, string filter, Dictionary<string, object> commandParameters = null)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = dbhelper.CreateEmptyQueryCommand())
|
|
{
|
|
command.CommandText += filter;
|
|
dbhelper.CreateParameterBinding(command, commandParameters);
|
|
dbhelper.LoadEntityCollection(collection, command);
|
|
}
|
|
}
|
|
|
|
[Obsolete("Ezt ne használjátok, mert mindenhova bele kellene fogalmazni a tanév szűrést is! Meg fog majd szűnni!")]
|
|
public override void LoadWithFilter(IEntityCollection<TanitasiOra> collection, string filter, ColumnFilterMode columnFilterMode, IEnumerable<string> columns, Dictionary<string, object> commandParameters = null)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = dbhelper.CreateDynamicQueryCommand(columnFilterMode, columns))
|
|
{
|
|
command.CommandText += filter;
|
|
dbhelper.CreateParameterBinding(command, commandParameters);
|
|
dbhelper.LoadEntityCollection(collection, command, columnFilterMode, columns);
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region InsertEntity
|
|
|
|
private const string m_InsertCommandText = @"
|
|
insert into T_TANITASIORA_OSSZES (
|
|
C_BEJEGYZESIDEJE,
|
|
C_BONTOTT,
|
|
C_DATUM,
|
|
C_HELYETTESITESOKA,
|
|
C_HELYETTESITESTIPUSA,
|
|
C_HETNAPJA,
|
|
C_HETSORSZAMA,
|
|
C_IKTTANORA,
|
|
C_MEGJEGYZES,
|
|
C_MEGTARTOTT,
|
|
C_NAPSORSZAMA,
|
|
C_NEMSZAKRENDSZERUORA,
|
|
C_ORAKEZDETE,
|
|
C_ORASZAM,
|
|
C_ORAVEGE,
|
|
C_SORSZAMOZANDO,
|
|
C_TAMOPORA,
|
|
C_TEMA,
|
|
C_TULORA,
|
|
C_OSZTALYFONOKI,
|
|
C_HAZIFELADAT,
|
|
C_DIFFERENCIALT,
|
|
C_DRAMA,
|
|
C_IPRTANORA,
|
|
C_KOOPERATIV,
|
|
C_MERES,
|
|
C_MINDENNAPOSTESTNEVELES,
|
|
C_NEMZETISEGIORA,
|
|
C_PARHUZAMOSORA,
|
|
C_TIOP12,
|
|
C_ADMINALTALKIIRT,
|
|
C_CSENGETESIRENDID,
|
|
C_CSENGETESIRENDORAID,
|
|
C_ORARENDIORAGROUPID,
|
|
C_MOBILNAPLOZOTT,
|
|
C_EFOP32317,
|
|
C_MULTIKULTURALISORA,
|
|
C_KOMPLEXORA,
|
|
C_KIPORA,
|
|
C_VEKOP73317,
|
|
C_KAPORA,
|
|
C_GINOP623,
|
|
C_EFOP31716,
|
|
C_EFOP33717,
|
|
C_TIOP1111212012001,
|
|
C_EGYEDINAP,
|
|
C_ISDFHTKIPORA,
|
|
C_ISDFHTORA,
|
|
C_ISDIGITALISALAPUALPROGRAM,
|
|
C_ISELETGYAKORLATALAPUALPROGRA,
|
|
C_ISLOGIKAALAPUALPROGRAM,
|
|
C_ISMUVESZETALAPUALPROGRAM,
|
|
C_ISRAHANGOLODAS,
|
|
C_ISTEORAD,
|
|
C_ISTESTMOZGASALAPUALPROGRAM,
|
|
C_ISFELNOTTOKTATASISZERZODES,
|
|
C_EFOP23517,
|
|
C_DIGESZKOZTIPUSID,
|
|
C_DIGPLATFORMTIPUSID,
|
|
C_ORAEVESSORSZAMA,
|
|
C_TANMENETID,
|
|
C_TANTARGYID,
|
|
C_NAPTARINAPID,
|
|
C_ORARENDIORAID,
|
|
C_FOGLALKOZASID,
|
|
C_HELYETTESITOTANARID,
|
|
C_TANARID,
|
|
C_TEREMID,
|
|
C_OSZTALYCSOPORTID,
|
|
C_ORATULAJDONOSID,
|
|
C_TANULASIEGYSEGID,
|
|
C_INTEZMENYID,
|
|
C_TANEVID,
|
|
TOROLT,
|
|
SERIAL,
|
|
CREATED,
|
|
CREATOR)
|
|
values (
|
|
:pBEJEGYZESIDEJE,
|
|
:pBONTOTT,
|
|
:pDATUM,
|
|
:pHELYETTESITESOKA,
|
|
:pHELYETTESITESTIPUSA,
|
|
:pHETNAPJA,
|
|
:pHETSORSZAMA,
|
|
:pIKTTANORA,
|
|
:pMEGJEGYZES,
|
|
:pMEGTARTOTT,
|
|
:pNAPSORSZAMA,
|
|
:pNEMSZAKRENDSZERUORA,
|
|
:pORAKEZDETE,
|
|
:pORASZAM,
|
|
:pORAVEGE,
|
|
:pSORSZAMOZANDO,
|
|
:pTAMOPORA,
|
|
:pTEMA,
|
|
:pTULORA,
|
|
:pOSZTALYFONOKI,
|
|
:pHAZIFELADAT,
|
|
:pDIFFERENCIALT,
|
|
:pDRAMA,
|
|
:pIPRTANORA,
|
|
:pKOOPERATIV,
|
|
:pMERES,
|
|
:pMINDENNAPOSTESTNEVELES,
|
|
:pNEMZETISEGIORA,
|
|
:pPARHUZAMOSORA,
|
|
:pTIOP12,
|
|
:pADMINALTALKIIRT,
|
|
:pCSENGETESIRENDID,
|
|
:pCSENGETESIRENDORAID,
|
|
:pORARENDIORAGROUPID,
|
|
:pMOBILNAPLOZOTT,
|
|
:pEFOP32317,
|
|
:pMULTIKULTURALISORA,
|
|
:pKOMPLEXORA,
|
|
:pKIPORA,
|
|
:pVEKOP73317,
|
|
:pKAPORA,
|
|
:pGINOP623,
|
|
:pEFOP31716,
|
|
:pEFOP33717,
|
|
:pTIOP1111212012001,
|
|
:pEGYEDINAP,
|
|
:pISDFHTKIPORA,
|
|
:pISDFHTORA,
|
|
:pISDIGITALISALAPUALPROGRAM,
|
|
:pISELETGYAKORLATALAPUALPROGRAM,
|
|
:pISLOGIKAALAPUALPROGRAM,
|
|
:pISMUVESZETALAPUALPROGRAM,
|
|
:pISRAHANGOLODAS,
|
|
:pISTEORAD,
|
|
:pISTESTMOZGASALAPUALPROGRAM,
|
|
:pISFELNOTTOKTATASISZERZODES,
|
|
:pEFOP23517,
|
|
:pDIGESZKOZTIPUSID,
|
|
:pDIGPLATFORMTIPUSID,
|
|
:pORAEVESSORSZAMA,
|
|
:pTANMENETID,
|
|
:pTANTARGYID,
|
|
:pNAPTARINAPID,
|
|
:pORARENDIORAID,
|
|
:pFOGLALKOZASID,
|
|
:pHELYETTESITOTANARID,
|
|
:pTANARID,
|
|
:pTEREMID,
|
|
:pOSZTALYCSOPORTID,
|
|
:pORATULAJDONOSID,
|
|
:pTANULASIEGYSEGID,
|
|
:pINTEZMENYID,
|
|
:pTANEVID,
|
|
:pTOROLT,
|
|
:pSERIAL,
|
|
:pCREATED,
|
|
:pCREATOR);
|
|
|
|
SELECT SCOPE_IDENTITY() as ID;
|
|
|
|
";
|
|
|
|
public override void InsertEntity(TanitasiOra entity)
|
|
{
|
|
entity.Serial = 0;
|
|
SetEntityCreator(entity, DateTime.Now, UserContext.Instance.UniqueIdentifier);
|
|
|
|
using (SDA.DataProvider.SDACommand command = DAUtil.CreateCommand(m_InsertCommandText))
|
|
{
|
|
dbhelper.BindAttributes(entity, command);
|
|
dbhelper.BindAssociations(entity, command);
|
|
command.Parameters.Add("pTOROLT", SDA.DataProvider.SDADBType.Boolean /* Boolean */).Value = false;
|
|
command.Parameters.Add("pSERIAL", SDA.DataProvider.SDADBType.Int).Value = 0;
|
|
command.Parameters.Add("pCREATED", SDA.DataProvider.SDADBType.DateTime).Value = entity.EntityCreated;
|
|
command.Parameters.Add("pCREATOR", SDA.DataProvider.SDADBType.Int).Value = entity.EntityCreator;
|
|
entity.ID = Convert.ToInt32(command.ExecuteScalar());
|
|
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region UpdateEntity
|
|
|
|
private const string m_UpdateAttributesCommandText = @"
|
|
update T_TANITASIORA_OSSZES
|
|
set
|
|
{COLUMNS}
|
|
SERIAL = ISNULL(SERIAL,0) + 1,
|
|
LASTCHANGED = :pLASTCHANGED,
|
|
MODIFIER = :pMODIFIER,
|
|
TOROLT = :pTOROLT
|
|
where
|
|
(ID = :pID) and (ISNULL(SERIAL,0) = :pSERIAL)
|
|
";
|
|
|
|
public override bool UpdateEntity(TanitasiOra entity)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = DAUtil.CreateCommand(m_UpdateAttributesCommandText))
|
|
{
|
|
bool result = true;
|
|
dbhelper.DynamicBindAttributes(entity, command);
|
|
|
|
SetEntityModifier(entity, DateTime.Now, UserContext.Instance.UniqueIdentifier);
|
|
|
|
command.Parameters.Add("pID", SDA.DataProvider.SDADBType.Int).Value = entity.ID;
|
|
command.Parameters.Add("pSERIAL", SDA.DataProvider.SDADBType.Int).Value = entity.Serial;
|
|
command.Parameters.Add("pLASTCHANGED", SDA.DataProvider.SDADBType.DateTime).Value = entity.EntityLastChanged;
|
|
command.Parameters.Add("pMODIFIER", SDA.DataProvider.SDADBType.Int).Value = entity.EntityModifier;
|
|
command.Parameters.Add("pTOROLT", SDA.DataProvider.SDADBType.Boolean /* Boolean */).Value = entity.Torolt;
|
|
|
|
result = (command.ExecuteNonQuery() == 1);
|
|
if (result == true)
|
|
entity.Serial++;
|
|
|
|
return result;
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region DeleteEntity
|
|
|
|
private const string m_FizikaiDeleteCommandText = @"DELETE FROM T_TANITASIORA_OSSZES WHERE (ID = :pID) ";
|
|
private const string m_LogikaiDeleteCommandText = @"
|
|
UPDATE T_TANITASIORA_OSSZES
|
|
SET TOROLT = 'T' ,
|
|
SERIAL = SERIAL + 1,
|
|
LASTCHANGED = :pLASTCHANGED,
|
|
MODIFIER = :pMODIFIER
|
|
WHERE (ID = :pID) ";
|
|
|
|
public override void DeleteEntity(TanitasiOra entity, bool logikai = true)
|
|
{
|
|
var _deleteCommandText = logikai ? m_LogikaiDeleteCommandText : m_FizikaiDeleteCommandText;
|
|
using (SDA.DataProvider.SDACommand command = DAUtil.CreateCommand(_deleteCommandText))
|
|
{
|
|
command.Parameters.Add("pID", SDA.DataProvider.SDADBType.Int).Value = entity.ID;
|
|
|
|
if (logikai)
|
|
{
|
|
DateTime lastchanged = DateTime.Now;
|
|
var modifier = UserContext.Instance.UniqueIdentifier;
|
|
|
|
command.Parameters.Add("pLASTCHANGED", SDA.DataProvider.SDADBType.DateTime).Value = lastchanged;
|
|
command.Parameters.Add("pMODIFIER", SDA.DataProvider.SDADBType.Int).Value = modifier;
|
|
}
|
|
|
|
if (command.ExecuteNonQuery() != 1)
|
|
{
|
|
throw new EntityNotFoundException("TanitasiOra", entity.ID);
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region UpdateAssociations
|
|
|
|
private const string m_UpdateAssociationCommandText = @"
|
|
update T_TANITASIORA_OSSZES
|
|
set
|
|
C_TANMENETID = :pTANMENETID,
|
|
C_TANTARGYID = :pTANTARGYID,
|
|
C_NAPTARINAPID = :pNAPTARINAPID,
|
|
C_ORARENDIORAID = :pORARENDIORAID,
|
|
C_FOGLALKOZASID = :pFOGLALKOZASID,
|
|
C_HELYETTESITOTANARID = :pHELYETTESITOTANARID,
|
|
C_TANARID = :pTANARID,
|
|
C_TEREMID = :pTEREMID,
|
|
C_OSZTALYCSOPORTID = :pOSZTALYCSOPORTID,
|
|
C_ORATULAJDONOSID = :pORATULAJDONOSID,
|
|
C_TANULASIEGYSEGID = :pTANULASIEGYSEGID,
|
|
C_INTEZMENYID = :pINTEZMENYID,
|
|
C_TANEVID = :pTANEVID,
|
|
SERIAL = ISNULL(SERIAL,0) + 1,
|
|
LASTCHANGED = :pLASTCHANGED,
|
|
MODIFIER = :pMODIFIER
|
|
where
|
|
(ID = :pID) and (ISNULL(SERIAL,0) = :pSERIAL)
|
|
";
|
|
|
|
public override bool UpdateAssociations(TanitasiOra entity)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = DAUtil.CreateCommand(m_UpdateAssociationCommandText))
|
|
{
|
|
dbhelper.BindAssociations(entity, command);
|
|
|
|
DateTime lastchanged = DateTime.Now;
|
|
var modifier = UserContext.Instance.UniqueIdentifier;
|
|
|
|
command.Parameters.Add("pID", SDA.DataProvider.SDADBType.Int).Value = entity.ID;
|
|
command.Parameters.Add("pSERIAL", SDA.DataProvider.SDADBType.Int).Value = entity.Serial;
|
|
command.Parameters.Add("pLASTCHANGED", SDA.DataProvider.SDADBType.DateTime).Value = lastchanged;
|
|
command.Parameters.Add("pMODIFIER", SDA.DataProvider.SDADBType.Int).Value = modifier;
|
|
|
|
bool result = (command.ExecuteNonQuery() == 1);
|
|
if (result == true)
|
|
{
|
|
entity.Serial++;
|
|
SetEntityModifier(entity, lastchanged, modifier);
|
|
}
|
|
return result;
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region Asszociációkkal kapcsolatos adatbázisműveletek (entitásspecifikus)
|
|
|
|
#region Mint asszociációs osztály
|
|
#endregion
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByOralatogatasokIdFilter = @" and (exists (select 1 from T_ORALATOGATAS_OSSZES where C_MEGTARTOTTORAID = T_TANITASIORA_OSSZES.ID and T_ORALATOGATAS_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByOralatogatasokId(int id, TanitasiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByOralatogatasokIdFilter, id);
|
|
}
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByErtekelesekIdFilter = @" and (exists (select 1 from T_TANULOERTEKELES_OSSZES where C_TANORAID = T_TANITASIORA_OSSZES.ID and T_TANULOERTEKELES_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByErtekelesekId(int id, TanitasiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByErtekelesekIdFilter, id);
|
|
}
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByTanuloEsemenyIdFilter = @" and (exists (select 1 from T_TANULOESEMENY_OSSZES where C_TANITASIORAID = T_TANITASIORA_OSSZES.ID and T_TANULOESEMENY_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByTanuloEsemenyId(int id, TanitasiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByTanuloEsemenyIdFilter, id);
|
|
}
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByHaziFeladatokIdFilter = @" and (exists (select 1 from T_HAZIFELADATOK_OSSZES where C_TANITASIORAID = T_TANITASIORA_OSSZES.ID and T_HAZIFELADATOK_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByHaziFeladatokId(int id, TanitasiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByHaziFeladatokIdFilter, id);
|
|
}
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByTanitasiOraTulajdonsagIdFilter = @" and (exists (select 1 from T_TANITASIORATULAJDONSAG_OSSZES where C_TANITASIORAID = T_TANITASIORA_OSSZES.ID and T_TANITASIORATULAJDONSAG_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByTanitasiOraTulajdonsagId(int id, TanitasiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByTanitasiOraTulajdonsagIdFilter, id);
|
|
}
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByOraFileIdFilter = @" and (exists (select 1 from T_ORAFILE_OSSZES where C_TANITASIORAID = T_TANITASIORA_OSSZES.ID and T_ORAFILE_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByOraFileId(int id, TanitasiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByOraFileIdFilter, id);
|
|
}
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByTanitasiOraDigTamEszkozIdFilter = @" and (exists (select 1 from T_TANITASIORADIGTAMESZKOZ_OSSZES where C_TANITASIORAID = T_TANITASIORA_OSSZES.ID and T_TANITASIORADIGTAMESZKOZ_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByTanitasiOraDigTamEszkozId(int id, TanitasiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByTanitasiOraDigTamEszkozIdFilter, id);
|
|
}
|
|
|
|
|
|
#endregion
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Tanmenet -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Tanmenet_TanitasiOra_DA : EntityCollectionDA<Tanmenet, TanitasiOra>
|
|
{
|
|
internal protected Tanmenet_TanitasiOra_DA(Tanmenet owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_TANMENETID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANMENETID = :pTANMENETID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANMENETID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Tanmenet owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANMENETID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Tanmenet, TanitasiOra>("Tanmenet_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANMENETID = null where (C_TANMENETID = :pTANMENETID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANMENETID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Tanmenet owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANMENETID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Tanmenet, TanitasiOra>("Tanmenet_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Tantargy -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Tantargy_TanitasiOra_DA : EntityCollectionDA<Tantargy, TanitasiOra>
|
|
{
|
|
internal protected Tantargy_TanitasiOra_DA(Tantargy owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_TANTARGYID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANTARGYID = :pTANTARGYID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANTARGYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Tantargy owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANTARGYID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Tantargy, TanitasiOra>("Tantargy_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANTARGYID = null where (C_TANTARGYID = :pTANTARGYID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANTARGYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Tantargy owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANTARGYID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Tantargy, TanitasiOra>("Tantargy_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'NaptariNap -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class NaptariNap_TanitasiOra_DA : EntityCollectionDA<NaptariNap, TanitasiOra>
|
|
{
|
|
internal protected NaptariNap_TanitasiOra_DA(NaptariNap owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_NAPTARINAPID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_NAPTARINAPID = :pNAPTARINAPID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pNAPTARINAPID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(NaptariNap owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pNAPTARINAPID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<NaptariNap, TanitasiOra>("NaptariNap_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_NAPTARINAPID = null where (C_NAPTARINAPID = :pNAPTARINAPID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pNAPTARINAPID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(NaptariNap owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pNAPTARINAPID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<NaptariNap, TanitasiOra>("NaptariNap_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'OrarendiOra -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class OrarendiOra_TanitasiOra_DA : EntityCollectionDA<OrarendiOra, TanitasiOra>
|
|
{
|
|
internal protected OrarendiOra_TanitasiOra_DA(OrarendiOra owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_ORARENDIORAID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_ORARENDIORAID = :pORARENDIORAID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(OrarendiOra owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pORARENDIORAID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, TanitasiOra>("OrarendiOra_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_ORARENDIORAID = null where (C_ORARENDIORAID = :pORARENDIORAID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(OrarendiOra owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pORARENDIORAID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, TanitasiOra>("OrarendiOra_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Foglalkozas -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Foglalkozas_TanitasiOra_DA : EntityCollectionDA<Foglalkozas, TanitasiOra>
|
|
{
|
|
internal protected Foglalkozas_TanitasiOra_DA(Foglalkozas owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_FOGLALKOZASID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_FOGLALKOZASID = :pFOGLALKOZASID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pFOGLALKOZASID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Foglalkozas owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFOGLALKOZASID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Foglalkozas, TanitasiOra>("Foglalkozas_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_FOGLALKOZASID = null where (C_FOGLALKOZASID = :pFOGLALKOZASID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pFOGLALKOZASID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Foglalkozas owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFOGLALKOZASID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Foglalkozas, TanitasiOra>("Foglalkozas_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Alkalmazott -> TanitasiOra (HelyettesitettOrak)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Alkalmazott_HelyettesitettOrak_DA : EntityCollectionDA<Alkalmazott, TanitasiOra>
|
|
{
|
|
internal protected Alkalmazott_HelyettesitettOrak_DA(Alkalmazott owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_HELYETTESITOTANARID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertHelyettesitettOrakCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_HELYETTESITOTANARID = :pHELYETTESITOTANARID where (ID = :pHELYETTESITETTORAKID)";
|
|
result.Parameters.Add("pHELYETTESITOTANARID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pHELYETTESITETTORAKID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Alkalmazott owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertHelyettesitettOrakCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pHELYETTESITOTANARID"].Value = owner.ID;
|
|
command.Parameters["pHELYETTESITETTORAKID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Alkalmazott, TanitasiOra>("HelyettesitoTanar_HelyettesitettOrak");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteHelyettesitettOrakCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_HELYETTESITOTANARID = null where (C_HELYETTESITOTANARID = :pHELYETTESITOTANARID and ID = :pHELYETTESITETTORAKID)";
|
|
result.Parameters.Add("pHELYETTESITOTANARID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pHELYETTESITETTORAKID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Alkalmazott owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteHelyettesitettOrakCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pHELYETTESITOTANARID"].Value = owner.ID;
|
|
command.Parameters["pHELYETTESITETTORAKID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Alkalmazott, TanitasiOra>("HelyettesitoTanar_HelyettesitettOrak");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Alkalmazott -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Alkalmazott_TanitasiOra_DA : EntityCollectionDA<Alkalmazott, TanitasiOra>
|
|
{
|
|
internal protected Alkalmazott_TanitasiOra_DA(Alkalmazott owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_TANARID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANARID = :pTANARID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANARID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Alkalmazott owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANARID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanitasiOra, Alkalmazott>("TanitasiOra_Tanar");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
entity.ModifyTanar(this.Owner);
|
|
if (entity.State == EntityState.Modified)
|
|
{
|
|
entity.UpdateAssociations(true);
|
|
}
|
|
else
|
|
{
|
|
entity.Insert(true);
|
|
}
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANARID = null where (C_TANARID = :pTANARID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANARID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Alkalmazott owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANARID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanitasiOra, Alkalmazott>("TanitasiOra_Tanar");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
entity.Delete(true);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Terem -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Terem_TanitasiOra_DA : EntityCollectionDA<Terem, TanitasiOra>
|
|
{
|
|
internal protected Terem_TanitasiOra_DA(Terem owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_TEREMID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TEREMID = :pTEREMID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTEREMID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Terem owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTEREMID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Terem, TanitasiOra>("Terem_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TEREMID = null where (C_TEREMID = :pTEREMID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTEREMID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Terem owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTEREMID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Terem, TanitasiOra>("Terem_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'OsztalyCsoport -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class OsztalyCsoport_TanitasiOra_DA : EntityCollectionDA<OsztalyCsoport, TanitasiOra>
|
|
{
|
|
internal protected OsztalyCsoport_TanitasiOra_DA(OsztalyCsoport owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_OSZTALYCSOPORTID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_OSZTALYCSOPORTID = :pOSZTALYCSOPORTID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pOSZTALYCSOPORTID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(OsztalyCsoport owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pOSZTALYCSOPORTID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OsztalyCsoport, TanitasiOra>("OsztalyCsoport_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_OSZTALYCSOPORTID = null where (C_OSZTALYCSOPORTID = :pOSZTALYCSOPORTID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pOSZTALYCSOPORTID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(OsztalyCsoport owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pOSZTALYCSOPORTID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OsztalyCsoport, TanitasiOra>("OsztalyCsoport_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Felhasznalo -> TanitasiOra (TanitasiOrai)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Felhasznalo_TanitasiOrai_DA : EntityCollectionDA<Felhasznalo, TanitasiOra>
|
|
{
|
|
internal protected Felhasznalo_TanitasiOrai_DA(Felhasznalo owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_ORATULAJDONOSID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraiCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_ORATULAJDONOSID = :pORATULAJDONOSID where (ID = :pTANITASIORAIID)";
|
|
result.Parameters.Add("pORATULAJDONOSID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAIID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Felhasznalo owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraiCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pORATULAJDONOSID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAIID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Felhasznalo, TanitasiOra>("OraTulajdonos_TanitasiOrai");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
entity.ModifyOraTulajdonos(this.Owner);
|
|
if (entity.State == EntityState.Modified)
|
|
{
|
|
entity.UpdateAssociations(true);
|
|
}
|
|
else
|
|
{
|
|
entity.Insert(true);
|
|
}
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraiCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_ORATULAJDONOSID = null where (C_ORATULAJDONOSID = :pORATULAJDONOSID and ID = :pTANITASIORAIID)";
|
|
result.Parameters.Add("pORATULAJDONOSID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAIID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Felhasznalo owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraiCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pORATULAJDONOSID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAIID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Felhasznalo, TanitasiOra>("OraTulajdonos_TanitasiOrai");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
entity.Delete(true);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'FeltoltottFajl -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class FeltoltottFajl_TanitasiOra_DA : EntityCollectionDA<FeltoltottFajl, TanitasiOra>
|
|
{
|
|
internal protected FeltoltottFajl_TanitasiOra_DA(FeltoltottFajl owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Kapcsolótábla van
|
|
private const string m_Filter = @" and (exists (select 1 from T_FELTOLTOTTFAJL_TANITASIORA where C_TANITASIORAID = T_TANITASIORA_OSSZES.ID and C_FELTOLTOTTFAJLID = :pID)) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// kapcsolótábla van...
|
|
result.CommandText = @"insert into T_FELTOLTOTTFAJL_TANITASIORA (C_FELTOLTOTTFAJLID, C_TANITASIORAID) values (:pFELTOLTOTTFAJLID, :pTANITASIORAID)";
|
|
result.Parameters.Add("pFELTOLTOTTFAJLID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(FeltoltottFajl owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFELTOLTOTTFAJLID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<FeltoltottFajl, TanitasiOra>("FeltoltottFajl_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// kapcsolótábla van...
|
|
result.CommandText = @"delete from T_FELTOLTOTTFAJL_TANITASIORA where (C_FELTOLTOTTFAJLID = :pFELTOLTOTTFAJLID) and (C_TANITASIORAID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pFELTOLTOTTFAJLID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(FeltoltottFajl owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFELTOLTOTTFAJLID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<FeltoltottFajl, TanitasiOra>("FeltoltottFajl_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'TanulasiEgyseg -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class TanulasiEgyseg_TanitasiOra_DA : EntityCollectionDA<TanulasiEgyseg, TanitasiOra>
|
|
{
|
|
internal protected TanulasiEgyseg_TanitasiOra_DA(TanulasiEgyseg owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_TANULASIEGYSEGID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANULASIEGYSEGID = :pTANULASIEGYSEGID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANULASIEGYSEGID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(TanulasiEgyseg owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANULASIEGYSEGID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanulasiEgyseg, TanitasiOra>("TanulasiEgyseg_TanitasiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANULASIEGYSEGID = null where (C_TANULASIEGYSEGID = :pTANULASIEGYSEGID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANULASIEGYSEGID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(TanulasiEgyseg owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANULASIEGYSEGID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanulasiEgyseg, TanitasiOra>("TanulasiEgyseg_TanitasiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Intezmeny -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Intezmeny_TanitasiOra_DA : EntityCollectionDA<Intezmeny, TanitasiOra>
|
|
{
|
|
internal protected Intezmeny_TanitasiOra_DA(Intezmeny owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_INTEZMENYID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_INTEZMENYID = :pINTEZMENYID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pINTEZMENYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Intezmeny owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pINTEZMENYID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanitasiOra, Intezmeny>("TanitasiOra_Intezmeny");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
entity.ModifyIntezmeny(this.Owner);
|
|
if (entity.State == EntityState.Modified)
|
|
{
|
|
entity.UpdateAssociations(true);
|
|
}
|
|
else
|
|
{
|
|
entity.Insert(true);
|
|
}
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_INTEZMENYID = null where (C_INTEZMENYID = :pINTEZMENYID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pINTEZMENYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Intezmeny owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pINTEZMENYID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanitasiOra, Intezmeny>("TanitasiOra_Intezmeny");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
entity.Delete(true);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Tanev -> TanitasiOra (TanitasiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Tanev_TanitasiOra_DA : EntityCollectionDA<Tanev, TanitasiOra>
|
|
{
|
|
internal protected Tanev_TanitasiOra_DA(Tanev owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_TANITASIORA_OSSZES.C_TANEVID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<TanitasiOra> collection)
|
|
{
|
|
new TanitasiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANEVID = :pTANEVID where (ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANEVID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Tanev owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANEVID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanitasiOra, Tanev>("TanitasiOra_Tanev");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
entity.ModifyTanev(this.Owner);
|
|
if (entity.State == EntityState.Modified)
|
|
{
|
|
entity.UpdateAssociations(true);
|
|
}
|
|
else
|
|
{
|
|
entity.Insert(true);
|
|
}
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteTanitasiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_TANITASIORA_OSSZES set C_TANEVID = null where (C_TANEVID = :pTANEVID and ID = :pTANITASIORAID)";
|
|
result.Parameters.Add("pTANEVID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pTANITASIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Tanev owner, TanitasiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteTanitasiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANEVID"].Value = owner.ID;
|
|
command.Parameters["pTANITASIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(TanitasiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<TanitasiOra, Tanev>("TanitasiOra_Tanev");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
entity.Delete(true);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
}
|
|
|