public MultiDog(int UserID, int DogID, int ClsID) : base() { _multiDog = new Fpp.Data.MultiDog(ModuleSettings); DataSet ds = _multiDog.getMultiDog(UserID, DogID, ClsID); if (ds.Tables[0].Rows.Count > 0) { LoadFromRow(ds.Tables[0].Rows[0]); } }
public MultiDog(DataRow row) : base() { _multiDog = new Fpp.Data.MultiDog(ModuleSettings); LoadFromRow(row); }
internal static void UpdateRO(int TeamPairId, int Ro) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); md.UpdateRo(TeamPairId, Ro); }
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<MultiDog> GetPairTeamsFromDog(int DogId, int ClassId) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); var ds = md.GetPairTeamsFromDog(DogId, ClassId); var tmp = new List<MultiDog>(); foreach (DataRow rdr in ds.Tables[0].Rows) { tmp.Add(new MultiDog(rdr)); } return tmp; }
public static List<Fpp.Core.Models.TeamPairs> GetPairTeamsForShow(int ShowId) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); var ds = md.GetPairTeamsDetailsForShow(ShowId); List<Fpp.Core.Models.TeamPairs> list = new List<Core.Models.TeamPairs>(); foreach (DataRow rdr in ds.Tables[0].Rows) { list.Add(new Core.Models.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 list; }
public MultiDog() : base() { _multiDog = new Fpp.Data.MultiDog(ModuleSettings); }
public static List<MultiDog> GetMultiDogsForShow(int id) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); List<MultiDog> list = new List<MultiDog>(); DataSet ds = md.GetPairTeamsMembersForShow(id); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { list.Add(new MultiDog(row)); } } return list; }
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; }
public static List<MultiDog> getMultiDog(int UserID, int DogID, int ClsID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); DataSet ds = md.getMultiDog(UserID, DogID, ClsID); List<MultiDog> list = new List<MultiDog>(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { list.Add(new MultiDog(row)); } } return list; }
public static void DeleteUserFromShow(int UserID, int ShowID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); md.DeleteUserFromShow(UserID, ShowID); }
// delete the record identified by the specified ID public static void Delete(int UserID, int ClsID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog ah = new Fpp.Data.MultiDog(moduleSettings); ah.Delete(UserID, ClsID); }
public static int AddTeamPairsDetails(int ShowId, int UserId, string captain, string teamName, int idx, int ClassId) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); return md.AddTeamPairsDetails(ShowId, UserId, captain, teamName, idx, ClassId); }
public static void Add(int teamPairsId, int newUserID, int userDogID, int clsId, int ShowID, String HandlerName, String DogName, int HandlerID, int DogId, int idx) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.MultiDog md = new Fpp.Data.MultiDog(moduleSettings); md.Add(newUserID, userDogID, clsId, ShowID, HandlerName, HandlerID, DogName, DogId, idx, teamPairsId); }