public static List<MultiDog> GetPairTeamsFromClass(int UserId, int DogId, int ClassId) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); var ds = md.GetPairTeamsFromClass(UserId, DogId, ClassId); var tmp = new List<MultiDog>(); if (ds.Tables[0].Rows.Count == 0) { // // this might be alt handler on another account ds = md.GetPairTeamsFromAltUserClass(UserId, DogId, ClassId); } foreach (DataRow rdr in ds.Tables[0].Rows) { tmp.Add(new MultiDog(rdr)); } return tmp; }
public static List<TeamPairs> GetPairTeamsByClass(int ClassId) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); var ds = md.GetPairTeamsFromClass(ClassId); var tmp = new List<TeamPairs>(); foreach (DataRow rdr in ds.Tables[0].Rows) { tmp.Add(new TeamPairs { Captain = Convert.ToString(rdr["Captain"]).Replace("''", "'").Replace("'", "'"), TeamName = Convert.ToString(rdr["TeamName"]).Replace("''", "'").Replace("'", "'"), Idx = (rdr["Idx"] == DBNull.Value ? 1 : Convert.ToInt32(rdr["Idx"])), Id = Convert.ToInt32(rdr["Id"]), ClassId = Convert.ToInt32(rdr["ClassId"]), RO = Convert.ToInt32(rdr["RO"]), UserId = Convert.ToInt32(rdr["UserId"]) }); } return tmp; }