C# (CSharp) enComparison 예제들

예제 #1

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sDescription":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objEmpLogin":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #2

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sInstituteName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sHigestDegree":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sUniversity":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sDegreeType":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sPassingYear":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "fPercentage":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Float, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sSpecialization":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sCertification":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objEmpLogin":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sEducationLevel":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #3

파일: cPermission_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iParentID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #4

파일: cFilter.cs 프로젝트: swapneshpal/HRIMS

 public cFilterParameter(bool i_bNegate, string i_sName, enComparison i_enOperator, string i_sValue)
 {
     bNegate    = i_bNegate;
     sName      = i_sName;
     enOperator = i_enOperator;
     sValue     = i_sValue;
 }

예제 #5

파일: cTimeSheetActivityDes_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objTimeSheetActivity":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sDescription":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sMonday":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sTuesday":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sWed":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sThu":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sFri":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sSat":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sSun":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #6

파일: cEmpLogin_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sEmailID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sPassword":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objRoleAccess":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sFirstTime":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objDesignation":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objLocation":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objTitle":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objManageGroup":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bFirstTime":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #7

파일: cProject_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sProjectName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objClient":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objExternalProjectHead":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iInternalHead":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sDescription":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtStartDate":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtEndDate":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objStatus":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sCompletion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #8

파일: cEmployeeQuadrant_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sMeasureDescription":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sEmployeeDescription":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sManagerDescription":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objQuadrant":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objStatus":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objEmpLogin":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bEmpFlag":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bManagerFlag":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #9

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtFromDate":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtToDate":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sReason":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objLeaveType":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objEmpLogin":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sLeaveStatus":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iReportingHead":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #10

파일: cQuadrantMeasure_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sMeasures":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objFunctionalGroup":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objQuadrant":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsAllLevel":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objQuadrantMeasureEnforce":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #11

파일: cFilter.cs 프로젝트: swapneshpal/HRIMS

 public cFilterParameter(bool i_bNegate, string i_sName, enComparison i_enOperator, string i_sValue)
 {
     bNegate = i_bNegate;
     sName = i_sName;
     enOperator = i_enOperator;
     sValue = i_sValue;
 }

예제 #12

파일: cFilter.cs 프로젝트: swapneshpal/HRIMS

 public cFilterParameter(string i_sName, string i_sValue)
 {
     sName      = i_sName;
     enOperator = enComparison.Equals;
     sValue     = i_sValue;
 }

예제 #13

파일: cEmpPersonalDetails_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sFirstName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sMiddleName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sLastName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sGender":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sFatherName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sMotherName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sCurrAddress":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sPerAddress":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sMartialStatus":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtDOB":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sGovtID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sCity":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sState":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sZipCode":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sCountry":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sNationality":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sPerContactNo":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sWorkTelp":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sPersoanlEmailID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "bIsActive":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Boolean, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "objEmpLogin":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.ObjectReference, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }

예제 #14

