public void ndihdQualificationUpdate(DBString cID,
DBString cName,
bool bIsActive,
DBInt nOrder,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdQualificationUpdate]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p3.Value = bIsActive;
SqlParameter p4 = sqlComm.Parameters.Add("@nOrder", SqlDbType.Int);
p4.Value = nOrder.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public DataSet ndihdJobOfferSelectBySubscriber(DBString cLogin,
DBString cType)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdJobOfferSelectBySubscriber]");
SqlParameter p1 = sqlComm.Parameters.Add("@cLogin", SqlDbType.VarChar, 500);
p1.Value = cLogin.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cType", SqlDbType.Char, 3);
p2.Value = cType.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cLogin.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdOrganisationFormSelect(DBString cID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationFormSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdOrganisationFormDelete(DBString cID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationFormDelete]");
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdOrganisationFormDelete(DBString cID,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationFormDelete]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public void ndihdOrganisationSelectFilteredForCsv(DBString cName,
DBString cRegionRef,
DBString cOrganisationFormRef,
DBInt bActivityPrevention,
DBInt bActivityResearch,
DBInt bActivityRehabilitation,
DBInt bActivityOther,
DBInt bIsActive,
DBInt bIsKef,
DBString cValidationState)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationSelectFilteredForCsv]");
SqlParameter p1 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p1.Value = cName.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cRegionRef", SqlDbType.Char, 10);
p2.Value = cRegionRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cOrganisationFormRef", SqlDbType.Char, 10);
p3.Value = cOrganisationFormRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@bActivityPrevention", SqlDbType.Int);
p4.Value = bActivityPrevention.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@bActivityResearch", SqlDbType.Int);
p5.Value = bActivityResearch.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@bActivityRehabilitation", SqlDbType.Int);
p6.Value = bActivityRehabilitation.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@bActivityOther", SqlDbType.Int);
p7.Value = bActivityOther.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p8.Value = bIsActive.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@bIsKef", SqlDbType.Int);
p9.Value = bIsKef.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cValidationState", SqlDbType.NVarChar, 50);
p10.Value = cValidationState.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cName.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdOrganisationQuestionFormUpdate(DBString cProgramCategoryRef,
DBGuid uOrganisationRef,
DBGuid uQuestionFormRef,
bool bIsActual,
DBDateTime dLastModifiedByUser,
DBDateTime dLastValidationDate)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationQuestionFormUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@bIsActual", SqlDbType.Bit);
p4.Value = bIsActual;
SqlParameter p5 = sqlComm.Parameters.Add("@dLastModifiedByUser", SqlDbType.DateTime);
p5.Value = dLastModifiedByUser.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@dLastValidationDate", SqlDbType.DateTime);
p6.Value = dLastValidationDate.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdOrganisationQuestionFormInsert(DBString cProgramCategoryRef,
DBGuid uOrganisationRef,
DBGuid uQuestionFormRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationQuestionFormInsert]");
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdProgramKeywordSelect(DBString cKeywordRef,
DBGuid uProgramRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramKeywordSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@cKeywordRef", SqlDbType.VarChar, 100);
p1.Value = cKeywordRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p2.Value = uProgramRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cKeywordRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdProgramKeywordInsert(DBString cKeywordRef,
DBGuid uProgramRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramKeywordInsert]");
SqlParameter p1 = sqlComm.Parameters.Add("@cKeywordRef", SqlDbType.VarChar, 100);
p1.Value = cKeywordRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p2.Value = uProgramRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cKeywordRef.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdProgramCategoryUpdate(DBString cId,
DBString cName,
DBString cDescription,
DBString cTypeOfEntity)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramCategoryUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@cId", SqlDbType.Char, 3);
p1.Value = cId.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 500);
p3.Value = cDescription.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cTypeOfEntity", SqlDbType.Char, 1);
p4.Value = cTypeOfEntity.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cId.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdProgramCategoryInsert(DBString cId,
DBString cName,
DBString cDescription,
DBString cTypeOfEntity,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramCategoryInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cId", SqlDbType.Char, 3);
p1.Value = cId.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 500);
p3.Value = cDescription.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cTypeOfEntity", SqlDbType.Char, 1);
p4.Value = cTypeOfEntity.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cId.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public void ndihdKefContactTypeUpdate(DBString cID,
DBString cName,
bool bMultiple,
DBInt nRank)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefContactTypeUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bMultiple", SqlDbType.Bit);
p3.Value = bMultiple;
SqlParameter p4 = sqlComm.Parameters.Add("@nRank", SqlDbType.Int);
p4.Value = nRank.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdKefContactTypeOfMembers(DBString cKefContactTypeRef,
DBGuid uOrganisationKefRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefContactTypeOfMembers]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cKefContactTypeRef", SqlDbType.Char, 10);
p1.Value = cKefContactTypeRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationKefRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationKefRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cKefContactTypeRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public DataSet ndihdKefCategoryOfKefWebDataSelectByIsActive(DBString cKefCategoryRef,
DBInt bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefCategoryOfKefWebDataSelectByIsActive]");
SqlParameter p1 = sqlComm.Parameters.Add("@cKefCategoryRef", SqlDbType.Char, 10);
p1.Value = cKefCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p2.Value = bIsActive.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cKefCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdQualificationOfUserDeleteBy(DBString cQualificationRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdQualificationOfUserDeleteBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@cQualificationRef", SqlDbType.Char, 10);
p1.Value = cQualificationRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cQualificationRef.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdOrganisationQuestionFormDelete(DBString cProgramCategoryRef,
DBGuid uOrganisationRef,
DBGuid uQuestionFormRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationQuestionFormDelete]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public DataSet ndihdProgramQuestionFormSelect(DBString cProgramCategoryRef,
DBGuid uProgramRef,
DBGuid uQuestionFormRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramQuestionFormSelect]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p2.Value = uProgramRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public DataSet ndihdOrganisationQuestionFormSelect(DBString cProgramCategoryRef,
DBGuid uOrganisationRef,
DBGuid uQuestionFormRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationQuestionFormSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdProgramQuestionFormUpdate(DBString cProgramCategoryRef,
DBGuid uProgramRef,
DBGuid uQuestionFormRef,
DBDateTime dLastModifiedDate,
DBDateTime dDecidedDate)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramQuestionFormUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p1.Value = cProgramCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p2.Value = uProgramRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p3.Value = uQuestionFormRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@dLastModifiedDate", SqlDbType.DateTime);
p4.Value = dLastModifiedDate.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@dDecidedDate", SqlDbType.DateTime);
p5.Value = dDecidedDate.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cProgramCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdOrganisationSelectFiltered(DBString cName,
DBString cRegionRef,
DBString cOrganisationFormRef,
DBInt bActivityPrevention,
DBInt bActivityResearch,
DBInt bActivityRehabilitation,
DBInt bActivityOther,
DBInt bIsActive,
DBInt bIsKef,
DBString cValidationState,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationSelectFiltered]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p1.Value = cName.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cRegionRef", SqlDbType.Char, 10);
p2.Value = cRegionRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cOrganisationFormRef", SqlDbType.Char, 10);
p3.Value = cOrganisationFormRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@bActivityPrevention", SqlDbType.Int);
p4.Value = bActivityPrevention.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@bActivityResearch", SqlDbType.Int);
p5.Value = bActivityResearch.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@bActivityRehabilitation", SqlDbType.Int);
p6.Value = bActivityRehabilitation.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@bActivityOther", SqlDbType.Int);
p7.Value = bActivityOther.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p8.Value = bIsActive.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@bIsKef", SqlDbType.Int);
p9.Value = bIsKef.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cValidationState", SqlDbType.NVarChar, 50);
p10.Value = cValidationState.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cName.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public DataSet ndihdProgramSelectByKeywordForRtf(DBString cKeyword1,
DBString cRelation1,
DBString cKeyword2,
DBString cRelation2,
DBString cKeyword3,
DBString cRelation3,
DBString cKeyword4)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramSelectByKeywordForRtf]");
SqlParameter p1 = sqlComm.Parameters.Add("@cKeyword1", SqlDbType.VarChar, 100);
p1.Value = cKeyword1.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cRelation1", SqlDbType.VarChar, 10);
p2.Value = cRelation1.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cKeyword2", SqlDbType.VarChar, 100);
p3.Value = cKeyword2.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cRelation2", SqlDbType.VarChar, 10);
p4.Value = cRelation2.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cKeyword3", SqlDbType.VarChar, 100);
p5.Value = cKeyword3.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cRelation3", SqlDbType.VarChar, 10);
p6.Value = cRelation3.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cKeyword4", SqlDbType.VarChar, 100);
p7.Value = cKeyword4.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cKeyword1.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdOrganisationSelectKefListFilteredByRegCode(DBString cRegionSearchCodeRef,
bool bIsActive,
bool bIsKef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationSelectKefListFilteredByRegCode]");
SqlParameter p1 = sqlComm.Parameters.Add("@cRegionSearchCodeRef", SqlDbType.Char, 10);
p1.Value = cRegionSearchCodeRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p2.Value = bIsActive;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsKef", SqlDbType.Bit);
p3.Value = bIsKef;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cRegionSearchCodeRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdProgramSelectByName(DBString cName,
DBGuid uOrganisationId,
DBGuid uProgramId)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramSelectByName]");
SqlParameter p1 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p1.Value = cName.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationId", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationId.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uProgramId", SqlDbType.UniqueIdentifier);
p3.Value = uProgramId.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cName.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdOrganisationUserSelectRights(DBString cLoginNameRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationUserSelectRights]");
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);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cLoginNameRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public DataSet ndihdProgramSelectFilteredForRtf(DBString cName,
DBGuid uOrganisationRef,
DBString cProgramCategoryRef,
DBInt bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramSelectFilteredForRtf]");
SqlParameter p1 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p1.Value = cName.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 10);
p3.Value = cProgramCategoryRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p4.Value = bIsActive.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cName.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdOrganisationFormInsert(DBString cID,
DBString cName,
bool bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationFormInsert]");
SqlParameter p1 = sqlComm.Parameters.Add("@cID", SqlDbType.Char, 10);
p1.Value = cID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p3.Value = bIsActive;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cID.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdProgramSelectFreeTextForRtf(DBString cSearchKey,
DBString cProgramCategoryRef,
DBInt nMaxPublicityLevel,
DBInt bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramSelectFreeTextForRtf]");
SqlParameter p1 = sqlComm.Parameters.Add("@cSearchKey", SqlDbType.VarChar, 250);
p1.Value = cSearchKey.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p2.Value = cProgramCategoryRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@nMaxPublicityLevel", SqlDbType.Int);
p3.Value = nMaxPublicityLevel.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p4.Value = bIsActive.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cSearchKey.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
/// <summary>
/// Remove a keyword from the program.
/// </summary>
private void RemoveThesaurus()
{
DBString ID = new DBString();
ID = Convert.ToString(dtgThesaurusDetail.GetSelectedRowCell("Keyword"));
if (ID.IsNull)
{
MessageBox.Show("Válasszon eltávolítani kívánt vezérszót a listában!", "NDI HelpDesk Adminisztrátor",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
try
{
// Logical undelete source item
Thesaurus selected = (Thesaurus) m_allDataThes[ID.ToString()];
m_allDataThes.Undelete(selected);
// Refresh grids
FillDatagridThesaurus(DBString.Null);
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a vezérszó eltávolítása során.", ex);
}
}
public DataSet ndihdQualificationOfRegisterUserSelectBy(DBString cQualificationRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdQualificationOfRegisterUserSelectBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@cQualificationRef", SqlDbType.Char, 10);
p1.Value = cQualificationRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
DataSet Result = new DataSet();
try
{
SqlDataAdapter sqlAdapt = new SqlDataAdapter(sqlComm);
sqlAdapt.Fill(Result);
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, cQualificationRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}