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