public List <EntryClassesCount> GetEntryClassCount()
{
List <EntryClassesCount> retVal = new List <EntryClassesCount>();
try
{
EntryClassCountBL entryClasses = new EntryClassCountBL(_connString);
tblEntryClassCount = entryClasses.GetEntryClassCount();
if (tblEntryClassCount != null && tblEntryClassCount.Rows.Count > 0)
{
foreach (DataRow row in tblEntryClassCount.Rows)
{
EntryClassesCount entryClass = new EntryClassesCount(_connString);
entryClass.Show_Entry_Class_ID = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]);
entryClass.Class_Name_Description = Utils.DBNullToString(row["Class_Name_Description"]);
entryClass.Class_No = Utils.DBNullToShort(row["Class_No"]);
entryClass.Entries = Utils.DBNullToShort(row["Entries"]);
retVal.Add(entryClass);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public EntryClassesCount(Guid show_Entry_Class_ID)
{
EntryClassCountBL entryClasses = new EntryClassCountBL();
tblEntryClassCount = entryClasses.GetEntryClassCountByShow_Entry_Class_ID(show_Entry_Class_ID);
Show_Entry_Class_ID = tblEntryClassCount[0].Show_Entry_Class_ID;
Class_Name_Description = tblEntryClassCount[0].Class_Name_Description;
Class_No = tblEntryClassCount[0].Class_No;
Entries = tblEntryClassCount[0].Entries;
}
public bool PopulateEntryClassCount(Guid show_ID)
{
bool retVal = false;
try
{
EntryClassCountBL entryClasses = new EntryClassCountBL(_connString);
retVal = entryClasses.PopulateEntryClassCount(show_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public EntryClassesCount(string connString, Guid show_Entry_Class_ID)
{
_connString = connString;
try
{
EntryClassCountBL entryClasses = new EntryClassCountBL(_connString);
tblEntryClassCount = entryClasses.GetEntryClassCountByShow_Entry_Class_ID(show_Entry_Class_ID);
DataRow row = tblEntryClassCount.Rows[0];
_show_Entry_Class_ID = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]);
_class_Name_Description = Utils.DBNullToString(row["Class_Name_Description"]);
_class_No = Utils.DBNullToShort(row["Class_No"]);
_entries = Utils.DBNullToShort(row["Entries"]);
}
catch (Exception ex)
{
throw ex;
}
}
public List<EntryClassesCount> GetEntryClassCount()
{
List<EntryClassesCount> entryClassList = new List<EntryClassesCount>();
EntryClassCountBL entryClasses = new EntryClassCountBL();
tblEntryClassCount = entryClasses.GetEntryClassCount();
if (tblEntryClassCount != null && tblEntryClassCount.Count > 0)
{
foreach (sss.tblEntryClassCountRow row in tblEntryClassCount)
{
EntryClassesCount entryClass = new EntryClassesCount();
entryClass.Show_Entry_Class_ID = row.Show_Entry_Class_ID;
entryClass.Class_Name_Description = row.Class_Name_Description;
entryClass.Class_No = row.Class_No;
entryClass.Entries = row.Entries;
entryClassList.Add(entryClass);
}
}
return entryClassList;
}
public bool PopulateEntryClassCount(Guid show_ID)
{
bool success = false;
EntryClassCountBL entryClasses = new EntryClassCountBL();
success = entryClasses.PopulateEntryClassCount(show_ID);
return success;
}