C# DBGuid.ToString方法代码示例

   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();
         }
   }