private void btnCommitSplitClasses_Click(object sender, EventArgs e)
{
FinalClassNames finalClassNames = new FinalClassNames(_connString);
List <FinalClassNames> finalClassNameList = finalClassNames.GetFinalClassNames();
if (finalClassNameList != null && finalClassNameList.Count > 0)
{
ClearFinalClassNames(finalClassNameList);
foreach (FinalClassNames finalClassName in finalClassNameList)
{
Guid? show_Final_Class_ID = null;
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, finalClassName.Show_Entry_Class_ID);
ShowFinalClasses showFinalClass = new ShowFinalClasses(_connString);
showFinalClass.Show_ID = showEntryClass.Show_ID;
showFinalClass.Show_Entry_Class_ID = showEntryClass.Show_Entry_Class_ID;
showFinalClass.Show_Final_Class_Description = finalClassName.Show_Final_Class_Description;
showFinalClass.Show_Final_Class_No = finalClassName.OrderBy;
show_Final_Class_ID = showFinalClass.Insert_Show_Final_Class(_user_ID);
if (show_Final_Class_ID == null)
{
MessageLabel.Text = "Show Final Class Insert Failed!";
break;
}
else
{
MessageLabel.Text = "Show Final Class Insert Successful.";
}
}
}
}
private void cboClassParts_SelectedIndexChanged(object sender, EventArgs e)
{
//No of part requests is greater than the number in the part
int classPart = 0;
int requiredCount = 0;
int actualCount = 0;
ShowFinalClasses showFinalClasses = new ShowFinalClasses(_connString, new Guid((cboClassParts.SelectedItem as ComboBoxItem).Value.ToString()));
FinalClassNames finalClassNames = new FinalClassNames(_connString, showFinalClasses.Show_Final_Class_No);
requiredCount = (int)finalClassNames.Entries;
DogClasses dogClasses = new DogClasses(_connString);
List <DogClasses> dogClassList = dogClasses.GetDog_ClassesByShow_Entry_Class_ID((Guid)showFinalClasses.Show_Entry_Class_ID);
int.TryParse(showFinalClasses.Show_Final_Class_Description.Substring(showFinalClasses.Show_Final_Class_Description.Length - 1), out classPart);
if (classPart > 0)
{
foreach (DogClasses dogClass in dogClassList)
{
if (dogClass.Preferred_Part == classPart)
{
actualCount++;
}
}
}
lblRequiredCount.Text = requiredCount.ToString();
lblActualCount.Text = actualCount.ToString();
if (actualCount > requiredCount)
{
lblActualCount.ForeColor = Color.Red;
lblRequiredCount.ForeColor = Color.Red;
}
else
{
lblActualCount.ForeColor = Color.Lime;
lblRequiredCount.ForeColor = Color.Lime;
}
}
