private void PopulateClassGridview(string show_ID)
{
bool valid = false;
if (!string.IsNullOrEmpty(show_ID))
{
valid = true;
if (valid)
{
if (!string.IsNullOrEmpty(show_ID))
{
Guid newShow_ID = new Guid(show_ID);
ShowEntryClasses showEntryClasses = new ShowEntryClasses();
List<ShowEntryClasses> tblShowEntryClasses;
tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(newShow_ID);
ClassGridView.DataSource = tblShowEntryClasses;
ClassGridView.DataBind();
}
}
divClassList.Visible = valid;
}
}
private void PopulateClassList(string Show_ID)
{
if (!string.IsNullOrEmpty(Show_ID))
{
Guid show_ID = new Guid(Show_ID);
ShowEntryClasses showEntryClasses = new ShowEntryClasses();
List<ShowEntryClasses> tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
List<ShowEntryClasses> classList = new List<ShowEntryClasses>();
ShowEntryClasses allClasses = new ShowEntryClasses();
allClasses.Class_Name_Description = "All Classes";
allClasses.Show_Entry_Class_ID = new Guid();
classList.Add(allClasses);
foreach (ShowEntryClasses row in tblShowEntryClasses)
{
classList.Add(row);
}
lstClasses.DataSource = classList;
lstClasses.DataBind();
}
}
private void PopulateListBoxes()
{
List<DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses();
Guid entrant_ID = new Guid(Entrant_ID);
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
List<Dogs> dogs = new List<Dogs>();
foreach (DogClasses row in tblDogClasses)
{
Dogs dog = new Dogs((Guid)row.Dog_ID);
Dogs dg = dogs.Find(delegate(Dogs d) { return d.Dog_ID == row.Dog_ID; });
if (dg == null)
dogs.Add(dog);
}
lstDogs.DataSource = dogs;
lstDogs.DataBind();
if (!string.IsNullOrEmpty(Show_ID))
{
Guid show_ID = new Guid(Show_ID);
ShowEntryClasses showEntryClasses = new ShowEntryClasses();
List<ShowEntryClasses> tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
lstClasses.DataSource = tblShowEntryClasses;
lstClasses.DataBind();
}
}
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);
}
