RESUMES

 RESUME LINKS

https://www.myperfectresume.com/build-resume/section/cntc

https://resumeworded.com/google-docs-resume-templates#buypromodal

SQL

 -- =============================================================================      

-- Author:  Jaipal      

-- Create date: 18/12/2020      

-- Modifications:      

--       

-- =============================================================================    

-- SELECT * FROM PROFILES WHERE NETWORKID ='dbiondaro'  

-- EXEC MidYearAppraisalArchiveProcess 30038, 30166, 21, 'HR Close'  

CREATE PROCEDURE  [dbo].[MidYearAppraisalArchiveProcess]      

 @ProfileId int,      

 @AppraisalID int,  

 @AppraisalTypeID int,  

 @ModifiedBy nvarchar(100)      

AS  

BEGIN      

 --SET NOCOUNT ON;        

    BEGIN TRANSACTION      

 BEGIN TRY     

  --IF (@ModifiedBy = 'HR Close')  

  --BEGIN  

  

  --END  

    

  INSERT INTO Archive.MidYear      

  (  

   OriginalMidYearId, ArchivedProfileId, AppraisalTypeId, EmpObjective, MgrObjective, EmpValueBehavior,   

   MgrValueBehavior, EmpDevelopmentPlan, MgrDevelopmentPlan, ReviewDate, EmpSignDate, EmployeeName,  

   MgrSignDate, ManagerName, CreatedBy, Created, ModifiedBy, ModifiedOn, ObjectiveID  

  )      

  SELECT   

   MidYearId, @ProfileID,  AppraisalTypeID, EmpObjective, MgrObjective, EmpValueBehavior,   

   MgrValueBehavior, EmpDevelopmentPlan, MgrDevelopmentPlan,   

   CASE WHEN @ModifiedBy = 'HR Close' THEN  GETDATE() ELSE ReviewDate END AS ReviewDate,  

   CASE WHEN @ModifiedBy = 'HR Close' THEN  ISNULL(EmpSignDate, GETDATE()) ELSE EmpSignDate END AS EmpSignDate,  

   CASE WHEN @ModifiedBy = 'HR Close' THEN  ISNULL(EmployeeName, 'HR Close') ELSE EmployeeName END AS EmployeeName,  

   CASE WHEN @ModifiedBy = 'HR Close' THEN  ISNULL(MgrSignDate, GETDATE()) ELSE MgrSignDate END AS MgrSignDate,  

   CASE WHEN @ModifiedBy = 'HR Close' THEN  ISNULL(ManagerName, 'HR Close') ELSE ManagerName END AS ManagerName,  

   --ReviewDate, EmpSignDate, EmployeeName, MgrSignDate, ManagerName,   

   CreatedBy, CreatedOn, @ModifiedBy, GETDATE(), ObjectiveID      

  FROM MidYear       

  WHERE MidYear.ProfileID = @ProfileID   

    

  INSERT INTO Archive.MidYear_EmpMgrValues      

  (  

   OriginalMidYearEmpValuesID,ProfileID,AppraisalTypeID,EnterpriseCompetencyID,EmpValueBehavior,  

   MgrValueBehavior,ReviewDate,EmployeeName,ManagerName,CreatedBy,CreatedOn,ModifiedBy,ModifiedOn  

  )      

  SELECT   

   MidYearEmpValuesID,ProfileID,AppraisalTypeID,EnterpriseCompetencyID,EmpValueBehavior,MgrValueBehavior,  

   ReviewDate,EmployeeName,ManagerName,CreatedBy,CreatedOn,ModifiedBy,GETDATE()  

  FROM dbo.MidYear_EmpMgrValues    

  WHERE ProfileID = @ProfileId  

  AND AppraisalTypeID = @AppraisalTypeID  

  

  INSERT INTO Archive.MidYear_EmpMgrDevPlan      

  (  

   OriginalMidYearEmpMgrDevID,ProfileID,AppraisalTypeID,EmpDevPlan,MgrDevPlan,ReviewDate,EmployeeName,  

   ManagerName,CreatedBy,CreatedOn,ModifiedBy,ModifiedOn,DevPlanDetailId  

  

  )      

  SELECT   

   MidYearEmpMgrDevID,ProfileID,AppraisalTypeID,EmpDevPlan,MgrDevPlan,ReviewDate,EmployeeName,  

   ManagerName,CreatedBy,CreatedOn,ModifiedBy,GETDATE(),DevPlanDetailId  

  FROM dbo.MidYear_EmpMgrDevPlan    

  WHERE ProfileID = @ProfileId  

  AND AppraisalTypeID = @AppraisalTypeID  

         

  DELETE FROM [dbo].[MidYear] WHERE MidYear.ProfileID = @ProfileID  

  DELETE FROM [dbo].[MidYear_EmpMgrValues] where ProfileID  = @ProfileID  

  

        

  UPDATE Appraisals SET   

   AppraisalTypeID = @AppraisalTypeID + 1,      

   COCViolation = '',      

   ManagerMeeting = '',      

   PerformanceRating = NULL,      

   CompetencyRating = NULL,      

   OverallRating = NULL,      

   ObjectiveComment = NULL,      

   CompetencyComment = NULL,      

   SkillComment = NULL,      

   ReviewDate = NULL,      

   SelfAssessmentComplete = 0,      

   ManagerStepComplete = 0,      

   EmployeeComment = NULL,      

   ManagerComment = NULL,      

   EmployeeName = NULL,      

   EmployeeSignDate = NULL,      

   ManagerName = NULL,      

   ManagerSignDate = NULL,      

   ManagersManagerName = NULL,      

   ManagersManagerSignDate = NULL,      

   ModifiedBy = 'Archive Process'      

 WHERE AppraisalID = @AppraisalID      

      

 COMMIT TRANSACTION      

  END TRY      

    BEGIN CATCH      

  INSERT INTO tbl_Errors(ErrorNumber,ErrorState,ErrorSeverity,ErrorLine,ErrorProcedure,ErrorMessage,ErrorDateTime )  

  SELECT    

   ERROR_NUMBER() AS ErrorNumber, ERROR_STATE() AS ErrorState, ERROR_SEVERITY() AS ErrorSeverity   

   ,ERROR_LINE() AS ErrorLine, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_MESSAGE() AS ErrorMessage  

   ,GETDATE()  

        DECLARE @ErrorMessage NVARCHAR(4000),      

            @ErrorNumber INT,      

            @ErrorSeverity INT,      

            @ErrorState INT,      

            @ErrorLine INT,      

            @ErrorProcedure NVARCHAR(200)      

      

            -- Assign variables to error-handling functions that      

            -- capture information for RAISERROR.      

        SELECT  @ErrorNumber = ERROR_NUMBER(), @ErrorSeverity = ERROR_SEVERITY(),      

                @ErrorState = ERROR_STATE(), @ErrorLine = ERROR_LINE(),      

                @ErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-') ;      

      

            -- Building the message string that will contain original      

            -- error information.      

        SELECT  @ErrorMessage = N'Error %d, Level %d, State %d, Procedure %s, Line %d, ' +      

                'Message: ' + ERROR_MESSAGE() ;      

      

            -- Raise an error: msg_str parameter of RAISERROR will contain      

            -- the original error information.      

        RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState, @ErrorNumber, -- parameter: original error number.      

          @ErrorSeverity, -- parameter: original error severity.      

          @ErrorState, -- parameter: original error state.      

          @ErrorProcedure, -- parameter: original error procedure name.      

          @ErrorLine-- parameter: original error line number.      

                ) ;     

    

  

  

        ROLLBACK TRANSACTION      

        RETURN 50001      

    END CATCH      

