adding variables via gitea variables

.gitea/workflows/deploy.yml

@@ -0,0 +1,211 @@
+name: Build and Deploy CPRNIMS
+
+on:
+  push:
+    branches: [ main ]
+
+jobs:
+  build-and-deploy:
+    runs-on: windows
+
+    steps:
+      - name: Checkout
+        uses: actions/checkout@v4
+
+      - name: Clean previous publish output
+        shell: pwsh
+        run: |
+          Remove-Item -Recurse -Force "C:\ci-output\webapi" -ErrorAction SilentlyContinue
+          Remove-Item -Recurse -Force "C:\ci-output\webapps" -ErrorAction SilentlyContinue
+
+      - name: Publish WebApi
+        shell: pwsh
+        run: dotnet publish .\CPRNIMS.WebApi\CPRNIMS.WebApi.csproj -c Release -o C:\ci-output\webapi
+
+      - name: Publish WebApps
+        shell: pwsh
+        run: dotnet publish .\CPRNIMS.WebApps\CPRNIMS.WebApps.csproj -c Release -o C:\ci-output\webapps
+
+      # ---- Generate production config from Gitea Actions secrets (never committed to git) ----
+      - name: Write production appsettings - WebApi
+        shell: pwsh
+        env:
+          TAVILY_KEY: ${{ secrets.LLI_NON_INVENTORY_PROD_TAVILY_API_KEY }}
+          GROQ_KEY: ${{ secrets.LLI_NON_INVENTORY_PROD_GROQ_API_KEY }}
+          JWT_SECRET: ${{ secrets.LLI_NON_INVENTORY_PROD_JWT_SECRET }}
+          DB_CONN: ${{ secrets.LLI_NON_INVENTORY_PROD_DB_CONNECTION }}
+          LOCALPURCH_CONN: ${{ secrets.LLI_NON_INVENTORY_PROD_DB_LOCALPURCH_CONNECTION }}
+        run: |
+          $config = @{
+            Tavily = @{
+              ApiKey = $env:TAVILY_KEY
+              SearchUrl = "https://api.tavily.com/search"
+            }
+            Groq = @{
+              ApiKey = $env:GROQ_KEY
+              ApiUrl = "https://api.groq.com/openai/v1/chat/completions"
+              Model = "llama-3.1-8b-instant"
+            }
+            JWT = @{
+              ValidAudience = "https://lloydwebapi.lloydlab.com:2021"
+              ValidIssuer = "https://lloydwebapi.lloydlab.com:2021"
+              Secret = $env:JWT_SECRET
+            }
+            WebEndPoint = @{
+              ForgotPassword = "https://llipurchasingnoninventory.com:8080/"
+              SupplierForm = "https://llipurchasingnoninventory.com:8083/"
+            }
+            ConnectionStrings = @{
+              DefaultConnection = $env:DB_CONN
+              LocalPurchConn = $env:LOCALPURCH_CONN
+            }
+          }
+
+          $json = $config | ConvertTo-Json -Depth 5
+          $json | Out-File -FilePath "C:\ci-output\webapi\appsettings.Production.json" -Encoding utf8
+          Write-Host "Wrote appsettings.Production.json to webapi output (values masked in this log automatically)"
+          exit 0
+
+      # ---- Generate production config for WebApps (uses Variables, not Secrets, since BaseUrl isn't sensitive) ----
+      - name: Write production appsettings - WebApps
+        shell: pwsh
+        env:
+          API_BASE_URL: ${{ vars.LLI_NON_INVENTORY_PROD_API_BASE_URL }}
+        run: |
+          $config = @{
+            CommonEndpoints = @{
+              ApiDefaultHeaders = @{
+                BaseUrl = $env:API_BASE_URL
+                ESignaturePath = "https://llipurchasingnoninventory.com:8080/Content/Images/Signatures/"
+                ItemImages = "https://llipurchasingnoninventory.com:8080/content/images/"
+                ContentTypeMedia = "application/json"
+                Authorization = "token"
+                ErrorMessage = "api/ErrorLogs/ErrorMessage/"
+              }
+            }
+          }
+
+          $json = $config | ConvertTo-Json -Depth 5
+          $json | Out-File -FilePath "C:\ci-output\webapps\appsettings.Production.json" -Encoding utf8
+          Write-Host "Wrote appsettings.Production.json to webapps output"
+          exit 0
+
+      # ---- Backup current live deployment before touching anything ----
+      - name: Backup current live files
+        shell: pwsh
+        run: |
+          $stamp = Get-Date -Format "yyyyMMdd-HHmmss"
+          New-Item -ItemType Directory -Force -Path "C:\backups\$stamp" | Out-Null
+
+          # Mirror current live folders into the backup location (only if they exist / aren't empty)
+          if (Test-Path "C:\inetpub\cprnims-api") {
+            robocopy "C:\inetpub\cprnims-api" "C:\backups\$stamp\webapi" /MIR /R:2 /W:3 | Out-Null
+          }
+          if (Test-Path "C:\inetpub\cprnims-web") {
+            robocopy "C:\inetpub\cprnims-web" "C:\backups\$stamp\webapps" /MIR /R:2 /W:3 | Out-Null
+          }
+
+          # Record this backup's timestamp so later steps know where it lives
+          $stamp | Out-File -FilePath "C:\backups\latest.txt" -Encoding ascii -NoNewline
+
+          # Keep only the last 5 backups to avoid filling the disk
+          $all = Get-ChildItem "C:\backups" -Directory | Sort-Object Name -Descending
+          if ($all.Count -gt 5) {
+            $all | Select-Object -Skip 5 | Remove-Item -Recurse -Force
+          }
+
+          Write-Host "Backed up current deployment to C:\backups\$stamp"
+          exit 0
+
+      - name: Stop app pools
+        shell: pwsh
+        run: |
+          Import-Module WebAdministration
+          Stop-WebAppPool -Name "CPRNIMS-Api" -ErrorAction SilentlyContinue
+          Stop-WebAppPool -Name "CPRNIMS-Web" -ErrorAction SilentlyContinue
+          Start-Sleep -Seconds 3
+
+      - name: Deploy WebApi files
+        id: deploy_api
+        shell: pwsh
+        run: |
+          robocopy "C:\ci-output\webapi" "C:\inetpub\cprnims-api" /MIR /R:3 /W:5
+          $rc = $LASTEXITCODE
+          Write-Host "ROBOCOPY EXIT CODE: $rc"
+          if ($rc -ge 8) {
+            throw "robocopy failed for WebApi with exit code $rc"
+          }
+          exit 0
+
+      - name: Deploy WebApps files
+        id: deploy_web
+        shell: pwsh
+        run: |
+          robocopy "C:\ci-output\webapps" "C:\inetpub\cprnims-web" /MIR /R:3 /W:5
+          $rc = $LASTEXITCODE
+          Write-Host "ROBOCOPY EXIT CODE: $rc"
+          if ($rc -ge 8) {
+            throw "robocopy failed for WebApps with exit code $rc"
+          }
+          exit 0
+
+      - name: Start app pools
+        shell: pwsh
+        run: |
+          Import-Module WebAdministration
+          Start-WebAppPool -Name "CPRNIMS-Api"
+          Start-WebAppPool -Name "CPRNIMS-Web"
+
+      - name: Verify app pools are running
+        shell: pwsh
+        run: |
+          Start-Sleep -Seconds 3
+          Import-Module WebAdministration
+          $api = Get-WebAppPoolState -Name "CPRNIMS-Api"
+          $web = Get-WebAppPoolState -Name "CPRNIMS-Web"
+          Write-Host "CPRNIMS-Api: $($api.Value)"
+          Write-Host "CPRNIMS-Web: $($web.Value)"
+          if ($api.Value -ne "Started" -or $web.Value -ne "Started") {
+            throw "One or more app pools failed to start"
+          }
+
+      # ---- Rollback path: only runs if any prior step in this job failed ----
+      - name: ROLLBACK - restore previous backup
+        if: failure()
+        shell: pwsh
+        run: |
+          $stamp = Get-Content "C:\backups\latest.txt" -Raw
+          $backupPath = "C:\backups\$stamp"
+          Write-Host "Deployment failed - rolling back to backup: $backupPath"
+
+          Import-Module WebAdministration
+          Stop-WebAppPool -Name "CPRNIMS-Api" -ErrorAction SilentlyContinue
+          Stop-WebAppPool -Name "CPRNIMS-Web" -ErrorAction SilentlyContinue
+          Start-Sleep -Seconds 3
+
+          if (Test-Path "$backupPath\webapi") {
+            robocopy "$backupPath\webapi" "C:\inetpub\cprnims-api" /MIR /R:3 /W:5 | Out-Null
+          }
+          if (Test-Path "$backupPath\webapps") {
+            robocopy "$backupPath\webapps" "C:\inetpub\cprnims-web" /MIR /R:3 /W:5 | Out-Null
+          }
+
+          Start-WebAppPool -Name "CPRNIMS-Api"
+          Start-WebAppPool -Name "CPRNIMS-Web"
+
+          Write-Host "Rollback complete. Restored from $backupPath"
+          exit 0
+
+      - name: ROLLBACK - verify pools after restore
+        if: failure()
+        shell: pwsh
+        run: |
+          Start-Sleep -Seconds 3
+          Import-Module WebAdministration
+          $api = Get-WebAppPoolState -Name "CPRNIMS-Api"
+          $web = Get-WebAppPoolState -Name "CPRNIMS-Web"
+          Write-Host "After rollback - CPRNIMS-Api: $($api.Value)"
+          Write-Host "After rollback - CPRNIMS-Web: $($web.Value)"
+          if ($api.Value -ne "Started" -or $web.Value -ne "Started") {
+            Write-Host "WARNING: app pools still not running after rollback. Manual intervention needed."
+          }

.gitignore

@@ -0,0 +1,48 @@
+# Build output
+[Bb]in/
+[Oo]bj/
+[Dd]ebug/
+[Rr]elease/
+x64/
+x86/
+build/
+bld/
+
+# Visual Studio
+.vs/
+*.user
+*.suo
+*.userosscache
+*.sln.docstates
+*.userprefs
+
+# Publish output
+publish/
+*.publishsettings
+PublishScripts/
+
+# NuGet
+*.nupkg
+*.snupkg
+packages/
+!packages/build/
+project.lock.json
+project.fragment.lock.json
+artifacts/
+
+# Rider / VS Code (if anyone uses them)
+.idea/
+.vscode/
+
+# Build results / logs
+*.binlog
+*.log
+msbuild.log
+msbuild.err
+
+# Environment-specific config with secrets
+appsettings.*.json
+!appsettings.json
+*.dev.json
+secrets.json
+*.pfx

.vs/NonInventPurchasing/v17/DocumentLayout.json

@@ -1,12 +0,0 @@
-{
-  "Version": 1,
-  "WorkspaceRootPath": "D:\\sourcecode\\NonInventPurchasing\\",
-  "Documents": [],
-  "DocumentGroupContainers": [
-    {
-      "Orientation": 0,
-      "VerticalTabListWidth": 256,
-      "DocumentGroups": []
-    }
-  ]
-}

.vs/VSWorkspaceState.json

@@ -1,6 +0,0 @@
-{
-  "ExpandedNodes": [
-    ""
-  ],
-  "PreviewInSolutionExplorer": false
-}

CPRNIMS.Domain/CPRNIMS.Domain.csproj

@@ -10,6 +10,9 @@
     <PackageReference Include="AutoMapper" Version="16.1.1" />
     <PackageReference Include="CaptchaGen.NetCore" Version="1.1.2" />
     <PackageReference Include="Dapper" Version="2.1.66" />
+    <PackageReference Include="FastReport.OpenSource" Version="2026.2.3" />
+    <PackageReference Include="FastReport.OpenSource.Export.PdfSimple" Version="2026.2.3" />
+    <PackageReference Include="FastReport.OpenSource.Web" Version="2026.2.3" />
     <PackageReference Include="Google.Apis.Drive.v3" Version="1.67.0.3373" />
     <PackageReference Include="Microsoft.AspNet.Identity.Core" Version="2.2.4" />
     <PackageReference Include="Microsoft.AspNetCore.SignalR.Core" Version="1.2.0" />

CPRNIMS.Domain/Contracts/Common/ITransactionFacade.cs

@@ -0,0 +1,14 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.Contracts.Common
+{
+    public interface ITransactionFacade
+    {
+        Task<T> ExecuteAsync<T>(Func<Task<T>> operation,CancellationToken ct);
+        Task ExecuteAsync(Func<Task> operation,CancellationToken ct);
+    }
+}

CPRNIMS.Domain/Contracts/Finance/IRR.cs

@@ -13,6 +13,6 @@ namespace CPRNIMS.Domain.Contracts.Finance
     {
         Task<List<ForPayment>> GetAllClosedPO(RRDetailsDto itemDto);
         Task<List<ReceivingDetail>> GetRRDetailByPO(RRDetailsDto itemDto);
-        Task<RRDetail> PostPutPayment(RRDetailsDto itemDto);
+        Task<RRDetailDto> PostPutPayment(RRDetailsDto itemDto);
     }
 }

CPRNIMS.Domain/Contracts/Inventory/IInventory.cs

@@ -1,4 +1,6 @@
 using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
 using CPRNIMS.Infrastructure.Entities.Inventory;
 using System;
 using System.Collections.Generic;
@@ -11,11 +13,15 @@ namespace CPRNIMS.Domain.Contracts.Inventory
     public interface IInventory
     {
         Task<List<Lot>> GetLotNo(InventoryDto itemDto);
-        Task<List<Lot>> GetLotNoById(InventoryDto itemDto);//
+        Task<List<Lot>> GetLotNoById(InventoryDto itemDto);
         Task<List<LotQtyByItem>> GetLotQtyByItem(InventoryDto itemDto);
         Task<List<Infrastructure.Entities.Inventory.Inventory>> GetInventoryByUserId(InventoryDto itemDto);
         Task<List<RequestItemDetail>> GetRequestedItemByUserId(InventoryDto itemDto);
         Task<List<ItemDetail>> GetInventoryById(InventoryDto itemDto);
+        Task<PagedResult<InventoryResponse>> GetInventory(InventoryRequest request, CancellationToken ct);
+        Task<List<InventoryByIdResponse>> GetInventoryById(InventoryRequest itemDto, CancellationToken ct);
+        Task<TransactContextDto?> GetTransactContextAsync(int inventoryId, CancellationToken ct);
+        Task<IReadOnlyList<DisciplineDto>> GetDisciplinesAsync(CancellationToken ct);
         Task<Infrastructure.Entities.Inventory.Inventory> PostPutReqApproval(InventoryDto itemDto);
         Task<RequestItem> PostPutReqItems(InventoryDto itemDto);
         Task<Lot> PostPutLotNo(InventoryDto itemDto);

CPRNIMS.Domain/Contracts/Inventory/IInventoryReports.cs

@@ -0,0 +1,17 @@
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.Contracts.Inventory
+{
+    public interface IInventoryReports
+    {
+        Task<RISReportDto> GetRISReportAsync(InventoryReportsRequest request, string userName, int? departmentId, CancellationToken ct);
+        Task<MRSReportDto> GetMRSReportAsync(InventoryReportsRequest request, string userName, int? departmentId, CancellationToken ct);
+        Task<InventoryReportDto> GetInventoryReportAsync(InventoryReportsRequest request,string userName, int? departmentId, CancellationToken ct);
+    }
+}

CPRNIMS.Domain/Contracts/Inventory/IMRS.cs

@@ -0,0 +1,22 @@
+using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Entities.Inventory;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.Contracts.Inventory
+{
+    public interface IMRS
+    {
+        Task<MRSPagedResult> GetPagedAsync(MRSFilterDto filter, CancellationToken ct,int? departmentId = null, string? userName = "");
+        Task<IReadOnlyList<RISSearchResultDto>> SearchRISForReturnAsync(string? risNoQuery, int? projectCodeId, CancellationToken ct);
+        Task<IReadOnlyList<ProjectCodeOptionDto>> GetProjectsWithOpenRISAsync(string? nameQuery, CancellationToken ct);
+        Task<MRS?> GetByIdAsync(long mrsId, CancellationToken ct);
+        Task<MRS> CreateAsync(CreateMRSRequest dto, string createdBy, CancellationToken ct);
+        Task ApproveAsync(long mrsId, string approvedBy, CancellationToken ct);
+        Task CancelAsync(CancelMRSRequest request, string canceledBy, CancellationToken ct);
+    }
+}

CPRNIMS.Domain/Contracts/Inventory/IRIS.cs

@@ -0,0 +1,22 @@
+using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using CPRNIMS.Infrastructure.Entities.Inventory;
+using CPRNIMS.Infrastructure.Entities.Purchasing;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.Contracts.Inventory
+{
+    public interface IRIS
+    {
+        Task<RISPagedResult> GetPagedAsync(RISFilterDto filter, CancellationToken ct, int? departmentId = null, string? userName = "");
+        Task<RISResponse?> GetByIdAsync(long risId, CancellationToken ct);
+        Task<Infrastructure.Entities.Inventory.RIS> CreateAsync(CreateRISRequest dto, string createdBy, CancellationToken ct);
+        Task ApproveAsync(ApproveRISRequest request, string approvedBy, CancellationToken ct);
+        Task CancelAsync(CancelRISRequest request,string canceledBy, CancellationToken ct);
+    }
+}

CPRNIMS.Domain/Contracts/Items/IItem.cs

@@ -16,14 +16,14 @@ namespace CPRNIMS.Domain.Contracts.Items
         Task<List<Departments>> GetDepartment(ItemCodeDto itemCode);
         Task<PagedResult<ItemList>> GetItemList(ItemCodeDto itemCode);
         Task<List<ItemCart>> GetItemCart(ItemDto itemDto);
-        Task<List<Item>> GetItemDetail(ItemDto itemDto);
+        Task<List<ItemDtos>> GetItemDetail(ItemDto itemDto);
         Task<List<ItemLocalization>> GetItemLocalization(ItemDto itemDto);
         Task<List<ItemCategory>> GetItemCateg(ItemDto itemDto);
         Task<List<ItemColor>> GetItemColor(ItemDto itemDto);
         Task<List<UnitOfMessure>> GetItemUOM(ItemDto itemDto);
         Task<List<NotifUserKey>> GetNotifUserKey(ItemDto itemDto);
-        Task<List<ProjectCodes>> GetProjectCode();
-        Task<List<ProjectCodes>> GetProjectCodeByTerm(string? fileName);
+        Task<IReadOnlyList<ProjectCodes>> GetProjectCode();
+        Task<IReadOnlyList<ProjectCodes>> GetProjectCodeByTerm(string? fileName);
         Task<(long, long)> GetPRNo();
         Task<ResponseObject> PostPurchRequest(ItemDto itemDto);
         Task<ItemCodeDto> PostPutItem(ItemCodeDto itemDto);

CPRNIMS.Domain/Contracts/PO/IPurchaseOrder.cs

@@ -70,6 +70,7 @@ namespace CPRNIMS.Domain.Contracts.PO
         Task<Incoterm> PostPutIncoterms(PODto pODto);
         Task<bool> DeleteIncShip(PODto poDto);
         Task<bool> PostIncShipFollowUp(PODto pODto);
+        Task<IReadOnlyList<Currencies>> GetCurrencies(string currencyName, CancellationToken ct);
         #endregion
     }
 }

CPRNIMS.Domain/Contracts/Receiving/IReceiving.cs

@@ -12,7 +12,7 @@ namespace CPRNIMS.Domain.Contracts.Receiving
     public interface IReceiving
     {
         Task<List<ReceivingDetail>> GetRRDetailByPO(ItemDto itemDto);
-        Task<List<RRDetail>> GetRRDetail(ItemDto itemDto);
+        Task<List<RRDetailDto>> GetRRDetail(ItemDto itemDto);
         Task<List<ForReceiving>> GetForReceiving(ItemDto itemDto);
         Task<List<RR>> GetRR(ItemDto itemDto);
         Task<List<RRSeries>> GetLatestRRNo(ItemDto itemDto);

CPRNIMS.Domain/Contracts/Reports/IReportBuilder.cs

@@ -0,0 +1,16 @@
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using FastReport;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.Contracts.Reports
+{
+    public interface IReportBuilder
+    {
+        Task<Report> RISBuildAsync(DateTime dateFrom, DateTime dateTo, string templatePath, CancellationToken ct);
+        Task<Report> MRSBuildAsync(DateTime dateFrom, DateTime dateTo, string templatePath, CancellationToken ct);
+    }
+}

CPRNIMS.Domain/Contracts/Reports/IReportDataService.cs

@@ -0,0 +1,16 @@
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.Contracts.Reports
+{
+    public interface IReportDataService
+    {
+        List<RISRowDto> GetMain(DateTime dateFrom, DateTime dateTo);
+        List<DisciplineAggDto> GetDisciplines(DateTime dateFrom, DateTime dateTo);
+        List<TopRecipientDto> GetRecipients(DateTime dateFrom, DateTime dateTo);
+    }
+}

CPRNIMS.Domain/Services/Account/Account.cs

@@ -57,6 +57,7 @@ namespace CPRNIMS.Domain.Services.Account
                 new Claim(ClaimTypes.NameIdentifier, user.Id),
                 new Claim("FullName", user.FullName ?? ""),
                 new Claim("Company", user.Company ?? ""),
+                new Claim("DepartmentId", Convert.ToString(user.DepartmentId)),
                 new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),
             };
 

CPRNIMS.Domain/Services/Common/TransactionFacade.cs

@@ -0,0 +1,49 @@
+using CPRNIMS.Domain.Contracts.Common;
+using CPRNIMS.Infrastructure.Database;
+using Microsoft.EntityFrameworkCore;
+
+namespace CPRNIMS.Domain.Services.Common
+{
+    public class TransactionFacade : ITransactionFacade
+    {
+        private readonly NonInventoryDbContext _db;
+
+        public TransactionFacade(NonInventoryDbContext db)
+            => _db = db ?? throw new ArgumentNullException(nameof(db));
+
+        public async Task<T> ExecuteAsync<T>(Func<Task<T>> operation, CancellationToken ct = default)
+        {
+            ArgumentNullException.ThrowIfNull(operation);
+
+            var strategy = _db.Database.CreateExecutionStrategy();
+
+            return await strategy.ExecuteAsync(async () =>
+            {
+                await using var tx = await _db.Database.BeginTransactionAsync(ct);
+                try
+                {
+                    var result = await operation();
+                    await _db.SaveChangesAsync(ct);
+                    await tx.CommitAsync(ct);
+                    return result;
+                }
+                catch
+                {
+                    await tx.RollbackAsync(ct);
+                    throw;
+                }
+            });
+        }
+
+        public async Task ExecuteAsync(Func<Task> operation, CancellationToken ct = default)
+        {
+            ArgumentNullException.ThrowIfNull(operation);
+
+            await ExecuteAsync<bool>(async () =>
+            {
+                await operation();
+                return true;
+            }, ct);
+        }
+    }
+}

CPRNIMS.Domain/Services/Finance/RR.cs

@@ -40,7 +40,7 @@ namespace CPRNIMS.Domain.Services.Finance
             return allItems ?? new List<ReceivingDetail>();
         }
 
-        public async Task<RRDetail> PostPutPayment(RRDetailsDto itemDto)
+        public async Task<RRDetailDto> PostPutPayment(RRDetailsDto itemDto)
         {
             await _dbContext.Database
                  .ExecuteSqlRawAsync("EXEC PostPutPayment @UserId, @PONo, @POTypeId, @PRDetailsId",
@@ -48,7 +48,7 @@ namespace CPRNIMS.Domain.Services.Finance
                   new SqlParameter("@PONo", itemDto.PONo),
                   new SqlParameter("@POTypeId", itemDto.POTypeId),
                   new SqlParameter("@PRDetailsId", itemDto.PRDetailsId));
-            return new RRDetail();
+            return new RRDetailDto();
         }
     }
 }

