public void FillRunningOrdersGrid(GridView gv, bool display) { if (!string.IsNullOrEmpty(Show_ID)) { Guid? show_Final_Class_ID = null; if (!string.IsNullOrEmpty(Show_Final_Class_ID) && Show_Final_Class_ID != new Guid().ToString()) { show_Final_Class_ID = new Guid(Show_Final_Class_ID); } Guid show_ID = new Guid(Show_ID); List<Guid> showList = new List<Guid>(); showList.Add(show_ID); LinkedShows ls = new LinkedShows(); List<LinkedShows> lsList = ls.GetLinked_ShowsByParent_ID(show_ID); if (lsList != null && lsList.Count > 0) { foreach (LinkedShows linkedShow in lsList) { showList.Add(linkedShow.Child_Show_ID); } } RunningOrders.SetDay1Show_ID(showList); List<OwnersDogsClassesDrawn> oDCDList = OwnersDogsClassesDrawn.GetOwnersDogsClassesDrawnListData(show_ID, show_Final_Class_ID, display); if (display) { gv.DataSource = oDCDList; gv.DataBind(); } else { OwnersDogsClassesDrawnList = oDCDList; } } }
public List <LinkedShows> GetLinked_Shows() { List <LinkedShows> retVal = new List <LinkedShows>(); try { LinkedShowsBL linkedShows = new LinkedShowsBL(_connString); lnkLinkedShows = linkedShows.GetLinked_Shows(); if (lnkLinkedShows != null && lnkLinkedShows.Rows.Count > 0) { foreach (DataRow row in lnkLinkedShows.Rows) { LinkedShows linkedShow = new LinkedShows(_connString, Utils.DBNullToGuid(row["Linked_Show_ID"])); retVal.Add(linkedShow); } } } catch (Exception ex) { throw ex; } return(retVal); }
public static void ClearRunningOrders(string show_ID, Guid user_ID) { Guid newShow_ID = new Guid(show_ID); List<Guid> showList = new List<Guid>(); showList.Add(newShow_ID); LinkedShows ls = new LinkedShows(); List<LinkedShows> lsList = ls.GetLinked_ShowsByParent_ID(newShow_ID); if (lsList != null && lsList.Count > 0) { foreach (LinkedShows linkedShow in lsList) { showList.Add(linkedShow.Child_Show_ID); } } List<OwnersDogsClassesDrawn> oDCDList = new List<OwnersDogsClassesDrawn>(); oDCDList = OwnersDogsClassesDrawn.GetOwnersDogsClassesDrawnListData(newShow_ID, null, true); if (oDCDList != null && oDCDList.Count > 0) { SetClassesAndDrawQty(newShow_ID); foreach (ClassesAndDrawQty classRow in ClassesAndDrawQtyList) { foreach (OwnersDogsClassesDrawn row in oDCDList) { if (row.Show_Final_Class_ID == classRow.Show_Final_Class_ID) { SetRunningOrderNull(row, user_ID); } } } } foreach (Guid s_ID in showList) { Shows show = new Shows(s_ID); show.Running_Orders_Allocated = false; show.Update_Show(s_ID, user_ID); } }
public static void AllocateRunningOrders(string show_ID, Guid user_ID) { Guid newShow_ID = new Guid(show_ID); List<Guid> showList = new List<Guid>(); showList.Add(newShow_ID); LinkedShows ls = new LinkedShows(); List<LinkedShows> lsList = ls.GetLinked_ShowsByParent_ID(newShow_ID); if (lsList != null && lsList.Count > 0) { foreach (LinkedShows linkedShow in lsList) { showList.Add(linkedShow.Child_Show_ID); } } SetDay1Show_ID(showList); if (OwnersDogsClassesDrawn.DeleteOwnersDogsClassesDrawnList()) { foreach (Guid s_ID in showList) { OwnersDrawn = null; DogsDrawn = null; Shows show = new Shows(s_ID); if (!(bool)show.Running_Orders_Allocated) { AllEntriesInClass = OwnersDogsClassesDrawn.GetOwnersDogsClassesDrawnListData(s_ID, null, false); AllocateRunningOrdersStage1(s_ID, user_ID); AllocateRunningOrdersStage2(s_ID, user_ID); AllocateRunningOrdersStage3(s_ID, user_ID); show.Running_Orders_Allocated = true; show.Update_Show(s_ID, user_ID); } } } }
protected void btnSaveLinkedShows_Click(object sender, EventArgs e) { MembershipUser userInfo = Membership.GetUser(); Guid user_ID = (Guid)userInfo.ProviderUserKey; Guid parent_Show_ID = new Guid(Parent_Show_ID); Guid child_Show_ID = new Guid(Child_Show_ID); Guid? linked_Show_ID; LinkedShows linkedShow = new LinkedShows(); linkedShow.Parent_Show_ID = parent_Show_ID; linkedShow.Child_Show_ID = child_Show_ID; linked_Show_ID = linkedShow.Insert_Linked_Shows(user_ID); if (linked_Show_ID != null) { Linked_Show_ID = linked_Show_ID.ToString(); Common.Linked_Show_ID = Linked_Show_ID; divSaveLinkedShows.Visible = false; MessageLabel.Text = "Shows linked successfully."; } else MessageLabel.Text = "Show linking failed!"; }
private void PopulateParentShowGridView() { List<LinkedShows> lnkLinkedShows; LinkedShows linkedShows = new LinkedShows(); 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(); 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((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((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 PopulateLinkedShowGridView() { Guid club_ID = new Guid(Club_ID); int show_Year_ID = Int32.Parse(Show_Year_ID); LinkedShows linkedShows = new LinkedShows(); List<LinkedShows> lnkLinkedShows; lnkLinkedShows = linkedShows.GetLinked_Shows(); List<LinkedShows> linkedShowList = new List<LinkedShows>(); foreach (LinkedShows linkedShowRow in lnkLinkedShows) { Shows parentShow = new Shows(linkedShowRow.Parent_Show_ID); Shows childShow = new Shows(linkedShowRow.Child_Show_ID); if (parentShow.Club_ID == club_ID && parentShow.Show_Year_ID == show_Year_ID) { LinkedShows newLinkedShow = new LinkedShows(linkedShowRow.Linked_Show_ID); newLinkedShow.Parent_Show_Name = parentShow.Show_Name; newLinkedShow.Parent_Show_Opens = parentShow.Show_Opens; newLinkedShow.Child_Show_Name = childShow.Show_Name; newLinkedShow.Child_Show_Opens = childShow.Show_Opens; linkedShowList.Add(newLinkedShow); } } if (linkedShowList != null && linkedShowList.Count > 0) { LinkedShowsGridView.DataSource = linkedShowList; LinkedShowsGridView.DataBind(); divClubLinkedShows.Visible = true; } else { divClubLinkedShows.Visible = false; } }
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(); tblShows = show.GetShowsByClub_ID_And_Show_Year_ID(club_ID, show_Year_ID); List<LinkedShows> lnkLinkedShows; LinkedShows linkedShows = new LinkedShows(); 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((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((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."; } }
public List<LinkedShows> GetLinked_Shows() { List<LinkedShows> linkedShowList = new List<LinkedShows>(); LinkedShowsBL linkedShows = new LinkedShowsBL(); lnkLinkedShows = linkedShows.GetLinked_Shows(); if (lnkLinkedShows != null && lnkLinkedShows.Count > 0) { foreach (sss.lnkLinked_ShowsRow row in lnkLinkedShows) { LinkedShows linkedShow = new LinkedShows(row.Linked_Show_ID); linkedShowList.Add(linkedShow); } } return linkedShowList; }