public static bool AllocateDogsToFinalClasses(Guid show_ID, Guid user_ID) { bool success = false; List<ShowEntryClasses> showEntryClassList = new List<ShowEntryClasses>(); ShowEntryClasses showEntryClasses = new ShowEntryClasses(); showEntryClassList = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID); foreach (ShowEntryClasses showEntryClass in showEntryClassList) { List<ShowFinalClasses> showFinalClassList = new List<ShowFinalClasses>(); ShowFinalClasses showFinalClasses = new ShowFinalClasses(); showFinalClassList = showFinalClasses.GetShow_Final_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID); if (showFinalClassList != null && showFinalClassList.Count > 0) { List<DogClasses> dogClassList = new List<DogClasses>(); DogClasses dogClasses = new DogClasses(); dogClassList = dogClasses.GetDog_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID); if (showFinalClassList.Count == 1) { foreach (DogClasses dogClass in dogClassList) { dogClass.Show_Final_Class_ID = showFinalClassList[0].Show_Final_Class_ID; Guid dog_Class_ID = new Guid(dogClass.Dog_Class_ID.ToString()); success = dogClass.Update_Dog_Class(dog_Class_ID, user_ID); } } else { List<ClassParts> classParts = new List<ClassParts>(); foreach (ShowFinalClasses showFinalClass in showFinalClassList) { ClassParts classPart = new ClassParts(); FinalClassNames finalClassNames = new FinalClassNames(showFinalClass.Show_Final_Class_No); classPart.Show_Final_Class_ID = showFinalClass.Show_Final_Class_ID; classPart.Show_Final_Class_Description = showFinalClass.Show_Final_Class_Description; classPart.MaxDogsInPart = finalClassNames.Entries; classParts.Add(classPart); } List<DogsInClass> allDogsInClass = new List<DogsInClass>(); allDogsInClass = AllocateDogsToClassParts(dogClassList, classParts); List<DogClasses> failedUpdateList = new List<DogClasses>(); foreach (DogsInClass dog in allDogsInClass) { DogClasses dogClass = new DogClasses(dog.Dog_Class_ID); dogClass.Show_Final_Class_ID = dog.Show_Final_Class_ID; success = dogClass.Update_Dog_Class(dog.Dog_Class_ID, user_ID); if (!success) failedUpdateList.Add(dogClass); } } } } return success; }
public static bool AllocateDogsToFinalClasses(string connString, Guid show_ID, Guid user_ID) { bool retVal = false; try { List <ShowEntryClasses> showEntryClassList = new List <ShowEntryClasses>(); ShowEntryClasses showEntryClasses = new ShowEntryClasses(connString); showEntryClassList = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID); foreach (ShowEntryClasses showEntryClass in showEntryClassList) { List <ShowFinalClasses> showFinalClassList = new List <ShowFinalClasses>(); ShowFinalClasses showFinalClasses = new ShowFinalClasses(connString); showFinalClassList = showFinalClasses.GetShow_Final_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID); if (showFinalClassList != null && showFinalClassList.Count > 0) { List <DogClasses> dogClassList = new List <DogClasses>(); DogClasses dogClasses = new DogClasses(connString); dogClassList = dogClasses.GetDog_ClassesByShow_Entry_Class_ID(showEntryClass.Show_Entry_Class_ID); if (showFinalClassList.Count == 1) { foreach (DogClasses dogClass in dogClassList) { dogClass.Show_Final_Class_ID = showFinalClassList[0].Show_Final_Class_ID; Guid dog_Class_ID = new Guid(dogClass.Dog_Class_ID.ToString()); retVal = dogClass.Update_Dog_Class(dog_Class_ID, user_ID); } } else { List <ClassParts> classParts = new List <ClassParts>(); foreach (ShowFinalClasses showFinalClass in showFinalClassList) { ClassParts classPart = new ClassParts(); FinalClassNames finalClassNames = new FinalClassNames(connString, showFinalClass.Show_Final_Class_No); classPart.Show_Final_Class_ID = showFinalClass.Show_Final_Class_ID; classPart.Show_Final_Class_Description = showFinalClass.Show_Final_Class_Description; classPart.MaxDogsInPart = finalClassNames.Entries; classParts.Add(classPart); } List <DogsInClass> allDogsInClass = new List <DogsInClass>(); allDogsInClass = AllocateDogsToClassParts(connString, dogClassList, classParts, show_ID); List <DogClasses> failedUpdateList = new List <DogClasses>(); foreach (DogsInClass dog in allDogsInClass) { DogClasses dogClass = new DogClasses(connString, dog.Dog_Class_ID); dogClass.Show_Final_Class_ID = dog.Show_Final_Class_ID; retVal = dogClass.Update_Dog_Class(dog.Dog_Class_ID, user_ID); if (!retVal) { failedUpdateList.Add(dogClass); } } } } } } catch (Exception ex) { throw ex; } return(retVal); }