Client Comments - Improvements #20996
Updated by Jesmy P Jose 7 months ago
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