public DataSet ndihdEDocumentSelectDispsetTop(DBGuid uCategoryRef,
DBString cTypeRef,
DBInt nShowMaxCount,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdEDocumentSelectDispsetTop]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@uCategoryRef", SqlDbType.UniqueIdentifier);
p1.Value = uCategoryRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cTypeRef", SqlDbType.Char, 10);
p2.Value = cTypeRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@nShowMaxCount", SqlDbType.Int);
p3.Value = nShowMaxCount.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, uCategoryRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public void ndihdProgramUpdate(DBGuid uID,
DBString cName,
DBString cDescription,
DBString cStartDate,
DBString cFinishDate,
DBString cProgramStatus,
DBString cNonregisteredPartners,
DBString cProgramCategoryRef,
DBGuid uOrganisationRef,
DBGuid uResponsibleRef,
DBGuid uCoordinator1Ref,
DBGuid uCoordinator2Ref,
bool bIsActive,
DBDateTime dLastModifiedDate)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 5000);
p3.Value = cDescription.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cStartDate", SqlDbType.Char, 50);
p4.Value = cStartDate.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cFinishDate", SqlDbType.Char, 50);
p5.Value = cFinishDate.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cProgramStatus", SqlDbType.Char, 10);
p6.Value = cProgramStatus.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cNonregisteredPartners", SqlDbType.Text);
p7.Value = cNonregisteredPartners.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cProgramCategoryRef", SqlDbType.Char, 3);
p8.Value = cProgramCategoryRef.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p9.Value = uOrganisationRef.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@uResponsibleRef", SqlDbType.UniqueIdentifier);
p10.Value = uResponsibleRef.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@uCoordinator1Ref", SqlDbType.UniqueIdentifier);
p11.Value = uCoordinator1Ref.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@uCoordinator2Ref", SqlDbType.UniqueIdentifier);
p12.Value = uCoordinator2Ref.Value;
SqlParameter p13 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p13.Value = bIsActive;
SqlParameter p14 = sqlComm.Parameters.Add("@dLastModifiedDate", SqlDbType.DateTime);
p14.Value = dLastModifiedDate.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Constructor
/// </summary>
// -------------------------------------------------------------------------------------
public frmProgramEdit(DBGuid ID)
{
// Required for Windows Form Designer support
InitializeComponent();
CurrentID = ID;
m_sCurrentID = ID.ToString();
}
public DataSet ndihdPendingQuestionFormOfProgramSelectBy(DBGuid uProgramRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormOfProgramSelectBy]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p1.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, uProgramRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public void ndihdPendingQuestionFormOfProgramDeleteBy(DBGuid uProgramRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormOfProgramDeleteBy]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p1.Value = uProgramRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uProgramRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public DataSet ndihdPendingQuestionFormOfOrganisationSelectBy(DBGuid uOrganisationRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormOfOrganisationSelectBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p1.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, uOrganisationRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdPendingQuestionFormDetailUpdate(DBGuid uQuestionFormRef,
DBString cTemplateDetailRef,
DBGuid uTemplateRef,
DBString cAnswer)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormDetailUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p1.Value = uQuestionFormRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cTemplateDetailRef", SqlDbType.VarChar, 50);
p2.Value = cTemplateDetailRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uTemplateRef", SqlDbType.UniqueIdentifier);
p3.Value = uTemplateRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cAnswer", SqlDbType.Text);
p4.Value = cAnswer.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uQuestionFormRef.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdPendingQuestionFormDetailInsert(DBGuid uQuestionFormRef,
DBString cTemplateDetailRef,
DBGuid uTemplateRef,
DBString cAnswer,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormDetailInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p1.Value = uQuestionFormRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cTemplateDetailRef", SqlDbType.VarChar, 50);
p2.Value = cTemplateDetailRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uTemplateRef", SqlDbType.UniqueIdentifier);
p3.Value = uTemplateRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cAnswer", SqlDbType.Text);
p4.Value = cAnswer.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uQuestionFormRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public DataSet ndihdOrganisationSelectKefMembers(DBGuid uOrganisationKefRef,
DBInt bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationSelectKefMembers]");
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationKefRef", SqlDbType.UniqueIdentifier);
p1.Value = uOrganisationKefRef.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, uOrganisationKefRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdOrganisationAttachmentUpdate(DBGuid uID,
DBGuid uOrganisationRef,
DBString cPath,
DBString cName,
DBString cDescription,
DBString cAuthor,
DBString cPublisher,
DBString cPublishedYear,
DBString cKeywords,
DBDateTime dCreatedDate,
DBInt nFileSize,
bool bIsActive,
DBString cKefFileTypeRef,
DBInt nRank)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationAttachmentUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cPath", SqlDbType.VarChar, 500);
p3.Value = cPath.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p4.Value = cName.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 1000);
p5.Value = cDescription.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cAuthor", SqlDbType.VarChar, 1000);
p6.Value = cAuthor.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cPublisher", SqlDbType.VarChar, 500);
p7.Value = cPublisher.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cPublishedYear", SqlDbType.Char, 4);
p8.Value = cPublishedYear.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cKeywords", SqlDbType.VarChar, 100);
p9.Value = cKeywords.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@dCreatedDate", SqlDbType.DateTime);
p10.Value = dCreatedDate.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@nFileSize", SqlDbType.Int);
p11.Value = nFileSize.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p12.Value = bIsActive;
SqlParameter p13 = sqlComm.Parameters.Add("@cKefFileTypeRef", SqlDbType.Char, 10);
p13.Value = cKefFileTypeRef.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@nRank", SqlDbType.Int);
p14.Value = nRank.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdOrganisationPendingUserUpdate(DBGuid uID,
DBGuid uOrganisationRef,
DBString cLoginNameRef,
DBString cRight,
DBString cStatus,
DBDateTime dSentDate,
DBString cDecidedBy,
DBDateTime dDecidedDate,
DBString cRejectComment)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationPendingUserUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cLoginNameRef", SqlDbType.VarChar, 50);
p3.Value = cLoginNameRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cRight", SqlDbType.Char, 1);
p4.Value = cRight.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cStatus", SqlDbType.Char, 3);
p5.Value = cStatus.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@dSentDate", SqlDbType.DateTime);
p6.Value = dSentDate.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cDecidedBy", SqlDbType.VarChar, 50);
p7.Value = cDecidedBy.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@dDecidedDate", SqlDbType.DateTime);
p8.Value = dDecidedDate.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cRejectComment", SqlDbType.VarChar, 1000);
p9.Value = cRejectComment.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdOrganisationPendingUserSelectFiltered(DBGuid uOrganisationRef,
DBString cLoginNameRef,
DBString cRight,
DBString cStatus)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationPendingUserSelectFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p1.Value = uOrganisationRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cLoginNameRef", SqlDbType.VarChar, 50);
p2.Value = cLoginNameRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cRight", SqlDbType.Char, 1);
p3.Value = cRight.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cStatus", SqlDbType.Char, 3);
p4.Value = cStatus.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, uOrganisationRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdOrganisationAttachmentSelectFiltered(DBGuid uOrganisationRef,
bool bIsStrategy,
bool bIsOtherDocument,
bool bIsOrgAttachment)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationAttachmentSelectFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p1.Value = uOrganisationRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bIsStrategy", SqlDbType.Bit);
p2.Value = bIsStrategy;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsOtherDocument", SqlDbType.Bit);
p3.Value = bIsOtherDocument;
SqlParameter p4 = sqlComm.Parameters.Add("@bIsOrgAttachment", SqlDbType.Bit);
p4.Value = bIsOrgAttachment;
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, uOrganisationRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdOrganisationPendingQuestionFormUpdate(DBGuid uOrganisationRef,
DBGuid uPendingQuestionFormRef,
bool bIsActual,
DBDateTime dLastModifiedByUser,
DBDateTime dLastValidationDate)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationPendingQuestionFormUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p1.Value = uOrganisationRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uPendingQuestionFormRef", SqlDbType.UniqueIdentifier);
p2.Value = uPendingQuestionFormRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@bIsActual", SqlDbType.Bit);
p3.Value = bIsActual;
SqlParameter p4 = sqlComm.Parameters.Add("@dLastModifiedByUser", SqlDbType.DateTime);
p4.Value = dLastModifiedByUser.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@dLastValidationDate", SqlDbType.DateTime);
p5.Value = dLastValidationDate.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uOrganisationRef.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdOrgOwnMemberUpdate(DBGuid uID,
DBGuid uOrganisationKefRef,
DBString cOrganisationName,
DBString cOrganisationDepartment,
DBString cOrganisationPostCode,
DBString cOrganisationCity,
DBString cOrganisationAddress,
DBString cContactName,
DBString cContactType,
DBString cContactPosition,
DBString cContactPositionInKef,
DBString cContactQualification,
DBString cMailingInstitution,
DBString cMailingZipCode,
DBString cMailingTownShip,
DBString cMailingAddress,
DBString cContactPhone1,
DBString cContactPhone2,
DBString cContactPhone3,
DBString cContactFax,
DBString cContactEmail1,
DBString cContactEmail2,
DBString cContactEmail3)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrgOwnMemberUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationKefRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationKefRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cOrganisationName", SqlDbType.VarChar, 250);
p3.Value = cOrganisationName.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cOrganisationDepartment", SqlDbType.VarChar, 250);
p4.Value = cOrganisationDepartment.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cOrganisationPostCode", SqlDbType.VarChar, 10);
p5.Value = cOrganisationPostCode.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cOrganisationCity", SqlDbType.VarChar, 100);
p6.Value = cOrganisationCity.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cOrganisationAddress", SqlDbType.VarChar, 100);
p7.Value = cOrganisationAddress.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cContactName", SqlDbType.VarChar, 250);
p8.Value = cContactName.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cContactType", SqlDbType.VarChar, 100);
p9.Value = cContactType.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cContactPosition", SqlDbType.VarChar, 250);
p10.Value = cContactPosition.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@cContactPositionInKef", SqlDbType.VarChar, 250);
p11.Value = cContactPositionInKef.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@cContactQualification", SqlDbType.VarChar, 250);
p12.Value = cContactQualification.Value;
SqlParameter p13 = sqlComm.Parameters.Add("@cMailingInstitution", SqlDbType.VarChar, 250);
p13.Value = cMailingInstitution.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@cMailingZipCode", SqlDbType.VarChar, 250);
p14.Value = cMailingZipCode.Value;
SqlParameter p15 = sqlComm.Parameters.Add("@cMailingTownShip", SqlDbType.VarChar, 250);
p15.Value = cMailingTownShip.Value;
SqlParameter p16 = sqlComm.Parameters.Add("@cMailingAddress", SqlDbType.VarChar, 250);
p16.Value = cMailingAddress.Value;
SqlParameter p17 = sqlComm.Parameters.Add("@cContactPhone1", SqlDbType.VarChar, 20);
p17.Value = cContactPhone1.Value;
SqlParameter p18 = sqlComm.Parameters.Add("@cContactPhone2", SqlDbType.VarChar, 20);
p18.Value = cContactPhone2.Value;
SqlParameter p19 = sqlComm.Parameters.Add("@cContactPhone3", SqlDbType.VarChar, 20);
p19.Value = cContactPhone3.Value;
SqlParameter p20 = sqlComm.Parameters.Add("@cContactFax", SqlDbType.VarChar, 20);
p20.Value = cContactFax.Value;
SqlParameter p21 = sqlComm.Parameters.Add("@cContactEmail1", SqlDbType.VarChar, 250);
p21.Value = cContactEmail1.Value;
SqlParameter p22 = sqlComm.Parameters.Add("@cContactEmail2", SqlDbType.VarChar, 250);
p22.Value = cContactEmail2.Value;
SqlParameter p23 = sqlComm.Parameters.Add("@cContactEmail3", SqlDbType.VarChar, 250);
p23.Value = cContactEmail3.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdOrganisationUpdate(DBGuid uID,
DBString cName,
DBString cDepartment,
DBString cPostCode,
DBString cCity,
DBString cAddress,
DBString cRegionRef,
DBString cCountry,
DBString cMailingPostCode,
DBString cMailingCity,
DBString cMailingAddress,
DBString cPhone1,
DBString cPhone2,
DBString cPhone3,
DBString cPhoneDiscounted,
DBString cFax,
DBString cEmail1,
DBString cEmail2,
DBString cEmail3,
DBString cHomePage,
DBString cContactName,
DBString cContactPhone,
DBString cContactEmail,
DBString cDescription,
DBString cCallingHours,
DBString cOrganisationFormRef,
DBDouble nSourceGovernment,
DBDouble nSourceCompetition,
DBDouble nSourceSponsor,
DBDouble nSourceDonation,
DBDouble nSourceTax,
DBDouble nSourceOther,
DBString cSourceOtherName,
DBString cEstablishmentYear,
bool bActivityPrevention,
bool bActivityResearch,
bool bActivityRehabilitation,
bool bActivityOther,
DBString cWorkingAreaRef,
DBString cWorkingAreaOther,
DBInt nWorkersFix,
DBInt nWorkersExternal,
DBInt nWorkersVolunteer,
bool bIsActive,
DBInt nJobPsychologist,
DBInt nJobPsychiater,
DBInt nJobDoctor,
DBInt nJobMedicalExpert,
DBInt nJobHealthExpert,
DBInt nJobSociologist,
DBInt nJobSocialPolitician,
DBInt nJobSocialWorker,
DBInt nJobSocialPedagogist,
DBInt nJobPedagogist,
DBInt nJobManualist,
DBInt nJobLawyer,
DBInt nJobPoliceman,
DBInt nJobMentalhygiene,
DBInt nJobCultureOrganizer,
DBInt nJobOther1,
DBInt nJobOther2,
DBInt nJobOther3,
DBString cJobOtherName1,
DBString cJobOtherName2,
DBString cJobOtherName3,
bool bIsKef,
DBString cRegionSearchCodeRef,
DBInt nDistrictSearchCodeRef,
DBString cIntroduceText,
DBString cDrogStrategyDescription,
DBString cAreaDescription,
DBString cEstablishmentMonth,
DBString cAreaHomePage,
DBDateTime dLastModified,
DBDateTime dIntroduceTextLastModified,
DBDateTime dAreaDescriptionLastModified,
DBDateTime dDrogStrategyLastModified,
DBDateTime dKefMembersLastModified,
DBDateTime dKefDownloadsLastModified,
DBDateTime dKefEventsLastModified,
DBString cValidationState,
DBDateTime dLastValidationDate,
bool bIsActual)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cName", SqlDbType.VarChar, 250);
p2.Value = cName.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cDepartment", SqlDbType.VarChar, 250);
p3.Value = cDepartment.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cPostCode", SqlDbType.VarChar, 10);
p4.Value = cPostCode.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cCity", SqlDbType.VarChar, 100);
p5.Value = cCity.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cAddress", SqlDbType.VarChar, 100);
p6.Value = cAddress.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cRegionRef", SqlDbType.Char, 10);
p7.Value = cRegionRef.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cCountry", SqlDbType.VarChar, 100);
p8.Value = cCountry.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cMailingPostCode", SqlDbType.VarChar, 10);
p9.Value = cMailingPostCode.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cMailingCity", SqlDbType.VarChar, 100);
p10.Value = cMailingCity.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@cMailingAddress", SqlDbType.VarChar, 100);
p11.Value = cMailingAddress.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@cPhone1", SqlDbType.VarChar, 20);
p12.Value = cPhone1.Value;
SqlParameter p13 = sqlComm.Parameters.Add("@cPhone2", SqlDbType.VarChar, 20);
p13.Value = cPhone2.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@cPhone3", SqlDbType.VarChar, 20);
p14.Value = cPhone3.Value;
SqlParameter p15 = sqlComm.Parameters.Add("@cPhoneDiscounted", SqlDbType.VarChar, 20);
p15.Value = cPhoneDiscounted.Value;
SqlParameter p16 = sqlComm.Parameters.Add("@cFax", SqlDbType.VarChar, 20);
p16.Value = cFax.Value;
SqlParameter p17 = sqlComm.Parameters.Add("@cEmail1", SqlDbType.VarChar, 250);
p17.Value = cEmail1.Value;
SqlParameter p18 = sqlComm.Parameters.Add("@cEmail2", SqlDbType.VarChar, 250);
p18.Value = cEmail2.Value;
SqlParameter p19 = sqlComm.Parameters.Add("@cEmail3", SqlDbType.VarChar, 250);
p19.Value = cEmail3.Value;
SqlParameter p20 = sqlComm.Parameters.Add("@cHomePage", SqlDbType.VarChar, 250);
p20.Value = cHomePage.Value;
SqlParameter p21 = sqlComm.Parameters.Add("@cContactName", SqlDbType.VarChar, 250);
p21.Value = cContactName.Value;
SqlParameter p22 = sqlComm.Parameters.Add("@cContactPhone", SqlDbType.VarChar, 20);
p22.Value = cContactPhone.Value;
SqlParameter p23 = sqlComm.Parameters.Add("@cContactEmail", SqlDbType.VarChar, 250);
p23.Value = cContactEmail.Value;
SqlParameter p24 = sqlComm.Parameters.Add("@cDescription", SqlDbType.VarChar, 1000);
p24.Value = cDescription.Value;
SqlParameter p25 = sqlComm.Parameters.Add("@cCallingHours", SqlDbType.VarChar, 1000);
p25.Value = cCallingHours.Value;
SqlParameter p26 = sqlComm.Parameters.Add("@cOrganisationFormRef", SqlDbType.Char, 10);
p26.Value = cOrganisationFormRef.Value;
SqlParameter p27 = sqlComm.Parameters.Add("@nSourceGovernment", SqlDbType.Float);
p27.Value = nSourceGovernment.Value;
SqlParameter p28 = sqlComm.Parameters.Add("@nSourceCompetition", SqlDbType.Float);
p28.Value = nSourceCompetition.Value;
SqlParameter p29 = sqlComm.Parameters.Add("@nSourceSponsor", SqlDbType.Float);
p29.Value = nSourceSponsor.Value;
SqlParameter p30 = sqlComm.Parameters.Add("@nSourceDonation", SqlDbType.Float);
p30.Value = nSourceDonation.Value;
SqlParameter p31 = sqlComm.Parameters.Add("@nSourceTax", SqlDbType.Float);
p31.Value = nSourceTax.Value;
SqlParameter p32 = sqlComm.Parameters.Add("@nSourceOther", SqlDbType.Float);
p32.Value = nSourceOther.Value;
SqlParameter p33 = sqlComm.Parameters.Add("@cSourceOtherName", SqlDbType.VarChar, 100);
p33.Value = cSourceOtherName.Value;
SqlParameter p34 = sqlComm.Parameters.Add("@cEstablishmentYear", SqlDbType.Char, 4);
p34.Value = cEstablishmentYear.Value;
SqlParameter p35 = sqlComm.Parameters.Add("@bActivityPrevention", SqlDbType.Bit);
p35.Value = bActivityPrevention;
SqlParameter p36 = sqlComm.Parameters.Add("@bActivityResearch", SqlDbType.Bit);
p36.Value = bActivityResearch;
SqlParameter p37 = sqlComm.Parameters.Add("@bActivityRehabilitation", SqlDbType.Bit);
p37.Value = bActivityRehabilitation;
SqlParameter p38 = sqlComm.Parameters.Add("@bActivityOther", SqlDbType.Bit);
p38.Value = bActivityOther;
SqlParameter p39 = sqlComm.Parameters.Add("@cWorkingAreaRef", SqlDbType.Char, 10);
p39.Value = cWorkingAreaRef.Value;
SqlParameter p40 = sqlComm.Parameters.Add("@cWorkingAreaOther", SqlDbType.VarChar, 500);
p40.Value = cWorkingAreaOther.Value;
SqlParameter p41 = sqlComm.Parameters.Add("@nWorkersFix", SqlDbType.Int);
p41.Value = nWorkersFix.Value;
SqlParameter p42 = sqlComm.Parameters.Add("@nWorkersExternal", SqlDbType.Int);
p42.Value = nWorkersExternal.Value;
SqlParameter p43 = sqlComm.Parameters.Add("@nWorkersVolunteer", SqlDbType.Int);
p43.Value = nWorkersVolunteer.Value;
SqlParameter p44 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p44.Value = bIsActive;
SqlParameter p45 = sqlComm.Parameters.Add("@nJobPsychologist", SqlDbType.Int);
p45.Value = nJobPsychologist.Value;
SqlParameter p46 = sqlComm.Parameters.Add("@nJobPsychiater", SqlDbType.Int);
p46.Value = nJobPsychiater.Value;
SqlParameter p47 = sqlComm.Parameters.Add("@nJobDoctor", SqlDbType.Int);
p47.Value = nJobDoctor.Value;
SqlParameter p48 = sqlComm.Parameters.Add("@nJobMedicalExpert", SqlDbType.Int);
p48.Value = nJobMedicalExpert.Value;
SqlParameter p49 = sqlComm.Parameters.Add("@nJobHealthExpert", SqlDbType.Int);
p49.Value = nJobHealthExpert.Value;
SqlParameter p50 = sqlComm.Parameters.Add("@nJobSociologist", SqlDbType.Int);
p50.Value = nJobSociologist.Value;
SqlParameter p51 = sqlComm.Parameters.Add("@nJobSocialPolitician", SqlDbType.Int);
p51.Value = nJobSocialPolitician.Value;
SqlParameter p52 = sqlComm.Parameters.Add("@nJobSocialWorker", SqlDbType.Int);
p52.Value = nJobSocialWorker.Value;
SqlParameter p53 = sqlComm.Parameters.Add("@nJobSocialPedagogist", SqlDbType.Int);
p53.Value = nJobSocialPedagogist.Value;
SqlParameter p54 = sqlComm.Parameters.Add("@nJobPedagogist", SqlDbType.Int);
p54.Value = nJobPedagogist.Value;
SqlParameter p55 = sqlComm.Parameters.Add("@nJobManualist", SqlDbType.Int);
p55.Value = nJobManualist.Value;
SqlParameter p56 = sqlComm.Parameters.Add("@nJobLawyer", SqlDbType.Int);
p56.Value = nJobLawyer.Value;
SqlParameter p57 = sqlComm.Parameters.Add("@nJobPoliceman", SqlDbType.Int);
p57.Value = nJobPoliceman.Value;
SqlParameter p58 = sqlComm.Parameters.Add("@nJobMentalhygiene", SqlDbType.Int);
p58.Value = nJobMentalhygiene.Value;
SqlParameter p59 = sqlComm.Parameters.Add("@nJobCultureOrganizer", SqlDbType.Int);
p59.Value = nJobCultureOrganizer.Value;
SqlParameter p60 = sqlComm.Parameters.Add("@nJobOther1", SqlDbType.Int);
p60.Value = nJobOther1.Value;
SqlParameter p61 = sqlComm.Parameters.Add("@nJobOther2", SqlDbType.Int);
p61.Value = nJobOther2.Value;
SqlParameter p62 = sqlComm.Parameters.Add("@nJobOther3", SqlDbType.Int);
p62.Value = nJobOther3.Value;
SqlParameter p63 = sqlComm.Parameters.Add("@cJobOtherName1", SqlDbType.VarChar, 50);
p63.Value = cJobOtherName1.Value;
SqlParameter p64 = sqlComm.Parameters.Add("@cJobOtherName2", SqlDbType.VarChar, 50);
p64.Value = cJobOtherName2.Value;
SqlParameter p65 = sqlComm.Parameters.Add("@cJobOtherName3", SqlDbType.VarChar, 50);
p65.Value = cJobOtherName3.Value;
SqlParameter p66 = sqlComm.Parameters.Add("@bIsKef", SqlDbType.Bit);
p66.Value = bIsKef;
SqlParameter p67 = sqlComm.Parameters.Add("@cRegionSearchCodeRef", SqlDbType.Char, 10);
p67.Value = cRegionSearchCodeRef.Value;
SqlParameter p68 = sqlComm.Parameters.Add("@nDistrictSearchCodeRef", SqlDbType.Int);
p68.Value = nDistrictSearchCodeRef.Value;
SqlParameter p69 = sqlComm.Parameters.Add("@cIntroduceText", SqlDbType.Text);
p69.Value = cIntroduceText.Value;
SqlParameter p70 = sqlComm.Parameters.Add("@cDrogStrategyDescription", SqlDbType.Text);
p70.Value = cDrogStrategyDescription.Value;
SqlParameter p71 = sqlComm.Parameters.Add("@cAreaDescription", SqlDbType.Text);
p71.Value = cAreaDescription.Value;
SqlParameter p72 = sqlComm.Parameters.Add("@cEstablishmentMonth", SqlDbType.Char, 2);
p72.Value = cEstablishmentMonth.Value;
SqlParameter p73 = sqlComm.Parameters.Add("@cAreaHomePage", SqlDbType.VarChar, 250);
p73.Value = cAreaHomePage.Value;
SqlParameter p74 = sqlComm.Parameters.Add("@dLastModified", SqlDbType.DateTime);
p74.Value = dLastModified.Value;
SqlParameter p75 = sqlComm.Parameters.Add("@dIntroduceTextLastModified", SqlDbType.DateTime);
p75.Value = dIntroduceTextLastModified.Value;
SqlParameter p76 = sqlComm.Parameters.Add("@dAreaDescriptionLastModified", SqlDbType.DateTime);
p76.Value = dAreaDescriptionLastModified.Value;
SqlParameter p77 = sqlComm.Parameters.Add("@dDrogStrategyLastModified", SqlDbType.DateTime);
p77.Value = dDrogStrategyLastModified.Value;
SqlParameter p78 = sqlComm.Parameters.Add("@dKefMembersLastModified", SqlDbType.DateTime);
p78.Value = dKefMembersLastModified.Value;
SqlParameter p79 = sqlComm.Parameters.Add("@dKefDownloadsLastModified", SqlDbType.DateTime);
p79.Value = dKefDownloadsLastModified.Value;
SqlParameter p80 = sqlComm.Parameters.Add("@dKefEventsLastModified", SqlDbType.DateTime);
p80.Value = dKefEventsLastModified.Value;
SqlParameter p81 = sqlComm.Parameters.Add("@cValidationState", SqlDbType.VarChar, 50);
p81.Value = cValidationState.Value;
SqlParameter p82 = sqlComm.Parameters.Add("@dLastValidationDate", SqlDbType.DateTime);
p82.Value = dLastValidationDate.Value;
SqlParameter p83 = sqlComm.Parameters.Add("@bIsActual", SqlDbType.Bit);
p83.Value = bIsActual;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdPageOfTemplateSelectByIsactive(DBGuid uTemplateRef,
bool bIsActive)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPageOfTemplateSelectByIsactive]");
SqlParameter p1 = sqlComm.Parameters.Add("@uTemplateRef", SqlDbType.UniqueIdentifier);
p1.Value = uTemplateRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@bIsActive", SqlDbType.Bit);
p2.Value = bIsActive;
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, uTemplateRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdOrganisationUserInsert(DBGuid uOrganisationRef,
DBString cLoginNameRef,
DBString cRight,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationUserInsert]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p1.Value = uOrganisationRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cLoginNameRef", SqlDbType.VarChar, 50);
p2.Value = cLoginNameRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cRight", SqlDbType.Char, 1);
p3.Value = cRight.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uOrganisationRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public DataSet ndihdPendingQuestionFormDetailSelect(DBGuid uQuestionFormRef,
DBString cTemplateDetailRef,
DBGuid uTemplateRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormDetailSelect]");
SqlParameter p1 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p1.Value = uQuestionFormRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cTemplateDetailRef", SqlDbType.VarChar, 50);
p2.Value = cTemplateDetailRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uTemplateRef", SqlDbType.UniqueIdentifier);
p3.Value = uTemplateRef.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, uQuestionFormRef.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public DataSet ndihdOrganisationUserSelect(DBGuid uOrganisationRef,
DBString cLoginNameRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationUserSelect]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p1.Value = uOrganisationRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cLoginNameRef", SqlDbType.VarChar, 50);
p2.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, uOrganisationRef.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
return Result;
}
public void ndihdPendingQuestionFormInsert(DBGuid uID,
DBGuid uQuestionFormRef,
DBGuid uTemplateRef,
DBString cStatus,
DBString cSentBy,
DBDateTime dSentDate,
DBString cDecidedBy,
DBDateTime dDecidedDate,
DBString cRejectComment,
bool bIsActual,
DBDateTime dLastModifiedByUser,
DBDateTime dLastValidationDate)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormInsert]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uQuestionFormRef", SqlDbType.UniqueIdentifier);
p2.Value = uQuestionFormRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uTemplateRef", SqlDbType.UniqueIdentifier);
p3.Value = uTemplateRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cStatus", SqlDbType.Char, 3);
p4.Value = cStatus.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cSentBy", SqlDbType.VarChar, 50);
p5.Value = cSentBy.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@dSentDate", SqlDbType.DateTime);
p6.Value = dSentDate.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cDecidedBy", SqlDbType.VarChar, 50);
p7.Value = cDecidedBy.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@dDecidedDate", SqlDbType.DateTime);
p8.Value = dDecidedDate.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cRejectComment", SqlDbType.VarChar, 1000);
p9.Value = cRejectComment.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@bIsActual", SqlDbType.Bit);
p10.Value = bIsActual;
SqlParameter p11 = sqlComm.Parameters.Add("@dLastModifiedByUser", SqlDbType.DateTime);
p11.Value = dLastModifiedByUser.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@dLastValidationDate", SqlDbType.DateTime);
p12.Value = dLastValidationDate.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdOrganisationUserUpdate(DBGuid uOrganisationRef,
DBString cLoginNameRef,
DBString cRight)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrganisationUserUpdate]");
SqlParameter p1 = sqlComm.Parameters.Add("@uOrganisationRef", SqlDbType.UniqueIdentifier);
p1.Value = uOrganisationRef.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cLoginNameRef", SqlDbType.VarChar, 50);
p2.Value = cLoginNameRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cRight", SqlDbType.Char, 1);
p3.Value = cRight.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uOrganisationRef.ToString());
}
finally
{
FinishSPCall();
}
}
public DataSet ndihdPendingQuestionFormOfOrganisationSelectFiltered(DBGuid cOrganisationId,
DBString cStatus,
DBString cProgramCategory)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormOfOrganisationSelectFiltered]");
SqlParameter p1 = sqlComm.Parameters.Add("@cOrganisationId", SqlDbType.UniqueIdentifier);
p1.Value = cOrganisationId.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cStatus", SqlDbType.Char, 3);
p2.Value = cStatus.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@cProgramCategory", SqlDbType.Char, 3);
p3.Value = cProgramCategory.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, cOrganisationId.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
public void ndihdOrgMemberOfOrgUpdate(DBGuid uID,
DBGuid uOrganisationKefRef,
DBGuid uOrganisationMemberRef,
DBString cContactName,
DBString cContactInstitution,
DBString cContactZipCode,
DBString cContactTownShip,
DBString cContactAddress,
DBString cContactPhone1,
DBString cContactPhone2,
DBString cContactPhone3,
DBString cContactFax,
DBString cContactPosition,
DBString cContactPositionInKef,
DBString cContactQualification,
DBString cContactEmail1,
DBString cContactEmail2,
DBString cContactEmail3,
DBString cKefContactTypeRef,
out int retVal)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrgMemberOfOrgUpdate]");
SqlParameter returnValue = sqlComm.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@uOrganisationKefRef", SqlDbType.UniqueIdentifier);
p2.Value = uOrganisationKefRef.Value;
SqlParameter p3 = sqlComm.Parameters.Add("@uOrganisationMemberRef", SqlDbType.UniqueIdentifier);
p3.Value = uOrganisationMemberRef.Value;
SqlParameter p4 = sqlComm.Parameters.Add("@cContactName", SqlDbType.VarChar, 250);
p4.Value = cContactName.Value;
SqlParameter p5 = sqlComm.Parameters.Add("@cContactInstitution", SqlDbType.VarChar, 250);
p5.Value = cContactInstitution.Value;
SqlParameter p6 = sqlComm.Parameters.Add("@cContactZipCode", SqlDbType.VarChar, 250);
p6.Value = cContactZipCode.Value;
SqlParameter p7 = sqlComm.Parameters.Add("@cContactTownShip", SqlDbType.VarChar, 250);
p7.Value = cContactTownShip.Value;
SqlParameter p8 = sqlComm.Parameters.Add("@cContactAddress", SqlDbType.VarChar, 250);
p8.Value = cContactAddress.Value;
SqlParameter p9 = sqlComm.Parameters.Add("@cContactPhone1", SqlDbType.VarChar, 20);
p9.Value = cContactPhone1.Value;
SqlParameter p10 = sqlComm.Parameters.Add("@cContactPhone2", SqlDbType.VarChar, 20);
p10.Value = cContactPhone2.Value;
SqlParameter p11 = sqlComm.Parameters.Add("@cContactPhone3", SqlDbType.VarChar, 20);
p11.Value = cContactPhone3.Value;
SqlParameter p12 = sqlComm.Parameters.Add("@cContactFax", SqlDbType.VarChar, 20);
p12.Value = cContactFax.Value;
SqlParameter p13 = sqlComm.Parameters.Add("@cContactPosition", SqlDbType.VarChar, 250);
p13.Value = cContactPosition.Value;
SqlParameter p14 = sqlComm.Parameters.Add("@cContactPositionInKef", SqlDbType.VarChar, 250);
p14.Value = cContactPositionInKef.Value;
SqlParameter p15 = sqlComm.Parameters.Add("@cContactQualification", SqlDbType.VarChar, 250);
p15.Value = cContactQualification.Value;
SqlParameter p16 = sqlComm.Parameters.Add("@cContactEmail1", SqlDbType.VarChar, 250);
p16.Value = cContactEmail1.Value;
SqlParameter p17 = sqlComm.Parameters.Add("@cContactEmail2", SqlDbType.VarChar, 250);
p17.Value = cContactEmail2.Value;
SqlParameter p18 = sqlComm.Parameters.Add("@cContactEmail3", SqlDbType.VarChar, 250);
p18.Value = cContactEmail3.Value;
SqlParameter p19 = sqlComm.Parameters.Add("@cKefContactTypeRef", SqlDbType.Char, 10);
p19.Value = cKefContactTypeRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
retVal = (int)returnValue.Value;
TraceInfoEvent.Raise("RetVal: {0}", retVal);
}
public void ndihdPendingQuestionFormOfProgramDeleteBy(DBGuid uProgramRef)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdPendingQuestionFormOfProgramDeleteBy]");
SqlParameter p1 = sqlComm.Parameters.Add("@uProgramRef", SqlDbType.UniqueIdentifier);
p1.Value = uProgramRef.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uProgramRef.ToString());
}
finally
{
FinishSPCall();
}
}
public void ndihdOrgOwnMemberDelete(DBGuid uID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrgOwnMemberDelete]");
SqlParameter p1 = sqlComm.Parameters.Add("@uID", SqlDbType.UniqueIdentifier);
p1.Value = uID.Value;
TraceDbCommandEvent.Raise(sqlComm);
try
{
sqlComm.ExecuteNonQuery();
TraceCallReturnEvent.Raise();
}
catch (SqlException e)
{
TraceCallReturnEvent.Raise(false);
SqlErrorHandler.Handle(e, uID.ToString());
}
finally
{
FinishSPCall();
}
}
public void NewsSetActiveFlag(DBGuid IDVal)
{
// Check permission: Admin
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permAdmin.Demand();
TraceCallEnterEvent.Raise();
try
{
// Logical checks
News selected = NewsSelect(IDVal);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik hír.");
// Save data
selected.IsActive = !selected.IsActive;
base.NewsUpdate(selected);
BusinessAuditEvent.Success(
new EventParameter("NewsID", IDVal.ToString()),
new EventParameter("NewsTitle", selected.Title)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("NewsID", IDVal.ToString())
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public DataSet ndihdOrgOwnMemberSelectCountByType(DBGuid uOrgID,
DBString cContactType)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdOrgOwnMemberSelectCountByType]");
SqlParameter p1 = sqlComm.Parameters.Add("@uOrgID", SqlDbType.UniqueIdentifier);
p1.Value = uOrgID.Value;
SqlParameter p2 = sqlComm.Parameters.Add("@cContactType", SqlDbType.VarChar, 10);
p2.Value = cContactType.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, uOrgID.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
/// <summary>
/// Shows the edit form to modify or create a record.
/// </summary>
private void EditAttachment(DBGuid ID)
{
frmProgramAttachmentEdit frmEdit = null;
try
{
if (ID.IsNull)
{
// Create a new item
DBGuid ProgramID = new DBGuid(new Guid(m_sCurrentID));
frmEdit = new frmProgramAttachmentEdit(ProgramID);
}
else
{
// Modify the existing item
ProgramAttachment Attachment = (ProgramAttachment) m_allDataAttachment[ID.ToString()];
frmEdit = new frmProgramAttachmentEdit(Attachment);
}
DialogResult result = frmEdit.ShowDialog();
if (result == DialogResult.OK)
{
FillDatagridAttachment(frmEdit.CurrentID, frmEdit.CurrentAttachment);
}
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Hiba történt a csatolt állomány módosítása során.", ex);
}
finally
{
if (frmEdit != null) frmEdit.Dispose();
}
}
public DataSet ndihdProgramSelectRelated(DBGuid uProgramID)
{
TraceCallEnterEvent.Raise();
SqlCommand sqlComm = PrepareSPCall("[dbo].[ndihdProgramSelectRelated]");
SqlParameter p1 = sqlComm.Parameters.Add("@uProgramID", SqlDbType.UniqueIdentifier);
p1.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, uProgramID.ToString());
}
finally
{
FinishSPCall();
}
return Result;
}