CPRNIMS.Domain/Services/Inventory/Inventory.cs

@@ -1,9 +1,11 @@
 using CPRNIMS.Domain.Contracts.Inventory;
 using CPRNIMS.Infrastructure.Database;
 using CPRNIMS.Infrastructure.Dto.Inventory;
-using CPRNIMS.Infrastructure.Dto.Items;
-using CPRNIMS.Infrastructure.Entities.Finance;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using CPRNIMS.Infrastructure.Entities.Account;
 using CPRNIMS.Infrastructure.Entities.Inventory;
+using Microsoft.AspNetCore.Identity;
 using Microsoft.Data.SqlClient;
 using Microsoft.EntityFrameworkCore;
 using System;
@@ -17,13 +19,113 @@ namespace CPRNIMS.Domain.Services.Inventory
     public class Inventory : IInventory
     {
         private readonly NonInventoryDbContext _dbContext;
-        public Inventory(NonInventoryDbContext dbContext)
+        private readonly UserManager<ApplicationUser> _userManager;
+        public Inventory(NonInventoryDbContext dbContext, UserManager<ApplicationUser> userManager)
         {
             _dbContext = dbContext;
+            _userManager = userManager;
         }
-        public async Task<List<Infrastructure.Entities.Inventory.ItemDetail>> GetInventoryById(InventoryDto itemDto)
+        public async Task<TransactContextDto?> GetTransactContextAsync(int inventoryId, CancellationToken ct)
         {
-            try
+            var inv = await _dbContext.Inventories
+                .Where(i => i.InventoryId == inventoryId && i.IsActive)
+                .Select(i => new
+                {
+                    i.InventoryId,
+                    i.QtyOnHand,
+                    i.QtyIn,
+                    i.QtyOut,
+
+                    LotNo = i.Lot != null ? i.Lot.LotName : null,
+
+                    Department = i.User != null && i.User.Department != null
+                                    ? i.User.Department.Department
+                                    : null,
+                    i.ItemNo,
+                    FirstDetail = i.InventTrans
+                        .Where(t => t.IsActive)         
+                        .SelectMany(t => t.InventTransDetails)
+                        .Where(d => d.PRDetails != null
+                                 && d.PRDetails.PRs != null
+                                 && d.IsActive)     
+                        .Select(d => new
+                        {
+                            d.PRDetails!.ItemName,
+                            PRNo = d.PRDetails.PRs!.PRNo        
+                        })
+                        .FirstOrDefault()
+                })
+                .FirstOrDefaultAsync(ct);
+
+            if (inv == null) return null;
+
+            // Computed property QtyAvailableToReturn can't be used in EF Where,
+            // so filter after projection using a raw expression in the query.
+            var openRIS = await _dbContext.RIS
+                .Where(r => r.InventoryId == inventoryId
+                         && r.Status == 1)
+                .Select(r => new RISReferenceDto
+                {
+                    RISId = r.RISId,
+                    RISNo = r.RISNo,
+                    QtyIssued = r.QtyIssued,
+                    TotalReturned = r.MaterialReturns
+                                      .Where(m => m.Status != 2)
+                                      .Sum(m => (int?)m.QtyReturned) ?? 0,
+                    DisciplineName = r.Discipline.DisciplineName,
+                    CreatedDate = r.CreatedDate
+                })
+
+                // Can't use the computed property here — EF won't translate it
+                // so we repeat the expression inline
+                .Where(r => r.QtyIssued - r.TotalReturned > 0)
+                .OrderByDescending(r => r.CreatedDate)
+                .ToListAsync(ct);
+
+            var disciplines = await GetDisciplinesAsync(ct);
+            var projectCodes = await GetProjectCodesAsync(ct);
+            return new TransactContextDto
+            {
+                InventoryId = inv.InventoryId,
+                ItemName = inv.FirstDetail?.ItemName ?? "—",
+                PRNo = inv.FirstDetail.PRNo,  
+                ItemNo = inv.ItemNo,
+                LotNo = inv.LotNo,
+                Department = inv.Department,
+                QtyOnHand = inv.QtyOnHand,
+                QtyIn = inv.QtyIn,
+                QtyOut = inv.QtyOut,
+                ProjectCodes = projectCodes,
+                Disciplines = disciplines,
+                OpenRISList = openRIS
+            };
+        }
+        public async Task<IReadOnlyList<DisciplineDto>> GetDisciplinesAsync(CancellationToken ct)
+        {
+            return await _dbContext.Disciplines
+                .AsNoTracking()
+                .OrderBy(d => d.DisciplineName)
+                .Select(d => new DisciplineDto
+                {
+                    DisciplineId = d.DisciplineId,
+                    DisciplineName = d.DisciplineName
+                })
+                .ToListAsync(ct);
+        }
+        public async Task<IReadOnlyList<ProjectCodeDto>> GetProjectCodesAsync(CancellationToken ct)
+        {
+            return await _dbContext.ProjectCodes
+                .Where(p => p.StatusName != "Completed" && p.IsActive)
+                .OrderBy(d => d.ProjectName)
+                .Select(d => new ProjectCodeDto
+                {
+                    ProjectCodeId = d.ProjectCodeId,
+                    ProjectCode = d.ProjectCode ?? "N/A",
+                    ProjectName = d.ProjectName ?? "N/A"
+                })
+                .ToListAsync(ct);
+        }
+        public async Task<List<ItemDetail>> GetInventoryById(InventoryDto itemDto)
         {
             var allItems = await _dbContext.ItemDetails
                   .FromSqlRaw($"EXEC GetInventoryById @UserId = '{itemDto.UserId}',@InventoryId = '{itemDto.InventoryId}'")
@@ -31,17 +133,86 @@ namespace CPRNIMS.Domain.Services.Inventory
 
             return allItems ?? new List<Infrastructure.Entities.Inventory.ItemDetail>();
         }
-            catch (SqlException ex)
+        public async Task<PagedResult<InventoryResponse>> GetInventory(InventoryRequest request, CancellationToken ct)
         {
-                ex.ToString();
-                throw;
-            }
+            var parameters = new[]
+            {
+                new SqlParameter("@UserId",           request.UserId),
+                new SqlParameter("@SearchPRNo",       request.SearchPRNo        ?? ""),
+                new SqlParameter("@SearchItemNo",     request.SearchItemNo      ?? ""),
+                new SqlParameter("@SearchItemName",   request.SearchItemName    ?? ""),
+                new SqlParameter("@SearchDept",       request.SearchDept        ?? ""),
+                new SqlParameter("@SearchProjectCode",request.SearchProjectCode ?? ""),
+                new SqlParameter("@PageNumber",       request.PageNumber),
+                new SqlParameter("@PageSize",         request.PageSize)
+            };
+
+            var departmentList = new List<string>();
+            int totalCount = 0;
+            var items = new List<InventoryResponse>();
+
+            await using var conn = _dbContext.Database.GetDbConnection();
+            await conn.OpenAsync(ct);
+
+            using var cmd = conn.CreateCommand();
+            cmd.CommandText = @"EXEC GetInventory @UserId, @SearchPRNo, @SearchItemNo, @SearchItemName, @SearchDept,@SearchProjectCode, @PageNumber, @PageSize";
+            foreach (var p in parameters) cmd.Parameters.Add(p);
+            cmd.CommandTimeout = 60;
+
+            using var reader = await cmd.ExecuteReaderAsync(ct);
+
+            while (await reader.ReadAsync(ct))
+                departmentList.Add(reader.GetString(0));
+
+            await reader.NextResultAsync(ct);
+            if (await reader.ReadAsync(ct))
+                totalCount = reader.GetInt32(0);
+
+            await reader.NextResultAsync(ct);
+            while (await reader.ReadAsync(ct))
+            {
+                items.Add(new InventoryResponse
+                {
+                    InventoryId = reader.GetInt32(reader.GetOrdinal("InventoryId")),
+                    QtyIn = reader["QtyIn"] as decimal? ?? 0,
+                    QtyOut = reader["QtyOut"] as decimal? ?? 0,
+                    QtyOnHand = reader["QtyOnHand"] as decimal? ?? 0,
+                    LotNo = reader["LotNo"]?.ToString(),
+                    PRNo = Convert.ToInt64(reader["PRNo"]),
+                    UserId = reader["UserId"]?.ToString(),
+                    ItemName = reader["ItemName"]?.ToString(),
+                    ItemNo = Convert.ToInt64(reader["ItemNo"]),
+                    ItemDescription = reader["ItemDescription"]?.ToString(),
+                    ItemCategoryName = reader["ItemCategoryName"]?.ToString(),
+                    Department = reader["Department"]?.ToString(),
+                    ProjectCode = reader["ProjectCode"]?.ToString(),
+                    CreatedDate = reader["CreatedDate"] == DBNull.Value
+                     ? DateTime.MinValue
+                     : Convert.ToDateTime(reader["CreatedDate"])
+                });
             }
 
-        public async Task<List<Infrastructure.Entities.Inventory.Inventory>> 
-            GetInventoryByUserId(InventoryDto itemDto)
+            await conn.CloseAsync();
+
+            return new PagedResult<InventoryResponse>
             {
-            try
+                Data = items,
+                TotalCount = totalCount,
+                PageNumber = request.PageNumber,
+                PageSize = request.PageSize,
+                DepartmentList = departmentList
+            };
+        }
+        public async Task<List<InventoryByIdResponse>> GetInventoryById(InventoryRequest itemDto,CancellationToken ct)
+        {
+            var allItems = await _dbContext.InventoryByIdResponses
+                  .FromSqlRaw($"EXEC GetInventoryById @InventoryId",
+                     new SqlParameter("@InventoryId", itemDto.InventoryId))
+                    .ToListAsync(ct);
+
+            return allItems ?? new List<InventoryByIdResponse>();
+        }
+        public async Task<List<Infrastructure.Entities.Inventory.Inventory>>GetInventoryByUserId(InventoryDto itemDto)
         {
             if (itemDto.IsSorting == false)
             {
@@ -58,16 +229,8 @@ namespace CPRNIMS.Domain.Services.Inventory
 
             return allItems ?? new List<Infrastructure.Entities.Inventory.Inventory>();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
 
         public async Task<List<Lot>> GetLotNoById(InventoryDto itemDto)
-        {
-            try
         {
             var allItems = await _dbContext.Lots
                    .FromSqlRaw($"EXEC GetLotById @UserId = '{itemDto.UserId}'")
@@ -75,12 +238,6 @@ namespace CPRNIMS.Domain.Services.Inventory
 
             return allItems ?? new List<Lot>();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
 
         public async Task<List<Lot>> GetLotNo(InventoryDto itemDto)
         {
@@ -93,8 +250,6 @@ namespace CPRNIMS.Domain.Services.Inventory
         }
 
         public async Task<Lot> PostPutLotNo(InventoryDto itemDto)
-        {
-            try
         {
             await _dbContext.Database
               .ExecuteSqlRawAsync("EXEC PostPutLotNo @UserId, @LotId, @LotTypeId,@LotName",
@@ -104,16 +259,8 @@ namespace CPRNIMS.Domain.Services.Inventory
                 new SqlParameter("@LotName", itemDto.LotName));
             return new Lot();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
 
         public async Task<Infrastructure.Entities.Inventory.Inventory> PostPutReqApproval(InventoryDto itemDto)
-        {
-            try
         {
             await _dbContext.Database
                  .ExecuteSqlRawAsync("EXEC PostPutReqApproval @UserId, @ItemNo, @Status, @Remarks",
@@ -123,16 +270,8 @@ namespace CPRNIMS.Domain.Services.Inventory
                   new SqlParameter("@Remarks", itemDto.Remarks ?? "N/A"));
             return new Infrastructure.Entities.Inventory.Inventory();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
 
         public async Task<ItemDetail> PostPutLotBin(InventoryDto itemDto)
-        {
-            try
         {
             await _dbContext.Database
                             .ExecuteSqlRawAsync("EXEC PostPutLotBin @UserId, @LotId, @InventoryId",
@@ -141,16 +280,8 @@ namespace CPRNIMS.Domain.Services.Inventory
                              new SqlParameter("@LotId", itemDto.LotId));
             return new ItemDetail();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
 
         public async Task<RequestItem> PostPutReqItems(InventoryDto itemDto)
-        {
-            try
         {
             if (itemDto.QtyReceived == null || itemDto.QtyReceived == 0)
             {
@@ -172,16 +303,8 @@ namespace CPRNIMS.Domain.Services.Inventory
                 new SqlParameter("@LotId", itemDto.LotId));
             return new RequestItem();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
 
         public async Task<List<RequestItemDetail>> GetRequestedItemByUserId(InventoryDto itemDto)
-        {
-            try
         {
             var allItems = await _dbContext.RequestItemDetails
                     .FromSqlRaw($"EXEC GetRequestedItemByUserId @UserId = '{itemDto.UserId}', " +
@@ -190,16 +313,8 @@ namespace CPRNIMS.Domain.Services.Inventory
 
             return allItems ?? new List<RequestItemDetail>();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
 
         public async Task<List<LotQtyByItem>> GetLotQtyByItem(InventoryDto itemDto)
-        {
-            try
         {
             var allItems = await _dbContext.LotQtyByItems
                  .FromSqlRaw($"EXEC GetLotQtyByItem @UserId = '{itemDto.UserId}', " +
@@ -208,11 +323,5 @@ namespace CPRNIMS.Domain.Services.Inventory
 
             return allItems ?? new List<LotQtyByItem>();
         }
-            catch (SqlException ex)
-            {
-                ex.ToString();
-                throw;
-            }
-        }
     }
 }

CPRNIMS.Domain/Services/Inventory/InventoryReports.cs

@@ -0,0 +1,307 @@
+using CPRNIMS.Domain.Contracts.Inventory;
+using CPRNIMS.Infrastructure.Database;
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using Microsoft.Data.SqlClient;
+using Microsoft.EntityFrameworkCore;
+using System.Drawing.Printing;
+using static System.Runtime.InteropServices.JavaScript.JSType;
+
+namespace CPRNIMS.Domain.Services.Inventory
+{
+    public class InventoryReports : IInventoryReports
+    {
+        private readonly NonInventoryDbContext _db;
+        public InventoryReports(NonInventoryDbContext db) => _db = db;
+
+        public async Task<RISReportDto> GetRISReportAsync(InventoryReportsRequest request, string userName, int? departmentId, CancellationToken ct)
+        {
+            var endDate = request.DateTo.Date.AddDays(1);
+
+            var allowedAllDeptUsers = new[] { "LSKRISUR24", "LSCYNDIZ25", "LSJONTAN25", "LHRIOCAS24" };
+            bool seeAllDepartments = !string.IsNullOrWhiteSpace(userName)
+                && allowedAllDeptUsers.Contains(userName, StringComparer.OrdinalIgnoreCase);
+
+            var dateToInclusive = request.DateTo.AddDays(1);
+
+            var query = _db.RIS
+                .Include(r => r.Discipline)
+                .Include(r => r.Inventory)
+                .Include(r => r.MaterialReturns)
+                .Skip((request.Page - 1) * request.PageSize)
+                .Take(request.PageSize)
+                .Where(r => r.CreatedDate >= request.DateFrom && r.CreatedDate < dateToInclusive);
+
+            if (departmentId.HasValue && !seeAllDepartments)
+            {
+                query = query.Where(m =>
+                    m.Inventory.User != null &&
+                    m.Inventory.User.DepartmentId == departmentId.Value);
+            }
+
+            var rows = await query
+                .OrderByDescending(r => r.CreatedDate)
+                .Select(r => new RISReportRow
+                {
+                    RISNo = r.RISNo,
+                    CreatedDate = r.CreatedDate,
+                    ItemName = r.PRDetail != null ? r.PRDetail.ItemName : "—",
+                    ItemNo = r.Inventory.ItemNo,
+                    DisciplineName = r.Discipline.DisciplineName,
+                    ProjectName = r.ProjectCodes.ProjectName,
+                    QtyIssued = r.QtyIssued,
+                    TotalReturned = r.MaterialReturns
+                                       .Where(m => m.Status != 2)
+                                       .Sum(m => (int?)m.QtyReturned) ?? 0,
+                    Status = r.Status,
+                    StatusLabel = r.Status == 0 ? "Draft"
+                                    : r.Status == 1 ? "Approved"
+                                    : "Cancelled"
+                })
+                .ToListAsync(ct);
+
+            foreach (var row in rows)
+                row.NetIssued = row.QtyIssued - row.TotalReturned;
+
+            var summary = new RISReportSummary
+            {
+                TotalRIS = rows.Count,
+                TotalApproved = rows.Count(r => r.Status == 1),
+                TotalPending = rows.Count(r => r.Status == 0),
+                TotalCancelled = rows.Count(r => r.Status == 2),
+                TotalQtyIssued = rows.Sum(r => r.QtyIssued),
+                TotalQtyReturned = rows.Sum(r => r.TotalReturned),
+                TotalNetIssued = rows.Sum(r => r.NetIssued),
+                ApprovalRatePct = rows.Count > 0
+                    ? Math.Round(rows.Count(r => r.Status == 1) * 100m / rows.Count, 1)
+                    : 0
+            };
+
+            var byDiscipline = rows
+                .GroupBy(r => r.DisciplineName)
+                .Select(g => new DisciplineCount { DisciplineName = g.Key, Count = g.Count() })
+                .OrderByDescending(d => d.Count)
+                .ToList();
+
+            var topRecipients = rows
+                .GroupBy(r => r.ProjectName)
+                .Select(g => new TopRecipient
+                {
+                    IssuedTo = g.Key,
+                    SlipCount = g.Count(),
+                    TotalQty = g.Sum(r => r.QtyIssued)
+                })
+                .OrderByDescending(t => t.TotalQty)
+                .Take(5)
+                .ToList();
+
+            return new RISReportDto
+            {
+                ReportNo = $"RPT-RIS-{DateTime.Now:yyyyMM}-{Random.Shared.Next(1, 999):D3}",
+                DateFrom = request.DateFrom,
+                DateTo = request.DateTo,
+                Summary = summary,
+                Rows = rows,
+                ByDiscipline = byDiscipline,
+                TopRecipients = topRecipients
+            };
+        }
+
+        public async Task<MRSReportDto> GetMRSReportAsync(InventoryReportsRequest request, string userName, int? departmentId, CancellationToken ct)
+        {
+            var endDate = request.DateTo.Date.AddDays(1);
+
+            var allowedAllDeptUsers = new[] { "LSKRISUR24", "LSCYNDIZ25", "LSJONTAN25", "LHRIOCAS24" };
+            bool seeAllDepartments = !string.IsNullOrWhiteSpace(userName)
+                && allowedAllDeptUsers.Contains(userName, StringComparer.OrdinalIgnoreCase);
+
+            var query = _db.MRS
+                      .Include(m => m.RIS)
+                      .Include(m => m.Inventory)
+                      .ThenInclude(i => i.User)
+                      .Skip((request.Page - 1) * request.PageSize)
+                      .Take(request.PageSize)
+                      .Where(m => m.CreatedDate >= request.DateFrom &&
+                                  m.CreatedDate < endDate);
+
+            if (departmentId.HasValue && !seeAllDepartments)
+            {
+                query = query.Where(m =>
+                    m.Inventory.User != null &&
+                    m.Inventory.User.DepartmentId == departmentId.Value);
+            }
+
+            var rows = await query
+                 .OrderByDescending(m => m.CreatedDate)
+                .Select(m => new MRSReportRow
+                {
+                    MRSNo = m.MRSNo,
+                    CreatedDate = m.CreatedDate,
+                    RISNo = m.RIS.RISNo,
+                    ItemName = m.RIS.PRDetail != null ? m.RIS.PRDetail.ItemName : "—",
+                    ReturnedBy = m.ReturnedBy,
+                    QtyReturned = m.QtyReturned,
+                    Condition = m.Condition ?? "Good",
+                    Status = m.Status,
+                    StatusLabel = m.Status == 0 ? "Draft"
+                                : m.Status == 1 ? "Approved"
+                                : "Cancelled"
+                })
+                .ToListAsync(ct);
+
+            // Total RIS qty issued in the same period (for the comparison panel)
+            var totalRISQty = await _db.RIS
+                .Where(r => r.CreatedDate >= request.DateFrom && r.CreatedDate < endDate
+                         && r.Status != 2)
+                .SumAsync(r => (int?)r.QtyIssued, ct) ?? 0;
+
+            var totalReturned = rows.Where(r => r.Status != 2).Sum(r => r.QtyReturned);
+            var goodCount = rows.Count(r => r.Condition == "Good");
+
+            var summary = new MRSReportSummary
+            {
+                TotalMRS = rows.Count,
+                TotalQtyReturned = totalReturned,
+                TotalQtyIssuedRIS = totalRISQty,
+                NetQtyConsumed = totalRISQty - totalReturned,
+                ReturnRatePct = totalRISQty > 0
+                    ? Math.Round(totalReturned * 100m / totalRISQty, 1)
+                    : 0,
+                GoodConditionPct = rows.Count > 0
+                    ? Math.Round(goodCount * 100m / rows.Count, 1)
+                    : 0
+            };
+
+            var byCondition = rows
+                .Where(r => r.Status != 2)
+                .GroupBy(r => r.Condition)
+                .Select(g => new ConditionTotal { Condition = g.Key, TotalQty = g.Sum(r => r.QtyReturned) })
+                .OrderByDescending(c => c.TotalQty)
+                .ToList();
+
+            return new MRSReportDto
+            {
+                ReportNo = $"RPT-MRS-{DateTime.Now:yyyyMM}-{Random.Shared.Next(1, 999):D3}",
+                DateFrom = request.DateFrom,
+                DateTo = request.DateTo,
+                Summary = summary,
+                Rows = rows,
+                ByCondition = byCondition
+            };
+        }
+
+        public async Task<InventoryReportDto> GetInventoryReportAsync(InventoryReportsRequest request, string userName, int? departmentId, CancellationToken ct)
+        {
+            var allowedAllDeptUsers = new[] { "LSKRISUR24", "LSCYNDIZ25", "LSJONTAN25", "LHRIOCAS24" };
+            bool seeAllDepartments = !string.IsNullOrWhiteSpace(userName)
+                && allowedAllDeptUsers.Contains(userName, StringComparer.OrdinalIgnoreCase);
+
+            var endDate = request.DateTo.Date.AddDays(1);
+
+            var dto = new InventoryReportDto
+            {
+                ReportNo = $"RPT-INV-{DateTime.Now:yyyyMM}-{Random.Shared.Next(1, 999):D3}",
+                AsOf = endDate,
+                Rows = new List<InventoryReportRow>(),
+                ByCategory = new List<CategoryStockLevel>(),
+                Alerts = new List<InventoryAlert>(),
+                Summary = new InventoryReportSummary(),
+                Departments = new List<string>(),   
+                Page = request.Page,                          
+                PageSize = request.PageSize                  
+            };
+
+            var conn = _db.Database.GetDbConnection();
+            await using var cmd = conn.CreateCommand();
+            cmd.CommandText = "dbo.GetInventoryReport";
+            cmd.CommandType = System.Data.CommandType.StoredProcedure;
+            cmd.Parameters.Add(new SqlParameter("@DateFrom", (object?)request.DateFrom ?? DBNull.Value));
+            cmd.Parameters.Add(new SqlParameter("@DateTo", (object?)request.DateTo ?? DBNull.Value));
+            cmd.Parameters.Add(new SqlParameter("@Department", (object?)request.Department ?? DBNull.Value));
+            cmd.Parameters.Add(new SqlParameter("@DepartmentId", (object?)departmentId ?? DBNull.Value));
+            cmd.Parameters.Add(new SqlParameter("@SeeAllDepartments", seeAllDepartments ? 1 : 0));
+            cmd.Parameters.Add(new SqlParameter("@Page", request.Page));
+            cmd.Parameters.Add(new SqlParameter("@PageSize", request.PageSize));
+            cmd.Parameters.Add(new SqlParameter("@Paginate", request.Paginate ? 1 : 0));
+
+            bool openedHere = conn.State != System.Data.ConnectionState.Open;
+            if (openedHere) await conn.OpenAsync(ct);
+
+            try
+            {
+                await using var reader = await cmd.ExecuteReaderAsync(ct);
+
+                // 0: departments
+                while (await reader.ReadAsync(ct))
+                    dto.Departments.Add(reader.GetString(reader.GetOrdinal("Department")));
+
+                // 1: detail rows
+                if (await reader.NextResultAsync(ct))
+                {
+                    while (await reader.ReadAsync(ct))
+                    {
+                        dto.Rows.Add(new InventoryReportRow
+                        {
+                            ItemName = reader.GetString(reader.GetOrdinal("ItemName")),
+                            ItemNo = reader.GetInt64(reader.GetOrdinal("ItemNo")),
+                            ItemCategoryName = reader.GetString(reader.GetOrdinal("ItemCategoryName")),
+                            LotNo = reader.IsDBNull(reader.GetOrdinal("LotNo")) ? null : reader.GetString(reader.GetOrdinal("LotNo")),
+                            Department = reader.IsDBNull(reader.GetOrdinal("Department")) ? null : reader.GetString(reader.GetOrdinal("Department")),
+                            CurrencyCode = reader.IsDBNull(reader.GetOrdinal("CurrencyCode")) ? null : reader.GetString(reader.GetOrdinal("CurrencyCode")),
+                            QtyIn = reader.GetDecimal(reader.GetOrdinal("QtyIn")),
+                            QtyOut = reader.GetDecimal(reader.GetOrdinal("QtyOut")),
+                            QtyOnHand = reader.GetDecimal(reader.GetOrdinal("QtyOnHand")),
+                            UnitPrice = reader.GetDecimal(reader.GetOrdinal("UnitPrice")),
+                            StockPct = reader.GetInt32(reader.GetOrdinal("StockPct"))
+                        });
+                    }
+                }
+
+                // 2: summary
+                if (await reader.NextResultAsync(ct) && await reader.ReadAsync(ct))
+                {
+                    dto.Summary = new InventoryReportSummary
+                    {
+                        TotalSKUs = reader.GetInt32(reader.GetOrdinal("TotalSKUs")),
+                        TotalOnHand = reader.GetDecimal(reader.GetOrdinal("TotalOnHand")),
+                        TotalQtyIn = reader.GetDecimal(reader.GetOrdinal("TotalQtyIn")),
+                        TotalQtyOut = reader.GetDecimal(reader.GetOrdinal("TotalQtyOut")),
+                        TotalValue = reader.GetDecimal(reader.GetOrdinal("TotalValue")),
+                        LowStockCount = reader.GetInt32(reader.GetOrdinal("LowStockCount")),
+                        OutOfStockCount = reader.GetInt32(reader.GetOrdinal("OutOfStockCount"))
+                    };
+                }
+
+                // 3: by category
+                if (await reader.NextResultAsync(ct))
+                    while (await reader.ReadAsync(ct))
+                        dto.ByCategory.Add(new CategoryStockLevel
+                        {
+                            CategoryName = reader.GetString(reader.GetOrdinal("CategoryName")),
+                            AvgStockPct = reader.GetInt32(reader.GetOrdinal("AvgStockPct"))
+                        });
+
+                // 4: alerts
+                if (await reader.NextResultAsync(ct))
+                    while (await reader.ReadAsync(ct))
+                        dto.Alerts.Add(new InventoryAlert
+                        {
+                            ItemName = reader.GetString(reader.GetOrdinal("ItemName")),
+                            QtyOnHand = reader.GetDecimal(reader.GetOrdinal("QtyOnHand")),
+                            Severity = reader.GetString(reader.GetOrdinal("Severity"))
+                        });
+
+                // 5: total row count
+                if (await reader.NextResultAsync(ct) && await reader.ReadAsync(ct))
+                    dto.TotalRows = reader.GetInt32(reader.GetOrdinal("TotalRows"));
+            }
+            finally
+            {
+                if (conn.State == System.Data.ConnectionState.Open)
+                    await conn.CloseAsync();
+            }
+
+            return dto;
+        }
+    }
+}

CPRNIMS.Domain/Services/Inventory/MRS.cs

@@ -0,0 +1,260 @@
+using CPRNIMS.Domain.Contracts.Common;
+using CPRNIMS.Domain.Contracts.Inventory;
+using CPRNIMS.Infrastructure.Database;
+using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Entities.Inventory;
+using Microsoft.EntityFrameworkCore;
+
+namespace CPRNIMS.Domain.Services.Inventory
+{
+    public class MRS : IMRS
+    {
+        private readonly NonInventoryDbContext _db;
+        private readonly ITransactionFacade _transactionFacade;
+        public MRS(NonInventoryDbContext db, ITransactionFacade transactionFacade)
+        {
+            _db = db;
+            _transactionFacade = transactionFacade;
+        }
+        public async Task ApproveAsync(long mrsId, string approvedBy, CancellationToken ct)
+        {
+            //var user = await _userManager.FindByNameAsync(approvedBy);
+            //if (user != null)
+            //{
+            //    bool isApprover2 = await _userManager.IsInRoleAsync(user, "APPROVER2");
+
+            //    if (!isApprover2)
+            //    {
+            //        throw new Exception("You have no permission to approve this item.");
+            //    }
+            //}
+
+            var rms = await _db.MRS.FindAsync(mrsId)
+                ?? throw new InvalidOperationException("MRS not found.");
+
+            if (rms.Status != 0)
+                throw new InvalidOperationException("Only Draft MRS records can be approved.");
+
+            rms.Status = 1; // Approved
+            rms.ApprovedBy = approvedBy;
+            rms.ApprovedDate = DateTime.Now;
+
+            await _db.SaveChangesAsync(ct);
+        }
+
+        public async Task CancelAsync(CancelMRSRequest request,string canceledBy, CancellationToken ct)
+        {
+            //var user = await _userManager.FindByNameAsync(canceledBy);
+            //if (user != null)
+            //{
+            //    bool isApprover2 = await _userManager.IsInRoleAsync(user, "APPROVER2");
+
+            //    if (!isApprover2)
+            //    {
+            //        throw new Exception("You have no permission to cancel this item.");
+            //    }
+            //}
+
+            await _transactionFacade.ExecuteAsync(async () =>
+            {
+                var mrs = await _db.MRS
+                .Include(m => m.Inventory)
+                .FirstOrDefaultAsync(m => m.MRSId == request.MRSId)
+                ?? throw new InvalidOperationException("MRS not found.");
+
+                if (mrs.Status == 2)
+                    throw new InvalidOperationException("MRS is already cancelled.");
+
+                // Reverse the return: deduct qty back out
+                mrs.Inventory.QtyOut = Math.Max(0m, mrs.Inventory.QtyOut) + mrs.QtyReturned;
+                mrs.Inventory.QtyOnHand = mrs.Inventory.QtyIn - mrs.Inventory.QtyOut;
+                mrs.Reason = request.Reason;
+                mrs.Status = 2;
+                mrs.CanceledDate = DateTime.Now;
+                mrs.CanceledBy = canceledBy;
+            }, ct);
+        }
+
+        public async Task<Infrastructure.Entities.Inventory.MRS> CreateAsync(CreateMRSRequest dto, string createdBy, CancellationToken ct)
+        {
+            return await _transactionFacade.ExecuteAsync(async () =>
+            {
+                var ris = await _db.RIS
+                   .Include(r => r.Inventory)
+                   .FirstOrDefaultAsync(r => r.RISId == dto.RISId, ct)
+                   ?? throw new InvalidOperationException("Referenced RIS not found.");
+
+                if (dto.QtyReturned > ris.QtyIssued)
+                    throw new InvalidOperationException(
+                        $"Cannot return more than issued. Issued: {ris.QtyIssued}.");
+
+                var mrsNo = await GenerateMRSNoAsync();
+
+                var mrs = new Infrastructure.Entities.Inventory.MRS
+                {
+                    MRSNo = mrsNo,
+                    RISId = dto.RISId,
+                    InventoryId = ris.InventoryId,
+                    ReturnedBy = dto.ReturnedBy,
+                    QtyReturned = dto.QtyReturned,
+                    Condition = dto.Condition,
+                    Remarks = dto.Remarks,
+                    Status = 1,//Matic Approve for now
+                    CreatedBy = createdBy,
+                    CreatedDate = DateTime.Now
+                };
+                _db.MRS.Add(mrs);
+
+                var inventory = ris.Inventory;
+                inventory.QtyOut = Math.Max(0m, inventory.QtyOut - dto.QtyReturned);
+
+                inventory.QtyOnHand = inventory.QtyIn - inventory.QtyOut;
+
+                var trans = await _db.InventTrans
+                    .FirstOrDefaultAsync(t => t.InventoryId == ris.InventoryId && t.IsActive == true, ct)!;
+
+                _db.InventTransDetails.Add(new InventTransDetail
+                {
+                    InventTransId = trans.InventTransId,
+                    TransTypeId = 6,
+                    QtyIn = dto.QtyReturned,
+                    CreatedDate = DateTime.Now,
+                    Remarks = $"MRS: {mrsNo} — return from MRS: {ris.RISNo}",
+                    IsActive = true
+                });
+
+                return mrs;
+            }, ct);
+        }
+
+        public async Task<Infrastructure.Entities.Inventory.MRS?> GetByIdAsync(long mrsId, CancellationToken ct)
+        
+             => await _db.MRS
+                .Include(r => r.Inventory)
+                .Include(r => r.RIS)
+                .FirstOrDefaultAsync(r => r.RISId == mrsId, ct);
+
+        public async Task<MRSPagedResult> GetPagedAsync(MRSFilterDto filter, CancellationToken ct,
+             int? departmentId = null, string? userName = "")
+        {
+            var allowedAllDeptUsers = new[] { "LSKRISUR24", "LSCYNDIZ25", "LSJONTAN25", "LHRIOCAS24" };
+            bool seeAllDepartments = !string.IsNullOrWhiteSpace(userName)
+                && allowedAllDeptUsers.Contains(userName, StringComparer.OrdinalIgnoreCase);
+
+            var q = _db.MRS
+                .Include(m => m.RIS)
+                .Include(m => m.Inventory)
+                .AsQueryable();
+
+            if (departmentId.HasValue && !seeAllDepartments)
+            {
+                q = q.Where(itd =>
+                    itd.Inventory.User.DepartmentId == departmentId.Value);
+            }
+
+            if (!string.IsNullOrWhiteSpace(filter.SearchMRSNo))
+                q = q.Where(m => m.MRSNo.Contains(filter.SearchMRSNo));
+
+            if (filter.RISId.HasValue)
+                q = q.Where(m => m.RISId == filter.RISId.Value);
+
+            if (filter.Status.HasValue)
+                q = q.Where(m => m.Status == filter.Status.Value);
+
+            if (filter.DateFrom.HasValue)
+                q = q.Where(m => m.CreatedDate >= filter.DateFrom.Value);
+
+            if (filter.DateTo.HasValue)
+                q = q.Where(m => m.CreatedDate <= filter.DateTo.Value.AddDays(1));
+
+            var total = await q.CountAsync(ct);
+
+            var data = await q
+                .OrderByDescending(m => m.CreatedDate)
+                .Skip((filter.PageNumber - 1) * filter.PageSize)
+                .Take(filter.PageSize)
+                .Select(m => new MRSPagedDto
+                {
+                    MRSId = m.MRSId,
+                    MRSNo = m.MRSNo,
+                    RISId = m.RISId,
+                    RISNo = m.RIS.RISNo,
+                    InventoryId = m.InventoryId,
+                    ItemName = m.Inventory.InventTrans
+                                   .SelectMany(t => t.InventTransDetails)
+                                   .Select(d => d.PRDetails != null ? d.PRDetails.ItemName : "—")
+                                   .FirstOrDefault() ?? "—",
+                    ReturnedBy = m.ReturnedBy,
+                    QtyReturned = m.QtyReturned,
+                    Condition = m.Condition,
+                    Remarks = m.Remarks,
+                    Status = m.Status,
+                    CreatedBy = m.CreatedBy,
+                    CreatedDate = m.CreatedDate,
+                    ApprovedBy = m.ApprovedBy,
+                    ApprovedDate = m.ApprovedDate
+                })
+                .ToListAsync(ct);
+
+            return new MRSPagedResult { Data = data, RecordsTotal = total };
+        }
+        private async Task<string> GenerateMRSNoAsync()
+        {
+            var year = DateTime.Now.Year;
+            var month = DateTime.Now.Month.ToString("D2");
+            var count = await _db.MRS.CountAsync(m => m.CreatedDate.Year == year) + 1;
+            return $"MRS-{year}{month}-{count:D4}";
+        }
+        public async Task<IReadOnlyList<RISSearchResultDto>> SearchRISForReturnAsync(string? risNoQuery, int? projectCodeId, CancellationToken ct)
+        {
+            var query = _db.RIS
+                .Where(r => r.Status == 1);
+
+            if (projectCodeId.HasValue)
+                query = query.Where(r => r.ProjectCodeId == projectCodeId.Value);
+
+            if (!string.IsNullOrWhiteSpace(risNoQuery))
+                query = query.Where(r => r.RISNo.Contains(risNoQuery));
+
+            return await query
+                .Select(r => new RISSearchResultDto
+                {
+                    RISId = r.RISId,
+                    RISNo = r.RISNo,
+                    ProjectCodeId = r.ProjectCodeId,
+                    ProjectCode = r.ProjectCodes.ProjectCode ?? "N/A",
+                    ProjectName = r.ProjectCodes.ProjectName ?? "N/A",
+                    DisciplineName = r.Discipline.DisciplineName,
+                    QtyAvailableToReturn = r.QtyIssued - r.MaterialReturns.Sum(m => m.QtyReturned)
+                })
+                .Where(r => r.QtyAvailableToReturn > 0)
+                .OrderByDescending(r => r.RISId)
+                .Take(20) 
+                .ToListAsync(ct);
+        }
+
+        public async Task<IReadOnlyList<ProjectCodeOptionDto>> GetProjectsWithOpenRISAsync(string? nameQuery, CancellationToken ct)
+        {
+            var query = _db.RIS
+                .Where(r => r.Status == 1 && r.QtyIssued > r.MaterialReturns.Sum(m => m.QtyReturned));
+
+            if (!string.IsNullOrWhiteSpace(nameQuery))
+                query = query.Where(r =>
+                    r.ProjectCodes.ProjectName.Contains(nameQuery) ||
+                    r.ProjectCodes.ProjectCode.Contains(nameQuery));
+
+            return await query
+                .Select(r => new ProjectCodeOptionDto
+                {
+                    ProjectCodeId = r.ProjectCodeId,
+                    ProjectCode = r.ProjectCodes.ProjectCode ?? "N/A",
+                    ProjectName = r.ProjectCodes.ProjectName ?? "N/A"
+                })
+                .Distinct()
+                .OrderBy(p => p.ProjectName)
+                .Take(20)
+                .ToListAsync(ct);
+        }
+    }
+}

CPRNIMS.Domain/Services/Inventory/RIS.cs

@@ -0,0 +1,331 @@
+using CPRNIMS.Domain.Contracts.Common;
+using CPRNIMS.Domain.Contracts.Inventory;
+using CPRNIMS.Infrastructure.Database;
+using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using CPRNIMS.Infrastructure.Entities.Inventory;
+using Microsoft.EntityFrameworkCore;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.Services.Inventory
+{
+    public class RIS : IRIS
+    {
+        private readonly NonInventoryDbContext _db;
+        private readonly ITransactionFacade _transactionFacade;
+        public RIS(NonInventoryDbContext db, ITransactionFacade transactionFacade)
+        {
+            _db = db;
+            _transactionFacade = transactionFacade;
+        }
+        public async Task<Infrastructure.Entities.Inventory.RIS> CreateAsync(CreateRISRequest dto, string createdBy, CancellationToken ct)
+        {
+            return await _transactionFacade.ExecuteAsync(async () =>
+            {
+                var inventory = await _db.Inventories
+                        .FirstOrDefaultAsync(i => i.InventoryId == dto.InventoryId, ct)
+                        ?? throw new InvalidOperationException("Inventory record not found.");
+
+                if (inventory.QtyOnHand < dto.QtyIssued)
+                    throw new InvalidOperationException(
+                        $"Insufficient stock. On hand: {inventory.QtyOnHand}, requested: {dto.QtyIssued}.");
+
+                var risNo = await GenerateRISNoAsync(ct);
+
+                var ris = new Infrastructure.Entities.Inventory.RIS
+                {
+                    RISNo = risNo,
+                    InventoryId = dto.InventoryId,
+                    PRDetailId = dto.PRDetailId,
+                    ProjectCodeId = dto.ProjectCodeId,
+                    DisciplineId = dto.DisciplineId,
+                    QtyIssued = dto.QtyIssued,
+                    Remarks = dto.Remarks,
+                    Status = 1,//Approved alredy 0 is Draft
+                    CreatedBy = createdBy,
+                    CreatedDate = DateTime.Now
+                };
+                _db.RIS.Add(ris);
+
+                var trans = await _db.InventTrans
+                    .Where(t => t.InventoryId == dto.InventoryId && t.IsActive == true)
+                    .FirstOrDefaultAsync(ct)
+                    ?? throw new InvalidOperationException(
+                        "No active InventTrans found for this inventory record.");
+
+                _db.InventTransDetails.Add(new InventTransDetail
+                {
+                    InventTransId = trans.InventTransId,
+                    TransTypeId = 5,
+                    PRDetailId = dto.PRDetailId,
+                    QtyOut = dto.QtyIssued,
+                    CreatedDate = DateTime.Now,
+                    Remarks = $"RIS: {risNo}",
+                    IsActive = true
+                });
+
+                inventory.QtyOut = Math.Max(0m, inventory.QtyOut) + dto.QtyIssued;
+                inventory.QtyOnHand = Math.Max(0m, inventory.QtyIn) - (decimal)inventory.QtyOut;
+
+                return ris;
+            }, ct);
+        }
+
+        public async Task ApproveAsync(ApproveRISRequest request, string approvedBy, CancellationToken ct)
+        {
+            //var user = await _userManager.FindByNameAsync(approvedBy);
+            //if (user != null)
+            //{
+            //    bool isApprover2 = await _userManager.IsInRoleAsync(user, "APPROVER2");
+
+            //    if (!isApprover2)
+            //    {
+            //        throw new Exception("You have no permission to approved this item.");
+            //    }
+            //}
+
+            var ris = await _db.RIS.FindAsync(request.RISId, ct)
+                ?? throw new InvalidOperationException("RIS not found.");
+
+            if (ris.Status != 0)
+                throw new InvalidOperationException("Only Draft RIS records can be approved.");
+
+            ris.Status = 1; // Approved
+            ris.ApprovedBy = approvedBy;
+            ris.ApprovedDate = DateTime.Now;
+
+            await _db.SaveChangesAsync(ct);
+        }
+
+        public async Task CancelAsync(CancelRISRequest request,string canceledBy, CancellationToken ct)
+        {
+            //var user = await _userManager.FindByNameAsync(canceledBy);
+            //if (user != null)
+            //{
+            //    bool isApprover2 = await _userManager.IsInRoleAsync(user, "APPROVER2");
+
+            //    if (!isApprover2)
+            //    {
+            //        throw new Exception("You have no permission to cancel this item.");
+            //    }
+            //}
+
+            await _transactionFacade.ExecuteAsync(async () =>
+            {
+                var ris = await _db.RIS
+                    .Include(r => r.Inventory)
+                    .FirstOrDefaultAsync(r => r.RISId == request.RISId, ct)
+                    ?? throw new InvalidOperationException("RIS not found.");
+
+                    if (ris.Status == 2)
+                        throw new InvalidOperationException("RIS is already cancelled.");
+
+                    //Check if already approved the related RIS No to MRS must cannot be cancel
+                    var mrs = await _db.MRS.FirstOrDefaultAsync(m => m.RISId == request.RISId, ct);
+
+                    if (mrs != null)
+                    {
+                        if (mrs.Status == 1)
+                        {
+                            throw new InvalidOperationException(
+                                $"MRS #{mrs.MRSNo} has already been approved in relation to RIS #{ris.RISNo}.");
+                        }
+
+                        mrs.Status = 2;
+                        mrs.CanceledDate = DateTime.Now;
+                        mrs.CanceledBy = canceledBy;
+                        mrs.Reason = "Canceled in RIS already";
+                    }
+
+                    ris.Inventory.QtyOut = Math.Max(0m, ris.Inventory.QtyOut - ris.QtyIssued);
+                    ris.Inventory.QtyOnHand = ris.Inventory.QtyIn - ris.Inventory.QtyOut;
+                    ris.Reason = request.Reason;
+                    ris.Status = 2; // Cancelled
+
+                    var trans = await _db.InventTrans
+                     .Where(t => t.InventoryId == ris.InventoryId && t.IsActive == true)
+                     .FirstOrDefaultAsync(ct)
+                     ?? throw new InvalidOperationException(
+                         "No active InventTrans found for this inventory record.");
+
+                    _db.InventTransDetails.Add(new InventTransDetail
+                    {
+                        InventTransId = trans.InventTransId,
+                        TransTypeId = 5,
+                        PRDetailId = ris.PRDetailId,
+                        QtyIn = ris.QtyIssued,//Return the issued Qty
+                        CreatedDate = DateTime.Now,
+                        Remarks = request.Reason,
+                        IsActive = true
+                    });
+            }, ct);
+        }
+
+        private async Task<string> GenerateRISNoAsync(CancellationToken ct)
+        {
+            var year = DateTime.Now.Year;
+            var month = DateTime.Now.Month.ToString("D2");
+            var count = await _db.RIS
+                .CountAsync(r => r.CreatedDate.Year == year,ct) + 1;
+            return $"RIS-{year}{month}-{count:D4}"; // e.g. RIS-202606-0001
+        }
+
+        public async Task<RISPagedResult> GetPagedAsync(RISFilterDto filter, CancellationToken ct,
+             int? departmentId = null, string? userName = "")
+        {
+            var allowedAllDeptUsers = new[] { "LSKRISUR24", "LSCYNDIZ25", "LSJONTAN25", "LHRIOCAS24" };
+            bool seeAllDepartments = !string.IsNullOrWhiteSpace(userName)
+                && allowedAllDeptUsers.Contains(userName, StringComparer.OrdinalIgnoreCase);
+
+            var q = _db.RIS
+                   .Include(r => r.Discipline)
+                   .Include(r => r.Inventory)
+                   .Include(r => r.MaterialReturns)
+                   .AsQueryable();
+
+            if (departmentId.HasValue && !seeAllDepartments)
+            {
+                q = q.Where(itd =>
+                    itd.Inventory.User.DepartmentId == departmentId.Value);
+            }
+
+            // Status filter (default to Draft=0 if null)
+            if (filter.Status.HasValue)
+                q = q.Where(r => r.Status == filter.Status.Value);
+            //else
+            //    q = q.Where(r => r.Status == 0);
+
+            // RIS No
+            if (!string.IsNullOrWhiteSpace(filter.SearchRISNo))
+                q = q.Where(r => r.RISNo.Contains(filter.SearchRISNo));
+
+            // Item Name
+            if (!string.IsNullOrWhiteSpace(filter.SearchItemName))
+                q = q.Where(r => r.Inventory.InventTrans
+                        .SelectMany(t => t.InventTransDetails)
+                        .Any(d => d.PRDetails != null &&
+                                  d.PRDetails.ItemName.Contains(filter.SearchItemName)));
+
+            // Issued To is Project code/name
+            if (!string.IsNullOrWhiteSpace(filter.SearchIssuedTo))
+                q = q.Where(r => r.ProjectCodes.ProjectCode.Contains(filter.SearchIssuedTo)
+                    || r.ProjectCodes.ProjectName.Contains(filter.SearchIssuedTo));
+
+            // Discipline
+            if (!string.IsNullOrWhiteSpace(filter.Discipline))
+                q = q.Where(r => r.Discipline.DisciplineName == filter.Discipline);
+
+            // Date range (if you ever add date filters)
+            if (filter.DateFrom.HasValue)
+                q = q.Where(r => r.CreatedDate >= filter.DateFrom.Value);
+            if (filter.DateTo.HasValue)
+                q = q.Where(r => r.CreatedDate <= filter.DateTo.Value.AddDays(1));
+
+            var total = await q.CountAsync(ct);
+
+            var data = await q
+                .OrderByDescending(r => r.CreatedDate)
+                .Skip((filter.PageNumber - 1) * filter.PageSize)
+                .Take(filter.PageSize)
+                .Select(r => new RISResponse
+                {
+                    RISId = r.RISId,
+                    RISNo = r.RISNo,
+                    InventoryId = r.InventoryId,
+                    ItemName = r.Inventory.InventTrans
+                                      .SelectMany(t => t.InventTransDetails)
+                                      .Select(d => d.PRDetails != null ? d.PRDetails.ItemName : "—")
+                                      .FirstOrDefault() ?? "—",
+                    ItemNo = r.Inventory.ItemNo,
+                    LotNo = r.Inventory.Lot != null ? r.Inventory.Lot.LotName : null,
+                    ProjectName = r.ProjectCodes.ProjectName,
+                    ProjectCode = r.ProjectCodes.ProjectCode,
+                    DisciplineName = r.Discipline.DisciplineName,
+                    DisciplineId = r.DisciplineId,
+                    QtyIssued = r.QtyIssued,
+                    Remarks = r.Remarks,
+                    Status = r.Status,
+                    CreatedBy = r.CreatedBy,
+                    CreatedDate = r.CreatedDate,
+                    ApprovedBy = r.ApprovedBy,
+                    ApprovedDate = r.ApprovedDate,
+                    MRSCount = r.MaterialReturns.Count(m => m.Status != 2),
+                    TotalReturned = r.MaterialReturns
+                                      .Where(m => m.Status != 2)
+                                      .Sum(m => m.QtyReturned)
+                })
+                .ToListAsync(ct);
+
+            // Full department list (never filtered)
+            var departments = await _db.Departments
+                .Select(d => d.Department)
+                .OrderBy(d => d)
+                .ToListAsync(ct);
+
+            var disciplines = await GetDisciplinesAsync(ct);
+
+            return new RISPagedResult
+            {
+                Data = data,
+                RecordsTotal = total,
+                DepartmentList = departments,
+                DisciplineList = disciplines
+            };
+        }
+        public async Task<IReadOnlyList<DisciplineDto>> GetDisciplinesAsync(CancellationToken ct)
+        {
+            return await _db.Disciplines
+                .OrderBy(d => d.DisciplineName)
+                .Select(d => new DisciplineDto
+                {
+                    DisciplineId = d.DisciplineId,
+                    DisciplineName = d.DisciplineName
+                })
+                .ToListAsync(ct);
+        }
+        public async Task<IReadOnlyList<ProjectCodeDto>> GetProjectCodesAsync(CancellationToken ct)
+        {
+            return await _db.ProjectCodes
+                .Where(p=>p.StatusName !="Completed")
+                .OrderBy(d => d.ProjectName)
+                .Select(d => new ProjectCodeDto
+                {
+                    ProjectCodeId= d.ProjectCodeId,
+                    ProjectCode = d.ProjectCode ?? "N/A",
+                    ProjectName = d.ProjectName ?? "N/A"
+                })
+                .ToListAsync(ct);
+        }
+        public async Task<RISResponse?> GetByIdAsync(long risId, CancellationToken ct)
+        { 
+             return  await _db.RIS
+                .Where(r => r.RISId == risId)
+                .Select(r => new RISResponse
+                {
+                    RISId = r.RISId,
+                    RISNo = r.RISNo,
+                    InventoryId = r.InventoryId,
+                    ProjectCodeId = r.ProjectCodeId,
+                    DisciplineName = r.Discipline.DisciplineName,
+                    DisciplineId = r.DisciplineId,
+                    QtyIssued = r.QtyIssued,
+                    Remarks = r.Remarks,
+                    Status = r.Status,
+                    CreatedBy = r.CreatedBy,
+                    CreatedDate = r.CreatedDate,
+                    ApprovedBy = r.ApprovedBy,
+                    ApprovedDate = r.ApprovedDate,
+                    MRSCount = r.MaterialReturns.Count(m => m.Status != 2),
+                    TotalReturned = r.MaterialReturns
+                                      .Where(m => m.Status != 2)
+                                      .Sum(m => m.QtyReturned)
+                })
+                .FirstOrDefaultAsync(ct);
+        }
+    }
+}

CPRNIMS.Domain/Services/Items/Item.cs

@@ -63,7 +63,6 @@ namespace CPRNIMS.Domain.Services.Items
                 UserId = itemDto.UserId
             };
         }
-
         public async Task<Infrastructure.Entities.Items.Item> PutItemDetail(ItemDto itemDto)
         {
             await _dbContext.Database
@@ -92,6 +91,139 @@ namespace CPRNIMS.Domain.Services.Items
 
             return new Infrastructure.Entities.Items.Item();
         }
+        public async Task<ItemAttachement> PostPutItemPath(ItemDto itemDto)
+        {
+            var isExist = await _dbContext.ItemAttachements
+                      .FirstOrDefaultAsync(ia => ia.IsActive == true
+                      && ia.ItemNo == itemDto.ItemNo);
+            if (isExist != null)
+            {
+                isExist.ItemAttachPath = itemDto.ItemAttachPath;
+                await _dbContext.SaveChangesAsync();
+                return new ItemAttachement();
+            }
+            else
+            {
+                return new ItemAttachement();
+            }
+        }
+        public async Task<ItemCart> PostPutItemCart(ItemDto itemDto)
+        {
+            await _dbContext.Database
+                .ExecuteSqlRawAsync("EXEC PostPutItemCart @ItemCartId,@ItemNo,@UserId,@UOMId,@ItemColorId,@ItemCategoryId,@PackagingTypeId,@ItemAttachId,@ItemLocalId",
+                 new SqlParameter("@ItemCartId", itemDto.ItemCartId != null ? itemDto.ItemCartId : 0L),
+                 new SqlParameter("@ItemNo", itemDto.ItemNo != null ? itemDto.ItemNo : 0L),
+                 new SqlParameter("@UOMId", itemDto.UOMId),
+                 new SqlParameter("@ItemColorId", itemDto.ItemColorId),
+                 new SqlParameter("@ItemCategoryId", itemDto.ItemCategoryId),
+                 new SqlParameter("@PackagingTypeId", itemDto.PackagingTypeId),
+                 new SqlParameter("@ItemAttachId", itemDto.ItemAttachId),
+                 new SqlParameter("@UserId", itemDto.UserId),
+                 new SqlParameter("@ItemLocalId", itemDto.ItemLocalId));
+            return new ItemCart();
+        }
+        public async Task<ResponseObject> PostPurchRequest(ItemDto itemDto)
+        {
+            var (messCode, message) = OutputParamMessage.CreateOutputParams();
+
+            if (itemDto.RequestTypeId == 1)//Internal
+            {
+                itemDto.Status = 2;
+                itemDto.IsApproved = 2;
+
+                await _dbContext.Database
+              .ExecuteSqlRawAsync("EXEC PostPutReqItems @UserId, @RequestItemId, @ItemNo, @QtyRequest,@Status,@IsApproved,@QtyReceived,@LotId," +
+              "@MessCode OUTPUT, @Message OUTPUT",
+               new SqlParameter("@UserId", itemDto.UserId),
+               new SqlParameter("@ItemNo", itemDto.ItemNo),
+               new SqlParameter("@RequestItemId", itemDto.RequestItemId != null ? itemDto.RequestItemId : 0L),
+               new SqlParameter("@QtyRequest", itemDto.Qty),
+               new SqlParameter("@Status", itemDto.Status),
+               new SqlParameter("@IsApproved", itemDto.IsApproved),
+                new SqlParameter("@QtyReceived", itemDto.QtyReceived),
+               new SqlParameter("@LotId", itemDto.LotId),
+               messCode,message);
+            }
+            else
+            {
+                await _dbContext.Database
+               .ExecuteSqlRawAsync("EXEC PostPurchRequest @ItemCartId, @IsActive, @UserId,@ItemCount," +
+                "@PRNo,@DateNeeded,@Qty,@ChargeTo,@Remarks,@ProjectCodeId,@MessCode OUTPUT, @Message OUTPUT",
+                 new SqlParameter("@ItemCartId", itemDto.ItemCartId != null ? itemDto.ItemCartId : 0L),
+                 new SqlParameter("@IsActive", 1),
+                 new SqlParameter("@UserId", itemDto.UserId),
+                 new SqlParameter("@ItemCount", itemDto.ItemCount),
+                 new SqlParameter("@PRNo", itemDto.PRNo),
+                 new SqlParameter("@DateNeeded", itemDto.DateNeeded),
+                 new SqlParameter("@Qty", itemDto.Qty),
+                 new SqlParameter("@ChargeTo", itemDto.ChargeTo),
+                 new SqlParameter("@Remarks", itemDto.Remarks ?? "N/A"),
+                 new SqlParameter("@ProjectCodeId", itemDto.ProjectCodeId),
+                messCode, message);
+            }
+
+            return new ResponseObject() { 
+                messCode= (byte)messCode.Value,
+                message= message.Value.ToString()
+            };
+        }
+        public async Task PostPutAttachment(AttachmentRequest attach)
+        {
+            var existing = await _dbContext.PRAttachments
+                .FirstOrDefaultAsync(a => a.PRId == attach.PRId);
+            if (existing == null)
+            {
+                var attchmnt = new PRAttachments()
+                {
+                    FileName = attach.FileName,
+                    OrigFileName = attach.OrigFileName,
+                    PRId = attach.PRId
+                };
+                await _dbContext.PRAttachments.AddAsync(attchmnt);
+            }
+            else
+            {
+                existing.OrigFileName = attach.OrigFileName;
+                existing.FileName = attach.FileName;
+            }
+            await _dbContext.SaveChangesAsync();
+        }   
+        Task<ItemCart> IItem.PostPutItemPath(ItemDto itemDto)
+        {
+            throw new NotImplementedException();
+        }
+        public async Task<List<ItemCart>> GetItemCart(ItemDto itemDto)
+        {
+            var allItems = await _dbContext.ItemCarts
+                  .FromSqlRaw($"EXEC GetItemCart @UserId,@RequestTypeId,@IsCount",
+                  new SqlParameter("@UserId", itemDto.UserId),
+                  new SqlParameter("@RequestTypeId", itemDto.RequestTypeId),
+                  new SqlParameter("@IsCount", itemDto.IsCount))
+                  .ToListAsync();
+
+            return allItems ?? new List<ItemCart>();
+        }
+        public async Task<(long, long)> GetPRNo()
+        {
+            try
+            {
+                var latestPR = await _dbContext.PRs
+                          .Where(ic => ic.PRNo != null)
+                          .OrderByDescending(ic => ic.PRNo)
+                          .FirstOrDefaultAsync();
+
+                if (latestPR != null)
+                    return (latestPR.PRNo + 1, latestPR.PRId + 1);
+                else
+                    return (0, 0);
+            }
+            catch (Exception ex)
+            {
+
+                throw;
+            }
+
+        }
         public async Task<List<ItemLocalization>> GetItemLocalization(ItemDto itemDto)
         {
             var localizations = await _dbContext.ItemLocalizations
@@ -119,18 +251,16 @@ namespace CPRNIMS.Domain.Services.Items
                 return categories ?? new List<ItemCategory>();
             }
         }
-
-        public async Task<List<Infrastructure.Entities.Items.Item>> GetItemDetail(ItemDto itemDto)
+        public async Task<List<ItemDtos>> GetItemDetail(ItemDto itemDto)
         {
-            var allItems = await _dbContext.Items
+            var allItems = await _dbContext.ItemDtos
                    .FromSqlRaw($"EXEC GetItemDetail @ItemCodeId,@UserId",
                    new SqlParameter("@ItemCodeId", itemDto.ItemCodeId),
                    new SqlParameter("@UserId", itemDto.UserId))
                    .ToListAsync();
 
-            return allItems ?? new List<Infrastructure.Entities.Items.Item>();
+            return allItems ?? new List<ItemDtos>();
         }
-
         public async Task<PagedResult<ItemList>> GetItemList(ItemCodeDto dto)
         {
             var parameters = new[]
@@ -200,7 +330,6 @@ namespace CPRNIMS.Domain.Services.Items
 
             return colors ?? new List<ItemColor>();
         }
-
         public async Task<List<UnitOfMessure>> GetItemUOM(ItemDto itemDto)
         {
             var uoms = await _dbContext.UnitOfMessures
@@ -211,143 +340,6 @@ namespace CPRNIMS.Domain.Services.Items
 
             return uoms ?? new List<UnitOfMessure>();
         }
-
-        public async Task<ItemAttachement> PostPutItemPath(ItemDto itemDto)
-        {
-            var isExist = await _dbContext.ItemAttachements
-                      .FirstOrDefaultAsync(ia => ia.IsActive == true
-                      && ia.ItemNo == itemDto.ItemNo);
-            if (isExist != null)
-            {
-                isExist.ItemAttachPath = itemDto.ItemAttachPath;
-                await _dbContext.SaveChangesAsync();
-                return new ItemAttachement();
-            }
-            else
-            {
-                return new ItemAttachement();
-            }
-        }
-        public async Task<ItemCart> PostPutItemCart(ItemDto itemDto)
-        {
-            await _dbContext.Database
-                .ExecuteSqlRawAsync("EXEC PostPutItemCart @ItemCartId,@ItemNo,@UserId,@UOMId,@ItemColorId,@ItemCategoryId,@PackagingTypeId,@ItemAttachId,@ItemLocalId",
-                 new SqlParameter("@ItemCartId", itemDto.ItemCartId != null ? itemDto.ItemCartId : 0L),
-                 new SqlParameter("@ItemNo", itemDto.ItemNo != null ? itemDto.ItemNo : 0L),
-                 new SqlParameter("@UOMId", itemDto.UOMId),
-                 new SqlParameter("@ItemColorId", itemDto.ItemColorId),
-                 new SqlParameter("@ItemCategoryId", itemDto.ItemCategoryId),
-                 new SqlParameter("@PackagingTypeId", itemDto.PackagingTypeId),
-                 new SqlParameter("@ItemAttachId", itemDto.ItemAttachId),
-                 new SqlParameter("@UserId", itemDto.UserId),
-                 new SqlParameter("@ItemLocalId", itemDto.ItemLocalId));
-            return new ItemCart();
-        }
-
-        public async Task<List<ItemCart>> GetItemCart(ItemDto itemDto)
-        {
-            var allItems = await _dbContext.ItemCarts
-                  .FromSqlRaw($"EXEC GetItemCart @UserId,@RequestTypeId,@IsCount",
-                  new SqlParameter("@UserId", itemDto.UserId),
-                  new SqlParameter("@RequestTypeId", itemDto.RequestTypeId),
-                  new SqlParameter("@IsCount", itemDto.IsCount))
-                  .ToListAsync();
-
-            return allItems ?? new List<ItemCart>();
-        }
-
-        public async Task<ResponseObject> PostPurchRequest(ItemDto itemDto)
-        {
-            var (messCode, message) = OutputParamMessage.CreateOutputParams();
-
-            if (itemDto.RequestTypeId == 1)//Internal
-            {
-                itemDto.Status = 2;
-                itemDto.IsApproved = 2;
-
-                await _dbContext.Database
-              .ExecuteSqlRawAsync("EXEC PostPutReqItems @UserId, @RequestItemId, @ItemNo, @QtyRequest,@Status,@IsApproved,@QtyReceived,@LotId," +
-              "@MessCode OUTPUT, @Message OUTPUT",
-               new SqlParameter("@UserId", itemDto.UserId),
-               new SqlParameter("@ItemNo", itemDto.ItemNo),
-               new SqlParameter("@RequestItemId", itemDto.RequestItemId != null ? itemDto.RequestItemId : 0L),
-               new SqlParameter("@QtyRequest", itemDto.Qty),
-               new SqlParameter("@Status", itemDto.Status),
-               new SqlParameter("@IsApproved", itemDto.IsApproved),
-                new SqlParameter("@QtyReceived", itemDto.QtyReceived),
-               new SqlParameter("@LotId", itemDto.LotId),
-               messCode,message);
-            }
-            else
-            {
-                await _dbContext.Database
-               .ExecuteSqlRawAsync("EXEC PostPurchRequest @ItemCartId, @IsActive, @UserId,@ItemCount," +
-                "@PRNo,@DateNeeded,@Qty,@ChargeTo,@Remarks,@ProjectCodeId,@MessCode OUTPUT, @Message OUTPUT",
-                 new SqlParameter("@ItemCartId", itemDto.ItemCartId != null ? itemDto.ItemCartId : 0L),
-                 new SqlParameter("@IsActive", 1),
-                 new SqlParameter("@UserId", itemDto.UserId),
-                 new SqlParameter("@ItemCount", itemDto.ItemCount),
-                 new SqlParameter("@PRNo", itemDto.PRNo),
-                 new SqlParameter("@DateNeeded", itemDto.DateNeeded),
-                 new SqlParameter("@Qty", itemDto.Qty),
-                 new SqlParameter("@ChargeTo", itemDto.ChargeTo),
-                 new SqlParameter("@Remarks", itemDto.Remarks ?? "N/A"),
-                 new SqlParameter("@ProjectCodeId", itemDto.ProjectCodeId),
-                messCode, message);
-            }
-
-            return new ResponseObject() { 
-                messCode= (byte)messCode.Value,
-                message= message.Value.ToString()
-            };
-        }
-        public async Task PostPutAttachment(AttachmentRequest attach)
-        {
-            var existing = await _dbContext.PRAttachments
-                .FirstOrDefaultAsync(a => a.PRId == attach.PRId);
-            if (existing == null)
-            {
-                var attchmnt = new PRAttachments()
-                {
-                    FileName = attach.FileName,
-                    OrigFileName = attach.OrigFileName,
-                    PRId = attach.PRId
-                };
-                await _dbContext.PRAttachments.AddAsync(attchmnt);
-            }
-            else
-            {
-                existing.OrigFileName = attach.OrigFileName;
-                existing.FileName = attach.FileName;
-            }
-            await _dbContext.SaveChangesAsync();
-        }
-        public async Task<(long,long)> GetPRNo()
-        {
-            try
-            {
-                var latestPR = await _dbContext.PRs
-                          .Where(ic => ic.PRNo != null)
-                          .OrderByDescending(ic => ic.PRNo)
-                          .FirstOrDefaultAsync();
-
-                if (latestPR != null)
-                    return (latestPR.PRNo + 1,latestPR.PRId + 1);
-                else
-                    return (0,0);
-            }
-            catch (Exception ex)
-            {
-
-                throw;
-            }
-
-        }
-        Task<ItemCart> IItem.PostPutItemPath(ItemDto itemDto)
-        {
-            throw new NotImplementedException();
-        }
-
         public async Task <List<Departments>> GetDepartment(ItemCodeDto itemCode)
         {
             return await _dbContext.Departments
@@ -366,18 +358,18 @@ namespace CPRNIMS.Domain.Services.Items
 
             return allItems ?? new List<NotifUserKey>();
         }
-
-        public async Task<List<ProjectCodes>> GetProjectCode()
+        public async Task<IReadOnlyList<ProjectCodes>> GetProjectCode()
         {
             return  await _dbContext.ProjectCodes
                            .AsNoTracking()
                            .ToListAsync();
         }
-        public async Task<List<ProjectCodes>> GetProjectCodeByTerm(string? term)
+        public async Task<IReadOnlyList<ProjectCodes>> GetProjectCodeByTerm(string? term)
         {
             return await _dbContext.ProjectCodes
                                    .AsNoTracking()
-                                   .Where(p => EF.Functions.Like(p.ProjectCode, $"%{term}%"))
+                                   .Where(p => p.StatusName != "Completed" && p.IsActive
+                                   && EF.Functions.Like(p.ProjectCode, $"%{term}%"))
                                    .ToListAsync();
         }
     }

CPRNIMS.Domain/Services/PO/PurchaseOrder.cs

@@ -30,6 +30,14 @@ namespace CPRNIMS.Domain.Services.PO
             _smptHelper = smptHelper;
         }
         #region Get
+
+        public async Task<IReadOnlyList<Currencies>> GetCurrencies(string currencyName, CancellationToken ct)
+        {
+            return await _dbContext.Currencies.AsNoTracking()
+                .Where(c => c.IsActive==true &&
+                            (string.IsNullOrEmpty(currencyName) || c.CurrencyName.Contains(currencyName)))
+                .ToListAsync(ct);
+        }
         public async Task<POFormData> GetPOFormDataAsync(long? poId)
         {
             // Reuse the connection from your existing DbContext
@@ -493,7 +501,7 @@ namespace CPRNIMS.Domain.Services.PO
             await _dbContext.Database
                .ExecuteSqlRawAsync("EXEC PostPutCustomPO @UserId,@POTypeId,@PONumber,@PRDetailsId,@Specification,@PRNo,@PORemarks,@IncoTermsId," +
                $"@PODId,@ProfInvoiceNo,@ProfInvoiceDate,@PaymentTermsId,@ShippingInstructionId,@SupplierId,@DeliveryDate,@Discount,@Amount," +
-               $"@UnitPrice,@Quantity,@DeliverTo,@CountryOrigin, @MessCode OUTPUT, @Message OUTPUT",
+               $"@UnitPrice,@Quantity,@DeliverTo,@CountryOrigin,@CurrencyId, @MessCode OUTPUT, @Message OUTPUT",
                new SqlParameter("@UserId", pODto.UserId),
                new SqlParameter("@POTypeId", pODto.POTypeId),
                new SqlParameter("@PONumber", formattedPONumber),
@@ -516,6 +524,7 @@ namespace CPRNIMS.Domain.Services.PO
                new SqlParameter("@Quantity", pODto.Quantity),
                new SqlParameter("@DeliverTo", pODto.DeliverTo),
                new SqlParameter("@CountryOrigin", pODto.CountryOrigin ?? "N/A"),
+               new SqlParameter("@CurrencyId", pODto.CurrencyId),
                 messCode,
                 message);
 
@@ -544,7 +553,7 @@ namespace CPRNIMS.Domain.Services.PO
             await _dbContext.Database
                .ExecuteSqlRawAsync("EXEC PutExistingPO @UserId,@POTypeId,@PONumber,@PRDetailsId,@Specification,@PRNo,@PORemarks,@IncoTermsId," +
                $"@PODId,@ProfInvoiceNo,@ProfInvoiceDate,@PaymentTermsId,@ShippingInstructionId,@SupplierId,@DeliveryDate,@Discount,@Amount," +
-               $"@UnitPrice,@Quantity,@DeliverTo,@IsRemoved,@CountryOrigin, @MessCode OUTPUT, @Message OUTPUT",
+               $"@UnitPrice,@Quantity,@DeliverTo,@IsRemoved,@CountryOrigin,@CurrencyId, @MessCode OUTPUT, @Message OUTPUT",
                new SqlParameter("@UserId", pODto.UserId),
                new SqlParameter("@POTypeId", pODto.POTypeId),
                new SqlParameter("@PONumber", pODto.PONo),
@@ -568,6 +577,7 @@ namespace CPRNIMS.Domain.Services.PO
                new SqlParameter("@DeliverTo", pODto.DeliverTo),
                new SqlParameter("@IsRemoved", isRemoved),
                new SqlParameter("@CountryOrigin", pODto.CountryOrigin ?? "N/A"),
+               new SqlParameter("@CurrencyId", pODto.CurrencyId),
                 messCode,
                 message);
 
@@ -635,7 +645,8 @@ namespace CPRNIMS.Domain.Services.PO
                 DeliverTo = PODto.DeliverTo ?? "N/A",
                 Specification = specification,
                 IsUpdate = PODto.IsUpdate,
-                CountryOrigin=PODto.CountryOrigin
+                CountryOrigin=PODto.CountryOrigin,
+                CurrencyId=PODto.CurrencyId
             };
         }
         public async Task<DocRequired> PostSuppDocRequirements(PODto poDto)

CPRNIMS.Domain/Services/PR/PRequest.cs

@@ -633,6 +633,17 @@ namespace CPRNIMS.Domain.Services.PR
                           && pr.IsActive
                           select pr).AnyAsync();
         }
+        private async Task<bool> ProjectStatusChanges(int projectCodeId,string? status)
+        {
+            var project = await _dbContext.ProjectCodes.FirstOrDefaultAsync(pc=>pc.ProjectCodeId==projectCodeId);
+            if (project == null)
+                return false;
+
+            if (project.StatusName == status) 
+                return false;
+            else 
+                return true;
+        }
         public async Task<MessageResponse> PRItemRemoval(PRDto prDto)
         {
             var (messCode, message) = CreateOutputParams();
@@ -653,7 +664,6 @@ namespace CPRNIMS.Domain.Services.PR
             };
             return response;
         }
-
         public async Task<ResponseObject> PostPutProjectCode(PRDto prDto)
         {
             if (prDto == null) throw new ArgumentNullException(nameof(prDto));
@@ -669,13 +679,14 @@ namespace CPRNIMS.Domain.Services.PR
                     ProjectName = prDto.ProjectName,
                     DeliveryAddress = prDto.DeliveryAddress,
                     MaxDays = prDto.MaxDays,
+                    StatusName = prDto.StatusName,
                     IsActive = prDto.IsActive
                 };
                 await _dbContext.ProjectCodes.AddAsync(project);
             }
             else
             {
-                if (await IsUsingAsync(prDto.ProjectCodeId))
+                if (await IsUsingAsync(prDto.ProjectCodeId) && await ProjectStatusChanges(prDto.ProjectCodeId,prDto.StatusName) == false)
                 {
                     return new ResponseObject()
                     {
@@ -684,12 +695,17 @@ namespace CPRNIMS.Domain.Services.PR
                         success = false,
                     };
                 }
+                if (await IsUsingAsync(prDto.ProjectCodeId))
+                {
+                    existing.StatusName = prDto.StatusName;
+                }
                 else
                 {
                     existing.ProjectCode = prDto.ProjectCode;
                     existing.ProjectName = prDto.ProjectName;
                     existing.DeliveryAddress = prDto.DeliveryAddress;
                     existing.MaxDays = prDto.MaxDays;
+                    existing.StatusName = prDto.StatusName;
                     existing.IsActive = prDto.IsActive;
                 }
             }

CPRNIMS.Domain/Services/Receiving/Receiving.cs

@@ -73,7 +73,7 @@ namespace CPRNIMS.Domain.Services.Receiving
 
             return allItems ?? new List<ReceivingDetail>();
         }
-        public async Task<List<RRDetail>> GetRRDetail(ItemDto itemDto)
+        public async Task<List<RRDetailDto>> GetRRDetail(ItemDto itemDto)
         {
             var allItems = await _dbContext.RRDetailss
                     .FromSqlRaw("EXEC GetRRDetail @RRNo,@UserId",
@@ -81,7 +81,7 @@ namespace CPRNIMS.Domain.Services.Receiving
                     new SqlParameter("@UserId", itemDto.UserId))
                     .ToListAsync();
 
-            return allItems ?? new List<RRDetail>();
+            return allItems ?? new List<RRDetailDto>();
         }
         #endregion
         #region Post Put

CPRNIMS.Domain/Services/Reports/ReportBuilder.cs

@@ -0,0 +1,80 @@
+using CPRNIMS.Domain.Contracts.Reports;
+using CPRNIMS.Domain.UIContracts.Common;
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using CPRNIMS.Infrastructure.Helper;
+using FastReport;
+using Microsoft.Extensions.Configuration;
+using System.Data;
+using System.Net.Http.Json;
+using System.Text.Json;
+
+namespace CPRNIMS.Infrastructure.Reports
+{
+    public class ReportBuilder : IReportBuilder
+    {
+        private readonly IConfiguration _configuration;
+        private readonly TokenHelper _tokenHelper;
+        private readonly IApiConfigurationService _apiConfigurationService;
+        public ReportBuilder(IConfiguration configuration, TokenHelper tokenHelper,
+            IApiConfigurationService apiConfigurationService)
+        {
+            _configuration = configuration;
+            _tokenHelper = tokenHelper;
+            _apiConfigurationService = apiConfigurationService;
+        }
+
+        private static readonly JsonSerializerOptions _jsonOptions = new()
+        {
+            PropertyNameCaseInsensitive = true
+        };
+        public Task<Report> MRSBuildAsync(DateTime dateFrom, DateTime dateTo, string templatePath, CancellationToken ct)
+        {
+            throw new NotImplementedException();
+        }
+
+        public async Task<Report> RISBuildAsync(
+        DateTime dateFrom, DateTime dateTo, string templatePath, CancellationToken ct = default)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var endpoint = _configuration["LLI:NonInvent:InventoryMgmt:RISReportData"]
+                ?? throw new InvalidOperationException("RISReportData endpoint is not configured.");
+
+            // Append the date range as query string
+            var url = $"{endpoint}?dateFrom={dateFrom:yyyy-MM-dd}&dateTo={dateTo:yyyy-MM-dd}";
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            var response = await httpClient.GetAsync(url, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+                throw new InvalidOperationException(
+                    $"Failed to fetch RIS report data. HTTP {(int)response.StatusCode}: {json}");
+
+            var dto = JsonSerializer.Deserialize<RISReportDataDto>(json, _jsonOptions)
+                      ?? new RISReportDataDto();
+
+            var report = new Report();
+            report.Load(templatePath);
+
+            // RegisterData accepts IEnumerable<object> — names must match the .frx datasources.
+            report.RegisterData(dto.Rows ?? new(), "TRIS");
+            report.RegisterData(dto.Disciplines ?? new(), "TDisciplineAgg");
+            report.RegisterData(dto.Recipients ?? new(), "TTopRecipients");
+
+            /*      report.GetDataSource("Table").Enabled = true;
+                  report.GetDataSource("Table1").Enabled = true;
+                  report.GetDataSource("Table3").Enabled = true;*/
+            report.GetDataSource("TRIS").Enabled = true;
+            report.GetDataSource("TDisciplineAgg").Enabled = true;
+            report.GetDataSource("TTopRecipients").Enabled = true;
+
+            report.SetParameterValue("DateFrom", dateFrom);
+            report.SetParameterValue("DateTo", dateTo);
+
+            return report;
+        }
+    }
+}

CPRNIMS.Domain/Services/Reports/ReportDataService.cs

@@ -0,0 +1,109 @@
+using CPRNIMS.Domain.Contracts.Reports;
+using CPRNIMS.Infrastructure.Database;
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using Dapper;
+using Microsoft.Data.SqlClient;
+using Microsoft.EntityFrameworkCore;
+
+namespace CPRNIMS.Infrastructure.Reports
+{
+    public class ReportDataService : IReportDataService
+    {
+        private readonly NonInventoryDbContext _context;
+
+        public ReportDataService(NonInventoryDbContext context) => _context = context;
+
+        private const string MainSql = """
+        SELECT
+            R.RISNo,
+            PR.PRNo,
+            R.QtyIssued,
+            R.IssuedTo,
+            CASE R.Status
+                WHEN 0 THEN 'Draft'
+                WHEN 1 THEN 'Approved'
+                WHEN 2 THEN 'Cancelled'
+                ELSE 'Unknown'
+            END                                            AS StatusLabel,
+            CreatedBy.CreatedBy,
+            ApprovedBy.ApprovedBy,
+            R.ApprovedDate,
+            R.CreatedDate,
+            D.DisciplineName,
+            PRD.ItemName,
+            PRD.ItemNo,
+            IV.QtyIn,
+            IV.QtyOut,
+            IV.QtyOnHand,
+            DEP.Department                                 AS DepartmentName,
+            ISNULL(MRS_AGG.TotalReturned, 0)               AS TotalReturned,
+            ISNULL(MRS_AGG.MRSCount, 0)                    AS MRSCount,
+            R.QtyIssued - ISNULL(MRS_AGG.TotalReturned, 0) AS NetIssued
+        FROM dbo.RIS R
+        INNER JOIN dbo.Disciplines D ON R.DisciplineId = D.DisciplineId
+        INNER JOIN dbo.Inventory IV ON R.InventoryId = IV.InventoryId AND IV.IsActive = 1
+        LEFT JOIN dbo.Lot L ON IV.LotId = L.LotId
+        OUTER APPLY (SELECT U.FullName ApprovedBy FROM dbo.Users U WHERE R.ApprovedBy = U.UserName) ApprovedBy
+        OUTER APPLY (SELECT U2.FullName CreatedBy FROM dbo.Users U2 WHERE R.CreatedBy = U2.UserName) CreatedBy
+        INNER JOIN Users U ON IV.UserId = U.Id
+        LEFT JOIN dbo.Departments DEP ON U.DepartmentId = DEP.DepartmentId
+        LEFT JOIN dbo.PRDetails PRD ON R.PRDetailId = PRD.PRDetailsId AND PRD.IsActive = 1
+        LEFT JOIN dbo.PR PR ON PRD.PRId = PR.PRId AND PR.IsActive = 1
+        LEFT JOIN (
+            SELECT
+                RISId,
+                COUNT(*)         AS MRSCount,
+                SUM(QtyReturned) AS TotalReturned
+            FROM dbo.MRS
+            WHERE Status != 2
+            GROUP BY RISId
+        ) MRS_AGG ON R.RISId = MRS_AGG.RISId
+        WHERE R.Status != 2
+          AND R.CreatedDate >= @DateFrom
+          AND R.CreatedDate < DATEADD(DAY, 1, @DateTo)
+        ORDER BY R.CreatedDate DESC, R.RISNo ASC;
+        """;
+
+        private const string DisciplineSql = """
+        SELECT
+            D.DisciplineName,
+            COUNT(*) AS SlipCount
+        FROM dbo.RIS R
+        INNER JOIN dbo.Disciplines D ON R.DisciplineId = D.DisciplineId
+        WHERE R.Status != 2
+          AND R.CreatedDate >= @DateFrom
+          AND R.CreatedDate < DATEADD(DAY, 1, @DateTo)
+        GROUP BY D.DisciplineName
+        ORDER BY SlipCount DESC;
+        """;
+
+        private const string RecipientsSql = """
+        SELECT TOP 5
+            R.IssuedTo      AS Name,
+            COUNT(*)        AS SlipCount,
+            SUM(IV.QtyOut)  AS QtyOut
+        FROM dbo.RIS R
+        INNER JOIN dbo.Inventory IV ON R.InventoryId = IV.InventoryId AND IV.IsActive = 1
+        WHERE R.Status != 2
+          AND R.CreatedDate >= @DateFrom
+          AND R.CreatedDate < DATEADD(DAY, 1, @DateTo)
+        GROUP BY R.IssuedTo
+        ORDER BY COUNT(*) DESC;
+        """;
+
+        public List<RISRowDto> GetMain(DateTime dateFrom, DateTime dateTo) =>
+            Query<RISRowDto>(MainSql, dateFrom, dateTo);
+
+        public List<DisciplineAggDto> GetDisciplines(DateTime dateFrom, DateTime dateTo) =>
+            Query<DisciplineAggDto>(DisciplineSql, dateFrom, dateTo);
+
+        public List<TopRecipientDto> GetRecipients(DateTime dateFrom, DateTime dateTo) =>
+            Query<TopRecipientDto>(RecipientsSql, dateFrom, dateTo);
+
+        private List<T> Query<T>(string sql, DateTime from, DateTime to)
+        {
+            using var conn = new SqlConnection(_context.Database.GetConnectionString());
+            return conn.Query<T>(sql, new { DateFrom = from, DateTo = to }).ToList();
+        }
+    }
+}

CPRNIMS.Domain/UIContracts/Inventory/IInventory.cs

@@ -1,4 +1,6 @@
 using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
 using CPRNIMS.Infrastructure.Models.Account;
 using CPRNIMS.Infrastructure.ViewModel.Inventory;
 using System;
@@ -11,12 +13,15 @@ namespace CPRNIMS.Domain.UIContracts.Inventory
 {
     public interface IInventory
     {
+        Task<TransactContextDto?> GetTransactContextAsync(int inventoryId);
         Task<List<InventoryVM>> GetInventoryByUserId(User user, InventoryVM viewModel);
         Task<List<InventoryVM>> GetRequestedItemByUserId(User user, InventoryVM viewModel);
         Task<List<InventoryVM>> GetInventoryById(User user, InventoryVM viewModel);
         Task<List<InventoryVM>> GetLotNo(User user, InventoryVM viewModel);
         Task<List<InventoryVM>> GetLotQtyByItem(User user, InventoryVM viewModel);
         Task<List<InventoryVM>> GetLotNoById(User user, InventoryVM viewModel);
+        Task<PagedResult<InventoryResponse>> GetInventory(User user, InventoryRequest request);
+
         Task<InventoryVM> PostPutLotNo(User user, InventoryVM viewModel);
         Task<InventoryVM> PostPutLotBin(User user, InventoryVM viewModel);
         Task<InventoryVM> PostPutReqApproval(User user, InventoryVM viewModel);

CPRNIMS.Domain/UIContracts/Inventory/IInventoryReports.cs

@@ -0,0 +1,18 @@
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.UIContracts.Inventory
+{
+    public interface IInventoryReports
+    {
+
+        Task<RISReportDto> GetRISReportAsync(InventoryReportsRequest request, CancellationToken ct);
+        Task<MRSReportDto> GetMRSReportAsync(InventoryReportsRequest request, CancellationToken ct);
+        Task<InventoryReportDto> GetInventoryReportAsync(InventoryReportsRequest request, CancellationToken ct);
+    }
+}

CPRNIMS.Domain/UIContracts/Inventory/IMRS.cs

@@ -0,0 +1,22 @@
+using CPRNIMS.Infrastructure.Dto.Common;
+using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.UIContracts.Inventory
+{
+    public interface IMRS
+    {
+        Task<MRSPagedResponse> GetMRSPaged(MRSPagedRequest request, CancellationToken ct);
+        Task<ApiResponse<object>> CreateMRS(CreateMRSRequest request, CancellationToken ct);
+        Task<ApiResponse<object>> ApproveMRS(ApproveMRSRequest request, CancellationToken ct);
+        Task<ApiResponse<object>> CancelMRS(CancelMRSRequest request, CancellationToken ct);
+        Task<ApiResponse<List<SearchRISProjectCodeResponse>>> SearchRIS(SearchRISProjectCodeRequest request, CancellationToken ct);
+        Task<ApiResponse<List<ProjectCodeOptionResponse>>> SearchProjects(SearchRISProjectCodeRequest request, CancellationToken ct);
+    }
+}

CPRNIMS.Domain/UIContracts/Inventory/IRIS.cs

@@ -0,0 +1,20 @@
+using CPRNIMS.Infrastructure.Dto.Common;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using CPRNIMS.Infrastructure.ViewModel.Inventory;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.UIContracts.Inventory
+{
+    public interface IRIS
+    {
+        Task<ApiResponse<object>> ApproveRIS(ApproveRISRequest request, CancellationToken ct);
+        Task<ApiResponse<object>> CancelRIS(CancelRISRequest request, CancellationToken ct);
+        Task<ApiResponse<object>> CreateRIS(CreateRISRequest request, CancellationToken ct);
+        Task<RISPagedResponse> GetRISPaged(RISPagedRequest request, CancellationToken ct);
+    }
+}

CPRNIMS.Domain/UIContracts/PO/IPurchaseOrder.cs

@@ -11,6 +11,7 @@ namespace CPRNIMS.Domain.UIContracts.PO
     public interface IPurchaseOrder 
     {
         #region Get
+        Task<List<POVM>> GetCurrencies(User user, POVM viewModels);
         Task<List<POVM>> GetSupplierBidById(User user, POVM viewModel);
         Task<List<POVM>> GetSupplierBidByItem(User user, POVM viewModel);
         Task<List<POVM>> GetSupplierBid(User user, POVM viewModel);

CPRNIMS.Domain/UIServices/Inventory/Inventory.cs

@@ -1,9 +1,11 @@
 using CPRNIMS.Domain.UIContracts.Common;
 using CPRNIMS.Domain.UIContracts.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
 using CPRNIMS.Infrastructure.Helper;
 using CPRNIMS.Infrastructure.Models.Account;
 using CPRNIMS.Infrastructure.Models.Common;
-using CPRNIMS.Infrastructure.ViewModel.Finance;
 using CPRNIMS.Infrastructure.ViewModel.Inventory;
 using Microsoft.Extensions.Configuration;
 using System;
@@ -123,6 +125,73 @@ namespace CPRNIMS.Domain.UIServices.Inventory
                 throw;
             }
         }
+        public async Task<TransactContextDto?> GetTransactContextAsync(int inventoryId)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+
+            if (string.IsNullOrEmpty(token))
+                return null;
+
+            var apiEndpoint =
+                _configuration["LLI:NonInvent:InventoryMgmt:GetTransactContext"] ?? "api/InventoryMgmt/GetTransactContext";
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+
+            var response = await httpClient.GetAsync( $"{apiEndpoint}?inventoryId={inventoryId}");
+
+            if (!response.IsSuccessStatusCode)
+                return null;
+
+            var jsonResponse = await response.Content.ReadAsStringAsync();
+
+            return JsonSerializer.Deserialize<TransactContextDto>(jsonResponse,
+                new JsonSerializerOptions{PropertyNameCaseInsensitive = true});
+        }
+
+        public async Task<Infrastructure.Dto.Inventory.PagedResult<InventoryResponse>> SendGetPageListApiRequest
+        (User user, InventoryRequest request, string apiEndpoint)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+
+            try
+            {
+                if (string.IsNullOrEmpty(token))
+                {
+                    return null;
+                }
+
+                request.UserId = user.UserId;
+                var jsonContent = JsonSerializer.Serialize(request);
+                var content = new StringContent(jsonContent, Encoding.UTF8, "application/json");
+
+                using (var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token))
+                {
+                    HttpResponseMessage response;
+
+                    response = await httpClient.PostAsync(apiEndpoint, content);
+                    var jsonResponse = await response.Content.ReadAsStringAsync();
+
+                    if (response.IsSuccessStatusCode)
+                    {
+                        var options = new JsonSerializerOptions { PropertyNameCaseInsensitive = true };
+                        var result = JsonSerializer.Deserialize<PagedResult<InventoryResponse>>(jsonResponse, options);
+                        return result ?? new PagedResult<InventoryResponse>();
+                    }
+                    else
+                    {
+                        return new PagedResult<InventoryResponse>
+                        {
+                            IsSuccess = false,
+                            ErrorMessage = $"API returned {response.StatusCode}"
+                        };
+                    }
+                }
+            }
+            catch (Exception ex)
+            {
+                throw;
+            }
+        }
         #endregion
         #region Get
         public async Task<List<InventoryVM>> GetInventoryById(User user, InventoryVM viewModel)
@@ -141,7 +210,11 @@ namespace CPRNIMS.Domain.UIServices.Inventory
             return await SendGetApiRequest(user, viewModel,
              _configuration["LLI:NonInvent:InventoryMgmt:GetLotNoById"]);
         }
