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;
}