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>
/// Default constructor (new)
/// </summary>
public frmLanguageEdit()
{
// Required for Windows Form Designer support
InitializeComponent();
CurrentID = new DBString();
//m_IsNewLanguage = true;
pHeader.Text2 = "Új nyelv 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;
}
/// <summary>
/// Edit constructor
/// </summary>
public frmThesaurusEdit(DBString ID)
{
// Required for Windows Form Designer support
InitializeComponent();
CurrentID = ID;
m_bNewItem = false;
m_bReadOnly = false;
pHeader.Text2 = "Tezaurusz szerkesztése";
txtKeyword.ReadOnly = true;
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Primary key based constructor
/// </summary>
/// <param name="ProgramCategoryRefVal">Value of 'cProgramCategoryRef' field</param>
/// <param name="OrganisationRefVal">Value of 'uOrganisationRef' field</param>
/// <param name="QuestionFormRefVal">Value of 'uQuestionFormRef' field</param>
// -------------------------------------------------------------------------------------
public OrganisationQuestionFormBase(DBString ProgramCategoryRefVal,
DBGuid OrganisationRefVal,
DBGuid QuestionFormRefVal)
: base()
{
ResetExceptions();
m_ProgramCategoryRef = ProgramCategoryRefVal;
m_OrganisationRef = OrganisationRefVal;
m_QuestionFormRef = QuestionFormRefVal;
}
protected void Page_Load(object sender, EventArgs e)
{
//lekérdezzzük a kategóriához tartozó fejléc és részletes adatokat
DBString strCategory = new DBString("LINKEK");
IKefWebDataService srvKefWebData = ServiceFactory.GetKefWebDataService();
KefWebDataContainer contKefWebData = srvKefWebData.KefCategoryOfKefWebDataSelectByIsActive(strCategory, 1);
RepeaterControl.DataSource = contKefWebData.All.Items;
RepeaterControl.DataBind();
}
public EDocumentContainer SelectChildrenByTypeOfEDocumentVisibleForVisitor(DBString IDVal)
{
EDocumentContainer all = SelectChildrenByTypeOfEDocument(IDVal);
EDocumentContainer result = new EDocumentContainer();
foreach (EDocument item in all.All)
{
if (item.IsActive && item.VisibleForVisitor)
{
result.Add(item);
}
}
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
IKefWebDataService srvKefWebData = ServiceFactory.GetKefWebDataService();
DBString category = new DBString("BEMUTAT");
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();
lblSubTitle.Text = kefData.SubTitle.ToString().ToUpper();
lblTitle.Text = kefData.Title.ToString();
}
}
private string MakeHomePageUrl(DBString url)
{
DBString kefWebUrl = "";
if (!url.IsNull && url.Length > 0)
{
kefWebUrl = url;
if (!kefWebUrl.StartsWith(@"http://") && !kefWebUrl.StartsWith(@"https://"))
{
kefWebUrl = @"http://" + kefWebUrl;
}
}
return kefWebUrl;
}
protected void Page_Load(object sender, EventArgs e)
{
//ha nincs megadva ID listázzuk az összes dokumentumot
if (Request["ID"] == null)
{
//lekérdezzzük a kategóriához tartozó fejléc és részletes adatokat
IKefWebDataService srvKefWebData = ServiceFactory.GetKefWebDataService();
DBString category = new DBString("SZAKANYAG");
KefWebDataContainer contKefWebData = srvKefWebData.KefCategoryOfKefWebDataSelectByIsActive(category, 1);
if (contKefWebData.All.Count > 0) //ha van aktív adat az oldalhoz
{
RepeaterControl.DataSource = contKefWebData.AllAsDatatable;
RepeaterControl.DataBind();
}
}
else
{
Guid assistanceID = new Guid(Request["ID"]);
//lekérdezzük a ID -hez tartozó szakmai támogatas részletes adatait
IKefWebDataService srvKefWebData = ServiceFactory.GetKefWebDataService();
KefWebData kef = srvKefWebData.KefWebDataSelect(assistanceID);
lblAssTitle.Text = kef.Title;
lblAssSubTitle.Text = kef.SubTitle;
lblAssDescription.Text = kef.Description;
lblAssTitle.Visible = true;
lblAssSubTitle.Visible = true;
lblAssDescription.Visible = true;
//lekérdezzül a hozzá tartotó doksikat
KefDownloadContainer contKefDownl = srvKefWebData.SelectChildrenByKefWebDataOfKefDownload(assistanceID);
RepeaterDownloadControl.DataSource = contKefDownl.AllAsDatatable;
RepeaterDownloadControl.DataBind();
if (contKefDownl.AllCount > 0) RepeaterDownloadControl.Visible = true;
else RepeaterDownloadControl.Visible = false;
}
}
public void AddEventProperty(DBInt nEventID, DBString cName, DBString cValue, out int retVal)
{
SqlCommand command1 = base.PrepareSPCall("aeAddEventProperty");
SqlParameter parameter1 = command1.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
parameter1.Direction = ParameterDirection.ReturnValue;
SqlParameter parameter2 = command1.Parameters.Add("@nEventID", SqlDbType.Int);
parameter2.Value = nEventID.Value;
SqlParameter parameter3 = command1.Parameters.Add("@cName", SqlDbType.VarChar, 0x20);
parameter3.Value = cName.Value;
SqlParameter parameter4 = command1.Parameters.Add("@cValue", SqlDbType.VarChar, 0xfa0);
parameter4.Value = cValue.Value;
try
{
command1.ExecuteNonQuery();
}
finally
{
base.FinishSPCall();
}
retVal = (int) parameter1.Value;
}
protected void Page_Load(object sender, EventArgs e)
{
IKefWebDataService srvKefWebData = ServiceFactory.GetKefWebDataService();
DBString category = new DBString("NDI");
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();
lblSubTitle.Text = kefData.SubTitle.ToString().ToUpper();
lblTitle.Text = kefData.Title.ToString();
lnkNdi.Text = kefData.Link.ToString();
if (!kefData.Link.IsNull && kefData.Link.Length > 0)
{
lnkNdi.Text = kefData.Link;
lnkNdi.NavigateUrl = kefData.Link;
if (lnkNdi != null)
{
lnkNdi.Visible = true;
if (!lnkNdi.Text.StartsWith(@"http://") && !lnkNdi.Text.StartsWith(@"https://"))
{
lnkNdi.NavigateUrl = @"http://" + lnkNdi.Text;
}
}
if (lnkNdi.Text.StartsWith(@"http://")) lnkNdi.Text = lnkNdi.Text.Substring(7);
if (lnkNdi.Text.StartsWith(@"https://")) lnkNdi.Text = lnkNdi.Text.Substring(8);
}
else
{
lnkNdi.Visible = false;
}
}
}
