public static bool CheckBalance(string id) { string sql = @"select Balance from dbo.GameUsers where UserId = '" + id + "';"; GameUserModel user = SqlDataAccess.LoadSingleData <GameUserModel>(sql); if (user.Balance >= 10) { return(true); } else { return(false); } }
public static PersonM LoadPerson(string Id) { string sql = @"SELECT * FROM dbo.Person WHERE PersonID = @Id"; return(SqlDataAccess.LoadSingleData <PersonM>(sql, Id)); }
public static GameModel LoadGame(string id) { string sql = @"select * from dbo.Games where Id ='" + id + "';"; return(SqlDataAccess.LoadSingleData <GameModel>(sql)); }