After Insert Trigger not working in Sql Server

I have created the 2 After Insert Trigger on same Table. 1st Trigger executed successfully. But 2nd Trigger is not executing and giving the exception from c# code 'Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded.'

Earlier I used the CTE in my trigger but I read that CTE is not supported in Triggers. Then I used Temp Tables.

ALTER TRIGGER [dbo].[CodedDatas_INS_ProjectOperationalDataUserWise]
    ON [LIO00110].[dbo].[CodedDatas]
    AFTER  INSERT
    AS
    BEGIN

    --UPDATE [SydCoding].[DBO].[ProjectReportOperationDataUserWise]
    --          SET DocCorrected = 0
    
    SET NOCOUNT ON;

    CREATE TABLE #CTE1 (EnteredBy varchar(50), ReviewedTimeInMin Decimal(30,4),CodingTimeInMin Decimal(30,4));
    CREATE TABLE #CTE2 (EnteredBy varchar(50), CodingTimeInHR Decimal(30,4),ReviewedTimeInHR Decimal(30,4));
    CREATE TABLE #CTE3 (EnteredBy varchar(50), DocCoded int);
    CREATE TABLE #CTE4 (EnteredBy varchar(50), DocReviewed int);
    CREATE TABLE #CTE5 (EnteredBy varchar(50), DocCorrected int);
    CREATE TABLE #CTE6 (EnteredBy varchar(50), LastModified varchar(50));
    CREATE TABLE #CTE7 (ProjectId varchar(50),EnteredBy varchar(50), CODINGRATE Decimal(30,4), REVIEWRATE Decimal(30,4), DocCoded int, DocReviewed int,
    CodingTimeInMin Decimal(30,4),ReviewedTimeInMin Decimal(30,4),DocCorrected int,LastModified varchar(50),PerDocCorrected Decimal(30,4));

    INSERT INTO #CTE1 (EnteredBy,ReviewedTimeInMin,CodingTimeInMin)
    Select C1.EnteredBy,ReviewedTimeInMin=Sum(ROUND(CAST(C1.QATime AS FLOAT)/(CAST(60 AS FLOAT)),4)),
    CodingTimeInMin=Sum(ROUND(CAST(C1.CODINGTIME AS FLOAT)/(CAST(60 AS FLOAT)),4))
    from Inserted C1
           INNER JOIN
           (Select Document_Id,Max(LastModified) As LastModified from Inserted Group By Document_Id) C2
            on C1.Document_ID=C2.Document_ID And C1.LastModified=C2.LastModified 
            group by C1.EnteredBy;

    INSERT INTO #CTE2 (EnteredBy,CodingTimeInHR,ReviewedTimeInHR)
    Select CodingTimeInHR=ROUND(CodingTimeInMin/CAST(60 AS FLOAT), 4) ,
    ReviewedTimeInHR=ROUND(ReviewedTimeInMin/CAST(60 AS FLOAT), 4), EnteredBy
    from #CTE1;

    INSERT INTO #CTE3 (EnteredBy,DocCoded)
    Select C1.EnteredBy,DocCoded=Count(C1.Document_Id)
    from Inserted C1
           INNER JOIN
           (Select Document_Id,Max(LastModified) As LastModified from Inserted Group By Document_Id) C2
            on C1.Document_ID=C2.Document_ID And C1.LastModified=C2.LastModified And C1.Coded=1
            group by C1.EnteredBy;

    INSERT INTO #CTE4 (EnteredBy,DocReviewed)
    Select C1.EnteredBy,DocReviewed=Count(C1.Document_Id)
    from Inserted C1
           INNER JOIN
           (Select Document_Id,Max(LastModified) As LastModified from Inserted Group By Document_Id) C2
            on C1.Document_ID=C2.Document_ID And C1.LastModified=C2.LastModified And C1.Coded=1 AND C1.Revision=1
            group by C1.EnteredBy;

    INSERT INTO #CTE5 (EnteredBy,DocCorrected)
    Select C1.EnteredBy,DocCorrected=Count(C1.Document_Id)
    from Inserted C1
           INNER JOIN
           (Select Document_Id,Max(LastModified) As LastModified from Inserted Group By Document_Id) C2
            on C1.Document_ID=C2.Document_ID And C1.LastModified=C2.LastModified And C1.IsCorrected=1
            group by C1.EnteredBy;

     INSERT INTO #CTE6 (EnteredBy,LastModified)
     Select C1.EnteredBy,LastModified=Max(C2.LastModified)
     from Inserted C1
           INNER JOIN
           (Select Document_Id,Max(LastModified) As LastModified from Inserted Group By Document_Id) C2
            on C1.Document_ID=C2.Document_ID And C1.LastModified=C2.LastModified And C1.Coded=1 AND C1.Revision=1
            group by C1.EnteredBy;


    INSERT INTO #CTE7 (ProjectId,EnteredBy,CODINGRATE,REVIEWRATE,DocCoded,DocReviewed,CodingTimeInMin,ReviewedTimeInMin,DocCorrected,LastModified,PerDocCorrected)
    Select ProjectId='LIO00110', CT3.EnteredBy, CODINGRATE=(CT3.DocCoded/NULLIF(CT2.CODINGTIMEINHR,0)),
    REVIEWRATE=(CT4.DocReviewed/NULLIF(CT2.ReviewedTimeInHR,0)),CT3.DocCoded,CT4.DocReviewed,
    CT1.CodingTimeInMin,CT1.ReviewedTimeInMin,CT5.DocCorrected,CT6.LastModified,
    PerDocCorrected=(Case When CT3.DocCoded>0 Then (Cast(  (ROUND(cast(CT5.DocCorrected AS float)/cast(CT3.DocCoded AS float), 4))*100 As int  ))
    Else 0.0000 END
    )
    From #CTE3 CT3
    Inner Join #CTE2 CT2 on CT3.EnteredBy=CT2.EnteredBy
    Inner Join #CTE4 CT4 on CT3.EnteredBy=CT4.EnteredBy
    Inner Join #CTE1 CT1 on CT3.EnteredBy=CT1.EnteredBy
    Inner Join #CTE6 CT6 on CT3.EnteredBy=CT6.EnteredBy
    Full Join #CTE5 CT5 on CT3.EnteredBy=CT5.EnteredBy;
    
    Select ProjectId,EnteredBy,CODINGRATE,REVIEWRATE,CodingTimeInMin,ReviewedTimeInMin,DocCoded,DocReviewed ,DocCorrected,
    PerDocCorrected,LastModified
    From #CTE7;

    MERGE INTO [SydCoding].[DBO].[ProjectReportOperationDataUserWise] AS target
            USING #CTE7 AS source ON target.ProjectId = source.ProjectId  AND target.UserId = source.EnteredBy
            WHEN MATCHED THEN
                -- Update existing clients
                UPDATE
                SET target.[TotalCoded] = source.DocCoded,
                    target.[TotalReviewed] = source.DocReviewed,
                    target.[CodedTime] = source.CodingTimeInMin,
                    target.[ReviewedTime] = source.ReviewedTimeInMin,
                    target.[CodedRate] = source.CODINGRATE,
                    target.[ReviewedRate] = source.REVIEWRATE,
                    target.[DocCorrected] = source.DocCorrected,
                    target.[PercentDocCorrected] = source.PerDocCorrected,
                    target.[LastModifiedOn] = source.LastModified
            WHEN NOT MATCHED BY target THEN
                -- Insert new data
                INSERT ([ProjectId],[TotalCoded], [TotalReviewed], [CodedTime], [ReviewedTime], [CodedRate], [ReviewedRate], [DocCorrected], 
                [PercentDocCorrected], [UserId], [CreatedOn],[LastModifiedOn])                       
                VALUES (source.ProjectId, source.DocCoded, source.DocReviewed, source.CodingTimeInMin,source.ReviewedTimeInMin, source.CODINGRATE, source.REVIEWRATE, 
                source.DocCorrected, source.PerDocCorrected, source.EnteredBy, GetDate(), source.LastModified)
            ;

        DROP TABLE #CTE1;
        DROP TABLE #CTE2;
        DROP TABLE #CTE3;
        DROP TABLE #CTE4;
        DROP TABLE #CTE5;
        DROP TABLE #CTE6;
        DROP TABLE #CTE7;

    End

What is wrong in my trigger or I am doing something wrong. Please suggest.