public static CustomList <SegmentNames> GetAllSegmentNames() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <SegmentNames> SegmentNamesCollection = new CustomList <SegmentNames>(); IDataReader reader = null; const String sql = "select *from SegmentNames"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { SegmentNames newSegmentNames = new SegmentNames(); newSegmentNames.SetData(reader); SegmentNamesCollection.Add(newSegmentNames); } return(SegmentNamesCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<SegmentNames> GetAllSegmentNames() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<SegmentNames> SegmentNamesCollection = new CustomList<SegmentNames>(); IDataReader reader = null; const String sql = "select *from SegmentNames"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { SegmentNames newSegmentNames = new SegmentNames(); newSegmentNames.SetData(reader); SegmentNamesCollection.Add(newSegmentNames); } return SegmentNamesCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList <SegmentNames> GetGroupSegmentNames(String itemGroupID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <SegmentNames> SegmentNamesCollection = new CustomList <SegmentNames>(); IDataReader reader = null; String sql = "EXEC spGetGroupWiseSegment " + itemGroupID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { SegmentNames newSegmentNames = new SegmentNames(); newSegmentNames.SetData(reader); SegmentNamesCollection.Add(newSegmentNames); } return(SegmentNamesCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<SegmentNames> GetGroupSegmentNames(String itemGroupID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<SegmentNames> SegmentNamesCollection = new CustomList<SegmentNames>(); IDataReader reader = null; String sql = "EXEC spGetGroupWiseSegment " + itemGroupID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { SegmentNames newSegmentNames = new SegmentNames(); newSegmentNames.SetData(reader); SegmentNamesCollection.Add(newSegmentNames); } return SegmentNamesCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }