public DogClasses()
: base()
{
_dogclasses = new Fpp.WebModules.Data.DogClasses(_moduleSettings);
_classlist = new List<int>();
_altHandlerlist = new List<int>();
}
public DogClasses(int DogID, int ShowID)
: base()
{
_dogclasses = new Fpp.WebModules.Data.DogClasses(_moduleSettings);
_dogid = DogID;
_classlist = new List<int>();
_altHandlerlist = new List<int>();
DataSet ds = _dogclasses.getDogsClasses(_dogid, ShowID);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
LoadFromRow(ds.Tables[0].Rows[0]);
}
public DogClasses(int DogID)
: base()
{
_dogclasses = new Fpp.WebModules.Data.DogClasses(_moduleSettings);
_dogid = DogID;
_classlist = new List<int>();
_altHandlerlist = new List<int>();
// DataSet ds = _dogclasses.GetDog(_id);
// if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 )
// LoadFromRow(ds.Tables[0].Rows[0]);
}
public static int MultiDogRemove(int showid, int classid)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
return dc.MultiDogRemove(showid, classid);
}
public static int MultiDogInsert(int dogid, int showid, int classid, int RO, int MultiDogId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
return dc.MultiDogInsert(dogid, showid, classid, RO, MultiDogId);
}
public static void Merge(int ShowDetailsId, int ClassNo)
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
var parts = ShowClasses.GetParts(ShowDetailsId, ClassNo);
var originalClass = parts.ElementAt(0);
parts.Remove(originalClass);
originalClass.Part = 0;
originalClass.Update();
var j = Judge.getJudgeForClass(originalClass.ID);
foreach (var clspart in parts)
{
List<DogClasses> dclist = new List<DogClasses>();
DataSet ds = dc.getDogsInClass(clspart.ID);
foreach (DataRow row in ds.Tables[0].Rows)
{
dclist.Add(new DogClasses(row));
}
dclist = dclist.OrderBy(t => t.RO).ToList();
ShowClasses.deleteJudgeClasses(clspart.ID, j.ID);
foreach (DogClasses dog in dclist)
{
dc.UpdateClassId(dog.ID, originalClass.ID);
}
clspart.Delete(clspart.ID);
}
}
public static void DeleteDog(int ShowID, int DogID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
dc.DeleteDog(DogID, ShowID);
}
public static List<UserDogsClasses>GetUserDogsInShow(int showID, int userid)
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.getUserDogsInShow(showID, userid);
var ret = new List<UserDogsClasses>();
foreach (DataRow row in ds.Tables[0].Rows)
{
ret.Add(new UserDogsClasses {
DogId = Convert.ToInt32(row["DogId"]),
Lho = Convert.ToInt32(row["Lho"])
});
}
return ret;
}
public static void UpdateStatus(int dogId, int classId, int status)
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
dc.updateStatus(dogId, classId, status);
}
public static void UpdateAltHandler(int HandlerID, int AltHandlerID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
dc.UpdateAltHandler(HandlerID, AltHandlerID);
}
public static DataSet getMasterList(int ShowID, String orderBy)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
return dc.getMasterList(ShowID, orderBy);
}
public static List<DogClassCount> GetEntryCountsByClassId(int ShowId, int ClassId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.getEntryCountsByClassNo(ShowId, ClassId);
List<DogClassCount> dcCounts = new List<DogClassCount>();
foreach (DataRow row in ds.Tables[0].Rows)
{
dcCounts.Add(new DogClassCount
{
ClassId = Convert.ToInt32(row["ClassId"]),
Count = Convert.ToInt32(row["Count"]),
Part = Convert.ToInt32(row["Part"]),
Lho = Convert.ToInt32(row["Lho"])
});
}
var cls = new ShowClasses(ClassId);
if (cls.Lho > 0 && dcCounts.Count == 1 )
{
if (cls.Lho == 1 )
{
dcCounts.Add(new DogClassCount
{
ClassId = ClassId,
Count = 0,
Part = 0,
Lho = 1
});
}
else if (cls.Lho == 2)
{
dcCounts.Insert(0, new DogClassCount
{
ClassId = ClassId,
Count = 0,
Part = 0,
Lho = 1
});
}
}
return dcCounts;
}
public static int GetDogsInRing(int RingId)
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.GetDogsInRing(RingId);
return Convert.ToInt32(ds.Tables[0].Rows[0]["ClsCount"]);
}
public static List<DogClassModel> GetDogsInClass(int ClassId)
{
var show = ShowClasses.GetShowFromClassId(ClassId);
var cls = new ShowClasses(ClassId);
var list = new List<DogClassModel>();
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds;
if (isMultiDog(cls.EntryType))
{
ds = dc.GetDogForClass(ClassId);
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new DogClassModel
{
DogClassesId = Convert.ToInt32(row["DogClassesId"]),
UserId = Convert.ToInt32(row["UserId"]),
UserName = row["Name"].ToString(),
KCName = row["KCName"].ToString(),
DogId = Convert.ToInt32(row["DogId"]),
Grade = Convert.ToInt32(row["Grade"]),
RO = Convert.ToInt32(row["RO"]),
Lho = Convert.ToInt32(row["Lho"]),
Height = ShowClasses.expandHeight(row),
HandlerAgeAtShow = GetAgeFromShow(row, show)
});
}
}
else
{
ds = dc.GetDogForClass(ClassId);
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new DogClassModel
{
DogClassesId = Convert.ToInt32(row["DogClassesId"]),
UserId = Convert.ToInt32(row["UserId"]),
UserName = row["Name"].ToString(),
KCName = row["KCName"].ToString(),
DogId = Convert.ToInt32(row["DogId"]),
Grade = Convert.ToInt32(row["Grade"]),
RO = Convert.ToInt32(row["RO"]),
Lho = Convert.ToInt32(row["Lho"]),
Height = ShowClasses.expandHeight(row),
HandlerAgeAtShow = GetAgeFromShow(row, show)
});
}
}
return list;
}
public static List<EntryInfoDto> ExportShowEntry(int ShowId)
{
var res = new List<EntryInfoDto>();
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.ExportShowEntry(ShowId);
foreach (DataRow row in ds.Tables[0].Rows)
{
var tmp = new EntryInfoDto
{
ClassNo = Convert.ToInt32(row["ClsNo"]),
Part = Convert.ToInt32(row["Part"]),
RingNumber = Convert.ToInt32(row["RingNumber"]),
KCName = Convert.ToString(row["KCName"]),
KCNumber = Convert.ToString(row["KCNumber"]),
Grade = Convert.ToInt32(row["Grade"]),
Height = Convert.ToInt32(row["Height"]),
RO = Convert.ToInt32(row["RO"]),
Handler = Convert.ToString(row["Handler"]),
DogHandlerName = Convert.ToString(row["DogHandlerName"]),
ClsHandlerName = Convert.ToString(row["ClsHandlerName"]),
Breed = Convert.ToString(row["Breed"]),
Sex = Convert.ToString(row["Sex"]),
DoB = Convert.ToString(row["DoB"]),
EMail = Convert.ToString(row["Email"]),
YkcNumber = Convert.ToString(row["YkcNumber"]),
DogLho = Convert.ToInt32(row["DogLho"]),
ClassLho = Convert.ToInt32(row["ClassLho"]),
HandlerType = Convert.ToInt32(row["HandlerType"]),
AwardByHeight = Convert.ToInt32(row["AwardByHeight"]),
PetName = Convert.ToString(row["PetName"])
};
if (row["JnrDob"] != DBNull.Value)
{
tmp.JnrDoB = Convert.ToDateTime(row["JnrDoB"]);
}
res.Add(tmp);
}
return res;
}
public static int DogsInShow(int ShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.DogsInShow(ShowId);
if (ds.Tables[0].Rows.Count > 0)
{
return Convert.ToInt32(ds.Tables[0].Rows[0]["DogsInShow"]);
}
return 0;
}
public static void deleteUserDogs(int UserID, int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
dc.Delete(UserID, ShowID);
}
public static List<DogClasses> Retrieve(int DogID, int ShowID)
{
List<DogClasses> dclist = new List<DogClasses>();
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new 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 void Split(int ClassId, int By)
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
List<DogClasses> dclist = new List<DogClasses>();
DataSet ds = dc.getDogsInClass(ClassId);
foreach (DataRow row in ds.Tables[0].Rows)
{
dclist.Add(new DogClasses(row));
}
dclist = dclist.OrderBy(t => t.RO).ToList();
int split = (int)Math.Truncate( (double)dclist.Count() / By);
var remainder = dclist.Count() - (split * By );
int splitLength = (int)split;
ShowClasses showClass = new ShowClasses(ClassId);
showClass.Part = 1;
showClass.Update();
var spt = splitLength;
var j = Judge.getJudgeForClass(ClassId);
var splitCnt = 2;
for (var i = 1; i< By; i++)
{
if (i + 1 == By) { splitLength += remainder; }
var copyid = showClass.copy(true);
var splitClass = new ShowClasses(copyid);
splitClass.ClassNo = showClass.ClassNo;
splitClass.Position = showClass.Position;
splitClass.RingID = showClass.RingID;
splitClass.Part = splitCnt;
splitClass.Update();
ShowClasses.updateJudgeClasses(copyid, j.ID);
for (int dogCnt = 0; dogCnt < splitLength; dogCnt++)
{
var dogclass = dclist.ElementAt( dogCnt + (int)spt);
dc.UpdateClassId(dogclass.ID, copyid);
}
spt += splitLength;
splitCnt++;
}
}
public static DataSet getMasterListForMember(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
return dc.GetMasterListForMembers(ShowID);
}
public static void UpdateRo(List<DogClassModel> updatedRo)
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
foreach (var item in updatedRo){
dc.updateROs(item.DogClassesId, item.RO);
}
}
public static List<TeamPairsTrioDto> GetMultiDogClasses(int ShowId)
{
var res = new List<TeamPairsTrioDto>();
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.GetMultiDogClasses(ShowId);
foreach (DataRow row in ds.Tables[0].Rows)
{
res.Add(new TeamPairsTrioDto
{
ClassId = Convert.ToInt32(row["ClassId"]),
ClassNo = Convert.ToInt32(row["ClsNo"]),
DogId = Convert.ToInt32(row["DogId"]),
DogName = Convert.ToString(row["KCName"]),
RO = Convert.ToInt32(row["RO"]),
HandlerId = Convert.ToInt32(row["HandlerId"]),
HandlerName = Convert.ToString(row["HandlerName"]),
Height = Convert.ToInt32(row["Height"])
});
}
return res;
}
internal static void DeleteDogsFromChampCls(int ShowId)
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
dc.DeleteDogsFromChampCls(ShowId);
}
public static void CopyDogs(int FromClsId, int ToClsId, int Max = 1000, bool FakeData = false )
{
string moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
dc.CopyDogs(FromClsId, ToClsId, Max, FakeData);
}
public static List<int> getROforClass(int clsid)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new 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 int countDogsInClassForShow(int HandlerID, int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new 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;
}
public static List<RunsPerDay> GetRunsPerDay(int ShowId)
{
var list = new List<RunsPerDay>();
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.RunsPerDay(ShowId);
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new RunsPerDay
{
ShowDate = Convert.ToDateTime(row["ShowDate"]),
Count = Convert.ToInt32(row["Count"])
});
}
return list;
}
public static List<EntryCost> calcCostOfEntry(int ShowId, int UserId)
{
List<EntryCost> tmp = new List<EntryCost>();
String moduleSettings = ModuleConfig.GetSettings();
Data.DogClasses dc = new Data.DogClasses(moduleSettings);
DataSet ds = dc.calcCostOfEntry(ShowId, UserId);
foreach (DataRow row in ds.Tables[0].Rows)
{
tmp.Add(new EntryCost(row));
}
return tmp;
}
