i want to add a check for [contractclaimstatustypeid=5]

Problem

The problem in the code is that it checks for ContractClaimStatusTypeID equal to 3 (IWI.ContractClaimStatusTypeID == 3) instead of 5 (IWI.ContractClaimStatusTypeID == 5) in the CountPendingApproved query.

Cause

The cause of the problem is that the code is checking for the wrong ContractClaimStatusTypeID value. It should be checking for 5 (approved) instead of 3 (submitted).

Solution

To fix the issue and add a check for ContractClaimStatusTypeID equal to 5, you need to modify the code in the CountPendingApproved query. Replace IWI.ContractClaimStatusTypeID == 3 with IWI.ContractClaimStatusTypeID == 5 in the query.

Here's the modified code:

var CountPendingApproved = (from IWI in db.InvoiceWorkItems
                            join VIWI in db.vw_InvoiceWorkItemSummary on IWI.ContactID equals VIWI.ContactID
                            where VIWI.ContactAssignmentID == contactAssignment.ContactAssignmentID
                            join ST in db.ContractClaimStatusTypes on IWI.ContractClaimStatusTypeID equals ST.ContractClaimStatusTypeID
                            where
                            (VIWI.BranchID == IWI.BranchID && VIWI.DeploymentReportID == IWI.DeploymentReportId)
                            && VIWI.ContactAssignmentID == contactAssignment.ContactAssignmentID
                            && IWI.IsDeleted == false && (IWI.ContractClaimStatusTypeID == 5) // Modified line
                            select (new
                            {
                                IWI.InvoiceWorkItemID,
                                IWI.ContractClaimStatusTypeID
                            })).Distinct().ToList();

The code will now check for ContractClaimStatusTypeID equal to 5 (approved) instead of 3 (submitted).

Adding a Check for ContractClaimStatusTypeID=5

To add a check for ContractClaimStatusTypeID equal to 5 (approved), you can modify the code in the if condition where PendingApproved is checked.

Replace PendingApproved > 0 with PendingApproved > 0 && contactAssignment.ContractClaimStatusTypeID == 5 in the if condition.

Here's the modified code:

if (PendingApproved > 0 && contactAssignment.ContractClaimStatusTypeID == 5)
{
    return this.ResponseMessage(Request.CreateResponse(HttpStatusCode.BadRequest, new
    {
        Status = Global.Status.Invalid.ToString(),
        Message = contactAssignment.ClientId == 2 ? Global.StatusMessage.CheckOutPendingInvoiceError : Global.StatusMessage.CheckOutPendingInvoiceErrorGeneric
    }));
}

The code will only return a response if PendingApproved is greater than 0 and ContractClaimStatusTypeID is equal to 5 (approved).

This change ensures that the post API will only be hit if ContractClaimStatusTypeID is 5 (approved), as requested.

Remember to test the code thoroughly after making these modifications to ensure that it behaves as expected.