END

swagger in nodejs

 npm install express swagger-jsdoc swagger-ui-express

const express = require('express');

const swaggerJSDoc = require('swagger-jsdoc');

const swaggerUI = require('swagger-ui-express');

const app = express();

const port = 3000;

// Swagger configuration

const swaggerOptions = {

  definition: {

    openapi: '3.0.0',

    info: {

      title: 'Your API Title',

      version: '1.0.0',

      description: 'API Documentation using Swagger',

    },

  },

  apis: ['./routes/*.js'], // Path to the API routes

};

const swaggerSpec = swaggerJSDoc(swaggerOptions);

// Serve Swagger UI at /api-docs

app.use('/api-docs', swaggerUI.serve, swaggerUI.setup(swaggerSpec));

// Define your API routes here (replace with your actual routes)

app.get('/', (req, res) => {

  res.send('Hello, Swagger!');

});

// Start the server

app.listen(port, () => {

  console.log(`Server is running at http://localhost:${port}`);

});

angular file upload

 onchange="console.log(event.target.files)"

to check file type

Angular File Upload - Complete Guide (angular-university.io)

Promise issue ionic angular

 due to promise in console value not printed. below issue we getting.

__zone_symbol__state: null, __zone_symbol__value: Array(0) - Ionic Framework / ionic-v3 - Ionic Forum

i used to resolve using promise.

error

to print use then

instead of this

this.userdata.get();

use below then;

this.userdata.get()

.then( res =>

  alert(console.log(res))

  )

    )

SQL

 When updating one column with another based on a condition, you generally don't need to use constraints. Constraints are more related to ensuring data integrity and maintaining relationships between tables. However, if you want to ensure that the values you are updating meet certain conditions, you can use a combination of the CHECK constraint and the WHERE clause in the UPDATE statement.

Here's an example:

-- Add a CHECK constraint to ensure that salary is not negative ALTER TABLE employees ADD CONSTRAINT CHK_Salary_NonNegative CHECK (salary >= 0); -- Update bonus based on a condition UPDATE employees SET bonus = salary WHERE salary > 50000;

In this example, a CHECK constraint is added to ensure that the salary column does not contain negative values. The UPDATE statement then updates the bonus column for rows where the salary is greater than 50000.

Remember, it's important to ensure that your data meets the conditions you are setting, and constraints can help with that. Always make sure to test your updates on a small set of data first, and consider creating a backup before making significant changes to your database.

Get List of sps based on table name..

SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%profiles%'

Get List of procedures create based on date

 Get List of procedures create based on date.

select name,create_date,modify_date

from sys.procedures

order by modify_date desc