public DataSet ndihdNewsSelectDispsetFiltered(DBInt bVisibleForVisitor,
DBInt bVisibleForRegistered,
DBInt bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdNewsSelectDispsetFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@bVisibleForVisitor", SqlDbType.Int);
p1.Value = bVisibleForVisitor.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bVisibleForRegistered", SqlDbType.Int);
p2.Value = bVisibleForRegistered.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p3.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, bVisibleForVisitor.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdKefEventSelectFiltered(DBInt bIsActive,
DBGuid uOrganisationRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefEventSelectFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p1.Value = bIsActive.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.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, bIsActive.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdKefWebDataSelectByRank(DBInt nLinkRank,
DBString cKefCategoryRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdKefWebDataSelectByRank]");
SqlParameter p1 = sqlComm.Parameters.Add("@nLinkRank", SqlDbType.Int);
p1.Value = nLinkRank.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cKefCategoryRef", SqlDbType.Char, 10);
p2.Value = cKefCategoryRef.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, nLinkRank.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdCounterUpdate(DBInt nID,
DBInt nCount)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdCounterUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@nCount", SqlDbType.Int);
p2.Value = nCount.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nID.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdForumGroupSelectFiltered(DBInt bVisibleForVisitor,
DBInt bVisibleForRegistered,
DBInt bIsActive,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdForumGroupSelectFiltered]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@bVisibleForVisitor", SqlDbType.Int);
p1.Value = bVisibleForVisitor.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bVisibleForRegistered", SqlDbType.Int);
p2.Value = bVisibleForRegistered.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Int);
p3.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, bVisibleForVisitor.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public void ndihdDistrictSearchCodeOfOrganisationDeleteBy(DBInt nDistrictSearchCodeRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdDistrictSearchCodeOfOrganisationDeleteBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCodeRef", SqlDbType.Int);
p1.Value = nDistrictSearchCodeRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nDistrictSearchCodeRef.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdCounterUpdate(DBInt nID,
DBInt nCount,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdCounterUpdate]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@nCount", SqlDbType.Int);
p2.Value = nCount.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public DataSet ndihdEventSelect(DBInt nID,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventSelect]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.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, nID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public void ndihdEventUpdate(DBInt nID,
DBDateTime dTimeStamp,
DBString cSeverity,
DBString cSource,
DBString cMethod,
DBString cThreadInfo,
DBString cWindowsIdentity,
DBString cPrincipalName,
DBString cMessage)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@dTimeStamp", SqlDbType.DateTime);
p2.Value = dTimeStamp.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cSeverity", SqlDbType.VarChar, 32);
p3.Value = cSeverity.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cSource", SqlDbType.VarChar, 128);
p4.Value = cSource.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cMethod", SqlDbType.VarChar, 128);
p5.Value = cMethod.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cThreadInfo", SqlDbType.VarChar, 128);
p6.Value = cThreadInfo.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cWindowsIdentity", SqlDbType.VarChar, 64);
p7.Value = cWindowsIdentity.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cPrincipalName", SqlDbType.VarChar, 64);
p8.Value = cPrincipalName.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cMessage", SqlDbType.VarChar, 512);
p9.Value = cMessage.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nID.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdEventPropertyInsert(DBInt nEventID,
DBString cName,
DBString cValue,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventPropertyInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nEventID", SqlDbType.Int);
p1.Value = nEventID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cValue", SqlDbType.VarChar, 4000);
p3.Value = cValue.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nEventID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public void ndihdEventPropertyUpdate(DBInt nEventID,
DBString cName,
DBString cValue)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventPropertyUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nEventID", SqlDbType.Int);
p1.Value = nEventID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 50);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cValue", SqlDbType.VarChar, 4000);
p3.Value = cValue.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nEventID.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdEventPropertyDeleteBy(DBInt nEventID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEventPropertyDeleteBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@nEventID", SqlDbType.Int);
p1.Value = nEventID.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nEventID.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdDistrictSearchUpdate(DBInt nDistrictSearchCode,
DBString cDistrictDescription)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdDistrictSearchUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCode", SqlDbType.Int);
p1.Value = nDistrictSearchCode.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cDistrictDescription", SqlDbType.VarChar, 50);
p2.Value = cDistrictDescription.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nDistrictSearchCode.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdDistrictSearchInsert(DBInt nDistrictSearchCode,
DBString cDistrictDescription,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdDistrictSearchInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCode", SqlDbType.Int);
p1.Value = nDistrictSearchCode.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cDistrictDescription", SqlDbType.VarChar, 50);
p2.Value = cDistrictDescription.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nDistrictSearchCode.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public DataSet ndihdJobOfferSelectFiltered(DBInt nRefId,
DBGuid uID,
DBString cLogin,
DBString cDescription,
DBString cMessage,
DBString cRequirements,
DBString cCity,
DBString cRegionRef,
DBString cQualificationMinRef,
DBString cStatus,
DBInt bActivityPrevention,
DBInt bActivityResearch,
DBInt bActivityRehabilitation,
DBInt bActivityOther,
DBInt bNoticationSend,
DBDateTime dExpireDate,
DBDateTime dNotificationDate,
DBDateTime dExpireDateExpired)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdJobOfferSelectFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@nRefId", SqlDbType.Int);
p1.Value = nRefId.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p2.Value = uID.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cLogin", SqlDbType.VarChar, 500);
p3.Value = cLogin.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 100);
p4.Value = cDescription.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cMessage", SqlDbType.VarChar, 100);
p5.Value = cMessage.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cRequirements", SqlDbType.VarChar, 100);
p6.Value = cRequirements.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cCity", SqlDbType.VarChar, 100);
p7.Value = cCity.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cRegionRef", SqlDbType.Char, 10);
p8.Value = cRegionRef.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cQualificationMinRef", SqlDbType.Char, 10);
p9.Value = cQualificationMinRef.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cStatus", SqlDbType.Char, 3);
p10.Value = cStatus.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@bActivityPrevention", SqlDbType.Int);
p11.Value = bActivityPrevention.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@bActivityResearch", SqlDbType.Int);
p12.Value = bActivityResearch.Value;
SqlParameter p13 = sqlComm.Parameters.Add("@bActivityRehabilitation", SqlDbType.Int);
p13.Value = bActivityRehabilitation.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@bActivityOther", SqlDbType.Int);
p14.Value = bActivityOther.Value;
SqlParameter p15 = sqlComm.Parameters.Add("@bNoticationSend", SqlDbType.Int);
p15.Value = bNoticationSend.Value;
SqlParameter p16 = sqlComm.Parameters.Add("@dExpireDate", SqlDbType.DateTime);
p16.Value = dExpireDate.Value;
SqlParameter p17 = sqlComm.Parameters.Add("@dNotificationDate", SqlDbType.DateTime);
p17.Value = dNotificationDate.Value;
SqlParameter p18 = sqlComm.Parameters.Add("@dExpireDateExpired", SqlDbType.DateTime);
p18.Value = dExpireDateExpired.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, nRefId.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdCounterSelect(DBInt nID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdCounterSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@nID", SqlDbType.Int);
p1.Value = nID.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, nID.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdOrganisationSelectKefListFilteredByDistrictCode(DBInt nDistrictSearchCodeRef,
bool bIsActive,
bool bIsKef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationSelectKefListFilteredByDistrictCode]");
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCodeRef", SqlDbType.Int);
p1.Value = nDistrictSearchCodeRef.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, nDistrictSearchCodeRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdDistrictSearchCodeOfOrganisationDeleteBy(DBInt nDistrictSearchCodeRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdDistrictSearchCodeOfOrganisationDeleteBy]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@nDistrictSearchCodeRef", SqlDbType.Int);
p1.Value = nDistrictSearchCodeRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, nDistrictSearchCodeRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}