private static void AddFinalClass(string connString, EntryClassesCount row, int part, int partCount, short order_By) { try { int newPart = part += 1; string newClassDescription = string.Format("{0} Part {1}", row.Class_Name_Description, newPart); 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 = newClassDescription; finalClassName.Entries = (short)partCount; finalClassName.OrderBy = order_By; finalClassName.InsertFinalClassNames(); } catch (Exception ex) { throw ex; } }
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 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); }