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