public static AdminTotals getAdminTotalsv2(int ShowID, int EnteredBy)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.Reporting r = new Data.Reporting(moduleSettings);
            DataSet ds = r.getTransactionDetails(ShowID, EnteredBy, 0);
            AdminTotals adminTotals = new AdminTotals();
            adminTotals.Entries = ds.Tables[0].Rows.Count;
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                int userid = Convert.ToInt32(row["UserID"]);
                DataSet ds2 = r.getClassesCountForDog(ShowID, userid);
                if (ds2.Tables[0].Rows.Count > 0)
                {
                    int cnt = Convert.ToInt32(ds2.Tables[0].Rows[0]["Count"]);
                    adminTotals.Runs += cnt;
                }
            }

            return adminTotals;
        }
        public static AdminTotals getAdminTotals(int ShowID, int EnteredBy)
        {
            String moduleSettings = ModuleConfig.GetSettings();

            UserShows us = new UserShows();
            DataSet ds = us.getAllUsersForShow(ShowID);
            AdminTotals adminTotals = new AdminTotals();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                UserShows usdetails = new UserShows(row);
                User u = new User(usdetails.Userid);
                Transaction trans = new Transaction(usdetails.Userid, ShowID);
                if (EnteredBy == trans.EnteredBy)
                {
                    adminTotals.Entries++;
                    adminTotals.Runs += DogClasses.countDogsInClassForShow(usdetails.Userid, ShowID);
                }
            }
            return adminTotals;
        }