public List <FinalClassNames> GetFinalClassNames()
{
List <FinalClassNames> retVal = new List <FinalClassNames>();
try
{
FinalClassNamesBL finalClassNames = new FinalClassNamesBL(_connString);
tblFinalClassNames = finalClassNames.GetFinalClassNames();
if (tblFinalClassNames != null && tblFinalClassNames.Rows.Count > 0)
{
foreach (DataRow row in tblFinalClassNames.Rows)
{
FinalClassNames finalClassName = new FinalClassNames(_connString);
finalClassName.Show_Entry_Class_ID = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]);
finalClassName.Class_Name_Description = Utils.DBNullToString(row["Class_Name_Description"]);
finalClassName.Class_No = Utils.DBNullToShort(row["Class_No"]);
finalClassName.Show_Final_Class_Description = Utils.DBNullToString(row["Show_Final_Class_Description"]);
finalClassName.Entries = Utils.DBNullToShort(row["Entries"]);
finalClassName.OrderBy = Utils.DBNullToShort(row["OrderBy"]);
retVal.Add(finalClassName);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public FinalClassNames(string connString, short orderBy)
{
_connString = connString;
try
{
FinalClassNamesBL finalClassNames = new FinalClassNamesBL(_connString);
tblFinalClassNames = finalClassNames.GetFinalClassNamesByOrderBy(orderBy);
DataRow row = tblFinalClassNames.Rows[0];
if (tblFinalClassNames != null && tblFinalClassNames.Rows.Count > 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"]);
_show_Final_Class_Description = Utils.DBNullToString(row["Show_Final_Class_Description"]);
_entries = Utils.DBNullToShort(row["Entries"]);
_orderBy = Utils.DBNullToShort(row["OrderBy"]);
}
}
catch (Exception ex)
{
throw ex;
}
}
public FinalClassNames(short orderBy)
{
FinalClassNamesBL finalClassNames = new FinalClassNamesBL();
tblFinalClassNames = finalClassNames.GetFinalClassNamesByOrderBy(orderBy);
if (tblFinalClassNames != null && tblFinalClassNames.Count > 0)
{
Show_Entry_Class_ID = tblFinalClassNames[0].Show_Entry_Class_ID;
Class_Name_Description = tblFinalClassNames[0].Class_Name_Description;
Class_No = tblFinalClassNames[0].Class_No;
Show_Final_Class_Description = tblFinalClassNames[0].Show_Final_Class_Description;
Entries = tblFinalClassNames[0].Entries;
OrderBy = tblFinalClassNames[0].OrderBy;
}
}
public bool ClearFinalClassNames()
{
bool retVal = false;
try
{
FinalClassNamesBL finalClassNames = new FinalClassNamesBL(_connString);
retVal = finalClassNames.ClearFinalClassNames();
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public bool UpdateFinalClassNames()
{
bool retVal = false;
try
{
FinalClassNamesBL finalClassNames = new FinalClassNamesBL(_connString);
retVal = finalClassNames.UpdateFinalClassNames(_show_Entry_Class_ID, _class_Name_Description, _class_No,
_show_Final_Class_Description, _entries, _orderBy);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public bool ClearFinalClassNames()
{
FinalClassNamesBL finalClassNames = new FinalClassNamesBL();
bool success = false;
success = finalClassNames.ClearFinalClassNames();
return success;
}
public bool UpdateFinalClassNames()
{
FinalClassNamesBL finalClassNames = new FinalClassNamesBL();
bool success = false;
success = finalClassNames.UpdateFinalClassNames(Show_Entry_Class_ID, Class_Name_Description, Class_No,
Show_Final_Class_Description, Entries, OrderBy);
return success;
}
public List<FinalClassNames> GetFinalClassNames()
{
List<FinalClassNames> finalClassNameList = new List<FinalClassNames>();
FinalClassNamesBL finalClassNames = new FinalClassNamesBL();
tblFinalClassNames = finalClassNames.GetFinalClassNames();
if (tblFinalClassNames != null && tblFinalClassNames.Count > 0)
{
foreach (sss.tblFinalClassNamesRow row in tblFinalClassNames)
{
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.Show_Final_Class_Description;
finalClassName.Entries = row.Entries;
finalClassName.OrderBy = row.OrderBy;
finalClassNameList.Add(finalClassName);
}
}
return finalClassNameList;
}
