public static bool UnAllocateDogsFromFinalClasses(string connString, Guid user_ID) { bool retVal = false; try { List <EntryClassesCount> entryClassesList = new List <EntryClassesCount>(); EntryClassesCount entryClasses = new EntryClassesCount(connString); entryClassesList = entryClasses.GetEntryClassCount(); foreach (EntryClassesCount entryClass in entryClassesList) { List <DogClasses> dogClassList = new List <DogClasses>(); DogClasses dogClasses = new DogClasses(connString); dogClassList = dogClasses.GetDog_ClassesByShow_Entry_Class_ID(entryClass.Show_Entry_Class_ID); foreach (DogClasses row in dogClassList) { row.Show_Final_Class_ID = null; Guid dog_Class_ID = new Guid(row.Dog_Class_ID.ToString()); retVal = row.Update_Dog_Class(dog_Class_ID, user_ID); } } } catch (Exception ex) { throw ex; } return(retVal); }
public static bool UnAllocateDogsFromFinalClasses(Guid user_ID) { bool success = false; List<EntryClassesCount> entryClassesList = new List<EntryClassesCount>(); EntryClassesCount entryClasses = new EntryClassesCount(); entryClassesList = entryClasses.GetEntryClassCount(); foreach (EntryClassesCount entryClass in entryClassesList) { List<DogClasses> dogClassList = new List<DogClasses>(); DogClasses dogClasses = new DogClasses(); dogClassList = dogClasses.GetDog_ClassesByShow_Entry_Class_ID(entryClass.Show_Entry_Class_ID); foreach (DogClasses row in dogClassList) { row.Show_Final_Class_ID = null; Guid dog_Class_ID = new Guid(row.Dog_Class_ID.ToString()); success = row.Update_Dog_Class(dog_Class_ID, user_ID); } } 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 bool PopulateFinalClassNames(string connString, int maxClassSize) { bool success = false; try { short order_By = 0; EntryClassesCount entryClasses = new EntryClassesCount(connString); EntryClassList = entryClasses.GetEntryClassCount(); if (EntryClassList != null && EntryClassList.Count > 0) { FinalClassNames clearFinalClassNames = new FinalClassNames(connString); bool clearSuccess = clearFinalClassNames.ClearFinalClassNames(); if (clearSuccess) { foreach (EntryClassesCount row in EntryClassList) { if (row.Entries > maxClassSize) { int classQty = ClassQty(row.Entries, maxClassSize); 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(connString, row, i, partCount, order_By); partMod -= 1; } } else { order_By += 1; FinalClassNames finalClassName = new FinalClassNames(connString); 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; } } } catch (Exception ex) { throw ex; } return(success); }
protected void PopulateEntryClassGridView() { EntryClassesCount entryClasses = new EntryClassesCount(); EntryClassList = entryClasses.GetEntryClassCount(); if (EntryClassList != null && EntryClassList.Count > 0) { Common.EntryClassList = EntryClassList; EntryClassGridView.DataSource = EntryClassList; EntryClassGridView.DataBind(); divEntryClassList.Visible = true; divGetFinalClasses.Visible = true; } else { MessageLabel.Text = "No Data for this Show."; divEntryClassList.Visible = false; divGetFinalClasses.Visible = false; divFinalClassList.Visible = false; } }