Project

General

Profile

Actions
Copy link

Client Comments - Improvements #20996

open

Maqaam- Fixed package || Admin || Optimization - Tagging System

Added by Sandeep Sajiv 7 months ago. Updated 6 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
04/29/2025
Due date:
05/02/2025 (about 7 months late)
% Done:

80%

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

NEW TABLE --- INV_PackageCategoryMaster --- [CategoryId] [bigint],[CategoryName] [varchar](100),[CategoryNameAr] [nvarchar](100),[IsActive] [bit],[IsDelete] [bit]

TBL --- INV_Packages --- Added new column --- PackageCategorylist varchar(50)

TBL --- PackageBookingDetail --- Added new column PackageCategoryId varchar(50)

NEW SP --- GetInvPackageCategory --- To select All Inventory Package Category

SP --- SaveInventoryPackages --- Added @PackageCategoryList

SP --- GetInventoryPackages --- Selected PackageCategorylist

SP --- SaveFixedPackageBookingDetail --- Added @PackageCategoryId

SP --- SelectBookingContractDetails --- Select PackageCategoryName,PackageCategoryNameAr

SP --- SelectBookingContractMiniDetails --- Select PackageCategoryName,PackageCategoryNameAr

SP -- GetInvPackageBookingDetails --- Select PackageCategoryName,PackageCategoryNameAr

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/InventoryJsonController.cs
Module/Admin/AdminWeb/Areas/AdminWeb/Models/InventoryPackageBookingDetailsModel.cs
Module/Admin/AdminWeb/Areas/AdminWeb/Models/InventoryPackageCategoryModel.cs
Module/Admin/AdminWeb/Areas/AdminWeb/Models/InventoryPackagesModel.cs
Module/Admin/AdminWeb/Areas/AdminWeb/Views/Inventory/InventoryPackageBasicPartial.cshtml
Module/Admin/AdminWeb/Areas/AdminWeb/Views/Reports/InventoryPackageBookingDetailsPartial.cshtml
Module/Admin/AdminWeb/Cax.Admin.Web.csproj
Module/Admin/AdminWeb/Content/js/InventoryPackageManagement.js
Module/Admin/DataAccess/Cax.Admin.DA/TransactionReports.cs
Module/Inventory/DataAccess/Cax.Inventory.DA/Booking/FixedPackageTransactionDA.cs
Module/Inventory/DataAccess/Cax.Inventory.DA/Cax.Inventory.DA.csproj
Module/Inventory/DataAccess/Cax.Inventory.DA/InventoryPackageCategoryDA.cs
Module/Inventory/DataAccess/Cax.Inventory.DA/InventoryPackageManagementDA.cs
Module/Inventory/DTO/Cax.Inventory.DTO/Cax.Inventory.DTO.csproj
Module/Inventory/DTO/Cax.Inventory.DTO/FixedPackageBookingDTO.cs
Module/Inventory/DTO/Cax.Inventory.DTO/InventoryPackageBookingDetailsDTO.cs
Module/Inventory/DTO/Cax.Inventory.DTO/InventoryPackageCategoryDTO.cs
Module/Inventory/DTO/Cax.Inventory.DTO/InventoryPackagesDTO.cs
Module/Inventory/Service/Cax.FixedPackage.Model/InventoryPackageModel.cs
Module/Inventory/Service/Cax.FixedPackage.Model/InventoryTicketResponseModel.cs
Module/Inventory/Service/Cax.Inventory.Service/Booking/FixedPackageTransactionService.cs
Module/Inventory/Service/Cax.Inventory.Service/Cax.Inventory.Service.csproj
Module/Inventory/Service/Cax.Inventory.Service/InventoryPackageCategoryManagementService.cs
Module/Inventory/Service/Cax.Inventory.Service/InventoryPackageManagementService.cs
Wrapper/FixedPackage/Cax.Wrapper.FixedPackage.Models/Detail/FixedPackageDetailResponeModel.cs
Wrapper/FixedPackage/Cax.Wrapper.FixedPackage.Models/Search/FixedPackageResultModel.cs
Wrapper/FixedPackage/Cax.Wrapper.FixedPackage.Models/Ticket/TicketResponseModel.cs
Wrapper/FixedPackage/Cax.Wrapper.FixedPackage.Service/Detail/Assembler/DetailsResponseAssembler.cs
Wrapper/FixedPackage/Cax.Wrapper.FixedPackage.Service/Search/Assembler/ResultResponseAssembler.cs

Description

Tagging System: Introduce package tags such as Economy, Standard, Premium, and Luxury for easy categorization. Need a master for this or need to hardcode these tags.
Create a master table and get data. Multi selection items in package creation, provide items in result, details and ticket, make sure it is showing in TQR also

Files

Download all files
PackageCategoryTQR.jpg (275 KB) PackageCategoryTQR.jpg Jesmy P Jose, 05/02/2025 04:20 PM
PackageCategoryList.jpg (207 KB) PackageCategoryList.jpg Jesmy P Jose, 05/02/2025 04:20 PM
PackageCategoryResultResponse.txt (5.87 KB) PackageCategoryResultResponse.txt Jesmy P Jose, 05/02/2025 04:27 PM
PackageCategoryDetailResponse.txt (45.6 KB) PackageCategoryDetailResponse.txt Jesmy P Jose, 05/02/2025 04:27 PM
TicketResponsePackgeCategory.txt (42.8 KB) TicketResponsePackgeCategory.txt Jesmy P Jose, 05/02/2025 04:27 PM
Actions
Copy link

Also available in: Atom PDF