public static CustomList <AccReportConfigurationHeadCategory> GetAllAccReportConfigurationHeadCategory() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <AccReportConfigurationHeadCategory> AccReportConfigurationHeadCategoryCollection = new CustomList <AccReportConfigurationHeadCategory>(); IDataReader reader = null; const String sql = "select *from AccReportConfigurationHeadCategory"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { AccReportConfigurationHeadCategory newAccReportConfigurationHeadCategory = new AccReportConfigurationHeadCategory(); newAccReportConfigurationHeadCategory.SetData(reader); AccReportConfigurationHeadCategoryCollection.Add(newAccReportConfigurationHeadCategory); } return(AccReportConfigurationHeadCategoryCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<AccReportConfigurationHeadCategory> GetAllAccReportConfigurationHeadCategory() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<AccReportConfigurationHeadCategory> AccReportConfigurationHeadCategoryCollection = new CustomList<AccReportConfigurationHeadCategory>(); IDataReader reader = null; const String sql = "select *from AccReportConfigurationHeadCategory"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { AccReportConfigurationHeadCategory newAccReportConfigurationHeadCategory = new AccReportConfigurationHeadCategory(); newAccReportConfigurationHeadCategory.SetData(reader); AccReportConfigurationHeadCategoryCollection.Add(newAccReportConfigurationHeadCategory); } return AccReportConfigurationHeadCategoryCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }