2380 lines
107 KiB
C#
2380 lines
107 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 OrarendiOraDBHelper : EntityDBHelper<OrarendiOra>
|
|
{
|
|
private Dictionary<string, string> dynamicColumns = new Dictionary<string, string>()
|
|
{
|
|
{ "Differencialt", "T_ORARENDIORA_OSSZES.C_DIFFERENCIALT" },
|
|
{ "Drama", "T_ORARENDIORA_OSSZES.C_DRAMA" },
|
|
{ "Hetirend", "T_ORARENDIORA_OSSZES.C_HETIREND" },
|
|
{ "HetNapja", "T_ORARENDIORA_OSSZES.C_HETNAPJA" },
|
|
{ "IKTTanora", "T_ORARENDIORA_OSSZES.C_IKTTANORA" },
|
|
{ "IPRTanora", "T_ORARENDIORA_OSSZES.C_IPRTANORA" },
|
|
{ "Kooperativ", "T_ORARENDIORA_OSSZES.C_KOOPERATIV" },
|
|
{ "Meres", "T_ORARENDIORA_OSSZES.C_MERES" },
|
|
{ "MindennaposTestneveles", "T_ORARENDIORA_OSSZES.C_MINDENNAPOSTESTNEVELES" },
|
|
{ "NemSzakrendszeruOra", "T_ORARENDIORA_OSSZES.C_NEMSZAKRENDSZERUORA" },
|
|
{ "NemzetisegiOra", "T_ORARENDIORA_OSSZES.C_NEMZETISEGIORA" },
|
|
{ "Oraszam", "T_ORARENDIORA_OSSZES.C_ORASZAM" },
|
|
{ "Sorszamozando", "T_ORARENDIORA_OSSZES.C_SORSZAMOZANDO" },
|
|
{ "TAMOPOra", "T_ORARENDIORA_OSSZES.C_TAMOPORA" },
|
|
{ "Tulora", "T_ORARENDIORA_OSSZES.C_TULORA" },
|
|
{ "Bontott", "T_ORARENDIORA_OSSZES.C_BONTOTT" },
|
|
{ "OraErvenyessegKezdete", "T_ORARENDIORA_OSSZES.C_ORAERVENYESSEGKEZDETE" },
|
|
{ "OraErvenyessegVege", "T_ORARENDIORA_OSSZES.C_ORAERVENYESSEGVEGE" },
|
|
{ "ParhuzamosOra", "T_ORARENDIORA_OSSZES.C_PARHUZAMOSORA" },
|
|
{ "TIOP12", "T_ORARENDIORA_OSSZES.C_TIOP12" },
|
|
{ "OraKezdete", "T_ORARENDIORA_OSSZES.C_ORAKEZDETE" },
|
|
{ "OraVege", "T_ORARENDIORA_OSSZES.C_ORAVEGE" },
|
|
{ "Importalt", "T_ORARENDIORA_OSSZES.C_IMPORTALT" },
|
|
{ "CsengetesirendId", "T_ORARENDIORA_OSSZES.C_CSENGETESIRENDID" },
|
|
{ "CsengetesirendOraId", "T_ORARENDIORA_OSSZES.C_CSENGETESIRENDORAID" },
|
|
{ "OrarendiOraGroupId", "T_ORARENDIORA_OSSZES.C_ORARENDIORAGROUPID" },
|
|
{ "EFOP32317", "T_ORARENDIORA_OSSZES.C_EFOP32317" },
|
|
{ "MultikulturalisOra", "T_ORARENDIORA_OSSZES.C_MULTIKULTURALISORA" },
|
|
{ "KomplexOra", "T_ORARENDIORA_OSSZES.C_KOMPLEXORA" },
|
|
{ "KIPOra", "T_ORARENDIORA_OSSZES.C_KIPORA" },
|
|
{ "VEKOP73317", "T_ORARENDIORA_OSSZES.C_VEKOP73317" },
|
|
{ "KAPOra", "T_ORARENDIORA_OSSZES.C_KAPORA" },
|
|
{ "GINOP623", "T_ORARENDIORA_OSSZES.C_GINOP623" },
|
|
{ "EgyediNap", "T_ORARENDIORA_OSSZES.C_EGYEDINAP" },
|
|
{ "IsKezzelFelvettegyediNap", "T_ORARENDIORA_OSSZES.C_ISKEZZELFELVETTEGYEDINAP" },
|
|
{ "EFOP31716", "T_ORARENDIORA_OSSZES.C_EFOP31716" },
|
|
{ "EFOP33717", "T_ORARENDIORA_OSSZES.C_EFOP33717" },
|
|
{ "TIOP1111212012001", "T_ORARENDIORA_OSSZES.C_TIOP1111212012001" },
|
|
{ "IsDfhtkipOra", "T_ORARENDIORA_OSSZES.C_ISDFHTKIPORA" },
|
|
{ "IsDfhtOra", "T_ORARENDIORA_OSSZES.C_ISDFHTORA" },
|
|
{ "IsDigitalisAlapuAlprogram", "T_ORARENDIORA_OSSZES.C_ISDIGITALISALAPUALPROGRAM" },
|
|
{ "IsEletgyakorlatAlapuAlprogram", "T_ORARENDIORA_OSSZES.C_ISELETGYAKORLATALAPUALPROGRA" },
|
|
{ "IsLogikaAlapuAlprogram", "T_ORARENDIORA_OSSZES.C_ISLOGIKAALAPUALPROGRAM" },
|
|
{ "IsMuveszetAlapuAlprogram", "T_ORARENDIORA_OSSZES.C_ISMUVESZETALAPUALPROGRAM" },
|
|
{ "IsRahangolodas", "T_ORARENDIORA_OSSZES.C_ISRAHANGOLODAS" },
|
|
{ "IsTeorad", "T_ORARENDIORA_OSSZES.C_ISTEORAD" },
|
|
{ "IsTestmozgasAlapuAlprogram", "T_ORARENDIORA_OSSZES.C_ISTESTMOZGASALAPUALPROGRAM" },
|
|
{ "IsFelnottoktatasiSzerzodes", "T_ORARENDIORA_OSSZES.C_ISFELNOTTOKTATASISZERZODES" },
|
|
{ "KozpontilagToroltOraGroupID", "T_ORARENDIORA_OSSZES.C_KOZPONTILAGTOROLTORAGROUPID" },
|
|
{ "KozpontiOraGroupId", "T_ORARENDIORA_OSSZES.C_KOZPONTIORAGROUPID" },
|
|
{ "EFOP23517", "T_ORARENDIORA_OSSZES.C_EFOP23517" },
|
|
};
|
|
|
|
private const string dynamicQueryCommandText =
|
|
"select " +
|
|
"T_ORARENDIORA_OSSZES.ID, " +
|
|
"{COLUMNS}" +
|
|
// OrarendiOra betöltése
|
|
// OrarendiOra kapcsoló mezői
|
|
"T_ORARENDIORA_OSSZES.C_TEREMID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_FOGLALKOZASID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANTARGYID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_OSZTALYCSOPORTID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANARID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANEVRENDJEID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_OGORARENDID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_ORATULAJDONOSID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_INTEZMENYID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANEVID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.TOROLT, " +
|
|
"T_ORARENDIORA_OSSZES.SERIAL, " +
|
|
"T_ORARENDIORA_OSSZES.CREATED, " +
|
|
"T_ORARENDIORA_OSSZES.CREATOR, " +
|
|
"T_ORARENDIORA_OSSZES.LASTCHANGED, " +
|
|
"T_ORARENDIORA_OSSZES.MODIFIER " +
|
|
"from " +
|
|
"T_ORARENDIORA_OSSZES " +
|
|
"where " +
|
|
"(1 = 1) ";
|
|
|
|
private const string emptyQueryCommandText =
|
|
"select " +
|
|
"T_ORARENDIORA_OSSZES.ID, " +
|
|
// OrarendiOra betöltése
|
|
// OrarendiOra mezői
|
|
"T_ORARENDIORA_OSSZES.C_DIFFERENCIALT, " +
|
|
"T_ORARENDIORA_OSSZES.C_DRAMA, " +
|
|
"T_ORARENDIORA_OSSZES.C_HETIREND, " +
|
|
"T_ORARENDIORA_OSSZES.C_HETNAPJA, " +
|
|
"T_ORARENDIORA_OSSZES.C_IKTTANORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_IPRTANORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_KOOPERATIV, " +
|
|
"T_ORARENDIORA_OSSZES.C_MERES, " +
|
|
"T_ORARENDIORA_OSSZES.C_MINDENNAPOSTESTNEVELES, " +
|
|
"T_ORARENDIORA_OSSZES.C_NEMSZAKRENDSZERUORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_NEMZETISEGIORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_ORASZAM, " +
|
|
"T_ORARENDIORA_OSSZES.C_SORSZAMOZANDO, " +
|
|
"T_ORARENDIORA_OSSZES.C_TAMOPORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_TULORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_BONTOTT, " +
|
|
"T_ORARENDIORA_OSSZES.C_ORAERVENYESSEGKEZDETE, " +
|
|
"T_ORARENDIORA_OSSZES.C_ORAERVENYESSEGVEGE, " +
|
|
"T_ORARENDIORA_OSSZES.C_PARHUZAMOSORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_TIOP12, " +
|
|
"T_ORARENDIORA_OSSZES.C_ORAKEZDETE, " +
|
|
"T_ORARENDIORA_OSSZES.C_ORAVEGE, " +
|
|
"T_ORARENDIORA_OSSZES.C_IMPORTALT, " +
|
|
"T_ORARENDIORA_OSSZES.C_CSENGETESIRENDID, " +
|
|
"T_ORARENDIORA_OSSZES.C_CSENGETESIRENDORAID, " +
|
|
"T_ORARENDIORA_OSSZES.C_ORARENDIORAGROUPID, " +
|
|
"T_ORARENDIORA_OSSZES.C_EFOP32317, " +
|
|
"T_ORARENDIORA_OSSZES.C_MULTIKULTURALISORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_KOMPLEXORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_KIPORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_VEKOP73317, " +
|
|
"T_ORARENDIORA_OSSZES.C_KAPORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_GINOP623, " +
|
|
"T_ORARENDIORA_OSSZES.C_EGYEDINAP, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISKEZZELFELVETTEGYEDINAP, " +
|
|
"T_ORARENDIORA_OSSZES.C_EFOP31716, " +
|
|
"T_ORARENDIORA_OSSZES.C_EFOP33717, " +
|
|
"T_ORARENDIORA_OSSZES.C_TIOP1111212012001, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISDFHTKIPORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISDFHTORA, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISDIGITALISALAPUALPROGRAM, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISELETGYAKORLATALAPUALPROGRA, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISLOGIKAALAPUALPROGRAM, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISMUVESZETALAPUALPROGRAM, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISRAHANGOLODAS, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISTEORAD, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISTESTMOZGASALAPUALPROGRAM, " +
|
|
"T_ORARENDIORA_OSSZES.C_ISFELNOTTOKTATASISZERZODES, " +
|
|
"T_ORARENDIORA_OSSZES.C_KOZPONTILAGTOROLTORAGROUPID, " +
|
|
"T_ORARENDIORA_OSSZES.C_KOZPONTIORAGROUPID, " +
|
|
"T_ORARENDIORA_OSSZES.C_EFOP23517, " +
|
|
// OrarendiOra kapcsoló mezői
|
|
"T_ORARENDIORA_OSSZES.C_TEREMID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_FOGLALKOZASID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANTARGYID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_OSZTALYCSOPORTID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANARID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANEVRENDJEID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_OGORARENDID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_ORATULAJDONOSID, " + /* Opcionális asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_INTEZMENYID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.C_TANEVID, " + /* Kötelező asszociációs kapcsolómező */
|
|
"T_ORARENDIORA_OSSZES.TOROLT, " +
|
|
"T_ORARENDIORA_OSSZES.SERIAL, " +
|
|
"T_ORARENDIORA_OSSZES.CREATED, " +
|
|
"T_ORARENDIORA_OSSZES.CREATOR, " +
|
|
"T_ORARENDIORA_OSSZES.LASTCHANGED, " +
|
|
"T_ORARENDIORA_OSSZES.MODIFIER " +
|
|
"from " +
|
|
"T_ORARENDIORA_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 OrarendiOra CreateEntityInstance()
|
|
{
|
|
return OrarendiOra.GiveAnInstance();
|
|
}
|
|
|
|
#region Lekérdezés
|
|
|
|
public override void LoadEntityFields(OrarendiOra entity, SDA.DataProvider.SDADataReader reader)
|
|
{
|
|
// OrarendiOra betöltése
|
|
// OrarendiOra mezői
|
|
|
|
entity.m_Differencialt = DAUtil.ReadBooleanAttribute(reader, 1, false);
|
|
|
|
|
|
entity.m_Drama = DAUtil.ReadBooleanAttribute(reader, 2, false);
|
|
|
|
|
|
entity.m_Hetirend = DAUtil.ReadIntegerAttribute(reader, 3, -1);
|
|
|
|
|
|
entity.m_HetNapja = DAUtil.ReadIntegerAttribute(reader, 4, -1);
|
|
|
|
|
|
entity.m_IKTTanora = DAUtil.ReadBooleanAttribute(reader, 5, false);
|
|
|
|
|
|
entity.m_IPRTanora = DAUtil.ReadBooleanAttribute(reader, 6, false);
|
|
|
|
|
|
entity.m_Kooperativ = DAUtil.ReadBooleanAttribute(reader, 7, false);
|
|
|
|
|
|
entity.m_Meres = DAUtil.ReadBooleanAttribute(reader, 8, false);
|
|
|
|
|
|
entity.m_MindennaposTestneveles = DAUtil.ReadBooleanAttribute(reader, 9, false);
|
|
|
|
|
|
entity.m_NemSzakrendszeruOra = DAUtil.ReadBooleanAttribute(reader, 10, false);
|
|
|
|
|
|
entity.m_NemzetisegiOra = DAUtil.ReadBooleanAttribute(reader, 11, false);
|
|
|
|
|
|
entity.m_Oraszam = DAUtil.ReadIntegerAttribute(reader, 12);
|
|
|
|
|
|
entity.m_Sorszamozando = DAUtil.ReadBooleanAttribute(reader, 13, true);
|
|
|
|
|
|
entity.m_TAMOPOra = DAUtil.ReadBooleanAttribute(reader, 14, false);
|
|
|
|
|
|
entity.m_Tulora = DAUtil.ReadBooleanAttribute(reader, 15, false);
|
|
|
|
|
|
entity.m_Bontott = DAUtil.ReadBooleanAttribute(reader, 16, false);
|
|
|
|
|
|
entity.m_OraErvenyessegKezdete = DAUtil.ReadDateTimeAttribute(reader, 17, DateTime.Now /* XXX DateTime */);
|
|
|
|
|
|
entity.m_OraErvenyessegVege = DAUtil.ReadDateTimeAttribute(reader, 18);
|
|
|
|
|
|
entity.m_ParhuzamosOra = DAUtil.ReadBooleanAttribute(reader, 19, false);
|
|
|
|
|
|
entity.m_TIOP12 = DAUtil.ReadBooleanAttribute(reader, 20, false);
|
|
|
|
|
|
entity.m_OraKezdete = DAUtil.ReadDateTimeAttribute(reader, 21);
|
|
|
|
|
|
entity.m_OraVege = DAUtil.ReadDateTimeAttribute(reader, 22);
|
|
|
|
|
|
entity.m_Importalt = DAUtil.ReadBooleanAttribute(reader, 23, false);
|
|
|
|
|
|
entity.m_CsengetesirendId = DAUtil.ReadIntegerAttribute(reader, 24);
|
|
|
|
|
|
entity.m_CsengetesirendOraId = DAUtil.ReadIntegerAttribute(reader, 25);
|
|
|
|
|
|
entity.m_OrarendiOraGroupId = DAUtil.ReadIntegerAttribute(reader, 26);
|
|
|
|
|
|
entity.m_EFOP32317 = DAUtil.ReadBooleanAttribute(reader, 27, false);
|
|
|
|
|
|
entity.m_MultikulturalisOra = DAUtil.ReadBooleanAttribute(reader, 28, false);
|
|
|
|
|
|
entity.m_KomplexOra = DAUtil.ReadBooleanAttribute(reader, 29, false);
|
|
|
|
|
|
entity.m_KIPOra = DAUtil.ReadBooleanAttribute(reader, 30, false);
|
|
|
|
|
|
entity.m_VEKOP73317 = DAUtil.ReadBooleanAttribute(reader, 31, false);
|
|
|
|
|
|
entity.m_KAPOra = DAUtil.ReadBooleanAttribute(reader, 32, false);
|
|
|
|
|
|
entity.m_GINOP623 = DAUtil.ReadBooleanAttribute(reader, 33, false);
|
|
|
|
|
|
entity.m_EgyediNap = DAUtil.ReadBooleanAttribute(reader, 34, false);
|
|
|
|
|
|
entity.m_IsKezzelFelvettegyediNap = DAUtil.ReadBooleanAttribute(reader, 35, false);
|
|
|
|
|
|
entity.m_EFOP31716 = DAUtil.ReadBooleanAttribute(reader, 36, false);
|
|
|
|
|
|
entity.m_EFOP33717 = DAUtil.ReadBooleanAttribute(reader, 37, false);
|
|
|
|
|
|
entity.m_TIOP1111212012001 = DAUtil.ReadBooleanAttribute(reader, 38, false);
|
|
|
|
|
|
entity.m_IsDfhtkipOra = DAUtil.ReadBooleanAttribute(reader, 39, false);
|
|
|
|
|
|
entity.m_IsDfhtOra = DAUtil.ReadBooleanAttribute(reader, 40, false);
|
|
|
|
|
|
entity.m_IsDigitalisAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 41, false);
|
|
|
|
|
|
entity.m_IsEletgyakorlatAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 42, false);
|
|
|
|
|
|
entity.m_IsLogikaAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 43, false);
|
|
|
|
|
|
entity.m_IsMuveszetAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 44, false);
|
|
|
|
|
|
entity.m_IsRahangolodas = DAUtil.ReadBooleanAttribute(reader, 45, false);
|
|
|
|
|
|
entity.m_IsTeorad = DAUtil.ReadBooleanAttribute(reader, 46, false);
|
|
|
|
|
|
entity.m_IsTestmozgasAlapuAlprogram = DAUtil.ReadBooleanAttribute(reader, 47, false);
|
|
|
|
|
|
entity.m_IsFelnottoktatasiSzerzodes = DAUtil.ReadBooleanAttribute(reader, 48, false);
|
|
|
|
|
|
entity.m_KozpontilagToroltOraGroupID = DAUtil.ReadGuidAttribute(reader, 49);
|
|
|
|
|
|
entity.m_KozpontiOraGroupId = DAUtil.ReadGuidAttribute(reader, 50);
|
|
|
|
|
|
entity.m_EFOP23517 = DAUtil.ReadBooleanAttribute(reader, 51, false);
|
|
|
|
// OrarendiOra kapcsoló mezői
|
|
DAUtil.ReadIDAttribute(reader, 52, ref entity.m_TeremId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 53, ref entity.m_FoglalkozasId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 54, ref entity.m_TantargyId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 55, ref entity.m_OsztalyCsoportId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 56, ref entity.m_TanarId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 57, ref entity.m_TanevRendjeId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 58, ref entity.m_OgOrarendId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 59, ref entity.m_OraTulajdonosId, -1);
|
|
DAUtil.ReadIDAttribute(reader, 60, ref entity.m_IntezmenyId, 0);
|
|
DAUtil.ReadIDAttribute(reader, 61, ref entity.m_TanevId, 0);
|
|
}
|
|
|
|
public override void LoadEntityFields(OrarendiOra entity, SDA.DataProvider.SDADataReader reader, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
|
|
{
|
|
int index = 1;
|
|
if (columns == null)
|
|
{
|
|
columns = new List<string>(index);
|
|
}
|
|
// OrarendiOra betöltése
|
|
// OrarendiOra mezői
|
|
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("Hetirend"))))
|
|
{
|
|
entity.m_Hetirend = DAUtil.ReadIntegerAttribute(reader, index++, -1);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("HetNapja"))))
|
|
{
|
|
entity.m_HetNapja = 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("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("NemSzakrendszeruOra"))))
|
|
{
|
|
entity.m_NemSzakrendszeruOra = 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("Oraszam"))))
|
|
{
|
|
entity.m_Oraszam = DAUtil.ReadIntegerAttribute(reader, index++);
|
|
}
|
|
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("Tulora"))))
|
|
{
|
|
entity.m_Tulora = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Bontott"))))
|
|
{
|
|
entity.m_Bontott = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("OraErvenyessegKezdete"))))
|
|
{
|
|
entity.m_OraErvenyessegKezdete = DAUtil.ReadDateTimeAttribute(reader, index++, DateTime.Now /* XXX DateTime */);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("OraErvenyessegVege"))))
|
|
{
|
|
entity.m_OraErvenyessegVege = DAUtil.ReadDateTimeAttribute(reader, index++);
|
|
}
|
|
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("OraKezdete"))))
|
|
{
|
|
entity.m_OraKezdete = DAUtil.ReadDateTimeAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("OraVege"))))
|
|
{
|
|
entity.m_OraVege = DAUtil.ReadDateTimeAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("Importalt"))))
|
|
{
|
|
entity.m_Importalt = 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("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("EgyediNap"))))
|
|
{
|
|
entity.m_EgyediNap = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("IsKezzelFelvettegyediNap"))))
|
|
{
|
|
entity.m_IsKezzelFelvettegyediNap = 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("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("KozpontilagToroltOraGroupID"))))
|
|
{
|
|
entity.m_KozpontilagToroltOraGroupID = DAUtil.ReadGuidAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("KozpontiOraGroupId"))))
|
|
{
|
|
entity.m_KozpontiOraGroupId = DAUtil.ReadGuidAttribute(reader, index++);
|
|
}
|
|
if (((columnFilterMode == ColumnFilterMode.DEFAULT_ALLOWED) ^ (columns.Contains("EFOP23517"))))
|
|
{
|
|
entity.m_EFOP23517 = DAUtil.ReadBooleanAttribute(reader, index++, false);
|
|
}
|
|
// OrarendiOra kapcsoló mezői
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TeremId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_FoglalkozasId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TantargyId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_OsztalyCsoportId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TanarId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_TanevRendjeId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_OgOrarendId, -1);
|
|
DAUtil.ReadIDAttribute(reader, index++, ref entity.m_OraTulajdonosId, -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(OrarendiOra entity, SDA.DataProvider.SDACommand command)
|
|
{
|
|
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, "pHETIREND", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_Hetirend, false);
|
|
|
|
DAUtil.BindParameter(command, "pHETNAPJA", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_HetNapja, false);
|
|
|
|
DAUtil.BindParameter(command, "pIKTTANORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IKTTanora, 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, "pNEMSZAKRENDSZERUORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_NemSzakrendszeruOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pNEMZETISEGIORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_NemzetisegiOra, false);
|
|
|
|
DAUtil.BindParameter(command, "pORASZAM", SDA.DataProvider.SDADBType.Int, entity.m_Oraszam, entity.m_Oraszam == null);
|
|
|
|
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, "pTULORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Tulora, false);
|
|
|
|
DAUtil.BindParameter(command, "pBONTOTT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Bontott, false);
|
|
|
|
DAUtil.BindParameter(command, "pORAERVENYESSEGKEZDETE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraErvenyessegKezdete, false);
|
|
|
|
DAUtil.BindParameter(command, "pORAERVENYESSEGVEGE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraErvenyessegVege, entity.m_OraErvenyessegVege == null);
|
|
|
|
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, "pORAKEZDETE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraKezdete, entity.m_OraKezdete == null);
|
|
|
|
DAUtil.BindParameter(command, "pORAVEGE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraVege, entity.m_OraVege == null);
|
|
|
|
DAUtil.BindParameter(command, "pIMPORTALT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Importalt, 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, "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, "pEGYEDINAP", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EgyediNap, false);
|
|
|
|
DAUtil.BindParameter(command, "pISKEZZELFELVETTEGYEDINAP", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsKezzelFelvettegyediNap, 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, "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, "pKOZPONTILAGTOROLTORAGROUPID", SDA.DataProvider.SDADBType.Guid, entity.m_KozpontilagToroltOraGroupID, entity.m_KozpontilagToroltOraGroupID == null);
|
|
|
|
DAUtil.BindParameter(command, "pKOZPONTIORAGROUPID", SDA.DataProvider.SDADBType.Guid, entity.m_KozpontiOraGroupId, entity.m_KozpontiOraGroupId == null);
|
|
|
|
DAUtil.BindParameter(command, "pEFOP23517", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP23517, false);
|
|
}
|
|
|
|
public override void DynamicBindAttributes(OrarendiOra entity, SDA.DataProvider.SDACommand command)
|
|
{
|
|
System.Text.StringBuilder sb = new System.Text.StringBuilder();
|
|
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("Hetirend"))
|
|
{
|
|
sb.Append("C_HETIREND = :pHETIREND,");
|
|
|
|
DAUtil.BindParameter(command, "pHETIREND", SDA.DataProvider.SDADBType.Int /* DictionaryItem */, 15, entity.m_Hetirend, false);
|
|
|
|
}
|
|
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("IKTTanora"))
|
|
{
|
|
sb.Append("C_IKTTANORA = :pIKTTANORA,");
|
|
|
|
DAUtil.BindParameter(command, "pIKTTANORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IKTTanora, 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("NemSzakrendszeruOra"))
|
|
{
|
|
sb.Append("C_NEMSZAKRENDSZERUORA = :pNEMSZAKRENDSZERUORA,");
|
|
|
|
DAUtil.BindParameter(command, "pNEMSZAKRENDSZERUORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_NemSzakrendszeruOra, 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("Oraszam"))
|
|
{
|
|
sb.Append("C_ORASZAM = :pORASZAM,");
|
|
|
|
DAUtil.BindParameter(command, "pORASZAM", SDA.DataProvider.SDADBType.Int, entity.m_Oraszam, entity.m_Oraszam == null);
|
|
|
|
}
|
|
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("Tulora"))
|
|
{
|
|
sb.Append("C_TULORA = :pTULORA,");
|
|
|
|
DAUtil.BindParameter(command, "pTULORA", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Tulora, 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("OraErvenyessegKezdete"))
|
|
{
|
|
sb.Append("C_ORAERVENYESSEGKEZDETE = :pORAERVENYESSEGKEZDETE,");
|
|
|
|
DAUtil.BindParameter(command, "pORAERVENYESSEGKEZDETE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraErvenyessegKezdete, false);
|
|
|
|
}
|
|
if (entity.HasChanged("OraErvenyessegVege"))
|
|
{
|
|
sb.Append("C_ORAERVENYESSEGVEGE = :pORAERVENYESSEGVEGE,");
|
|
|
|
DAUtil.BindParameter(command, "pORAERVENYESSEGVEGE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraErvenyessegVege, entity.m_OraErvenyessegVege == null);
|
|
|
|
}
|
|
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("OraKezdete"))
|
|
{
|
|
sb.Append("C_ORAKEZDETE = :pORAKEZDETE,");
|
|
|
|
DAUtil.BindParameter(command, "pORAKEZDETE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraKezdete, entity.m_OraKezdete == null);
|
|
|
|
}
|
|
if (entity.HasChanged("OraVege"))
|
|
{
|
|
sb.Append("C_ORAVEGE = :pORAVEGE,");
|
|
|
|
DAUtil.BindParameter(command, "pORAVEGE", SDA.DataProvider.SDADBType.DateTime, entity.m_OraVege, entity.m_OraVege == null);
|
|
|
|
}
|
|
if (entity.HasChanged("Importalt"))
|
|
{
|
|
sb.Append("C_IMPORTALT = :pIMPORTALT,");
|
|
|
|
DAUtil.BindParameter(command, "pIMPORTALT", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_Importalt, 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("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("EgyediNap"))
|
|
{
|
|
sb.Append("C_EGYEDINAP = :pEGYEDINAP,");
|
|
|
|
DAUtil.BindParameter(command, "pEGYEDINAP", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EgyediNap, false);
|
|
|
|
}
|
|
if (entity.HasChanged("IsKezzelFelvettegyediNap"))
|
|
{
|
|
sb.Append("C_ISKEZZELFELVETTEGYEDINAP = :pISKEZZELFELVETTEGYEDINAP,");
|
|
|
|
DAUtil.BindParameter(command, "pISKEZZELFELVETTEGYEDINAP", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_IsKezzelFelvettegyediNap, 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("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("KozpontilagToroltOraGroupID"))
|
|
{
|
|
sb.Append("C_KOZPONTILAGTOROLTORAGROUPID = :pKOZPONTILAGTOROLTORAGROUPID,");
|
|
|
|
DAUtil.BindParameter(command, "pKOZPONTILAGTOROLTORAGROUPID", SDA.DataProvider.SDADBType.Guid, entity.m_KozpontilagToroltOraGroupID, entity.m_KozpontilagToroltOraGroupID == null);
|
|
|
|
}
|
|
if (entity.HasChanged("KozpontiOraGroupId"))
|
|
{
|
|
sb.Append("C_KOZPONTIORAGROUPID = :pKOZPONTIORAGROUPID,");
|
|
|
|
DAUtil.BindParameter(command, "pKOZPONTIORAGROUPID", SDA.DataProvider.SDADBType.Guid, entity.m_KozpontiOraGroupId, entity.m_KozpontiOraGroupId == null);
|
|
|
|
}
|
|
if (entity.HasChanged("EFOP23517"))
|
|
{
|
|
sb.Append("C_EFOP23517 = :pEFOP23517,");
|
|
|
|
DAUtil.BindParameter(command, "pEFOP23517", SDA.DataProvider.SDADBType.Boolean /* Boolean */, 1, entity.m_EFOP23517, false);
|
|
|
|
}
|
|
command.CommandText = command.CommandText.Replace("{COLUMNS}", sb.ToString());
|
|
}
|
|
|
|
public override void BindAssociations(OrarendiOra entity, SDA.DataProvider.SDACommand command)
|
|
{
|
|
DAUtil.BindIdParameter(command, "pTEREMID", entity.InternalTeremId);
|
|
DAUtil.BindIdParameter(command, "pFOGLALKOZASID", entity.InternalFoglalkozasId);
|
|
DAUtil.BindIdParameter(command, "pTANTARGYID", entity.InternalTantargyId);
|
|
DAUtil.BindIdParameter(command, "pOSZTALYCSOPORTID", entity.InternalOsztalyCsoportId);
|
|
DAUtil.BindIdParameter(command, "pTANARID", entity.InternalTanarId);
|
|
DAUtil.BindIdParameter(command, "pTANEVRENDJEID", entity.InternalTanevRendjeId);
|
|
DAUtil.BindIdParameter(command, "pOGORARENDID", entity.InternalOgOrarendId);
|
|
DAUtil.BindIdParameter(command, "pORATULAJDONOSID", entity.InternalOraTulajdonosId);
|
|
DAUtil.BindIdParameter(command, "pINTEZMENYID", entity.InternalIntezmenyId);
|
|
DAUtil.BindIdParameter(command, "pTANEVID", entity.InternalTanevId);
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
|
|
internal class OrarendiOraDA : EntityDataAccessor<OrarendiOra>
|
|
{
|
|
private static OrarendiOraDBHelper m_dbhelper = new OrarendiOraDBHelper();
|
|
|
|
protected override IEntityDBHelper<OrarendiOra> dbhelper
|
|
{
|
|
get { return m_dbhelper; }
|
|
}
|
|
|
|
#region Load
|
|
|
|
public override bool LoadEntity(OrarendiOra entity, int entityId)
|
|
{
|
|
return LoadById(entity, entityId);
|
|
}
|
|
|
|
public override bool FilteredLoadEntity(OrarendiOra entity, int entityId, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
|
|
{
|
|
return LoadById(entity, entityId, columnFilterMode, columns);
|
|
}
|
|
|
|
public bool LoadById(OrarendiOra entity, int entityId)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = dbhelper.CreateEmptyQueryCommand())
|
|
{
|
|
command.CommandText += " and (T_ORARENDIORA_OSSZES.ID = :pID) ";
|
|
command.Parameters.Add("pID", SDA.DataProvider.SDADBType.Int).Value = entityId;
|
|
return dbhelper.LoadSingleEntity(entity, command);
|
|
}
|
|
}
|
|
|
|
public bool LoadById(OrarendiOra entity, int entityId, ColumnFilterMode columnFilterMode, IEnumerable<string> columns)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = dbhelper.CreateDynamicQueryCommand(columnFilterMode, columns))
|
|
{
|
|
command.CommandText += " and (T_ORARENDIORA_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<OrarendiOra> 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<OrarendiOra> 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_ORARENDIORA_OSSZES (
|
|
C_DIFFERENCIALT,
|
|
C_DRAMA,
|
|
C_HETIREND,
|
|
C_HETNAPJA,
|
|
C_IKTTANORA,
|
|
C_IPRTANORA,
|
|
C_KOOPERATIV,
|
|
C_MERES,
|
|
C_MINDENNAPOSTESTNEVELES,
|
|
C_NEMSZAKRENDSZERUORA,
|
|
C_NEMZETISEGIORA,
|
|
C_ORASZAM,
|
|
C_SORSZAMOZANDO,
|
|
C_TAMOPORA,
|
|
C_TULORA,
|
|
C_BONTOTT,
|
|
C_ORAERVENYESSEGKEZDETE,
|
|
C_ORAERVENYESSEGVEGE,
|
|
C_PARHUZAMOSORA,
|
|
C_TIOP12,
|
|
C_ORAKEZDETE,
|
|
C_ORAVEGE,
|
|
C_IMPORTALT,
|
|
C_CSENGETESIRENDID,
|
|
C_CSENGETESIRENDORAID,
|
|
C_ORARENDIORAGROUPID,
|
|
C_EFOP32317,
|
|
C_MULTIKULTURALISORA,
|
|
C_KOMPLEXORA,
|
|
C_KIPORA,
|
|
C_VEKOP73317,
|
|
C_KAPORA,
|
|
C_GINOP623,
|
|
C_EGYEDINAP,
|
|
C_ISKEZZELFELVETTEGYEDINAP,
|
|
C_EFOP31716,
|
|
C_EFOP33717,
|
|
C_TIOP1111212012001,
|
|
C_ISDFHTKIPORA,
|
|
C_ISDFHTORA,
|
|
C_ISDIGITALISALAPUALPROGRAM,
|
|
C_ISELETGYAKORLATALAPUALPROGRA,
|
|
C_ISLOGIKAALAPUALPROGRAM,
|
|
C_ISMUVESZETALAPUALPROGRAM,
|
|
C_ISRAHANGOLODAS,
|
|
C_ISTEORAD,
|
|
C_ISTESTMOZGASALAPUALPROGRAM,
|
|
C_ISFELNOTTOKTATASISZERZODES,
|
|
C_KOZPONTILAGTOROLTORAGROUPID,
|
|
C_KOZPONTIORAGROUPID,
|
|
C_EFOP23517,
|
|
C_TEREMID,
|
|
C_FOGLALKOZASID,
|
|
C_TANTARGYID,
|
|
C_OSZTALYCSOPORTID,
|
|
C_TANARID,
|
|
C_TANEVRENDJEID,
|
|
C_OGORARENDID,
|
|
C_ORATULAJDONOSID,
|
|
C_INTEZMENYID,
|
|
C_TANEVID,
|
|
TOROLT,
|
|
SERIAL,
|
|
CREATED,
|
|
CREATOR)
|
|
values (
|
|
:pDIFFERENCIALT,
|
|
:pDRAMA,
|
|
:pHETIREND,
|
|
:pHETNAPJA,
|
|
:pIKTTANORA,
|
|
:pIPRTANORA,
|
|
:pKOOPERATIV,
|
|
:pMERES,
|
|
:pMINDENNAPOSTESTNEVELES,
|
|
:pNEMSZAKRENDSZERUORA,
|
|
:pNEMZETISEGIORA,
|
|
:pORASZAM,
|
|
:pSORSZAMOZANDO,
|
|
:pTAMOPORA,
|
|
:pTULORA,
|
|
:pBONTOTT,
|
|
:pORAERVENYESSEGKEZDETE,
|
|
:pORAERVENYESSEGVEGE,
|
|
:pPARHUZAMOSORA,
|
|
:pTIOP12,
|
|
:pORAKEZDETE,
|
|
:pORAVEGE,
|
|
:pIMPORTALT,
|
|
:pCSENGETESIRENDID,
|
|
:pCSENGETESIRENDORAID,
|
|
:pORARENDIORAGROUPID,
|
|
:pEFOP32317,
|
|
:pMULTIKULTURALISORA,
|
|
:pKOMPLEXORA,
|
|
:pKIPORA,
|
|
:pVEKOP73317,
|
|
:pKAPORA,
|
|
:pGINOP623,
|
|
:pEGYEDINAP,
|
|
:pISKEZZELFELVETTEGYEDINAP,
|
|
:pEFOP31716,
|
|
:pEFOP33717,
|
|
:pTIOP1111212012001,
|
|
:pISDFHTKIPORA,
|
|
:pISDFHTORA,
|
|
:pISDIGITALISALAPUALPROGRAM,
|
|
:pISELETGYAKORLATALAPUALPROGRAM,
|
|
:pISLOGIKAALAPUALPROGRAM,
|
|
:pISMUVESZETALAPUALPROGRAM,
|
|
:pISRAHANGOLODAS,
|
|
:pISTEORAD,
|
|
:pISTESTMOZGASALAPUALPROGRAM,
|
|
:pISFELNOTTOKTATASISZERZODES,
|
|
:pKOZPONTILAGTOROLTORAGROUPID,
|
|
:pKOZPONTIORAGROUPID,
|
|
:pEFOP23517,
|
|
:pTEREMID,
|
|
:pFOGLALKOZASID,
|
|
:pTANTARGYID,
|
|
:pOSZTALYCSOPORTID,
|
|
:pTANARID,
|
|
:pTANEVRENDJEID,
|
|
:pOGORARENDID,
|
|
:pORATULAJDONOSID,
|
|
:pINTEZMENYID,
|
|
:pTANEVID,
|
|
:pTOROLT,
|
|
:pSERIAL,
|
|
:pCREATED,
|
|
:pCREATOR);
|
|
|
|
SELECT SCOPE_IDENTITY() as ID;
|
|
|
|
";
|
|
|
|
public override void InsertEntity(OrarendiOra 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_ORARENDIORA_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(OrarendiOra 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_ORARENDIORA_OSSZES WHERE (ID = :pID) ";
|
|
private const string m_LogikaiDeleteCommandText = @"
|
|
UPDATE T_ORARENDIORA_OSSZES
|
|
SET TOROLT = 'T' ,
|
|
SERIAL = SERIAL + 1,
|
|
LASTCHANGED = :pLASTCHANGED,
|
|
MODIFIER = :pMODIFIER
|
|
WHERE (ID = :pID) ";
|
|
|
|
public override void DeleteEntity(OrarendiOra 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("OrarendiOra", entity.ID);
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region UpdateAssociations
|
|
|
|
private const string m_UpdateAssociationCommandText = @"
|
|
update T_ORARENDIORA_OSSZES
|
|
set
|
|
C_TEREMID = :pTEREMID,
|
|
C_FOGLALKOZASID = :pFOGLALKOZASID,
|
|
C_TANTARGYID = :pTANTARGYID,
|
|
C_OSZTALYCSOPORTID = :pOSZTALYCSOPORTID,
|
|
C_TANARID = :pTANARID,
|
|
C_TANEVRENDJEID = :pTANEVRENDJEID,
|
|
C_OGORARENDID = :pOGORARENDID,
|
|
C_ORATULAJDONOSID = :pORATULAJDONOSID,
|
|
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(OrarendiOra 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_LoadByTanitasiOraIdFilter = @" and (exists (select 1 from T_TANITASIORA_OSSZES where C_ORARENDIORAID = T_ORARENDIORA_OSSZES.ID and T_TANITASIORA_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByTanitasiOraId(int id, OrarendiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByTanitasiOraIdFilter, id);
|
|
}
|
|
|
|
// kapcsolómező a másik táblában van, és nem önmagára mutat
|
|
private const string m_LoadByOrarendiOraTulajdonsagIdFilter = @" and (exists (select 1 from T_ORARENDIORATULAJDONSAG_OSSZES where C_ORARENDIORAID = T_ORARENDIORA_OSSZES.ID and T_ORARENDIORATULAJDONSAG_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByOrarendiOraTulajdonsagId(int id, OrarendiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByOrarendiOraTulajdonsagIdFilter, 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_ORARENDIORAID = T_ORARENDIORA_OSSZES.ID and T_HAZIFELADATOK_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByHaziFeladatokId(int id, OrarendiOra 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_LoadByOraFileIdFilter = @" and (exists (select 1 from T_ORAFILE_OSSZES where C_ORARENDIORAID = T_ORARENDIORA_OSSZES.ID and T_ORAFILE_OSSZES.ID = :pID)) ";
|
|
|
|
public bool LoadByOraFileId(int id, OrarendiOra entity)
|
|
{
|
|
return dbhelper.LoadByPartnerId(entity, m_LoadByOraFileIdFilter, id);
|
|
}
|
|
|
|
|
|
#endregion
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Terem -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Terem_OrarendiOra_DA : EntityCollectionDA<Terem, OrarendiOra>
|
|
{
|
|
internal protected Terem_OrarendiOra_DA(Terem owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_TEREMID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TEREMID = :pTEREMID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTEREMID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Terem owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTEREMID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Terem, OrarendiOra>("Terem_OrarendiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TEREMID = null where (C_TEREMID = :pTEREMID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTEREMID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Terem owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTEREMID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Terem, OrarendiOra>("Terem_OrarendiOra");
|
|
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 -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Foglalkozas_OrarendiOra_DA : EntityCollectionDA<Foglalkozas, OrarendiOra>
|
|
{
|
|
internal protected Foglalkozas_OrarendiOra_DA(Foglalkozas owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_FOGLALKOZASID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_FOGLALKOZASID = :pFOGLALKOZASID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pFOGLALKOZASID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Foglalkozas owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFOGLALKOZASID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Foglalkozas>("OrarendiOra_Foglalkozas");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_FOGLALKOZASID = null where (C_FOGLALKOZASID = :pFOGLALKOZASID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pFOGLALKOZASID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Foglalkozas owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFOGLALKOZASID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Foglalkozas>("OrarendiOra_Foglalkozas");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Tantargy -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Tantargy_OrarendiOra_DA : EntityCollectionDA<Tantargy, OrarendiOra>
|
|
{
|
|
internal protected Tantargy_OrarendiOra_DA(Tantargy owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_TANTARGYID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANTARGYID = :pTANTARGYID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANTARGYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Tantargy owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANTARGYID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Tantargy>("OrarendiOra_Tantargy");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANTARGYID = null where (C_TANTARGYID = :pTANTARGYID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANTARGYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Tantargy owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANTARGYID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Tantargy>("OrarendiOra_Tantargy");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'OsztalyCsoport -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class OsztalyCsoport_OrarendiOra_DA : EntityCollectionDA<OsztalyCsoport, OrarendiOra>
|
|
{
|
|
internal protected OsztalyCsoport_OrarendiOra_DA(OsztalyCsoport owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_OSZTALYCSOPORTID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_OSZTALYCSOPORTID = :pOSZTALYCSOPORTID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pOSZTALYCSOPORTID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(OsztalyCsoport owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pOSZTALYCSOPORTID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, OsztalyCsoport>("OrarendiOra_OsztalyCsoport");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_OSZTALYCSOPORTID = null where (C_OSZTALYCSOPORTID = :pOSZTALYCSOPORTID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pOSZTALYCSOPORTID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(OsztalyCsoport owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pOSZTALYCSOPORTID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, OsztalyCsoport>("OrarendiOra_OsztalyCsoport");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Alkalmazott -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Alkalmazott_OrarendiOra_DA : EntityCollectionDA<Alkalmazott, OrarendiOra>
|
|
{
|
|
internal protected Alkalmazott_OrarendiOra_DA(Alkalmazott owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_TANARID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANARID = :pTANARID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANARID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Alkalmazott owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANARID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Alkalmazott>("OrarendiOra_Tanar");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANARID = null where (C_TANARID = :pTANARID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANARID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Alkalmazott owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANARID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Alkalmazott>("OrarendiOra_Tanar");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'FeltoltottFajl -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class FeltoltottFajl_OrarendiOra_DA : EntityCollectionDA<FeltoltottFajl, OrarendiOra>
|
|
{
|
|
internal protected FeltoltottFajl_OrarendiOra_DA(FeltoltottFajl owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Kapcsolótábla van
|
|
private const string m_Filter = @" and (exists (select 1 from T_FELTOLTOTTFAJL_ORARENDIORA where C_ORARENDIORAID = T_ORARENDIORA_OSSZES.ID and C_FELTOLTOTTFAJLID = :pID)) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// kapcsolótábla van...
|
|
result.CommandText = @"insert into T_FELTOLTOTTFAJL_ORARENDIORA (C_FELTOLTOTTFAJLID, C_ORARENDIORAID) values (:pFELTOLTOTTFAJLID, :pORARENDIORAID)";
|
|
result.Parameters.Add("pFELTOLTOTTFAJLID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(FeltoltottFajl owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFELTOLTOTTFAJLID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<FeltoltottFajl, OrarendiOra>("FeltoltottFajl_OrarendiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// kapcsolótábla van...
|
|
result.CommandText = @"delete from T_FELTOLTOTTFAJL_ORARENDIORA where (C_FELTOLTOTTFAJLID = :pFELTOLTOTTFAJLID) and (C_ORARENDIORAID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pFELTOLTOTTFAJLID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(FeltoltottFajl owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pFELTOLTOTTFAJLID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<FeltoltottFajl, OrarendiOra>("FeltoltottFajl_OrarendiOra");
|
|
assochandler.BeforeDelete(this.Owner, entity);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(this.Owner, entity);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'TanevRendje -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class TanevRendje_OrarendiOra_DA : EntityCollectionDA<TanevRendje, OrarendiOra>
|
|
{
|
|
internal protected TanevRendje_OrarendiOra_DA(TanevRendje owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_TANEVRENDJEID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANEVRENDJEID = :pTANEVRENDJEID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANEVRENDJEID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(TanevRendje owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANEVRENDJEID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, TanevRendje>("OrarendiOra_TanevRendje");
|
|
assochandler.BeforeInsert(entity, this.Owner);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(entity, this.Owner);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANEVRENDJEID = null where (C_TANEVRENDJEID = :pTANEVRENDJEID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANEVRENDJEID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(TanevRendje owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANEVRENDJEID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, TanevRendje>("OrarendiOra_TanevRendje");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
this.DoRemove(this.Owner, entity);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'OgOrarend -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class OgOrarend_OrarendiOra_DA : EntityCollectionDA<OgOrarend, OrarendiOra>
|
|
{
|
|
internal protected OgOrarend_OrarendiOra_DA(OgOrarend owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_OGORARENDID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_OGORARENDID = :pOGORARENDID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pOGORARENDID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(OgOrarend owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pOGORARENDID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OgOrarend, OrarendiOra>("OgOrarend_OrarendiOra");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_OGORARENDID = null where (C_OGORARENDID = :pOGORARENDID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pOGORARENDID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(OgOrarend owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pOGORARENDID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OgOrarend, OrarendiOra>("OgOrarend_OrarendiOra");
|
|
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 -> OrarendiOra (OrarendiOrai)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Felhasznalo_OrarendiOrai_DA : EntityCollectionDA<Felhasznalo, OrarendiOra>
|
|
{
|
|
internal protected Felhasznalo_OrarendiOrai_DA(Felhasznalo owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_ORATULAJDONOSID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraiCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_ORATULAJDONOSID = :pORATULAJDONOSID where (ID = :pORARENDIORAIID)";
|
|
result.Parameters.Add("pORATULAJDONOSID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAIID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Felhasznalo owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraiCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pORATULAJDONOSID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAIID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Felhasznalo, OrarendiOra>("OraTulajdonos_OrarendiOrai");
|
|
assochandler.BeforeInsert(this.Owner, entity);
|
|
this.DoAdd(this.Owner, entity);
|
|
assochandler.AfterInsert(this.Owner, entity);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateDeleteOrarendiOraiCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_ORATULAJDONOSID = null where (C_ORATULAJDONOSID = :pORATULAJDONOSID and ID = :pORARENDIORAIID)";
|
|
result.Parameters.Add("pORATULAJDONOSID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAIID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Felhasznalo owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraiCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pORATULAJDONOSID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAIID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<Felhasznalo, OrarendiOra>("OraTulajdonos_OrarendiOrai");
|
|
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 -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Intezmeny_OrarendiOra_DA : EntityCollectionDA<Intezmeny, OrarendiOra>
|
|
{
|
|
internal protected Intezmeny_OrarendiOra_DA(Intezmeny owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_INTEZMENYID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_INTEZMENYID = :pINTEZMENYID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pINTEZMENYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Intezmeny owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pINTEZMENYID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Intezmeny>("OrarendiOra_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 CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_INTEZMENYID = null where (C_INTEZMENYID = :pINTEZMENYID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pINTEZMENYID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Intezmeny owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pINTEZMENYID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Intezmeny>("OrarendiOra_Intezmeny");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
entity.Delete(true);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// Az osztály elvégzi az UML modell 'Tanev -> OrarendiOra (OrarendiOra)'
|
|
/// asszociációjának teljes kezelését.
|
|
/// </summary>
|
|
internal class Tanev_OrarendiOra_DA : EntityCollectionDA<Tanev, OrarendiOra>
|
|
{
|
|
internal protected Tanev_OrarendiOra_DA(Tanev owner)
|
|
: base(owner)
|
|
{
|
|
}
|
|
|
|
// Nincs kapcsolótábla
|
|
private const string m_Filter = @" and (T_ORARENDIORA_OSSZES.C_TANEVID = :pID) ";
|
|
|
|
public override void LoadCollection(IAssociatedEntityCollection<OrarendiOra> collection)
|
|
{
|
|
new OrarendiOraDBHelper().LoadByPartnerId(collection, m_Filter, Owner.ID);
|
|
}
|
|
|
|
private static SDA.DataProvider.SDACommand CreateInsertOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANEVID = :pTANEVID where (ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANEVID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoAdd(Tanev owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateInsertOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANEVID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void AddItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Tanev>("OrarendiOra_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 CreateDeleteOrarendiOraCommand()
|
|
{
|
|
SDA.DataProvider.SDACommand result = new SDA.DataProvider.SDACommand();
|
|
// nincs kapcsolótábla...
|
|
result.CommandText = @"update T_ORARENDIORA_OSSZES set C_TANEVID = null where (C_TANEVID = :pTANEVID and ID = :pORARENDIORAID)";
|
|
result.Parameters.Add("pTANEVID", SDA.DataProvider.SDADBType.Int);
|
|
result.Parameters.Add("pORARENDIORAID", SDA.DataProvider.SDADBType.Int);
|
|
return result;
|
|
}
|
|
|
|
private void DoRemove(Tanev owner, OrarendiOra partner)
|
|
{
|
|
using (SDA.DataProvider.SDACommand command = CreateDeleteOrarendiOraCommand())
|
|
{
|
|
command.Connection = UserContext.Instance.SDAConnection;
|
|
command.Transaction = UserContext.Instance.SDATransaction;
|
|
command.Parameters["pTANEVID"].Value = owner.ID;
|
|
command.Parameters["pORARENDIORAID"].Value = partner.ID;
|
|
command.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
public override void DeleteItem(OrarendiOra entity)
|
|
{
|
|
var assochandler = AssociationHandlerManager.Create<OrarendiOra, Tanev>("OrarendiOra_Tanev");
|
|
assochandler.BeforeDelete(entity, this.Owner);
|
|
entity.Delete(true);
|
|
assochandler.AfterDelete(entity, this.Owner);
|
|
}
|
|
}
|
|
|
|
}
|
|
|