protected void Page_Load(object sender, EventArgs e)
        {
            //lekérdezzzük a kategóriához tartozó fejléc és részletes adatokat
              IKefWebDataService srvKefWebData = ServiceFactory.GetKefWebDataService();
              DBString category = new DBString("DROG_STRAT");

              KefWebDataContainer contKefWebData = srvKefWebData.KefCategoryOfKefWebDataSelectByIsActive(category, 1);

              if (contKefWebData.All.Count > 0) //ha van aktív adat az oldalhoz
              {
            KefWebData kefData = (KefWebData) contKefWebData.All.Items[0];

            lblDescription.Text = kefData.Description.ToString();
            lblTitle.Text = kefData.Title.ToString();
            lblSubTitle.Text = kefData.SubTitle.ToString().ToUpper();

            //lekérdezzük a mellékleteket is
            KefDownloadContainer contKefDownl = srvKefWebData.SelectChildrenByKefWebDataOfKefDownload(kefData.ID);

            RepeaterControl.DataSource = contKefDownl.AllAsDatatable;
            RepeaterControl.DataBind();

            if (contKefDownl.AllCount > 0) RepeaterControl.Visible = true;
            else RepeaterControl.Visible = false;
              }
        }

 public virtual void DeleteChildrenByKefContactTypeOfMember(DBString IDVal)
 {
     TraceCallEnterEvent.Raise();
       try
       {
     m_DataContext.BeginNestedTran();
     try
     {
       m_DataContext.ndihdKefContactTypeOfMemberDeleteBy(IDVal);
       m_DataContext.CommitNested();
     }
     catch
     {
       m_DataContext.RollbackNested();
       throw;
     }
     TraceCallReturnEvent.Raise();
     return;
       }
       catch (Exception ex)
       {
     ExceptionManager.Publish(ex);
     TraceCallReturnEvent.Raise(false);
     throw;
       }
 }

        public bool CheckProgramExistByName(DBString programName, DBGuid organizationRef, DBGuid programID)
        {
            TraceCallEnterEvent.Raise();
              try
              {
            Program result = null;
            DataSet entitySet = m_DataContext.ndihdProgramSelectByName(
              programName,
              organizationRef,
              programID);

            if (entitySet.Tables[0].Rows.Count != 0)
            {
              result = new Program(entitySet);
            }

            TraceCallReturnEvent.Raise();

            if (result != null)
            {
              return true;
            }

            return false;
              }
              catch (Exception ex)
              {
            ExceptionManager.Publish(ex);
            TraceCallReturnEvent.Raise(false);
            throw;
              }
        }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="KeywordRefVal">Value of 'cKeywordRef' field</param>
 /// <param name="ProgramRefVal">Value of 'uProgramRef' field</param>
 // -------------------------------------------------------------------------------------
 public ProgramKeywordBase(DBString KeywordRefVal,
                       DBGuid ProgramRefVal)
 {
     ResetExceptions();
       m_KeywordRef = KeywordRefVal;
       m_ProgramRef = ProgramRefVal;
 }

 public virtual void DeleteChildrenByWorkingAreaOfOrganisation(DBString IDVal)
 {
     TraceCallEnterEvent.Raise();
       try
       {
     m_DataContext.BeginNestedTran();
     try
     {
       m_DataContext.ndihdWorkingAreaOfOrganisationDeleteBy(IDVal);
       m_DataContext.CommitNested();
     }
     catch
     {
       m_DataContext.RollbackNested();
       throw;
     }
     TraceCallReturnEvent.Raise();
     return;
       }
       catch (Exception ex)
       {
     ExceptionManager.Publish(ex);
     TraceCallReturnEvent.Raise(false);
     throw;
       }
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="JobRefVal">Value of 'uJobRef' field</param>
 /// <param name="TypeVal">Value of 'cType' field</param>
 /// <param name="SubscriberNameRefVal">Value of 'cSubscriberNameRef' field</param>
 /// <param name="SenderNameRefVal">Value of 'cSenderNameRef' field</param>
 // -------------------------------------------------------------------------------------
 public JobAnswer(DBGuid JobRefVal,
              DBString TypeVal,
              DBString SubscriberNameRefVal,
              DBString SenderNameRefVal)
     : base(JobRefVal, TypeVal, SubscriberNameRefVal, SenderNameRefVal)
 {
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="ProgramRefVal">Value of 'uProgramRef' field</param>
 /// <param name="RegionRefVal">Value of 'cRegionRef' field</param>
 // -------------------------------------------------------------------------------------
 public ProgramRegionBase(DBGuid ProgramRefVal,
                      DBString RegionRefVal)
 {
     ResetExceptions();
       m_ProgramRef = ProgramRefVal;
       m_RegionRef = RegionRefVal;
 }

 public void AddEvent(DBDateTime dTimeStamp, DBString cSeverity, DBString cSource, DBString cMethod,
                  DBString cThreadInfo, DBString cWindowsIdentity, DBString cPrincipalName, DBString cMessage,
                  out int retVal)
 {
     SqlCommand command1 = base.PrepareSPCall("aeAddEvent");
       SqlParameter parameter1 = command1.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
       parameter1.Direction = ParameterDirection.ReturnValue;
       SqlParameter parameter2 = command1.Parameters.Add("@dTimeStamp", SqlDbType.DateTime);
       parameter2.Value = dTimeStamp.Value;
       SqlParameter parameter3 = command1.Parameters.Add("@cSeverity", SqlDbType.VarChar, 0x20);
       parameter3.Value = cSeverity.Value;
       SqlParameter parameter4 = command1.Parameters.Add("@cSource", SqlDbType.VarChar, 0x80);
       parameter4.Value = cSource.Value;
       SqlParameter parameter5 = command1.Parameters.Add("@cMethod", SqlDbType.VarChar, 0x80);
       parameter5.Value = cMethod.Value;
       SqlParameter parameter6 = command1.Parameters.Add("@cThreadInfo", SqlDbType.VarChar, 0x80);
       parameter6.Value = cThreadInfo.Value;
       SqlParameter parameter7 = command1.Parameters.Add("@cWindowsIdentity", SqlDbType.VarChar, 0x40);
       parameter7.Value = cWindowsIdentity.Value;
       SqlParameter parameter8 = command1.Parameters.Add("@cPrincipalName", SqlDbType.VarChar, 0x40);
       parameter8.Value = cPrincipalName.Value;
       SqlParameter parameter9 = command1.Parameters.Add("@cMessage", SqlDbType.VarChar, 0x200);
       parameter9.Value = cMessage.Value;
       try
       {
     command1.ExecuteNonQuery();
       }
       finally
       {
     base.FinishSPCall();
       }
       retVal = (int) parameter1.Value;
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="TemplateRefVal">Value of 'uTemplateRef' field</param>
 /// <param name="ProgramCategoryRefVal">Value of 'cProgramCategoryRef' field</param>
 // -------------------------------------------------------------------------------------
 public TemplateCategoryBase(DBGuid TemplateRefVal,
                         DBString ProgramCategoryRefVal)
 {
     ResetExceptions();
       m_TemplateRef = TemplateRefVal;
       m_ProgramCategoryRef = ProgramCategoryRefVal;
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="IDRefVal">Value of 'uIDRef' field</param>
 /// <param name="SearchCategoryRefVal">Value of 'cSearchCategoryRef' field</param>
 // -------------------------------------------------------------------------------------
 public GlobalSearchBase(DBGuid IDRefVal,
                     DBString SearchCategoryRefVal)
 {
     ResetExceptions();
       m_IDRef = IDRefVal;
       m_SearchCategoryRef = SearchCategoryRefVal;
 }

   public void ndihdAttachementOfUserDeleteBy(DBString cLoginNameRef,
 out int retVal)
   {
       TraceCallEnterEvent.Raise();
         SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdAttachementOfUserDeleteBy]");
         SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
         returnValue.Direction = ParameterDirection.ReturnValue;
         SqlParameter p1 = sqlComm.Parameters.Add("@cLoginNameRef", SqlDbType.VarChar, 50);
         p1.Value = cLoginNameRef.Value;
         TraceDbCommandEvent.Raise(sqlComm);
         try
         {
       sqlComm.ExecuteNonQuery();
       TraceCallReturnEvent.Raise();
         }
         catch (SqlException e)
         {
       TraceCallReturnEvent.Raise(false);
       SqlErrorHandler.Handle(e, cLoginNameRef.ToString());
         }
         finally
         {
       FinishSPCall();
         }
         retVal = (int)returnValue.Value;
         TraceInfoEvent.Raise("RetVal: {0}", retVal);
   }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="OrganisationRefVal">Value of 'uOrganisationRef' field</param>
 /// <param name="LoginNameRefVal">Value of 'cLoginNameRef' field</param>
 // -------------------------------------------------------------------------------------
 public OrganisationUserBase(DBGuid OrganisationRefVal,
                         DBString LoginNameRefVal)
 {
     ResetExceptions();
       m_OrganisationRef = OrganisationRefVal;
       m_LoginNameRef = LoginNameRefVal;
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="EventIDVal">Value of 'nEventID' field</param>
 /// <param name="NameVal">Value of 'cName' field</param>
 // -------------------------------------------------------------------------------------
 public EventPropertyBase(DBInt EventIDVal,
                      DBString NameVal)
 {
     ResetExceptions();
       m_EventID = EventIDVal;
       m_Name = NameVal;
 }

        public frmUserChangePassword(DBString ID)
        {
            // Required for Windows Form Designer support
              InitializeComponent();

              CurrentID = ID;
        }

 public virtual void DeleteChildrenByAttachementOfUser(DBString LoginNameVal)
 {
     TraceCallEnterEvent.Raise();
       try
       {
     m_DataContext.BeginNestedTran();
     try
     {
       m_DataContext.ndihdAttachementOfUserDeleteBy(LoginNameVal);
       m_DataContext.CommitNested();
     }
     catch
     {
       m_DataContext.RollbackNested();
       throw;
     }
     TraceCallReturnEvent.Raise();
     return;
       }
       catch (Exception ex)
       {
     ExceptionManager.Publish(ex);
     TraceCallReturnEvent.Raise(false);
     throw;
       }
 }

 public virtual void DeleteChildrenByTemplateDetailOfPendingQuestionFormDetail(DBString IDVal,
                                                                           DBGuid TemplateRefVal)
 {
     TraceCallEnterEvent.Raise();
       try
       {
     m_DataContext.BeginNestedTran();
     try
     {
       m_DataContext.ndihdTemplateDetailOfPendingQuestionFormDetailDeleteBy(IDVal,
                                                                        TemplateRefVal);
       m_DataContext.CommitNested();
     }
     catch
     {
       m_DataContext.RollbackNested();
       throw;
     }
     TraceCallReturnEvent.Raise();
     return;
       }
       catch (Exception ex)
       {
     ExceptionManager.Publish(ex);
     TraceCallReturnEvent.Raise(false);
     throw;
       }
 }

        /// <summary>
        /// Edit constructor
        /// </summary>
        public frmLanguageEdit(DBString ID)
        {
            // Required for Windows Form Designer support
              InitializeComponent();

              CurrentID = ID;
              pHeader.Text2 = "Nyelv szerkesztése";
        }

 /// <summary>
 /// New constructor
 /// </summary>
 public frmThesaurusEdit()
 {
     // Required for Windows Form Designer support
       InitializeComponent();
       CurrentID = new DBString();
       m_bNewItem = true;
       m_bReadOnly = false;
       pHeader.Text2 = "Új tezaurusz létrehozása";
 }

   // -------------------------------------------------------------------------------------
   /// <summary>
   /// Primary key based constructor
   /// </summary>
   /// <param name="ProgramCategoryRefVal">Value of 'cProgramCategoryRef' field</param>
   /// <param name="ProgramRefVal">Value of 'uProgramRef' field</param>
   /// <param name="QuestionFormRefVal">Value of 'uQuestionFormRef' field</param>
   // -------------------------------------------------------------------------------------
   public ProgramQuestionFormBase(DBString ProgramCategoryRefVal,
 DBGuid ProgramRefVal,
 DBGuid QuestionFormRefVal)
       : base()
   {
       ResetExceptions();
         m_ProgramCategoryRef = ProgramCategoryRefVal;
         m_ProgramRef = ProgramRefVal;
         m_QuestionFormRef = QuestionFormRefVal;
   }

   // -------------------------------------------------------------------------------------
   /// <summary>
   /// Primary key based constructor
   /// </summary>
   /// <param name="QuestionFormRefVal">Value of 'uQuestionFormRef' field</param>
   /// <param name="TemplateDetailRefVal">Value of 'cTemplateDetailRef' field</param>
   /// <param name="TemplateRefVal">Value of 'uTemplateRef' field</param>
   // -------------------------------------------------------------------------------------
   public PendingQuestionFormDetailBase(DBGuid QuestionFormRefVal,
 DBString TemplateDetailRefVal,
 DBGuid TemplateRefVal)
       : base()
   {
       ResetExceptions();
         m_QuestionFormRef = QuestionFormRefVal;
         m_TemplateDetailRef = TemplateDetailRefVal;
         m_TemplateRef = TemplateRefVal;
   }