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