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); }