// -------------------------------------------------------------------------------------
 /// <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;
 }

 /// <summary>
 /// Default constructor (new)
 /// </summary>
 public frmTemplateEdit()
 {
     // Required for Windows Form Designer support
       InitializeComponent();
       m_CurrentTemplateID = new DBGuid();
       m_insert = true;
 }

        public int KefMembersCountByType(DBGuid OrganisationID, string ContactType)
        {
            TraceCallEnterEvent.Raise();
              try
              {
            int result = 0;
            DataSet entitySet = m_DataContext.ndihdOrgOwnMemberSelectCountByType(OrganisationID, ContactType);

            if (entitySet.Tables.Count > 0)
            {
              if (entitySet.Tables[0].Rows.Count > 0)
              {
            result = Convert.ToInt32(entitySet.Tables[0].Rows[0]["db"]);
              }
            }

            TraceCallReturnEvent.Raise();

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

 // -------------------------------------------------------------------------------------
 /// <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 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="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>
 /// Default constructor (new)
 /// </summary>
 public frmTemplatePageEdit(DBGuid TemplateId, TemplatePageContainer ExistingPages)
 {
     // Required for Windows Form Designer support
       InitializeComponent();
       m_TemplateID = TemplateId;
       m_ExistingPages = ExistingPages;
 }

 public virtual void DeleteChildrenByAttachmentOfJobOffer(DBGuid IDVal)
 {
     TraceCallEnterEvent.Raise();
       try
       {
     m_DataContext.BeginNestedTran();
     try
     {
       m_DataContext.ndihdAttachmentOfJobOfferDeleteBy(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)
 {
 }

 public virtual void DeleteChildrenByDetailOfPendingQuestionForm(DBGuid IDVal)
 {
     TraceCallEnterEvent.Raise();
       try
       {
     m_DataContext.BeginNestedTran();
     try
     {
       m_DataContext.ndihdDetailOfPendingQuestionFormDeleteBy(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="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="TemplateRefVal">Value of 'uTemplateRef' field</param>
 /// <param name="PageIndexVal">Value of 'nPageIndex' field</param>
 // -------------------------------------------------------------------------------------
 public TemplatePageBase(DBGuid TemplateRefVal,
                     DBInt PageIndexVal)
 {
     ResetExceptions();
       m_TemplateRef = TemplateRefVal;
       m_PageIndex = PageIndexVal;
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="OrganisationRefVal">Value of 'uOrganisationRef' field</param>
 /// <param name="ProgramRefVal">Value of 'uProgramRef' field</param>
 // -------------------------------------------------------------------------------------
 public ProgramPartnerBase(DBGuid OrganisationRefVal,
                       DBGuid ProgramRefVal)
 {
     ResetExceptions();
       m_OrganisationRef = OrganisationRefVal;
       m_ProgramRef = ProgramRefVal;
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="WordIDVal">Value of 'uWordID' field</param>
 /// <param name="RefWordIdVal">Value of 'uRefWordId' field</param>
 // -------------------------------------------------------------------------------------
 public DictionaryAssocBase(DBGuid WordIDVal,
                        DBGuid RefWordIdVal)
 {
     ResetExceptions();
       m_WordID = WordIDVal;
       m_RefWordId = RefWordIdVal;
 }

 // -------------------------------------------------------------------------------------
 /// <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;
 }

 // -------------------------------------------------------------------------------------
 /// <summary>
 /// Primary key based constructor
 /// </summary>
 /// <param name="ExpertRefVal">Value of 'uExpertRef' field</param>
 /// <param name="ProgramRefVal">Value of 'uProgramRef' field</param>
 // -------------------------------------------------------------------------------------
 public ProgramParticipantBase(DBGuid ExpertRefVal,
                           DBGuid ProgramRefVal)
 {
     ResetExceptions();
       m_ExpertRef = ExpertRefVal;
       m_ProgramRef = ProgramRefVal;
 }

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

        /// <summary>
        /// 
        /// </summary>
        private void CreateControl(DBGuid id, string name)
        {
            //Létrehozzuk a lista controlt és hozzáadjuk a contrlok közzé
              DataListControl control;
              control = (DataListControl) LoadControl("Controls/DataListControl.ascx");

              //pnlOtherDb.Controls.Add(control);
              //Controls.Add(control);

              IEDocumentService srvEDoc = ServiceFactory.GetEDocumentService();
              Ndi.HelpDesk.BusinessDocuments.EDocument filter = new Ndi.HelpDesk.BusinessDocuments.EDocument(Guid.Empty);
              filter.TypeRef = EDocumentTypeEnum.KDB;
              filter.CategoryRef = id;
              filter.Title = Helpers.CreateLikeSearchText(txtName.Text);
              if (Context.User.Identity.IsAuthenticated)
              {
            filter.FilterOnVisibleForRegistered = 1;
            filter.FilterOnVisibleForVisitor = DBInt.Null;
              }
              else
              {
            filter.FilterOnVisibleForRegistered = DBInt.Null;
            filter.FilterOnVisibleForVisitor = 1;
              }

              DataSet eOtherDoc = srvEDoc.EDocumentSelectFiltered(filter, 0);

              control.Caption = name;
              control.DataSource = eOtherDoc;
              pnlOtherDb.Controls.Add(control);
        }

 /// <summary>
 /// Edit constructor
 /// </summary>
 public frmDocumentCategoryEdit(DBGuid ID)
 {
     // Required for Windows Form Designer support
       InitializeComponent();
       m_UpdateAction = true;
       CurrentID = ID;
       pHeader.Text2 = "Kategória szerkesztése";
 }

        public frmForumItemEdit(DBGuid ID)
        {
            // Required for Windows Form Designer support
              InitializeComponent();

              CurrentID = ID;
              m_ForumThreadRef = DBGuid.Null;
        }