-
+        public async Task<Infrastructure.Dto.Inventory.PagedResult<InventoryResponse>> GetInventory(User user, InventoryRequest reqquest)
+        {
+            return await SendGetPageListApiRequest(user, reqquest,
+                _configuration["LLI:NonInvent:InventoryMgmt:GetInventory"]);
+        }
         public async Task<List<InventoryVM>> GetInventoryByUserId(User user, InventoryVM viewModel)
         {
             return await SendGetApiRequest(user, viewModel,
@@ -153,7 +226,11 @@ namespace CPRNIMS.Domain.UIServices.Inventory
             return await SendGetApiRequest(user, viewModel,
            _configuration["LLI:NonInvent:InventoryMgmt:GetRequestedItemByUserId"]);
         }
-
+        public async Task<List<InventoryVM>> GetLotQtyByItem(User user, InventoryVM viewModel)
+        {
+            return await SendGetApiRequest(user, viewModel,
+          _configuration["LLI:NonInvent:InventoryMgmt:GetLotQtyByItem"]);
+        }
         #endregion
         #region Post Put
         public async Task<InventoryVM> PostPutReqApproval(User user, InventoryVM viewModel)
@@ -177,12 +254,6 @@ namespace CPRNIMS.Domain.UIServices.Inventory
             return await SendPostApiRequest(user, viewModel,
            _configuration["LLI:NonInvent:InventoryMgmt:PostPutReqItems"]);
         }
