public bool ModifyFund(int gameId, int roomId, long value1) { try { string gameName = string.Empty; string query = string.Empty; switch (gameId) { case 1: gameName = "Nông trại"; query += "declare @_fund bigint\n"; query += $"update [eBankGame.SlotDiamondDB].[dbo].[RoomFunds] set @_fund = PrizeFund -= {value1} where RoomID = {roomId}"; break; case 2: gameName = "Mafia"; query += "declare @_fund bigint\n"; query += $"update [eBankGame.SlotIslandsDB].[dbo].[RoomFunds] set @_fund = PrizeFund -= {value1} where RoomID = {roomId}"; break; case 3: gameName = "Hải vương"; query += "declare @_fund int\n"; query += $"update [Slot.25Lines].[dbo].[RoomFund] set @_fund = PrizeFund -= {value1} where RoomID = {roomId}"; break; case 4: gameName = "Vua bão"; query += "declare @_fund bigint\n"; query += $"update [eBankGame.SlotsGodDB].[dbo].[RoomFunds] set @_fund = PrizeFund -= {value1} where RoomID = {roomId}"; break; case 6: gameName = "Minipoker"; query += "declare @_fund bigint\n"; query += $"update [CardGame.MiniPokerDB].[dbo].[Funds] set @_fund = PrizeFund -= {value1} where RoomID = {roomId} and BetType = 1"; break; case 7: gameName = "Cao thấp"; query += "declare @_fund bigint\n"; query += $"update [MiniGame.Hilo].[dbo].[Funds] set @_fund = PrizeFund -= {value1} where RoomID = {roomId} and BetType = 1"; break; //case 8: // gameName = "Bầu cua"; // query += "declare @_fund bigint\n"; // query += $"update [HooHeyHow].[dbo].[GoldFund] set @_fund = Fund -= {value1}"; // break; //case 9: // gameName = "Xóc xóc"; // query += "declare @_fund bigint\n"; // query += $"update [CardGame].[dbo].[DiskShaking.GoldFund] set @_fund = Fund -= {value1}"; // break; } query += "\nselect @_fund response"; var newFund = Convert.ToInt64(GameDAO.ExecuteQueryWithResultRootDb(query).FirstOrDefault().response); GameDAO.AddEditFundLog(UserContext.UserInfo.FullName, gameName, value1, newFund, roomId); GameDAO.UpdateMinusGameFund(value1, 2); return(true); } catch (Exception ex) { NLogManager.PublishException(ex); } return(false); }