public static CustomList <SegmentValues> GetAllSegmentValues(Int32 segmentNameID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <SegmentValues> SegmentValuesCollection = new CustomList <SegmentValues>(); IDataReader reader = null; String sql = "select *from SegmentValues Where SegNameID=" + segmentNameID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { SegmentValues newSegmentValues = new SegmentValues(); newSegmentValues.SetData(reader); SegmentValuesCollection.Add(newSegmentValues); } return(SegmentValuesCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<SegmentValues> GetAllSegmentValues(Int32 segmentNameID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<SegmentValues> SegmentValuesCollection = new CustomList<SegmentValues>(); IDataReader reader = null; String sql = "select *from SegmentValues Where SegNameID=" + segmentNameID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { SegmentValues newSegmentValues = new SegmentValues(); newSegmentValues.SetData(reader); SegmentValuesCollection.Add(newSegmentValues); } return SegmentValuesCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }