Exemple #1
0
        public List <Shows> GetShowsLikeShow_Name(string show_Name)
        {
            List <Shows> retVal = new List <Shows>();

            try
            {
                ShowsBL shows = new ShowsBL(_connString);
                tblShows = shows.GetShowsLikeShow_Name(show_Name);

                if (tblShows != null && tblShows.Rows.Count > 0)
                {
                    foreach (DataRow row in tblShows.Rows)
                    {
                        Shows show = new Shows(_connString, Utils.DBNullToGuid(row["Show_ID"]));
                        retVal.Add(show);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Exemple #2
0
        public Shows(Guid show_ID)
        {
            ShowsBL shows = new ShowsBL();
            tblShows = shows.GetShowByShow_ID(show_ID);

            Show_ID = tblShows[0].Show_ID;
            Club_ID = tblShows[0].Club_ID;
            Show_Year_ID = tblShows[0].Show_Year_ID;
            if (!tblShows[0].IsShow_Type_IDNull())
                Show_Type_ID = tblShows[0].Show_Type_ID;
            if (!tblShows[0].IsVenue_IDNull())
                Venue_ID = tblShows[0].Venue_ID;
            if (!tblShows[0].IsShow_OpensNull())
                Show_Opens = tblShows[0].Show_Opens;
            if (!tblShows[0].IsJudging_CommencesNull())
                Judging_Commences = tblShows[0].Judging_Commences;
            if (!tblShows[0].IsShow_NameNull())
                Show_Name = tblShows[0].Show_Name;
            if (!tblShows[0].IsClosing_DateNull())
                Closing_Date = tblShows[0].Closing_Date;
            if (!tblShows[0].IsEntries_CompleteNull())
                Entries_Complete = tblShows[0].Entries_Complete;
            if (!tblShows[0].IsJudges_AllocatedNull())
                Judges_Allocated = tblShows[0].Judges_Allocated;
            if (!tblShows[0].IsSplit_ClassesNull())
                Split_Classes = tblShows[0].Split_Classes;
            if (!tblShows[0].IsRunning_Orders_AllocatedNull())
                Running_Orders_Allocated = tblShows[0].Running_Orders_Allocated;
            if (!tblShows[0].IsRing_Numbers_AllocatedNull())
                Ring_Numbers_Allocated = tblShows[0].Ring_Numbers_Allocated;
            if (!tblShows[0].IsLinked_ShowNull())
                Linked_Show = (tblShows[0].IsLinked_ShowNull()) ? false : tblShows[0].Linked_Show;
            if (!tblShows[0].IsMaxClassesPerDogNull())
                MaxClassesPerDog = tblShows[0].MaxClassesPerDog;
        }
Exemple #3
0
        public List <Shows> GetShowsByClub_ID_And_Show_Year_ID(Guid club_ID, int show_Year_ID)
        {
            List <Shows> retVal = new List <Shows>();

            try
            {
                ShowsBL shows = new ShowsBL(_connString);
                tblShows = shows.GetShowsByClub_ID_And_Show_Year_ID(club_ID, show_Year_ID);

                if (tblShows != null && tblShows.Rows.Count > 0)
                {
                    foreach (DataRow row in tblShows.Rows)
                    {
                        Shows show = new Shows(_connString, Utils.DBNullToGuid(row["Show_ID"]));
                        retVal.Add(show);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Exemple #4
0
        public Shows(string connString, Guid show_ID)
        {
            _connString = connString;

            try
            {
                ShowsBL shows = new ShowsBL(_connString);
                tblShows = shows.GetShowByShow_ID(show_ID);
                DataRow row = tblShows.Rows[0];

                _show_ID                  = show_ID;
                _club_ID                  = Utils.DBNullToGuid(row["Club_ID"]);
                _show_Year_ID             = Utils.DBNullToInt(row["Show_Year_ID"]);
                _show_Type_ID             = Utils.DBNullToInt(row["Show_Type_ID"]);
                _venue_ID                 = Utils.DBNullToGuid(row["Venue_ID"]);
                _show_Opens               = Utils.DBNullToDate(row["Show_Opens"]);
                _judging_Commences        = Utils.DBNullToDate(row["Judging_Commences"]);
                _show_Name                = Utils.DBNullToString(row["Show_Name"]);
                _closing_Date             = Utils.DBNullToDate(row["Closing_Date"]);
                _entries_Complete         = Utils.DBNullToBool(row["Entries_Complete"]);
                _judges_Allocated         = Utils.DBNullToBool(row["Judges_Allocated"]);
                _split_Classes            = Utils.DBNullToBool(row["Split_Classes"]);
                _running_Orders_Allocated = Utils.DBNullToBool(row["Running_Orders_Allocated"]);
                _ring_Numbers_Allocated   = Utils.DBNullToBool(row["Ring_Numbers_Allocated"]);
                _linked_Show              = Utils.DBNullToBool(row["Linked_Show"]);
                _maxClassesPerDog         = Utils.DBNullToShort(row["MaxClassesPerDog"]);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #5
0
        public Guid?Insert_Show(Guid user_ID)
        {
            Guid?retVal = null;

            try
            {
                ShowsBL shows = new ShowsBL(_connString);
                retVal = (Guid?)shows.Insert_Shows(_club_ID, _show_Year_ID, _show_Type_ID, _venue_ID, _show_Opens,
                                                   _judging_Commences, _show_Name, _closing_Date, _maxClassesPerDog, _linked_Show, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
Exemple #6
0
        public bool Update_Show(Guid show_ID, Guid user_ID)
        {
            bool success = false;

            try
            {
                ShowsBL shows = new ShowsBL(_connString);
                success = shows.Update_Shows(show_ID, _club_ID, _show_Year_ID, _show_Type_ID, _venue_ID, _show_Opens,
                                             _judging_Commences, _show_Name, _closing_Date, _entries_Complete, _judges_Allocated, _split_Classes,
                                             _running_Orders_Allocated, _ring_Numbers_Allocated, _maxClassesPerDog, _linked_Show, _deleteShow, user_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(success);
        }
Exemple #7
0
        public bool Update_Show(Guid show_ID, Guid user_ID)
        {
            bool success = false;

            ShowsBL shows = new ShowsBL();
            success = shows.Update_Shows(show_ID, Club_ID, Show_Year_ID, Show_Type_ID, Venue_ID, Show_Opens,
                Judging_Commences, Show_Name, Closing_Date, Entries_Complete, Judges_Allocated, Split_Classes,
                Running_Orders_Allocated, Ring_Numbers_Allocated, MaxClassesPerDog, Linked_Show, DeleteShow, user_ID);

            return success;
        }
Exemple #8
0
        public Guid? Insert_Show(Guid user_ID)
        {
            ShowsBL shows = new ShowsBL();
            Guid? newID = (Guid?)shows.Insert_Shows(Club_ID, Show_Year_ID, Show_Type_ID, Venue_ID, Show_Opens,
                Judging_Commences, Show_Name, Closing_Date, MaxClassesPerDog, Linked_Show, user_ID);

            return newID;
        }
Exemple #9
0
        public List<Shows> GetShowsLikeShow_Name(string show_Name)
        {
            List<Shows> showList = new List<Shows>();
            ShowsBL shows = new ShowsBL();
            tblShows = shows.GetShowsLikeShow_Name(show_Name);

            if (tblShows != null && tblShows.Count > 0)
            {
                foreach (sss.tblShowsRow row in tblShows)
                {
                    Shows show = new Shows(row.Show_ID);
                    showList.Add(show);
                }
            }

            return showList;
        }
Exemple #10
0
        public List<Shows> GetShowsByVenue_ID(Guid venue_ID)
        {
            List<Shows> showList = new List<Shows>();
            ShowsBL shows = new ShowsBL();
            tblShows = shows.GetShowsByVenue_ID(venue_ID);

            if (tblShows != null && tblShows.Count > 0)
            {
                foreach (sss.tblShowsRow row in tblShows)
                {
                    Shows show = new Shows(row.Show_ID);
                    showList.Add(show);
                }
            }

            return showList;
        }
Exemple #11
0
        public List<Shows> GetShowsByClub_ID_And_Show_Year_ID(Guid club_ID, int show_Year_ID)
        {
            List<Shows> showList = new List<Shows>();
            ShowsBL shows = new ShowsBL();
            tblShows = shows.GetShowsByClub_ID_And_Show_Year_ID(club_ID, show_Year_ID);

            if (tblShows != null && tblShows.Count > 0)
            {
                foreach (sss.tblShowsRow row in tblShows)
                {
                    Shows show = new Shows(row.Show_ID);
                    showList.Add(show);
                }
            }

            return showList;
        }