private static void AddFinalClass(EntryClassesCount row, int part, int partCount, short order_By)
{
int newPart = part += 1;
string newClassDescription = string.Format("{0} Part {1}", row.Class_Name_Description, newPart);
FinalClassNames finalClassName = new FinalClassNames();
finalClassName.Show_Entry_Class_ID = row.Show_Entry_Class_ID;
finalClassName.Class_Name_Description = row.Class_Name_Description;
finalClassName.Class_No = row.Class_No;
finalClassName.Show_Final_Class_Description = newClassDescription;
finalClassName.Entries = (short)partCount;
finalClassName.OrderBy = order_By;
finalClassName.InsertFinalClassNames();
}
public static bool UpdateFinalClassName(short orderBy, string newClassName)
{
bool success = false;
FinalClassNames finalClassName = new FinalClassNames(orderBy);
finalClassName.Show_Final_Class_Description = newClassName;
success = finalClassName.UpdateFinalClassNames();
return success;
}
public static bool PopulateFinalClassNames()
{
short order_By = 0;
bool success = false;
EntryClassesCount entryClasses = new EntryClassesCount();
EntryClassList = entryClasses.GetEntryClassCount();
if (EntryClassList != null && EntryClassList.Count > 0)
{
FinalClassNames clearFinalClassNames = new FinalClassNames();
bool clearSuccess = clearFinalClassNames.ClearFinalClassNames();
if (clearSuccess)
{
foreach (EntryClassesCount row in EntryClassList)
{
if (row.Entries > Constants.MAX_CLASS_SIZE)
{
int classQty = ClassQty(row.Entries);
int partMod = row.Entries % classQty;
for (int i = 0; i < classQty; i++)
{
int partCount = row.Entries / classQty;
if (partMod > 0)
partCount += 1;
order_By += 1;
AddFinalClass(row, i, partCount, order_By);
partMod -= 1;
}
}
else
{
order_By += 1;
FinalClassNames finalClassName = new FinalClassNames();
finalClassName.Show_Entry_Class_ID = row.Show_Entry_Class_ID;
finalClassName.Class_Name_Description = row.Class_Name_Description;
finalClassName.Class_No = row.Class_No;
finalClassName.Show_Final_Class_Description = row.Class_Name_Description;
finalClassName.Entries = row.Entries;
finalClassName.OrderBy = order_By;
finalClassName.InsertFinalClassNames();
}
}
success = true;
}
else
{
success = false;
}
}
return success;
}
public static List<FinalClassNames> DisplayFinalClassNames()
{
FinalClassNames finalClassNames = new FinalClassNames();
return finalClassNames.GetFinalClassNames();
}
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 List<FinalClassNames> GetFinalClassNames()
{
List<FinalClassNames> finalClassNameList = new List<FinalClassNames>();
FinalClassNamesBL finalClassNames = new FinalClassNamesBL();
tblFinalClassNames = finalClassNames.GetFinalClassNames();
if (tblFinalClassNames != null && tblFinalClassNames.Count > 0)
{
foreach (sss.tblFinalClassNamesRow row in tblFinalClassNames)
{
FinalClassNames finalClassName = new FinalClassNames();
finalClassName.Show_Entry_Class_ID = row.Show_Entry_Class_ID;
finalClassName.Class_Name_Description = row.Class_Name_Description;
finalClassName.Class_No = row.Class_No;
finalClassName.Show_Final_Class_Description = row.Show_Final_Class_Description;
finalClassName.Entries = row.Entries;
finalClassName.OrderBy = row.OrderBy;
finalClassNameList.Add(finalClassName);
}
}
return finalClassNameList;
}
