private async Task <long> ReorderMasterAmenities(ReorderRowsByIcon input)
        {
            long affectedRows = 0;

            try
            {
                UnitOfWorkManager.Current.DisableFilter(AbpDataFilters.MayHaveTenant);
                List <SqlParameter> pc = new List <SqlParameter>
                {
                    new SqlParameter("PresentRowNewId", input.PresentRowNewId),
                    new SqlParameter("NewRowOrderValue", input.NewRowOrderValue),
                    new SqlParameter("Parentid ", input.ParentId)
                };

                var ID = await CurrentUnitOfWork.GetDbContext <CruisePMSDbContext>().Database.ExecuteSqlRawAsync("ReorderMasterAmenities @PresentRowNewId, @NewRowOrderValue,@Parentid", pc.ToArray());

                if (ID > 0 || ID < 0 || ID == 0)
                {
                }
                else
                {
                    affectedRows = 0;
                };

                await CurrentUnitOfWork.SaveChangesAsync();
            }
            catch (Exception ex)
            {
            }
            return(affectedRows);
        }
        public async Task ReOrderRowByIcon(ReorderRowsByIcon input)
        {
            string defaultCurrentLanguage = await SettingManager.GetSettingValueForUserAsync(AppSettings.DefaultCurrentLanguage, AbpSession.ToUserIdentifier());

            if (string.IsNullOrWhiteSpace(defaultCurrentLanguage))
            {
                defaultCurrentLanguage = "EN";
            }

            await ReorderMasterAmenities(input);
        }