public DataSet getClassesForJudge() { String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); return j.getClassesForJudge(_id); }
public static Boolean isJudgeAtShow(int UserID, int ShowID) { String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); DataSet ds = j.SearchFor(UserID, ShowID); return (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0); }
public static void UpdateJudge(int JudgeID, int ShowDetailsID) { String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); j.UpdateJudgeToShowDay(JudgeID, ShowDetailsID); }
public static List<Judge> GetJudgesListForShowDay(int ShowDetailsID) { String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); DataSet ds = j.GetJudgesForShowDay(ShowDetailsID); List<Judge> judgeList = new List<Judge>(); foreach (DataRow row in ds.Tables[0].Rows) { judgeList.Add(new Judge(row)); } return judgeList; }
public static List<Judge> getJudgesForRingList(int RingID) { String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); DataSet ds = j.getJudgeForRing(RingID); List<Judge> judgeList = new List<Judge>(); foreach (DataRow row in ds.Tables[0].Rows) { judgeList.Add(new Judge(row)); } return judgeList; }
public static String getJudgeForClass(int ClassID) { var tmp = ""; String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); DataSet ds = j.getJudgeForClass(ClassID); if (ds.Tables[0].Rows.Count > 0) { int JudgeID = Convert.ToInt32(ds.Tables[0].Rows[0]["JudgeID"]); Judge judge = new Judge(JudgeID); if (judge.ID > -1) { tmp = judge.Name; } } return tmp; }
public static String GetAllJudgesForShow(int ShowID) { String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); DataSet ds = j.GetAllJudgesForShow(ShowID); List<Judge> judgeList = new List<Judge>(); foreach (DataRow row in ds.Tables[0].Rows) { judgeList.Add(new Judge(row)); } return fastJSON.JSON.Instance.ToJSON(judgeList); }
// add a news public static int Add(int ShowID, int ShowDetailsID, int UserID, String Notes, int Status, int Allocated) { String moduleSettings = ModuleConfig.GetSettings(); Data.Judge j = new Fpp.WebModules.Data.Judge(moduleSettings); int id = j.Add(UserID, Notes, Status, Allocated); j.AddJudgeToShow(ShowID, ShowDetailsID, id); return id; }