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