-
-        public async Task<List<InventoryVM>> GetLotQtyByItem(User user, InventoryVM viewModel)
-        {
-            return await SendGetApiRequest(user, viewModel,
-          _configuration["LLI:NonInvent:InventoryMgmt:GetLotQtyByItem"]);
-        }
         #endregion
     }
 }

CPRNIMS.Domain/UIServices/Inventory/InventoryReports.cs

@@ -0,0 +1,126 @@
+using Azure.Core;
+using CPRNIMS.Domain.UIContracts.Common;
+using CPRNIMS.Domain.UIContracts.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports;
+using CPRNIMS.Infrastructure.Dto.Inventory.Reports.Response;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Helper;
+using Microsoft.AspNetCore.WebUtilities;
+using Microsoft.Extensions.Configuration;
+using System.Text;
+using System.Text.Json;
+
+namespace CPRNIMS.Domain.UIServices.Inventory
+{
+    public class InventoryReports : IInventoryReports
+    {
+        private readonly IConfiguration _configuration;
+        private readonly TokenHelper _tokenHelper;
+        private readonly IApiConfigurationService _apiConfigurationService;
+        public InventoryReports(IConfiguration configuration, TokenHelper tokenHelper, IApiConfigurationService apiConfigurationService)
+        {
+            _configuration = configuration;
+            _tokenHelper = tokenHelper;
+            _apiConfigurationService = apiConfigurationService;
+        }
+        private static readonly JsonSerializerOptions _jsonOpts = new()
+        {
+            PropertyNameCaseInsensitive = true
+        };
+        public async Task<InventoryReportDto> GetInventoryReportAsync(InventoryReportsRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var baseEndpoint = _configuration["LLI:NonInvent:InventoryMgmt:GetInventoryReport"]
+                ?? throw new InvalidOperationException("GetInventoryReport endpoint is not configured.");
+
+            var qs = new Dictionary<string, string?>
+            {
+                ["dateFrom"] = request.DateFrom.ToString("yyyy-MM-dd"),
+                ["dateTo"] = request.DateTo.ToString("yyyy-MM-dd"),
+                ["department"] = request.Department,
+                ["page"] = request.Page.ToString(),
+                ["pageSize"] = request.PageSize.ToString(),
+                ["paginate"] = request.Paginate.ToString().ToLowerInvariant()
+            };
+
+            var url = QueryHelpers.AddQueryString(baseEndpoint, qs);
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            var response = await httpClient.GetAsync(url, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+                return new InventoryReportDto();
+
+            var result = JsonSerializer.Deserialize<InventoryReportDto>(json, _jsonOpts);
+            return result ?? new InventoryReportDto();
+        }
+
+        public async Task<MRSReportDto> GetMRSReportAsync(InventoryReportsRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var baseEndpoint = _configuration["LLI:NonInvent:InventoryMgmt:GetMRSReport"]
+                ?? throw new InvalidOperationException("GetMRS endpoint is not configured.");
+
+            var qs = new Dictionary<string, string?>
+            {
+                ["dateFrom"] = request.DateFrom.ToString("yyyy-MM-dd"),
+                ["dateTo"] = request.DateTo.ToString("yyyy-MM-dd"),
+                ["department"] = request.Department,
+                ["page"] = request.Page.ToString(),
+                ["pageSize"] = request.PageSize.ToString(),
+                ["paginate"] = request.Paginate.ToString().ToLowerInvariant()
+            };
+
+            var url = QueryHelpers.AddQueryString(baseEndpoint, qs);
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            var response = await httpClient.GetAsync(url, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+                return new MRSReportDto { };
+
+            var result = JsonSerializer.Deserialize<MRSReportDto>(json, _jsonOpts);
+            return result ?? new MRSReportDto();
+        }
+
+        public async Task<RISReportDto> GetRISReportAsync(InventoryReportsRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var baseEndpoint = _configuration["LLI:NonInvent:InventoryMgmt:GetRISReport"]
+                ?? throw new InvalidOperationException("GetMRS endpoint is not configured.");
+
+            var qs = new Dictionary<string, string?>
+            {
+                ["dateFrom"] = request.DateFrom.ToString("yyyy-MM-dd"),
+                ["dateTo"] = request.DateTo.ToString("yyyy-MM-dd"),
+                ["department"] = request.Department,
+                ["page"] = request.Page.ToString(),
+                ["pageSize"] = request.PageSize.ToString(),
+                ["paginate"] = request.Paginate.ToString().ToLowerInvariant()
+            };
+
+            var url = QueryHelpers.AddQueryString(baseEndpoint, qs);
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            var response = await httpClient.GetAsync(url, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+                return new RISReportDto {};
+
+            var result = JsonSerializer.Deserialize<RISReportDto>(json, _jsonOpts);
+            return result ?? new RISReportDto();
+        }
+    }
+}

CPRNIMS.Domain/UIServices/Inventory/MRS.cs

@@ -0,0 +1,197 @@
+using Azure.Core;
+using CPRNIMS.Domain.Services;
+using CPRNIMS.Domain.UIContracts.Common;
+using CPRNIMS.Domain.UIContracts.Inventory;
+using CPRNIMS.Infrastructure.Dto.Common;
+using CPRNIMS.Infrastructure.Dto.Inventory;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using CPRNIMS.Infrastructure.Helper;
+using Microsoft.Extensions.Configuration;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Text.Json;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.UIServices.Inventory
+{
+    public class MRS : IMRS
+    {
+        private readonly IConfiguration _configuration;
+        private readonly TokenHelper _tokenHelper;
+        private readonly IApiConfigurationService _apiConfigurationService;
+        public MRS(IConfiguration configuration, TokenHelper tokenHelper,IApiConfigurationService apiConfigurationService)      
+        {
+            _configuration = configuration;
+            _tokenHelper = tokenHelper;
+            _apiConfigurationService = apiConfigurationService;
+        }
+        private static readonly JsonSerializerOptions _mrsJsonOpts = new()
+        {
+            PropertyNameCaseInsensitive = true
+        };
+
+        public async Task<MRSPagedResponse> GetMRSPaged(MRSPagedRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var baseEndpoint = _configuration["LLI:NonInvent:InventoryMgmt:GetMRS"]
+                ?? throw new InvalidOperationException("GetMRS endpoint is not configured.");
+
+            var qs = new StringBuilder(baseEndpoint).Append('?');
+            qs.Append($"pageNumber={request.PageNumber}&pageSize={request.PageSize}");
+
+            if (!string.IsNullOrWhiteSpace(request.SearchMRSNo))
+                qs.Append($"&searchMRSNo={Uri.EscapeDataString(request.SearchMRSNo)}");
+            if (!string.IsNullOrWhiteSpace(request.SearchRISNo))
+                qs.Append($"&searchRISNo={Uri.EscapeDataString(request.SearchRISNo)}");
+            if (!string.IsNullOrWhiteSpace(request.SearchItemName))
+                qs.Append($"&searchItemName={Uri.EscapeDataString(request.SearchItemName)}");
+            if (!string.IsNullOrWhiteSpace(request.SearchReturnedBy))
+                qs.Append($"&searchReturnedBy={Uri.EscapeDataString(request.SearchReturnedBy)}");
+            if (request.Status.HasValue)
+                qs.Append($"&status={request.Status.Value}");
+            if (!string.IsNullOrWhiteSpace(request.Condition))
+                qs.Append($"&condition={Uri.EscapeDataString(request.Condition)}");
+
+            using var http = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            var response = await http.GetAsync(qs.ToString(), ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+                return new MRSPagedResponse { Data = [], RecordsTotal = 0 };
+
+            var result = JsonSerializer.Deserialize<MRSPagedResponse>(json, _mrsJsonOpts);
+            return result ?? new MRSPagedResponse();
+        }
+
+        public async Task<ApiResponse<object>> CreateMRS(CreateMRSRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var endpoint = _configuration["LLI:NonInvent:InventoryMgmt:CreateMRS"]
+                ?? throw new InvalidOperationException("CreateMRS endpoint is not configured.");
+
+            using var http = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            using var content = new StringContent(JsonSerializer.Serialize(request), Encoding.UTF8, "application/json");
+
+            var response = await http.PostAsync(endpoint, content, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            var result = JsonSerializer.Deserialize<ApiResponse<object>>(json, _mrsJsonOpts)
+                ?? new ApiResponse<object> { success = false, message = $"HTTP {(int)response.StatusCode}" };
+
+            if (!response.IsSuccessStatusCode)
+                result.success = false;
+
+            return result;
+        }
+
+        public async Task<ApiResponse<object>> ApproveMRS(ApproveMRSRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var endpoint = _configuration["LLI:NonInvent:InventoryMgmt:ApproveMRS"]
+                ?? throw new InvalidOperationException("ApproveMRS endpoint is not configured.");
+
+            using var http = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            using var content = new StringContent(
+                JsonSerializer.Serialize(request),
+                Encoding.UTF8, "application/json");
+
+            var response = await http.PostAsync(endpoint, content, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+            var result = JsonSerializer.Deserialize<ApiResponse<object>>(json, _mrsJsonOpts)
+             ?? new ApiResponse<object> { success = false, message = $"HTTP {(int)response.StatusCode}" };
+
+            if (!response.IsSuccessStatusCode)
+                result.success = false;
+
+            return result;
+        }
+
+        public async Task<ApiResponse<object>> CancelMRS(CancelMRSRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var endpoint = _configuration["LLI:NonInvent:InventoryMgmt:CancelMRS"]
+                ?? throw new InvalidOperationException("CancelMRS endpoint is not configured.");
+
+            using var http = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            using var content = new StringContent(
+                JsonSerializer.Serialize(request),
+                Encoding.UTF8, "application/json");
+
+            var response = await http.PostAsync(endpoint, content, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+            var result = JsonSerializer.Deserialize<ApiResponse<object>>(json, _mrsJsonOpts)
+             ?? new ApiResponse<object> { success = false, message = $"HTTP {(int)response.StatusCode}" };
+
+            if (!response.IsSuccessStatusCode)
+                result.success = false;
+
+            return result;
+        }
+
+        public async Task<ApiResponse<List<SearchRISProjectCodeResponse>>> SearchRIS(SearchRISProjectCodeRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var baseEndpoint = _configuration["LLI:NonInvent:InventoryMgmt:SearchRIS"]
+                ?? throw new InvalidOperationException("GetMRS endpoint is not configured.");
+
+            var qs = new StringBuilder(baseEndpoint).Append('?');
+
+            if (!string.IsNullOrWhiteSpace(request.SearchRISNo))
+                qs.Append($"&searchRISNo={Uri.EscapeDataString(request.SearchRISNo)}");
+            if (!string.IsNullOrWhiteSpace(request.SearchRISNo))
+                qs.Append($"&projectCodeId= {request.SearchProjectCodeId}");
+
+            using var http = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            var response = await http.GetAsync(qs.ToString(), ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+                return new ApiResponse<List<SearchRISProjectCodeResponse>>{ };
+
+            var result = JsonSerializer.Deserialize<ApiResponse<List<SearchRISProjectCodeResponse>>>(json, _mrsJsonOpts);
+            return result ?? new ApiResponse<List<SearchRISProjectCodeResponse>>();
+        }
+
+        public async Task<ApiResponse<List<ProjectCodeOptionResponse>>> SearchProjects(SearchRISProjectCodeRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has expired.");
+
+            var baseEndpoint = _configuration["LLI:NonInvent:InventoryMgmt:SearchProjects"]
+                ?? throw new InvalidOperationException("SearchProjects endpoint is not configured.");
+
+            var qs = new StringBuilder(baseEndpoint);
+            if (!string.IsNullOrWhiteSpace(request.SearchProjectCode))
+                qs.Append('?').Append("searchProjectCode=").Append(Uri.EscapeDataString(request.SearchProjectCode));
+
+            using var http = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            var response = await http.GetAsync(qs.ToString(), ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+                return new ApiResponse<List<ProjectCodeOptionResponse>>();
+
+            var result = JsonSerializer.Deserialize<ApiResponse<List<ProjectCodeOptionResponse>>>(json, _mrsJsonOpts);
+            return result ?? new ApiResponse<List<ProjectCodeOptionResponse>>();
+        }
+    }
+}

CPRNIMS.Domain/UIServices/Inventory/RIS.cs

@@ -0,0 +1,157 @@
+using CPRNIMS.Domain.UIContracts.Common;
+using CPRNIMS.Domain.UIContracts.Inventory;
+using CPRNIMS.Infrastructure.Dto.Common;
+using CPRNIMS.Infrastructure.Dto.Inventory.Request;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using CPRNIMS.Infrastructure.Dto.PR.Response;
+using CPRNIMS.Infrastructure.Helper;
+using Microsoft.Extensions.Configuration;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Net;
+using System.Text;
+using System.Text.Json;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Domain.UIServices.Inventory
+{
+    public class RIS : IRIS
+    {
+        private readonly IConfiguration _configuration;
+        private readonly TokenHelper _tokenHelper;
+        private readonly IApiConfigurationService _apiConfigurationService;
+        public RIS(IConfiguration configuration, TokenHelper tokenHelper,
+            IApiConfigurationService apiConfigurationService)
+        {
+            _configuration = configuration;
+            _tokenHelper = tokenHelper;
+            _apiConfigurationService = apiConfigurationService;
+        }
+        #region Get
+        public async Task<RISPagedResponse> GetRISPaged(RISPagedRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var baseEndpoint = _configuration["LLI:NonInvent:InventoryMgmt:GetRIS"]
+                ?? throw new InvalidOperationException("GetRIS endpoint is not configured.");
+
+            // ── Build query string — GET request, no body ──
+            var qs = new StringBuilder(baseEndpoint).Append('?');
+            qs.Append($"pageNumber={request.PageNumber}");
+            qs.Append($"&pageSize={request.PageSize}");
+
+            if (!string.IsNullOrWhiteSpace(request.SearchRISNo))
+                qs.Append($"&searchRISNo={Uri.EscapeDataString(request.SearchRISNo)}");
+
+            if (!string.IsNullOrWhiteSpace(request.SearchItemName))
+                qs.Append($"&searchItemName={Uri.EscapeDataString(request.SearchItemName)}");
+
+            if (!string.IsNullOrWhiteSpace(request.SearchIssuedTo))
+                qs.Append($"&searchIssuedTo={Uri.EscapeDataString(request.SearchIssuedTo)}");
+
+            if (!string.IsNullOrWhiteSpace(request.Discipline))
+                qs.Append($"&discipline={Uri.EscapeDataString(request.Discipline)}");
+
+            if (request.Status.HasValue)
+                qs.Append($"&status={request.Status.Value}");
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+
+            // ── GET, no content body ──
+            var response = await httpClient.GetAsync(qs.ToString(), ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            if (!response.IsSuccessStatusCode)
+            {
+                Console.WriteLine($"[GetRISPaged] Error {(int)response.StatusCode}: {json}");
+                return new RISPagedResponse { Data = [], RecordsTotal = 0 };
+            }
+
+            var result = JsonSerializer.Deserialize<RISPagedResponse>(json, _jsonOptions);
+            return result ?? new RISPagedResponse();
+        }
+        #endregion
+        #region Post Put
+        public async Task<ApiResponse<object>> ApproveRIS(ApproveRISRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var endpoint = _configuration["LLI:NonInvent:InventoryMgmt:ApproveRIS"]
+                ?? throw new InvalidOperationException("ApproveRIS endpoint is not configured.");
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            using var content = new StringContent(JsonSerializer.Serialize(request),Encoding.UTF8,"application/json");
+
+            var response = await httpClient.PutAsync(endpoint, content, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+            var result = JsonSerializer.Deserialize<ApiResponse<object>>(json, _jsonOptions)
+                        ?? new ApiResponse<object> { success = false, message = $"HTTP {(int)response.StatusCode}" };
+
+            if (!response.IsSuccessStatusCode)
+                result.success = false;
+
+            return result;
+        }
+
+        public async Task<ApiResponse<object>> CancelRIS(CancelRISRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+            var endpoint = _configuration["LLI:NonInvent:InventoryMgmt:CancelRIS"]
+                ?? throw new InvalidOperationException("CancelRIS endpoint is not configured.");
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            using var content = new StringContent(JsonSerializer.Serialize(request), Encoding.UTF8, "application/json");
+
+            var response = await httpClient.PutAsync(endpoint, content, ct);
+            var json = await response.Content.ReadAsStringAsync(ct);
+
+            var result = JsonSerializer.Deserialize<ApiResponse<object>>(json, _jsonOptions)
+                ?? new ApiResponse<object> { success = false, message = $"HTTP {(int)response.StatusCode}" };
+
+            if (!response.IsSuccessStatusCode)
+                result.success = false;
+
+            return result;
+        }
+
+        public async Task<ApiResponse<object>> CreateRIS(CreateRISRequest request, CancellationToken ct)
+        {
+            var token = await _tokenHelper.GetValidTokenAsync();
+            if (string.IsNullOrEmpty(token))
+                throw new InvalidOperationException("Token has been expired.");
+
+
+            var endpoint = _configuration["LLI:NonInvent:InventoryMgmt:CreateRIS"] ??
+                           throw new InvalidOperationException("CreateRIS endpoint is not configured.");
+
+            using var httpClient = _apiConfigurationService.CreateHttpClientWithDefaultHeaders(token);
+            using var content = new StringContent(JsonSerializer.Serialize(request),Encoding.UTF8,"application/json");
+
+            var response = await httpClient.PostAsync(endpoint, content,ct);
+
+            var json = await response.Content.ReadAsStringAsync();
+
+            var result = JsonSerializer.Deserialize<ApiResponse<object>>(json, _jsonOptions)
+                       ?? new ApiResponse<object> { success = false, message = $"HTTP {(int)response.StatusCode}" };
+
+            if (!response.IsSuccessStatusCode)
+                result.success = false;
+
+            return result;
+        }
+
+        private static readonly JsonSerializerOptions _jsonOptions = new()
+        {
+            PropertyNameCaseInsensitive = true
+        };
+        #endregion
+    }
+}

CPRNIMS.Domain/UIServices/PO/PurchaseOrder.cs

@@ -284,6 +284,11 @@ namespace CPRNIMS.Domain.UIServices.PO
             return await SendGetApiRequest(user, viewModel,
            _configuration["LLI:NonInvent:POMgmt:GetPortOfDischarge"]);
         }
+        public async Task<List<POVM>> GetCurrencies(User user, POVM viewModel)
+        {
+            return await SendGetApiRequest(user, viewModel,
+            _configuration["LLI:NonInvent:POMgmt:GetCurrencies"]);
+        }
         #endregion
         #region Post Put
         public async Task<POVM> PostApprovedSupplier(User user, POVM viewModel)

CPRNIMS.Infrastructure/Database/NonInventoryDbContext.cs

@@ -1,4 +1,5 @@
 using CPRNIMS.Infrastructure.Dto.Canvass.Response;
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
 using CPRNIMS.Infrastructure.Entities.Account;
 using CPRNIMS.Infrastructure.Entities.Canvass;
 using CPRNIMS.Infrastructure.Entities.Common;
@@ -22,9 +23,7 @@ namespace CPRNIMS.Infrastructure.Database
     public class NonInventoryDbContext : IdentityDbContext<ApplicationUser>
     {
         public NonInventoryDbContext(DbContextOptions<NonInventoryDbContext> options) : base(options) { }
-        public virtual DbSet<ItemCode> ItemCodes { get; set; }
-        public virtual DbSet<ItemList> ItemList { get; set; }
-        public virtual DbSet<Item> Items { get; set; }
+        #region Common
         public DbSet<Departments> Departments { get; set; }
         public DbSet<IdentityRole> IdentityRoles { get; set; }
         public DbSet<AuthorizeRoles> AuthorizeRoles { get; set; }
@@ -32,39 +31,52 @@ namespace CPRNIMS.Infrastructure.Database
         public DbSet<IdentityUserRole<string>> IdentityUserRoles { get; set; }
         public DbSet<ForgotPassword> ForgotPasswords { get; set; }
         public virtual DbSet<Otps> Otps { get; set; }
+        public virtual DbSet<ErrorMessage> ErrorMessages { get; set; }
+        public virtual DbSet<ControllerAccess> ControllerAccess { get; set; }
+        public virtual DbSet<SMTPCredential> SMTPCredentials { get; set; }
+        #endregion
+
+        #region Item
+        public virtual DbSet<ItemCode> ItemCodes { get; set; }
+        public virtual DbSet<ItemList> ItemList { get; set; }
+        public virtual DbSet<Item> Items { get; set; }
+        public DbSet<ItemDtos> ItemDtos { get; set; }
         public DbSet<Attachment> Attachments { get; set; }
         public virtual DbSet<AttachmentExtension> AttachmentExtensions { get; set; }
         public virtual DbSet<AttachmentFileType> AttachmentFileTypes { get; set; }
         public virtual DbSet<ItemAttachement> ItemAttachements { get; set; }
-        public virtual DbSet<ErrorMessage> ErrorMessages { get; set; }
-        public virtual DbSet<ControllerAccess> ControllerAccess { get; set; }
         public virtual DbSet<ItemCategory> ItemCategories { get; set; }
         public virtual DbSet<UnitOfMessure> UnitOfMessures { get; set; }
         public virtual DbSet<ItemColor> ItemColors { get; set; }
         public virtual DbSet<ItemLocalization> ItemLocalizations { get; set; }
         public virtual DbSet<ItemCart> ItemCarts { get; set; }
+        public virtual DbSet<ItemApproval> ItemApprovals { get; set; }
+        public virtual DbSet<Entities.Inventory.ItemDetail> ItemDetails { get; set; }
+        #endregion
+
+        #region PR
         public virtual DbSet<PR> PRs { get; set; }
         public virtual DbSet<Approved> Approved { get; set; }
         public virtual DbSet<ApprovedPR> ApprovedPrs { get; set; }
         public virtual DbSet<DeletedPR> DeletedPRs { get; set; }
-        public virtual DbSet<SMTPCredential> SMTPCredentials { get; set; }
         public virtual DbSet<PRDetails> PRDetails { get; set; }
         public virtual DbSet<PRItemList> PRItemLists { get; set; }
         public DbSet<PRAttachments> PRAttachments { get; set; }
         public DbSet<ProjectCodes> ProjectCodes { get; set; }
+        public virtual DbSet<Entities.Purchasing.PRList> PRLists { get; set; }
+        public virtual DbSet<Entities.Canvass.PRList> PRItemList { get; set; }
+        public virtual DbSet<PRWOCanvass> PRWOCanvasses { get; set; }
+        public virtual DbSet<Entities.PO.ItemDetail> PRItemDetails { get; set; }
+        public virtual DbSet<DetailedPRTracking> DetailedPRTrackings { get; set; }
+        public virtual DbSet<PRTracking> PRTrackings { get; set; }
+        public virtual DbSet<Dashboard> Dashboards { get; set; }
+        #endregion
+
+        #region Canvassing
         public virtual DbSet<NotificationById> NotificationByIds { get; set; }
         public virtual DbSet<AlternativeOffer> AlternativeOffers { get; set; }
         public virtual DbSet<AlternativeOfferDetails> AlternativeOfferDetails { get; set; }
         public virtual DbSet<MyPRWOCanvass> MyPRWOCanvass { get; set; }
-        public virtual DbSet<Entities.Purchasing.PRList> PRLists { get; set; }        
-        public virtual DbSet<Entities.Canvass.PRList> PRItemList { get; set; }
-        public virtual DbSet<ItemApproval> ItemApprovals { get; set; }
-        public virtual DbSet<ForReceiving> ForReceivings { get; set; }
-        public virtual DbSet<Infrastructure.Entities.Receiving.RRReport> RRReports { get; set; }
-        public virtual DbSet<ReceivingDetail> ReceivingDetails { get; set; }
-        public virtual DbSet<RRDetail> RRDetails { get; set; }
-        public virtual DbSet<ForRR> ForRRs { get; set; }
-        public virtual DbSet<RR> RRs { get; set; }
         public virtual DbSet<Canvass> Canvasses { get; set; }
         public DbSet<SupplierForCanvass> SupplierForCanvass { get; set; }
         public DbSet<SupplierResponseDto> SupplierResponses { get; set; }
@@ -87,6 +99,9 @@ namespace CPRNIMS.Infrastructure.Database
         public DbSet<ForAISearchingTagging> ForAISearchingTaggings { get; set; }
         public virtual DbSet<CanvassGroupByPRNo> CanvassGroupByPRNos { get; set; }
         public virtual DbSet<ForCanvass> ForCanvasses { get; set; }
+        #endregion
+
+        #region PO
         public virtual DbSet<ForPO> ForPOs { get; set; }
         public virtual DbSet<CreatedPO> CreatedPOs { get; set; }
         public virtual DbSet<CustomPO> CustomPOs { get; set; }
@@ -94,6 +109,7 @@ namespace CPRNIMS.Infrastructure.Database
         public virtual DbSet<ForPOApproval> ForPOApprovals { get; set; }
         public virtual DbSet<ApprovedPO> ApprovedPOs { get; set; }
         public virtual DbSet<PurchaseOrder> PurchaseOrders { get; set; }
+        public virtual DbSet<ForPayment> ForPayments { get; set; }
         public virtual DbSet<PO> POs { get; set; }
         public DbSet<PODetails> PODetails { get; set; }
         public virtual DbSet<PRPOSummaryCount> PRPOSummaryCounts { get; set; }
@@ -103,29 +119,44 @@ namespace CPRNIMS.Infrastructure.Database
         public virtual DbSet<PortOfDischarges> PortOfDischarges { get; set; }
         public virtual DbSet<DocRequired> DocRequireds { get; set; }
         public virtual DbSet<BiddingApproval> BiddingApprovals { get; set; }
-        public virtual DbSet<Entities.Receiving.RRDetail> RRDetailss { get; set; }
-        public virtual DbSet<RRSeries> RRSeries { get; set; }
-        public virtual DbSet<PRWOCanvass> PRWOCanvasses { get; set; }
-        public virtual DbSet<ForPayment> ForPayments { get; set; }
-        public virtual DbSet<Inventory> Inventories { get; set; }
-        public virtual DbSet<Entities.Inventory.ItemDetail> ItemDetails { get; set; }
-        public virtual DbSet<Entities.PO.ItemDetail> PRItemDetails { get; set; }
-        public virtual DbSet<Lot> Lots { get; set; }
-        public virtual DbSet<LotQtyByItem> LotQtyByItems { get; set; }
-        public virtual DbSet<RequestItem> RequestItems { get; set; }
-        public virtual DbSet<RequestItemDetail> RequestItemDetails { get; set; }
+
         public virtual DbSet<NotifUserKey> NotifUserKeys { get; set; }
         public virtual DbSet<ItemListForPO> ItemListForPOs { get; set; }
         public virtual DbSet<CreatedPOPerSupId> CreatedPOPerSupIds { get; set; }
-        public virtual DbSet<PRTracking> PRTrackings { get; set; }
-        public virtual DbSet<Dashboard> Dashboards { get; set; }
+        public DbSet<IncomingShipment> IncomingShipments { get; set; }
+        public virtual DbSet<IncomingShipmentDto> IncomingShipmentDtos { get; set; }
         public virtual DbSet<PaymentTerm> PaymentTerms { get; set; }
         public virtual DbSet<Incoterm> Incoterms { get; set; }
         public virtual DbSet<CentralPONo> CentralPONos { get; set; }
-        public virtual DbSet<DetailedPRTracking> DetailedPRTrackings { get; set; }
-        public DbSet<IncomingShipment> IncomingShipments { get; set; }
-        public virtual DbSet<IncomingShipmentDto> IncomingShipmentDtos { get; set; }
+        public DbSet<Currencies> Currencies { get; set; }
+        #endregion
 
+        #region Inventory
+        public virtual DbSet<Inventory> Inventories { get; set; }
+        public virtual DbSet<Lot> Lots { get; set; }
+        public virtual DbSet<LotType> LotTypes { get; set; }
+        public virtual DbSet<LotQtyByItem> LotQtyByItems { get; set; }
+        public virtual DbSet<RequestItem> RequestItems { get; set; }
+        public virtual DbSet<RequestItemDetail> RequestItemDetails { get; set; }
+        public virtual DbSet<RIS> RIS { get; set; }
+        public virtual DbSet<MRS> MRS { get; set; }
+        public virtual DbSet<Discipline> Disciplines { get; set; }
+        public virtual DbSet<InventTrans> InventTrans { get; set; }
+        public virtual DbSet<InventTransDetail> InventTransDetails { get; set; }
+        public DbSet<InventoryByIdResponse> InventoryByIdResponses { get; set; }
+        #endregion
+
+        #region RR
+        public virtual DbSet<ForReceiving> ForReceivings { get; set; }
+        public virtual DbSet<Infrastructure.Entities.Receiving.RRReport> RRReports { get; set; }
+        public virtual DbSet<ReceivingDetail> ReceivingDetails { get; set; }
+        public virtual DbSet<RRDetailDto> RRDetailDtos { get; set; }
+        public virtual DbSet<ForRR> ForRRs { get; set; }
+        public virtual DbSet<RR> RRs { get; set; }
+        public virtual DbSet<Entities.Receiving.RRDetailDto> RRDetailss { get; set; }
+        public virtual DbSet<Entities.Receiving.RRDetails> RRDetails { get; set; }
+        public virtual DbSet<RRSeries> RRSeries { get; set; }
+        #endregion
 
         #region Automation Part
         public virtual DbSet<AllForCanvass> AllForCanvasses { get; set; }
@@ -170,7 +201,7 @@ namespace CPRNIMS.Infrastructure.Database
                 b.HasOne(u => u.Attachment)
                     .WithOne(a => a.ApplicationUser)
                     .HasForeignKey<Attachment>(a => a.AttachmentId)
-                    .IsRequired(false); // Allow null if there is no attachment
+                    .IsRequired(false); 
             });
             modelBuilder.Entity<Attachment>(b =>
             {
@@ -178,7 +209,7 @@ namespace CPRNIMS.Infrastructure.Database
                 b.HasOne(a => a.AttachmentExtention)
                     .WithOne()
                     .HasForeignKey<Attachment>(a => a.ExtensionId)
-                    .IsRequired(false); // Allow null if there is no extension
+                    .IsRequired(false);
             });
             modelBuilder.Entity<ApplicationUser>(b =>
             {
@@ -236,6 +267,74 @@ namespace CPRNIMS.Infrastructure.Database
             {
                 b.ToTable("UserRoles");
             });
+            modelBuilder.Entity<Inventory>()
+                .HasOne(i => i.Lot)
+                .WithMany()
+                .HasForeignKey(i => i.LotId)
+                .OnDelete(DeleteBehavior.Restrict);
+
+            modelBuilder.Entity<Inventory>()
+             .HasOne(i => i.Item)
+             .WithMany()
+             .HasForeignKey(i => i.ItemNo)
+             .OnDelete(DeleteBehavior.Restrict);
+
+            modelBuilder.Entity<Item>()
+             .HasOne(i => i.ItemCode)
+             .WithMany()
+             .HasForeignKey(i => i.ItemCodeId)
+             .OnDelete(DeleteBehavior.Restrict);
+
+            modelBuilder.Entity<ItemCode>()
+            .HasOne(i => i.ItemCategory)
+            .WithMany()
+            .HasForeignKey(i => i.ItemCategoryId)
+            .OnDelete(DeleteBehavior.Restrict);
+
+            modelBuilder.Entity<InventTransDetail>(e =>
+            {
+                e.HasOne(i => i.PRDetails)
+                 .WithMany()
+                 .HasForeignKey(t => t.PRDetailId)
+                 .OnDelete(DeleteBehavior.Restrict);
+
+                e.HasOne(r => r.RRDetails)
+                 .WithMany()
+                 .HasForeignKey(r => r.RRDetailId)
+                 .IsRequired(false)
+                 .HasForeignKey(r => r.RRDetailId)
+                 .OnDelete(DeleteBehavior.Restrict);
+            });
+
+            modelBuilder.Entity<PRDetails>(e =>
+            {
+                e.HasOne(i => i.PRs)
+                 .WithMany()
+                 .HasForeignKey(t => t.PRId)
+                 .OnDelete(DeleteBehavior.Restrict);
+            });
+
+            modelBuilder.Entity<RIS>(e => {
+                e.HasOne(r => r.Inventory)
+                 .WithMany()
+                 .HasForeignKey(r => r.InventoryId)
+                 .OnDelete(DeleteBehavior.Restrict);
+
+                e.HasOne(r => r.Discipline)
+                 .WithMany()
+                 .HasForeignKey(r => r.DisciplineId);
+
+                e.HasOne(r => r.ProjectCodes)
+                .WithMany()
+                .HasForeignKey(r => r.ProjectCodeId);
+            });
+
+            modelBuilder.Entity<MRS>(e => {
+                e.HasOne(m => m.RIS)
+                 .WithMany(r => r.MaterialReturns)
+                 .HasForeignKey(m => m.RISId)
+                 .OnDelete(DeleteBehavior.Restrict);
+            });
         }
     }
 }

CPRNIMS.Infrastructure/Dto/Account/LoginResponse.cs

@@ -3,6 +3,7 @@ using System;
 using System.Collections.Generic;
 using System.ComponentModel.DataAnnotations;
 using System.Linq;
+using System.Security.Claims;
 using System.Text;
 using System.Threading.Tasks;
 
@@ -20,6 +21,7 @@ namespace CPRNIMS.Infrastructure.Dto.Account
         public string URLAttachment { get; set; } = string.Empty;
         public string? token { get; set; }
         public string? company { get; set; }
+        public int? departmentId { get; set; }
         public string? refreshToken { get; set; }
         public DateTime expiresAt { get; set; }
         public int expiresInSeconds { get; set; }

CPRNIMS.Infrastructure/Dto/Account/UserClaimsDto.cs

@@ -13,5 +13,6 @@ namespace CPRNIMS.Infrastructure.Dto.Account
         public string FullName { get; init; } = default!;
         public string Company { get; init; } = default!;
         public IReadOnlyList<string> Roles { get; init; } = [];
+        public int? DepartmentId { get; set; }
     }
 }

CPRNIMS.Infrastructure/Dto/Common/ApiResponse.cs

@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Common
+{
+    public class ApiResponse<T>
+    {
+        public bool success { get; set; }
+        public string? message { get; set; } 
+        public T? data { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/DisciplineDto.cs

@@ -0,0 +1,20 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class DisciplineDto
+    {
+        public byte DisciplineId { get; set; }
+        public string DisciplineName { get; set; } = string.Empty;
+    }
+    public class ProjectCodeDto
+    {
+        public string ProjectCode { get; set; } = string.Empty;
+        public string ProjectName { get; set; } = string.Empty;
+        public int ProjectCodeId { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/MRSFilterDto.cs

@@ -0,0 +1,20 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class MRSFilterDto
+    {
+        public int PageNumber { get; set; } = 1;
+        public int PageSize { get; set; } = 12;
+        public string? SearchMRSNo { get; set; }
+        public long? RISId { get; set; }
+        public short? Status { get; set; }
+        public DateTime? DateFrom { get; set; }
+        public DateTime? DateTo { get; set; }
+    }
+
+}

CPRNIMS.Infrastructure/Dto/Inventory/MRSPagedDto.cs

@@ -0,0 +1,30 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Text.Json.Serialization;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class MRSPagedDto
+    {
+        public long MRSId { get; set; }
+        public string MRSNo { get; set; } = string.Empty;
+        public long RISId { get; set; }
+        public string? RISNo { get; set; }
+        public string? ItemName { get; set; }
+        public string? ReturnedBy { get; set; }
+        public decimal QtyReturned { get; set; }
+        public string? Condition { get; set; }
+        public string? Remarks { get; set; }
+        public short Status { get; set; }
+        public string? StatusLabel { get; set; }
+        public string? CreatedBy { get; set; }
+        public DateTime CreatedDate { get; set; }
+        public string? ApprovedBy { get; set; }
+        public DateTime? ApprovedDate { get; set; }
+        public int InventoryId { get; set; }
+        public List<MRSPagedDto> Data { get; set; } = [];
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/MRSPagedRequest.cs

@@ -0,0 +1,20 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class MRSPagedRequest
+    {
+        public string? SearchMRSNo { get; set; }
+        public string? SearchRISNo { get; set; }
+        public string? SearchItemName { get; set; }
+        public string? SearchReturnedBy { get; set; }
+        public short? Status { get; set; }
+        public string? Condition { get; set; }
+        public int PageNumber { get; set; } = 1;
+        public int PageSize { get; set; } = 12;
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/MRSPagedResult.cs

@@ -0,0 +1,17 @@
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class MRSPagedResult
+    {
+        public IEnumerable<MRSPagedDto> Data { get; set; } = [];
+        public int RecordsTotal { get; set; }
+        public List<string> DepartmentList { get; set; } = new List<string>();
+        public List<string> DisciplineList { get; set; } = new List<string>();
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/PagedResult.cs

@@ -0,0 +1,20 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class PagedResult<T>
+    {
+        public List<T> Data { get; set; } = new List<T>();
+        public int TotalCount { get; set; }
+        public int PageNumber { get; set; }
+        public int PageSize { get; set; }
+        public List<string> DepartmentList { get; set; } = new List<string>();
+        public List<string> CategoryList { get; set; } = new List<string>();
+        public bool IsSuccess { get; set; } = true;
+        public string? ErrorMessage { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/RISFilterDto.cs

@@ -0,0 +1,21 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class RISFilterDto
+    {
+        public string? SearchRISNo { get; set; }
+        public string? SearchItemName { get; set; }
+        public string? SearchIssuedTo { get; set; }
+        public string? Discipline { get; set; }
+        public short? Status { get; set; }
+        public int PageNumber { get; set; } = 1;
+        public int PageSize { get; set; } = 12;
+        public DateTime? DateFrom { get; set; }
+        public DateTime? DateTo { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/RISPagedResult.cs

@@ -0,0 +1,17 @@
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class RISPagedResult
+    {
+        public IEnumerable<RISResponse> Data { get; set; } = [];
+        public int RecordsTotal { get; set; }
+        public IEnumerable<string> DepartmentList { get; set; } = [];
+        public IEnumerable<DisciplineDto> DisciplineList { get; set; } = [];
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/RISReferenceDto.cs

@@ -0,0 +1,19 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class RISReferenceDto
+    {
+        public long RISId { get; set; }
+        public string RISNo { get; set; } = string.Empty;
+        public decimal QtyIssued { get; set; }
+        public decimal TotalReturned { get; set; }
+        public decimal QtyAvailableToReturn => QtyIssued - TotalReturned;
+        public string DisciplineName { get; set; } = string.Empty;
+        public DateTime CreatedDate { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/RISSearchResultDto.cs

@@ -0,0 +1,26 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class RISSearchResultDto
+    {
+        public long RISId { get; set; }
+        public string RISNo { get; set; } = string.Empty;
+        public int ProjectCodeId { get; set; }
+        public string ProjectCode { get; set; } = string.Empty;
+        public string ProjectName { get; set; } = string.Empty;
+        public string DisciplineName { get; set; } = string.Empty;
+        public decimal QtyAvailableToReturn { get; set; }
+    }
+
+    public class ProjectCodeOptionDto
+    {
+        public int ProjectCodeId { get; set; }
+        public string ProjectCode { get; set; } = string.Empty;
+        public string ProjectName { get; set; } = string.Empty;
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Reports/RISReportDataDto.cs

@@ -0,0 +1,50 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Reports
+{
+    public class RISReportDataDto
+    {
+        public List<RISRowDto> Rows { get; set; } = new();
+        public List<DisciplineAggDto> Disciplines { get; set; } = new();
+        public List<TopRecipientDto> Recipients { get; set; } = new();
+    }
+    public class RISRowDto
+    {
+        public string? RISNo { get; set; }
+        public long? PRNo { get; set; }
+        public decimal QtyIssued { get; set; }
+        public string? IssuedTo { get; set; }
+        public string? StatusLabel { get; set; }
+        public string? CreatedBy { get; set; }
+        public string? ApprovedBy { get; set; }
+        public DateTime? ApprovedDate { get; set; }
+        public DateTime? CreatedDate { get; set; }
+        public string? DisciplineName { get; set; }
+        public string? ItemName { get; set; }
+        public long? ItemNo { get; set; }
+        public decimal QtyIn { get; set; }
+        public decimal QtyOut { get; set; }
+        public decimal QtyOnHand { get; set; }
+        public string? DepartmentName { get; set; }
+        public decimal TotalReturned { get; set; }
+        public int MRSCount { get; set; }
+        public decimal NetIssued { get; set; }
+    }
+
+    public class DisciplineAggDto
+    {
+        public string? DisciplineName { get; set; }
+        public int SlipCount { get; set; }
+    }
+
+    public class TopRecipientDto
+    {
+        public string? Name { get; set; }
+        public int SlipCount { get; set; }
+        public decimal QtyOut { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Reports/ReportDtos.cs

@@ -0,0 +1,160 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Reports
+{
+    public class RISReportDto
+    {
+        public string CompanyName { get; set; } = "Lloyd Laboratories Incorporated";
+        public string PreparedBy { get; set; } = "Finance Department";
+        public string ReportNo { get; set; } = string.Empty;
+        public DateTime DateFrom { get; set; }
+        public DateTime DateTo { get; set; }
+
+        public RISReportSummary Summary { get; set; } = new();
+        public List<RISReportRow> Rows { get; set; } = [];
+        public List<DisciplineCount> ByDiscipline { get; set; } = [];
+        public List<TopRecipient> TopRecipients { get; set; } = [];
+    }
+
+    public class RISReportSummary
+    {
+        public int TotalRIS { get; set; }
+        public int TotalApproved { get; set; }
+        public int TotalPending { get; set; }
+        public int TotalCancelled { get; set; }
+        public decimal TotalQtyIssued { get; set; }
+        public decimal TotalQtyReturned { get; set; }
+        public decimal TotalNetIssued { get; set; }
+        public decimal ApprovalRatePct { get; set; }
+    }
+
+    public class RISReportRow
+    {
+        public string RISNo { get; set; } = string.Empty;
+        public DateTime CreatedDate { get; set; }
+        public string ItemName { get; set; } = string.Empty;
+        public long ItemNo { get; set; }
+        public string DisciplineName { get; set; } = string.Empty;
+        public string ProjectName { get; set; } = string.Empty;
+        public decimal QtyIssued { get; set; }
+        public decimal TotalReturned { get; set; }
+        public decimal NetIssued { get; set; }
+        public short Status { get; set; }
+        public string StatusLabel { get; set; } = string.Empty;
+    }
+
+    public class DisciplineCount
+    {
+        public string DisciplineName { get; set; } = string.Empty;
+        public int Count { get; set; }
+    }
+
+    public class TopRecipient
+    {
+        public string IssuedTo { get; set; } = string.Empty;
+        public int SlipCount { get; set; }
+        public decimal TotalQty { get; set; }
+    }
+
+    public class MRSReportDto
+    {
+        public string CompanyName { get; set; } = "Lloyd Laboratories Incorporated";
+        public string PreparedBy { get; set; } = "Finance Department";
+        public string ReportNo { get; set; } = string.Empty;
+        public DateTime DateFrom { get; set; }
+        public DateTime DateTo { get; set; }
+
+        public MRSReportSummary Summary { get; set; } = new();
+        public List<MRSReportRow> Rows { get; set; } = [];
+        public List<ConditionTotal> ByCondition { get; set; } = [];
+    }
+
+    public class MRSReportSummary
+    {
+        public int TotalMRS { get; set; }
+        public decimal TotalQtyReturned { get; set; }
+        public decimal TotalQtyIssuedRIS { get; set; }
+        public decimal NetQtyConsumed { get; set; }
+        public decimal ReturnRatePct { get; set; }
+        public decimal GoodConditionPct { get; set; }
+    }
+
+    public class MRSReportRow
+    {
+        public string MRSNo { get; set; } = string.Empty;
+        public DateTime CreatedDate { get; set; }
+        public string RISNo { get; set; } = string.Empty;
+        public string ItemName { get; set; } = string.Empty;
+        public string ReturnedBy { get; set; } = string.Empty;
+        public decimal QtyReturned { get; set; }
+        public string Condition { get; set; } = string.Empty;
+        public short Status { get; set; }
+        public string StatusLabel { get; set; } = string.Empty;
+    }
+
+    public class ConditionTotal
+    {
+        public string Condition { get; set; } = string.Empty;
+        public decimal TotalQty { get; set; }
+    }
+
+    public class InventoryReportDto
+    {
+        public string CompanyName { get; set; } = "Lloyd Laboratories Incorporated";
+        public string PreparedBy { get; set; } = "Finance Department";
+        public string ReportNo { get; set; } = string.Empty;
+        public DateTime AsOf { get; set; }
+        public List<string> Departments { get; set; } = new();
+        public int Page { get; set; }
+        public int PageSize { get; set; }
+        public int TotalRows { get; set; }
+        public int TotalPages => PageSize > 0 ? (int)Math.Ceiling(TotalRows / (double)PageSize) : 0;
+        public InventoryReportSummary Summary { get; set; } = new();
+        public List<InventoryReportRow> Rows { get; set; } = [];
+        public List<CategoryStockLevel> ByCategory { get; set; } = [];
+        public List<InventoryAlert> Alerts { get; set; } = [];
+    }
+
+    public class InventoryReportSummary
+    {
+        public int TotalSKUs { get; set; }
+        public decimal TotalOnHand { get; set; }
+        public decimal TotalQtyIn { get; set; }
+        public decimal TotalQtyOut { get; set; }
+        public decimal TotalValue {  get; set; }
+        public int LowStockCount { get; set; }
+        public int OutOfStockCount { get; set; }
+    }
+
+    public class InventoryReportRow
+    {
+        public string ItemName { get; set; } = string.Empty;
+        public long ItemNo { get; set; }
+        public string ItemCategoryName { get; set; } = string.Empty;
+        public string? LotNo { get; set; }
+        public decimal QtyIn { get; set; }
+        public decimal QtyOut { get; set; }
+        public decimal QtyOnHand { get; set; }
+        public decimal UnitPrice { get; set; }
+        public int StockPct { get; set; }
+        public string? Department { get; set; }
+        public string? CurrencyCode { get; set; }
+    }
+
+    public class CategoryStockLevel
+    {
+        public string CategoryName { get; set; } = string.Empty;
+        public int AvgStockPct { get; set; }
+    }
+
+    public class InventoryAlert
+    {
+        public string ItemName { get; set; } = string.Empty;
+        public decimal QtyOnHand { get; set; }
+        public string Severity { get; set; } = string.Empty; // "Critical" | "Low"
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Reports/Response/InventoryData.cs

@@ -0,0 +1,14 @@
+using CPRNIMS.Infrastructure.Dto.Inventory.Response;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Reports.Response
+{
+    public class InventoryData
+    {
+        public List<InventoryReportDto> Data { get; set; } = [];
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Reports/Response/MRSData.cs

@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Reports.Response
+{
+    public class MRSData
+    {
+        public List<MRSReportDto> Data { get; set; } = [];
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Reports/Response/RISData.cs

@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Reports.Response
+{
+    public class RISData
+    {
+        public List<RISReportDto> Data { get; set; } = [];
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/ApproveMRSRequest.cs

@@ -0,0 +1,10 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class ApproveMRSRequest { public long MRSId { get; set; } }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/ApproveRISRequest.cs

@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class ApproveRISRequest
+    {
+        public long RISId { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/CancelMRSRequest.cs

@@ -0,0 +1,14 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class CancelMRSRequest
+    {
+        public long MRSId { get; set; }
+        public string Reason { get; set; } = string.Empty;
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/CancelRISRequest.cs

@@ -0,0 +1,14 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class CancelRISRequest
+    {
+        public long RISId { get; set; }
+        public string Reason { get; set; } = string.Empty;
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/CreateMRSRequest.cs

@@ -0,0 +1,17 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class CreateMRSRequest
+    {
+        public long RISId { get; set; }
+        public decimal QtyReturned { get; set; }
+        public string ReturnedBy { get; set; } = string.Empty;
+        public string? Condition { get; set; }
+        public string? Remarks { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/CreateRISRequest.cs

@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class CreateRISRequest
+    {
+        public int InventoryId { get; set; }
+        public long PRDetailId { get; set; }
+        public int ProjectCodeId { get; set; }
+        public byte DisciplineId { get; set; }
+        public decimal QtyIssued { get; set; }
+        public string? Remarks { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/InventoryReportsRequest.cs

@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class InventoryReportsRequest
+    {
+        public DateTime DateFrom {  get; set; }
+        public DateTime DateTo { get; set; }
+        public string? Department { get; set; }
+        public int Page { get; set; } 
+        public int PageSize { get; set; }
+        public bool Paginate { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/InventoryRequest.cs

@@ -0,0 +1,23 @@
+using System;
+using System.Collections.Generic;
+using System.Data;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class InventoryRequest
+    {
+        public string? SearchPRNo { get; set; }
+        public string? SearchItemName { get; set; }
+        public string? SearchDept { get; set; }
+        public int PageNumber { get; set; } = 1;
+        public int PageSize { get; set; } = 10;
+        public byte MessCode { get; set; }
+        public string? SearchProjectCode { get; set; }
+        public string? SearchItemNo { get; set; }
+        public string? UserId { get; set; }
+        public int InventoryId { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/RISPagedRequest.cs

@@ -0,0 +1,19 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class RISPagedRequest
+    {
+        public string? SearchRISNo { get; set; }
+        public string? SearchItemName { get; set; }
+        public string? SearchIssuedTo { get; set; }
+        public string? Discipline { get; set; }
+        public short? Status { get; set; }
+        public int PageNumber { get; set; } = 1;
+        public int PageSize { get; set; } = 12;
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Request/SearchRISProjectCodeRequest.cs

@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Request
+{
+    public class SearchRISProjectCodeRequest
+    {
+        public int? SearchProjectCodeId { get; set; }
+        public string? SearchRISNo { get; set; }
+        public string? SearchProjectCode { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/InventoryByIdResponse.cs

@@ -0,0 +1,28 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class InventoryByIdResponse
+    {
+        [Key]
+        public int InventoryId { get; set; }
+        public decimal QtyIn { get; set; }
+        public decimal QtyOut { get; set; }
+        public decimal QtyOnHand { get; set; }
+        public string? LotNo { get; set; }
+        public string? ProjectCode { get; set; }
+        public string? UserId { get; set; }
+        public string? ItemName { get; set; }
+        public string? ItemDescription { get; set; }
+        public string? ItemCategoryName { get; set; }
+        public string? Department { get; set; }
+        public DateTime CreatedDate { get; set; }
+        public long ItemNo { get; set; }
+        public long PRNo { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/InventoryResponse.cs

@@ -0,0 +1,28 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class InventoryResponse
+    {
+        [Key]
+        public int InventoryId { get; set; }
+        public decimal QtyIn { get; set; }
+        public decimal QtyOut { get; set; }
+        public decimal QtyOnHand { get; set; }
+        public string? LotNo { get; set; }
+        public string? ProjectCode { get; set; }
+        public string? UserId { get; set; }
+        public string? ItemName { get; set; }
+        public string? ItemDescription { get; set; }
+        public string? ItemCategoryName { get; set; }
+        public string? Department { get; set; }
+        public DateTime CreatedDate { get; set; }
+        public long ItemNo { get; set; }
+        public long PRNo { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/MRSPagedResponse.cs

@@ -0,0 +1,34 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Text.Json.Serialization;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class MRSPagedResponse
+    {
+        public List<MRSListItem> Data { get; set; } = [];
+        public int RecordsTotal { get; set; }
+    }
+    public class MRSListItem
+    {
+        public long MRSId { get; set; }
+        public string MRSNo { get; set; } = string.Empty;
+        public long RISId { get; set; }
+        public string? RISNo { get; set; }
+        public string? ItemName { get; set; }
+        public string? ReturnedBy { get; set; }
+        public decimal QtyReturned { get; set; }
+        public string? Condition { get; set; }
+        public string? Remarks { get; set; }
+        public short Status { get; set; }
+        public string? StatusLabel { get; set; }
+        public string? CreatedBy { get; set; }
+        public DateTime CreatedDate { get; set; }
+        public string? ApprovedBy { get; set; }
+        public DateTime? ApprovedDate { get; set; }
+        public int InventoryId { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/MRSResponse.cs

@@ -0,0 +1,17 @@
+using CPRNIMS.Infrastructure.Models.Inventory;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Text.Json.Serialization;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class MRSResponse
+    {
+        [JsonPropertyName("success")] public bool Success { get; set; }
+        [JsonPropertyName("message")] public string? Message { get; set; }
+        [JsonPropertyName("data")] public MRSData? Data { get; set; }      
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/RISPagedResponse.cs

@@ -0,0 +1,58 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class RISPagedResponse
+    {
+        public List<RISListItem> Data { get; set; } = [];
+
+        public int RecordsTotal { get; set; }
+
+        public List<string> DepartmentList { get; set; } = [];
+
+        public List<DisciplineItem> DisciplineList { get; set; } = [];
+    }
+    public class RISListItem
+    {
+        public long RISId { get; set; }
+
+        public string RISNo { get; set; } = string.Empty;
+
+        public int InventoryId { get; set; }
+        public string? ItemName { get; set; }
+
+        public long ItemNo { get; set; }
+
+        public string? ProjectCode { get; set; }
+
+        public string? ProjectName { get; set; }
+
+        public string? DisciplineName { get; set; }
+
+        public decimal QtyIssued { get; set; }
+
+        public decimal TotalReturned { get; set; }
+        public string? Remarks { get; set; }
+
+        public short Status { get; set; }
+
+        public string? StatusLabel { get; set; }
+
+        public string? CreatedBy { get; set; }
+
+        public DateTime CreatedDate { get; set; }
+
+        public string? ApprovedBy { get; set; }
+        public DateTime? ApprovedDate { get; set; }
+        public decimal MRSCount { get; set; }
+    }
+    public class DisciplineItem
+    {
+        public byte DisciplineId { get; set; }
+        public string DisciplineName { get; set; } = string.Empty;
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/RISProjectCodeResponse.cs

@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class RISProjectCodeResponse
+    {
+        public string ProjectCode { get; set; }=string.Empty;
+        public string ProjectName { get; set; } = string.Empty;
+
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/RISResponse.cs

@@ -0,0 +1,34 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class RISResponse
+    {
+        public long RISId { get; set; }
+        public string RISNo { get; set; } = string.Empty;
+        public int InventoryId { get; set; }
+        public string ItemName { get; set; } = string.Empty;
+        public long ItemNo { get; set; }
+        public string? LotNo { get; set; }
+        public int ProjectCodeId { get; set; } 
+        public string DisciplineName { get; set; } = string.Empty;
+        public string? Message { get; set; }
+        public byte DisciplineId { get; set; }
+        public decimal QtyIssued { get; set; }
+        public string? Remarks { get; set; }
+        public short Status { get; set; }
+        public string StatusLabel => Status switch { 0 => "Draft", 1 => "Approved", 2 => "Cancelled", _ => "Unknown" };
+        public string CreatedBy { get; set; } = string.Empty;
+        public DateTime CreatedDate { get; set; }
+        public string? ApprovedBy { get; set; }
+        public DateTime? ApprovedDate { get; set; }
+        public decimal MRSCount { get; set; }
+        public decimal TotalReturned { get; set; }
+        public string? ProjectName { get; set; }
+        public string? ProjectCode { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/Response/SearchRISProjectCodeResponse.cs

@@ -0,0 +1,30 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory.Response
+{
+    public class SearchApiResponse<T>
+    {
+        public bool Success { get; set; }
+        public List<T> data { get; set; } = new List<T>();
+    }
+    public class SearchRISProjectCodeResponse
+    {
+        public long RISId { get; set; }
+        public string RISNo { get; set; } = string.Empty;
+        public int ProjectCodeId { get; set; }
+        public string ProjectCode { get; set; } = string.Empty;
+        public string ProjectName { get; set; } = string.Empty;
+        public string DisciplineName { get; set; } = string.Empty;
+        public decimal QtyAvailableToReturn { get; set; }
+    }
+    public class ProjectCodeOptionResponse
+    {
+        public int ProjectCodeId { get; set; }
+        public string ProjectCode { get; set; } = string.Empty;
+        public string ProjectName { get; set; } = string.Empty;
+    }
+}

CPRNIMS.Infrastructure/Dto/Inventory/TransactContextDto.cs

@@ -0,0 +1,24 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Dto.Inventory
+{
+    public class TransactContextDto
+    {
+        public int InventoryId { get; set; }
+        public string ItemName { get; set; } = string.Empty;
+        public long ItemNo { get; set; }
+        public long PRNo { get; set; }
+        public string? LotNo { get; set; }
+        public string? Department { get; set; }
+        public decimal QtyOnHand { get; set; }
+        public decimal QtyIn { get; set; }
+        public decimal QtyOut { get; set; }
+        public IEnumerable<ProjectCodeDto> ProjectCodes { get; set; } = [];
+        public IEnumerable<DisciplineDto> Disciplines { get; set; } = [];
+        public IEnumerable<RISReferenceDto> OpenRISList { get; set; } = [];
+    }
+}

CPRNIMS.Infrastructure/Dto/PO/PODto.cs

@@ -23,7 +23,7 @@ namespace CPRNIMS.Infrastructure.Dto.PO
         public string? SupplierName { get; set; }
         public string? Manufacturer { get; set; }
         public int ItemCount { get; set; }
-        public short CurrencyId { get; set; }
+        public byte CurrencyId { get; set; }
         public string? Department { get; set; }
         public string? ItemCategoryName { get; set; }
         public DateTime CommitmentDate { get; set; }

CPRNIMS.Infrastructure/Entities/Account/ApplicationUser.cs

@@ -23,6 +23,7 @@ namespace CPRNIMS.Infrastructure.Entities.Account
         public DateTime UpdatedDate { get; set; }
         public string? ProfilePicture { get; set; }
         public string? Address { get; set; }
+        public bool? IsActive { get; set; }
         public Attachment? Attachment { get; set; }
     }
 }

CPRNIMS.Infrastructure/Entities/Finance/RRDetailDto.cs

@@ -8,7 +8,7 @@ using System.Threading.Tasks;
 
 namespace CPRNIMS.Infrastructure.Entities.Finance
 {
-    public class RRDetail : CommonProperties
+    public class RRDetailDto : CommonProperties
     {
         [Key]
         public long RRDetailId { get; set; }

CPRNIMS.Infrastructure/Entities/Inventory/Discipline.cs

@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Inventory
+{
+    public class Discipline
+    {
+        [Key]
+        public byte DisciplineId { get; set; }
+
+        [Required, MaxLength(100)]
+        public string DisciplineName { get; set; } = string.Empty;
+    }
+}

CPRNIMS.Infrastructure/Entities/Inventory/InventTrans.cs

@@ -0,0 +1,23 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Inventory
+{
+    [Table("InventTrans")]
+    public class InventTrans
+    {
+        [Key]
+        public int InventTransId { get; set; }
+        public int InventoryId { get; set; }
+        public long RRNo { get; set; }
+        public string CreatedBy { get; set; }=string.Empty;
+        public bool IsActive { get; set; }
+        public Inventory? Inventory { get; set; }
+        public ICollection<InventTransDetail> InventTransDetails { get; set; } = [];
+    }
+}

CPRNIMS.Infrastructure/Entities/Inventory/InventTransDetail.cs

@@ -0,0 +1,32 @@
+using CPRNIMS.Infrastructure.Entities.Items;
+using CPRNIMS.Infrastructure.Entities.Purchasing;
+using CPRNIMS.Infrastructure.Entities.Receiving;
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Inventory
+{
+    [Table("InventTransDetail")]
+    public class InventTransDetail
+    {
+        [Key]
+        public long InventTransDetailId { get; set; }
+        public int InventTransId { get; set; }
+        public byte TransTypeId { get; set; }
+        public decimal QtyIn {  get; set; }
+        public decimal QtyOut { get; set; }
+        public DateTime CreatedDate { get; set; }
+        public string? Remarks { get; set; }
+        public bool IsActive { get; set; }
+        public long PRDetailId { get; set; }
+        public long? RRDetailId { get; set; }
+        public PRDetails? PRDetails { get; set; }
+        public RRDetails? RRDetails { get; set; }
+        public InventTrans? InventTrans { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Entities/Inventory/Inventory.cs

@@ -1,12 +1,16 @@
-using System;
+using CPRNIMS.Infrastructure.Entities.Account;
+using CPRNIMS.Infrastructure.Entities.Items;
+using System;
 using System.Collections.Generic;
 using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
 
 namespace CPRNIMS.Infrastructure.Entities.Inventory
 {
+    [Table("Inventory")]
     public class Inventory
     {
         [Key]
@@ -14,15 +18,13 @@ namespace CPRNIMS.Infrastructure.Entities.Inventory
         public decimal QtyIn { get; set; }
         public decimal QtyOut { get; set; }
         public decimal QtyOnHand { get; set; }
-        public decimal RemainingQty { get; set; }
-        public string? LotNo { get; set; }
         public string? UserId { get; set; }
-        public string? ItemName { get; set; }    
-        public string? ItemDescription { get; set; }
-        public string? ItemCategoryName { get; set; }
-        public string? Department { get; set; }
-        public DateTime CreatedDate { get; set; }
         public bool IsActive { get; set; }
         public long ItemNo { get; set; }
+        public int LotId { get; set; }
+        public Lot? Lot { get; set; }
+        public ICollection<InventTrans> InventTrans { get; set; } = [];
+        public ApplicationUser? User { get; set; }
+        public Item? Item { get; set; }
     }
 }

CPRNIMS.Infrastructure/Entities/Inventory/Lot.cs

@@ -17,8 +17,8 @@ namespace CPRNIMS.Infrastructure.Entities.Inventory
         public int LotId { get; set; }
         public int InventoryId { get; set; }
         public string? LotName { get; set; }
-        public string? LotTypeName { get; set; }
         public byte LotTypeId { get; set; }
         public string? UserId { get; set; }
+        public LotType? LotType { get; set; }
     }
 }

CPRNIMS.Infrastructure/Entities/Inventory/LotType.cs

@@ -0,0 +1,18 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Inventory
+{
+    [Table("LotType")]
+    public class LotType
+    {
+        [Key]
+        public int LotTypeId { get; set; }
+        public string? LotTypeName { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Entities/Inventory/MRS.cs

@@ -0,0 +1,45 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Inventory
+{
+    [Table("MRS")]
+    public class MRS
+    {
+        [Key]
+        public long MRSId { get; set; }
+
+        [Required, MaxLength(50)]
+        public string MRSNo { get; set; } = string.Empty;
+        public long RISId { get; set; }
+        public int InventoryId { get; set; }
+        [Required, MaxLength(450)]
+        public string ReturnedBy { get; set; } = string.Empty;
+        public decimal QtyReturned { get; set; }
+
+        [MaxLength(100)]
+        public string? Condition { get; set; }
+
+        [MaxLength(500)]
+        public string? Remarks { get; set; }
+
+        public short Status { get; set; } = 0;
+
+        [Required, MaxLength(450)]
+        public string CreatedBy { get; set; } = string.Empty;
+
+        public DateTime CreatedDate { get; set; } = DateTime.Now;
+        public string? ApprovedBy { get; set; }
+        public DateTime? ApprovedDate { get; set; }
+        public string? CanceledBy { get; set; }
+        public DateTime? CanceledDate { get; set; }
+        public string? Reason { get; set; }
+        public RIS RIS { get; set; } = null!;
+        public Inventory Inventory { get; set; } = null!;
+    }
+}

CPRNIMS.Infrastructure/Entities/Inventory/RIS.cs

@@ -0,0 +1,46 @@
+using CPRNIMS.Infrastructure.Entities.Purchasing;
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Inventory
+{
+    [Table("RIS")]
+    public class RIS
+    {
+        [Key]
+        public long RISId { get; set; }
+
+        [Required, MaxLength(50)]
+        public string RISNo { get; set; } = string.Empty;
+
+        public int InventoryId { get; set; }
+        public long PRDetailId { get; set; }
+        public byte DisciplineId { get; set; }
+        public decimal QtyIssued { get; set; }
+
+        [MaxLength(500)]
+        public string? Remarks { get; set; }
+
+        public short Status { get; set; } = 0;
+
+        [Required, MaxLength(450)]
+        public string CreatedBy { get; set; } = string.Empty;
+        public DateTime CreatedDate { get; set; } = DateTime.Now;
+        public string? ApprovedBy { get; set; }
+        public DateTime? ApprovedDate { get; set; }
+        public string? CanceledBy { get; set; }
+        public DateTime?  CanceledDate { get; set; }
+        public string? Reason { get; set; }
+        public int ProjectCodeId { get; set; }
+        public ProjectCodes ProjectCodes { get; set; } = null!;
+        public Inventory Inventory { get; set; } = null!;
+        public PRDetails PRDetail { get; set; } = null!;
+        public Discipline Discipline { get; set; } = null!;
+        public ICollection<MRS> MaterialReturns { get; set; } = [];
+    }
+ }

CPRNIMS.Infrastructure/Entities/Items/Item.cs

@@ -1,13 +1,7 @@
-using CPRNIMS.Infrastructure.Entities.Account;
-using CPRNIMS.Infrastructure.Entities.Common;
-using System;
-using System.Collections.Generic;
+using CPRNIMS.Infrastructure.Entities.Common;
 using System.ComponentModel.DataAnnotations;
 using System.ComponentModel.DataAnnotations.Schema;
-using System.Linq;
-using System.Text;
-using System.Threading.Tasks;
-using static System.Runtime.InteropServices.JavaScript.JSType;
+
 
 namespace CPRNIMS.Infrastructure.Entities.Items
 {
@@ -42,5 +36,6 @@ namespace CPRNIMS.Infrastructure.Entities.Items
         public string? ItemAttachPath { get; set; }
         public bool IsMDLD { get; set; }
         public bool CheckBox { get; set; }
+        public ItemCode? ItemCode { get; set; }
     }
 }

CPRNIMS.Infrastructure/Entities/Items/ItemCode.cs

@@ -23,5 +23,7 @@ namespace CPRNIMS.Infrastructure.Entities.Items
         public byte RequestTypeId { get; set; }
         public bool IsActive { get; set; }
         public int CartItemCount { get; set; }
+        public short ItemCategoryId { get; set; }
+        public ItemCategory? ItemCategory { get; set; }
     }
 }

CPRNIMS.Infrastructure/Entities/Items/ItemDtos.cs

@@ -0,0 +1,41 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Items
+{
+    public class ItemDtos
+    {
+        [Key]
+        public long ItemNo { get; set; }
+        public long ItemCodeId { get; set; }
+        public string? Department { get; set; }
+        public string? ItemCategoryName { get; set; }
+        public string? UserId { get; set; }
+        public string? ItemName { get; set; }
+        public string? ItemDescription { get; set; }
+        public string? StatusName { get; set; }
+        public bool IsActive { get; set; }
+        public bool IsCommon { get; set; }
+        public byte RequestTypeId { get; set; }
+        public string? ItemLocalName { get; set; }
+        public string? ItemTypeName { get; set; }
+        public string? PRTypeName { get; set; }
+        public decimal Qty { get; set; }
+        public int ItemColorId { get; set; }
+        public short ItemLocalId { get; set; }
+        public int UOMId { get; set; }
+        public short ItemCategoryId { get; set; }
+        public string? PackagingTypeName { get; set; }
+        public short ItemClassId { get; set; }
+        public string? UOMName { get; set; }
+        public string? ItemColorName { get; set; }
+        public long ItemAttachId { get; set; }
+        public string? ItemAttachPath { get; set; }
+        public bool IsMDLD { get; set; }
+        public bool CheckBox { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Entities/PO/Currencies.cs

@@ -0,0 +1,22 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.PO
+{
+    [Table("Currencies")]
+    public class Currencies
+    {
+        [Key]
+        public byte CurrencyId { get; set; }
+        public string CurrencyName { get; set; }=string.Empty;
+        public decimal VatRate { get; set; }
+        public decimal CER { get; set; }
+        public string? AmountWords { get; set; }
+        public bool? IsActive { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Entities/PO/POHeader.cs

@@ -34,6 +34,7 @@ namespace CPRNIMS.Infrastructure.Entities.PO
         public byte PODId { get; set; }
         public byte POTypeId { get; set; }
         public byte IncoTermsId { get; set; }
+        public byte CurrencyId { get; set; }
         public string? IncotermsName { get; set; }
         public string? CountryOrigin { get; set; }
     }

CPRNIMS.Infrastructure/Entities/Purchasing/PR.cs

@@ -6,7 +6,7 @@ using System.ComponentModel.DataAnnotations.Schema;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
-using static System.Runtime.InteropServices.JavaScript.JSType;
+
 
 namespace CPRNIMS.Infrastructure.Entities.Purchasing
 {

CPRNIMS.Infrastructure/Entities/Purchasing/PRDetails.cs

@@ -1,4 +1,5 @@
 using CPRNIMS.Infrastructure.Entities.Common;
+using CPRNIMS.Infrastructure.Entities.Items;
 using CPRNIMS.Infrastructure.ViewModel.Items;
 using System;
 using System.Collections.Generic;
@@ -15,6 +16,7 @@ namespace CPRNIMS.Infrastructure.Entities.Purchasing
     {
         [Key]
         public long PRDetailsId { get; set; }
+        public long PRId { get; set; }
         public string ItemName { get; set; }=string.Empty;
         public string ItemDescription { get; set; } = string.Empty;
         public short Status { get; set; }
@@ -22,5 +24,7 @@ namespace CPRNIMS.Infrastructure.Entities.Purchasing
         public long ItemNo { get; set; }
         public decimal Qty { get; set; }
         public bool IsSearched { get; set; }
+        public PR? PRs { get; set; }
+        public ItemCategory? ItemCategory { get; set; }
     }
 }

CPRNIMS.Infrastructure/Entities/Purchasing/ProjectCodes.cs

@@ -17,6 +17,7 @@ namespace CPRNIMS.Infrastructure.Entities.Purchasing
         public string? ProjectName { get; set; }
         public int MaxDays { get; set; }
         public string? DeliveryAddress { get; set; } 
+        public string? StatusName { get; set; }
         public bool IsActive { get; set; }
     }
 }

CPRNIMS.Infrastructure/Entities/Receiving/RRDetailDto.cs

@@ -8,7 +8,7 @@ using System.Threading.Tasks;
 
 namespace CPRNIMS.Infrastructure.Entities.Receiving
 {
-    public class RRDetail
+    public class RRDetailDto
     {
         [Key]
         public long PRDetailsId { get; set; }

CPRNIMS.Infrastructure/Entities/Receiving/RRDetails.cs

@@ -0,0 +1,25 @@
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace CPRNIMS.Infrastructure.Entities.Receiving
+{
+    [Table("RRDetails")]
+    public class RRDetails
+    {
+        [Key]
+        public long RRDetailId { get; set; }
+        public long PRDetailId { get; set; }
+        public long RRId { get; set; }
+        public long PODetailId { get; set; }
+        public decimal Quantity { get; set; }
+        public decimal QuantityReceived { get; set; } 
+        public decimal QtyRemaining { get; set; }
+        public decimal UnitPrice { get; set; }
+        public bool IsActive { get; set; }
+    }
+}

CPRNIMS.Infrastructure/Models/Account/User.cs

@@ -23,5 +23,6 @@ namespace CPRNIMS.Infrastructure.Models.Account
         public string? Token { get; set; }
         public string? Company { get; set; }
         public string? MyAccess { get; set; }
+        public int DepartmentId { get; set; }
     }
 }