public static CustomList <Gen_LookupEnt> GetAllGen_LookupEnt(ASL.Hr.DAO.enumsHr.enumEntitySetup entitySetup) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <Gen_LookupEnt> Gen_LookupEntCollection = new CustomList <Gen_LookupEnt>(); IDataReader reader = null; String sql = "select *from Gen_LookupEnt where EntityKey='" + (int)entitySetup + "'"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { Gen_LookupEnt newGen_LookupEnt = new Gen_LookupEnt(); newGen_LookupEnt.SetData(reader); Gen_LookupEntCollection.Add(newGen_LookupEnt); } Gen_LookupEntCollection.InsertSpName = "spInsertGen_LookupEnt"; Gen_LookupEntCollection.UpdateSpName = "spUpdateGen_LookupEnt"; Gen_LookupEntCollection.DeleteSpName = "spDeleteGen_LookupEnt"; return(Gen_LookupEntCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public CustomList <Gen_LookupEnt> GetAllGen_LookupEnt(ASL.Hr.DAO.enumsHr.enumEntitySetup entitySetup) { return(Gen_LookupEnt.GetAllGen_LookupEnt(entitySetup)); }