private void PopulateParentShowGridView()
{
List <LinkedShows> lnkLinkedShows;
LinkedShows linkedShows = new LinkedShows(_connString);
lnkLinkedShows = linkedShows.GetLinked_Shows();
Guid club_ID = new Guid(Club_ID);
int show_Year_ID = Int32.Parse(Show_Year_ID);
List <Shows> tblShows;
Shows show = new Shows(_connString);
tblShows = show.GetShowsByClub_ID_And_Show_Year_ID(club_ID, show_Year_ID);
List <Shows> parentShowList = new List <Shows>();
foreach (Shows showRow in tblShows)
{
if (lnkLinkedShows.Count == 0)
{
Shows newShow = new Shows(_connString, (Guid)showRow.Show_ID);
parentShowList.Add(newShow);
}
else
{
foreach (LinkedShows linkedShowRow in lnkLinkedShows)
{
if (showRow.Show_ID != linkedShowRow.Parent_Show_ID && showRow.Show_ID != linkedShowRow.Child_Show_ID)
{
Shows newShow = new Shows(_connString, (Guid)showRow.Show_ID);
parentShowList.Add(newShow);
}
}
}
}
if (parentShowList != null && parentShowList.Count > 0)
{
ParentShowGridView.DataSource = parentShowList;
ParentShowGridView.DataBind();
divParentShowList.Visible = true;
divParentShowDetails.Visible = false;
}
else
{
MessageLabel.Text = "There are no unlinked shows for this Club.";
}
}
private void PopulateChildShowGridView()
{
Guid club_ID = new Guid(Club_ID);
int show_Year_ID = Int32.Parse(Show_Year_ID);
List <Shows> tblShows;
Shows show = new Shows(_connString);
tblShows = show.GetShowsByClub_ID_And_Show_Year_ID(club_ID, show_Year_ID);
List <LinkedShows> lnkLinkedShows;
LinkedShows linkedShows = new LinkedShows(_connString);
lnkLinkedShows = linkedShows.GetLinked_Shows();
Guid parent_Show_ID = new Guid(Parent_Show_ID);
List <Shows> childShowList = new List <Shows>();
foreach (Shows row in tblShows)
{
if (lnkLinkedShows.Count == 0 && row.Show_ID != parent_Show_ID)
{
Shows childShow = new Shows(_connString, (Guid)row.Show_ID);
childShowList.Add(childShow);
}
else
{
foreach (LinkedShows linkedShowRow in lnkLinkedShows)
{
if (row.Show_ID != parent_Show_ID && row.Show_ID != linkedShowRow.Parent_Show_ID && row.Show_ID != linkedShowRow.Child_Show_ID)
{
Shows childShow = new Shows(_connString, (Guid)row.Show_ID);
childShowList.Add(childShow);
}
}
}
}
if (childShowList != null && childShowList.Count > 0)
{
ChildShowGridView.DataSource = childShowList;
ChildShowGridView.DataBind();
}
else
{
MessageLabel.Text = "There is no second, unlinked show for this Club.";
}
}
