public static void UpdateAltHandler(int HandlerID, int AltHandlerID)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);

            dc.UpdateAltHandler(HandlerID, AltHandlerID);
        }
 public static int Insert(int dogid, int showid, int classid, int RO)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);
     return dc.Insert(dogid, showid, classid, RO);
 }
        public static List<DogClasses> Retrieve(int DogID, int ShowID)
        {
            List<DogClasses> dclist = new List<DogClasses>();
            String moduleSettings = ModuleConfig.GetSettings();
            Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);

            DataSet ds = dc.getDogsClasses(DogID, ShowID);
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                dclist.Add(new DogClasses(row));
            }

            return dclist;
        }
        public static List<int> getROforClass(int clsid)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);

            DataSet ds = dc.getROforClass(clsid);
            List<int> ros = new List<int>();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                ros.Add(Convert.ToInt32(row["RO"]));
            }
            return ros;
        }
        public static DataSet getMasterList(int ShowID, String orderBy)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);

            return dc.getMasterList(ShowID, orderBy);
        }
        public static void deleteUserDogs(int UserID, int ShowID)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);

            dc.Delete(UserID, ShowID);
        }
 public static void DeleteDog(int ShowID, int DogID)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);
     dc.DeleteDog(DogID, ShowID);
 }
        public static int countDogsInClassForShow(int HandlerID, int ShowID)
        {
            String moduleSettings = ModuleConfig.GetSettings();
            Data.DogClasses dc = new Fpp.WebModules.Data.DogClasses(moduleSettings);

            int count = 0;
            DataSet ds = dc.countDogsInClassForShow(HandlerID, ShowID);
            if (ds.Tables[0].Rows.Count > 0)
            {
                count = Convert.ToInt32(ds.Tables[0].Rows[0]["DogInClass"]);
            }
            return count;
        }