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
 #1

Updated by Sandeep Sajiv 7 months ago

  • Estimated time changed from 6:00 h to 10:00 h
Actions
Copy link
 #2

Updated by Sandeep Sajiv 7 months ago

  • Due date changed from 04/30/2025 to 05/02/2025
Actions
Copy link
 #3

Updated by Jesmy P Jose 7 months ago

  • Status changed from Assigned to In Progress
Actions
Copy link
 #4

Updated by Jesmy P Jose 7 months ago

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, -- Done
Added category list in package basic partial page and saved multiple ids to DB.
provide items in result, details and ticket, make sure it is showing in TQR also -- Done in search, result and detail.

Actions
Copy link Download all files
 #5

Updated by Jesmy P Jose 7 months ago

Assign Front End
Fixed Package --- In Result, Detail and Ticket response package category is given. It should be shown result,detail and ticket pages.
Result and Detail response --- [PackageCategoryName] -- Its a dictionary. It includes eng and arabic values.
Voucher response --- [PackageCategory] -- Its a dictionary. It includes eng and arabic values.
Attached result, detail and ticket response files.
---------------------------------------------------------------

Admin Side --- Added package Category and shows TQR -- DONE
In Admin --- Category multiple saved on the basic page where add a package. Create a category master table and inserted static data. Attached screenshot
IN TQR --- Package Category is showing. Attached screenshot
---------------------------------------------------------------
CREATE NEW TABLE QUERY
NEW TABLE [INV_PackageCategoryMaster]

CREATE TABLE [dbo].[INV_PackageCategoryMaster](
[CategoryId] [bigint] IDENTITY NOT NULL,
[CategoryName] [varchar](100) NULL,
[CategoryNameAr] [nvarchar](100) NULL,
[IsActive] [bit] NULL,
[IsDelete] [bit] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[INV_PackageCategoryMaster] ADD CONSTRAINT [DF_INV_PackageCategoryMaster_IsActive] DEFAULT ((1)) FOR [IsActive]
GO

ALTER TABLE [dbo].[INV_PackageCategoryMaster] ADD CONSTRAINT [DF_INV_PackageCategoryMaster_IsDelete] DEFAULT ((0)) FOR [IsDelete]
GO

INSERT STATIC DATA

INSERT INTO [INV_PackageCategoryMaster] (CategoryName,CategoryNameAr)
VALUES ('Economy',N'اقتصاد')

INSERT INTO [INV_PackageCategoryMaster] (CategoryName,CategoryNameAr)
VALUES ('Standard',N'معيار')

INSERT INTO [INV_PackageCategoryMaster] (CategoryName,CategoryNameAr)
VALUES ('Premium',N'غالي')

INSERT INTO [INV_PackageCategoryMaster] (CategoryName,CategoryNameAr)
VALUES ('Luxury',N'رفاهية')

Actions
Copy link
 #6

Updated by Sandeep Sajiv 6 months ago

  • Status changed from For Review to Fixed not Tested
  • Assignee changed from Sandeep Sajiv to Jesmy P Jose
Actions
Copy link
 #7

Updated by Sandeep Sajiv 6 months ago

  • Status changed from Fixed not Tested to New
  • Assignee deleted (Jesmy P Jose)
Actions
Copy link
 #8

Updated by Sandeep Sajiv 6 months ago

  • Project changed from 321 to Almaqam-Final Phase-Web
Actions
Copy link

Also available in: Atom PDF