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