Пример #1
0
   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);
   }
Пример #2
0
   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;
   }
Пример #3
0
 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;
 }
Пример #4
0
 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();
       }
 }
Пример #5
0
   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);
   }
Пример #6
0
   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();
         }
   }
Пример #7
0
   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;
   }
Пример #8
0
   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();
         }
   }
Пример #9
0
   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;
   }
Пример #10
0
   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();
         }
   }
Пример #11
0
   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();
         }
   }
Пример #12
0
   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);
   }
Пример #13
0
   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();
         }
   }
Пример #14
0
   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;
   }
Пример #15
0
   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;
   }
Пример #16
0
 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();
       }
 }
Пример #17
0
   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);
   }
Пример #18
0
   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;
   }
Пример #19
0
   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;
   }
Пример #20
0
   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();
         }
   }
Пример #21
0
   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;
   }
Пример #22
0
   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;
   }
Пример #23
0
   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;
   }
Пример #24
0
   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;
   }
Пример #25
0
   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;
   }
Пример #26
0
   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;
   }
Пример #27
0
   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();
         }
   }
Пример #28
0
   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;
   }
Пример #29
0
        /// <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);
              }
        }
Пример #30
0
 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;
 }