public async Task MenuOrder(Menus entity, SqlConnection con, IDbTransaction transaction) { var menus = await _dapperManager.QueryAsyncTrans <Menus>("SELECT * FROM Menus WHERE ParentMenuId=@ParentMenuId", new { entity.ParentMenuId }, transaction, con); if (menus.Select(a => a.MenuOrder).Contains(entity.MenuOrder)) { foreach (var m in menus.Where(a => a.MenuOrder >= entity.MenuOrder && a.MenuId != entity.MenuId).OrderBy(a => a.MenuOrder)) { m.MenuOrder = m.MenuOrder + 1; _menusRepo.Update(m, transaction, con); } } }