파일: cMSSQL.cs 프로젝트: swapneshpal/HRIMS

 public static string ValidateSQLFilterParameter(enDataType i_enDataType, string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
 {
     string sValue = cMSSQL.RemoveUnacceptableSQLCharacters(i_sPropertyValue);
     if (i_sPropertyValue != sValue) throw new cInvalidFilterParameterValueException("Suspicious Characters/SQL: " + i_sPropertyName + " = " + i_sPropertyValue);
     string sCode = string.Empty;
     switch (i_enDataType)
     {
         case enDataType.Boolean:
             sCode = Convert.ToBoolean(i_sPropertyValue) ? "1" : "0";
             break;
         case enDataType.Int32:
             sCode = Convert.ToInt32(i_sPropertyValue).ToString();
             break;
         case enDataType.Int64:
             sCode = Convert.ToInt64(i_sPropertyValue).ToString();
             break;
         case enDataType.DateTime:
             sCode = "'" + Convert.ToDateTime(i_sPropertyValue).ToString() + "'";
             break;
         case enDataType.Currency:
             sCode = Convert.ToSingle(i_sPropertyValue).ToString();
             break;
         case enDataType.String:
         case enDataType.NameOfPerson:
         case enDataType.EMailID:
         case enDataType.Phone:
         case enDataType.URL:
             {
                 if (i_enOperator == enComparison.Like)
                 {
                     if (!i_sPropertyValue.Contains("%")) throw new cInvalidFilterParameterValueException("'LIKE' without '%' : " + i_sPropertyName + " = " + i_sPropertyValue);
                 }
                 else
                 {
                     if (i_sPropertyValue.Contains("%")) throw new cInvalidFilterParameterValueException("not 'LIKE' but '%' found : " + i_sPropertyName + " = " + i_sPropertyValue);
                 }
                 sCode = "'" + i_sPropertyValue + "'";
             }
             break;
         case enDataType.ObjectReference:
             sCode = Convert.ToInt64(i_sPropertyValue).ToString();
             break;
         case enDataType.Float:
             sCode = Convert.ToSingle(i_sPropertyValue).ToString();
             break;
         default:
             throw new cInvalidFilterParameterValueException("Unknown datatype");
     }
     return sCode;
 }

예제 #15

파일: cReviewRating_Base.cs 프로젝트: swapneshpal/HRIMS

using System;

예제 #16

파일: cFilter.cs 프로젝트: swapneshpal/HRIMS

 public cFilterParameter(string i_sName, enComparison i_enOperator, string i_sValue)
 {
     sName      = i_sName;
     enOperator = i_enOperator;
     sValue     = i_sValue;
 }

예제 #17

파일: cFilter.cs 프로젝트: swapneshpal/HRIMS

 public cFilterParameter(string i_sName, string i_sValue)
 {
     sName = i_sName;
     enOperator = enComparison.Equals;
     sValue = i_sValue;
 }

예제 #18

파일: cMSSQL.cs 프로젝트: swapneshpal/HRIMS

        public static string ValidateSQLFilterParameter(enDataType i_enDataType, string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            string sValue = cMSSQL.RemoveUnacceptableSQLCharacters(i_sPropertyValue);

            if (i_sPropertyValue != sValue)
            {
                throw new cInvalidFilterParameterValueException("Suspicious Characters/SQL: " + i_sPropertyName + " = " + i_sPropertyValue);
            }
            string sCode = string.Empty;

            switch (i_enDataType)
            {
            case enDataType.Boolean:
                sCode = Convert.ToBoolean(i_sPropertyValue) ? "1" : "0";
                break;

            case enDataType.Int32:
                sCode = Convert.ToInt32(i_sPropertyValue).ToString();
                break;

            case enDataType.Int64:
                sCode = Convert.ToInt64(i_sPropertyValue).ToString();
                break;

            case enDataType.DateTime:
                sCode = "'" + Convert.ToDateTime(i_sPropertyValue).ToString() + "'";
                break;

            case enDataType.Currency:
                sCode = Convert.ToSingle(i_sPropertyValue).ToString();
                break;

            case enDataType.String:
            case enDataType.NameOfPerson:
            case enDataType.EMailID:
            case enDataType.Phone:
            case enDataType.URL:
            {
                if (i_enOperator == enComparison.Like)
                {
                    if (!i_sPropertyValue.Contains("%"))
                    {
                        throw new cInvalidFilterParameterValueException("'LIKE' without '%' : " + i_sPropertyName + " = " + i_sPropertyValue);
                    }
                }
                else
                {
                    if (i_sPropertyValue.Contains("%"))
                    {
                        throw new cInvalidFilterParameterValueException("not 'LIKE' but '%' found : " + i_sPropertyName + " = " + i_sPropertyValue);
                    }
                }
                sCode = "'" + i_sPropertyValue + "'";
            }
            break;

            case enDataType.ObjectReference:
                sCode = Convert.ToInt64(i_sPropertyValue).ToString();
                break;

            case enDataType.Float:
                sCode = Convert.ToSingle(i_sPropertyValue).ToString();
                break;

            default:
                throw new cInvalidFilterParameterValueException("Unknown datatype");
            }
            return(sCode);
        }

예제 #19

파일: cFilter.cs 프로젝트: swapneshpal/HRIMS

 public cFilterParameter(string i_sName, enComparison i_enOperator, string i_sValue)
 {
     sName = i_sName;
     enOperator = i_enOperator;
     sValue = i_sValue;
 }

예제 #20

파일: cExcelEmployeeData_Base.cs 프로젝트: swapneshpal/HRIMS

        /// <summary>
        /// For Internal Use Only
        /// </summary>
        /// <param name="i_sPropertyName"></param>
        /// <param name="i_enOperator"></param>
        /// <param name="i_sPropertyValue"></param>
        /// <returns></returns>
        public string _ValidateSQLFilterParameter(string i_sPropertyName, enComparison i_enOperator, string i_sPropertyValue)
        {
            switch (i_sPropertyName)
            {
            case "iID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iVersion":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.Int32, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtCreatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iCreatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtLastUpdatedOn":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "iLastUpdatedBy":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sFirstName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sMiddleName":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sLastNam":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sWorkEmailaID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sDepartment":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sFunctionalGroup":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sDesignation":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sPersonalEmailID":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sTitle":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sPassword":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sReportingHead":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sRollAccess":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "sLocation":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.String, i_sPropertyName, i_enOperator, i_sPropertyValue));

            case "dtDOJ":
                return(cMSSQL.ValidateSQLFilterParameter(enDataType.DateTime, i_sPropertyName, i_enOperator, i_sPropertyValue));
            }
            throw new cInvalidFilterParameterException(i_sPropertyName);
        }