Project

General

Profile

Actions
Copy link

Client Comments - Improvements #20150

open

Maqaam || Transfer optimization Waiting charges - admin and api

Added by Sandeep Sajiv 8 months ago. Updated 8 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
04/03/2025
Due date:
04/04/2025 (about 8 months late)
% Done:

80%

Estimated time:
6:00 h
Spent time:
6:00 h
remarks:
DB Changes:

NEW TABLE --- TransferWaitingChargeDetail

SP --- SelectTransfersVoucherDetails ---- Select Transfer Waiting Charge Details

NEW SP --- SelectTransferWaitingChargeDetails --- To select all transfer waiting charge details

NEW SP --- InsertTransferWaitingChargeDetail --- To Insert Transfers Waiting Charge Details

Keys & Permissions:
Areas Affected:
Files Changed:

CommonService/DataService/Cax.Common.Procedures/Procedures.cs
Module/Admin/AdminWeb/App_GlobalResources/CommonResources.ar.resx
Module/Admin/AdminWeb/App_GlobalResources/CommonResources.Designer.cs
Module/Admin/AdminWeb/App_GlobalResources/CommonResources.resx
Module/Admin/AdminWeb/Areas/AdminWeb/Controllers/ReportsJsonController.Transfers.cs
Module/Admin/AdminWeb/Areas/AdminWeb/Views/Reports/OtherInfoPartial.cshtml
Module/Admin/AdminWeb/Content/js/managetransfersbookings.js
Module/Admin/DataAccess/Cax.Admin.DA/TransactionReports.cs
Module/Admin/TravelBusiness/Cax.Admin.BA/TransactionServices.cs
Module/Inventory/DTO/Cax.Inventory.DTO/InventoryTransferWaitingChargeDTO.cs
Module/Transfers/DataAccess/Cax.Transfers.DA/TransferBookingDA.cs
Module/Transfers/DataAccess/Cax.Transfers.DA/TransfersVoucherDetailsDA.cs
Module/Transfers/Model/Cax.Transfers.Model/DMO/TransfersBookingDetailsDataDMO.cs
Module/Transfers/Service/Cax.Transfer.UtilService/Cax.Transfer.UtilService.csproj
Module/Transfers/Service/Cax.Transfers.Service/Booking/TransfersBookingDetailsDTOService.cs
Module/Transfers/Service/Cax.Transfers.Service/Booking/TransfersDMService.cs
Module/Transfers/Service/Cax.Transfers.Service/Search/Handler/ResultHandler.cs
Wrapper/Transfers/Cax.Wrapper.Transfers.Service/Impl/VoucherResponseService.cs
Wrapper/Transfers/Cax.Wrapper.Transfers.Service/Search/Impl/TFSearchService.cs

Description

Waiting charges added from the admin to be shown in the frontend.

Files

Download all files
TransferResult.txt (5.75 KB) TransferResult.txt Jesmy P Jose, 04/08/2025 10:46 AM
TransferVoucherDetails.txt (8.96 KB) TransferVoucherDetails.txt Jesmy P Jose, 04/08/2025 10:46 AM
WaitingCharge.jpg (294 KB) WaitingCharge.jpg Jesmy P Jose, 04/08/2025 10:47 AM
Actions
Copy link
 #1

Updated by Jesmy P Jose 8 months ago

  • Status changed from Assigned to In Progress
Actions
Copy link Download all files
 #2

Updated by Jesmy P Jose 8 months ago

Assign Front End
[Waiting charges] details are given in result and voucher response. Attached response text files.
In result page --- click details -- showing waiting charge details. please shown on the voucher and to show it on any other pages. ***************************************
Create New Table [TransferWaitingChargeDetail] --- Saved booking transfer waiting charge detals
CREATE TABLE [dbo].[TransferWaitingChargeDetail](
[TransferWaitingChargeId] [bigint] IDENTITY NOT NULL,
[TransferBookingId] [bigint] NULL,
[TransferWCDescription] [varchar](500) NULL,
[TransferWCDescriptionAr] [nvarchar](500) NULL,
[TransferWCValue] [decimal](18, 2) NULL,
[VehicleMasterId] [bigint] NULL,
CONSTRAINT [PK_TransferWaitingChargeDetail] PRIMARY KEY CLUSTERED
(
[TransferWaitingChargeId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO *********************************************************
Waiting charge details showing in TQR --- [OtherInfo] tab.

Actions
Copy link
 #3

Updated by Sandeep Sajiv 8 months ago

  • Project changed from 321 to Almaqam-Final Phase-Web
  • Status changed from For Review to New
  • Assignee deleted (Sandeep Sajiv)
Actions
Copy link

Also available in: Atom PDF