Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Nick Bloodworth 13 posts 83 karma points
    1 week ago
    Nick Bloodworth
    0

    Newbie question about custom data

    Hi all, I know this must have been asked before, but I can't find the answer.

    I have been tasked with creating a league table site, and can either use ASP. Core 2 or something else (and I've played with Umbraco a bit in the past).

    My question is a follows: We have multiple league tables, each with a number of teams, each having a list of players. What we would like is to have these models (or custom properties), and have the relationships maintained. So if we click on the league, it displays a list of teams, and when clicking on each team lists a list of players. We would also stats for creating the table (matches won etc), and how many points each player has. Can we also have a team manager register on the site, and only have access to manager their team, pay their £10 subscription and enter re match results?

    Am I expecting too much from Umbraco, or is this an ideal site for Umbraco? The site owner would also like to have a blog, and have the ability to change text etc which I assume is just a property on the homepage.

    Nothing has been created yet.

    Thanks, Nick

  • Nick Bloodworth 13 posts 83 karma points
    4 days ago
    Nick Bloodworth
    0

    No takers?

  • Phil Veloso 28 posts 208 karma points
    3 days ago
    Phil Veloso
    0

    Hi Nick,

    I would say you could create such an architecture using umbraco.

    Maybe start by defining the information architecture, for example using an document type for each: league, team, player and then a custom data type for on the league node for match results. The team managers could be umbraco members assigned to access only a specific node branch.

    Hope this helps!

  • Gilles 20 posts 92 karma points
    3 days ago
    Gilles
    0

    Phil essentially gave the same answer I would give you.

    What I wanted to add is the basically, whatever you can do with an ASP.NET MVC Site, you can do in Umbraco as Umbraco is pure .NET. Umbraco is just an empty shell which you build your site around.

  • Nick Bloodworth 13 posts 83 karma points
    3 days ago
    Nick Bloodworth
    0

    How do I link a team with a league, and a player with a team?

  • Phil Veloso 28 posts 208 karma points
    3 days ago
    Phil Veloso
    0

    Depending on whether a player is on more than one team or not, I would create them as child nodes of the team document type.

  • Nick Bloodworth 13 posts 83 karma points
    3 days ago
    Nick Bloodworth
    0

    Keeping it simple, one player can only play on one team Many to many relationships are a pain........ ;-)

  • Nick Bloodworth 13 posts 83 karma points
    1 day ago
    Nick Bloodworth
    0

    So just so I understand. I'm trying to understand the relationship between a child node and it's parent. Are these the same as table relationships (ie primary and foreign keys) or am I not understanding correctly and they're completely unrelated in this way? Would I create a node for League, then under that have team, and under that have the player? Is it possible for a user to create the team and enter the players at the same time, and have them related?

    Sorry for the questions, but my head is spinning......

  • Phil Veloso 28 posts 208 karma points
    1 day ago
    Phil Veloso
    0

    Hi Nick,

    I'm not sure about the relational links in the database but yes you could create the node in such as structure.

    • League
      • Team
        • Player

    Regarding the node creation, you would have to look an a method in which you can import the data to simultaneously create multiple nodes, otherwise they would have to be done one by one.

  • Nick Bloodworth 13 posts 83 karma points
    1 day ago
    Nick Bloodworth
    0

    Does anyone know if this is how you do the database table relationships?

Please Sign in or register to post replies

Write your reply to:

Draft