public static CustomList <DataCaptureConfiguration> GetAllDataCaptureConfigurationForDataCapture() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <DataCaptureConfiguration> DataCaptureConfigurationCollection = new CustomList <DataCaptureConfiguration>(); IDataReader reader = null; const String sql = "Select RowID,Field from DataCaptureConfiguration Where IsFixed=1"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { DataCaptureConfiguration newDataCaptureConfiguration = new DataCaptureConfiguration(); newDataCaptureConfiguration.SetDataForRate(reader); DataCaptureConfigurationCollection.Add(newDataCaptureConfiguration); } return(DataCaptureConfigurationCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList <DataCaptureConfiguration> GetAllDataCaptureConfiguration() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <DataCaptureConfiguration> DataCaptureConfigurationCollection = new CustomList <DataCaptureConfiguration>(); IDataReader reader = null; const String sql = "select *from DataCaptureConfiguration"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { DataCaptureConfiguration newDataCaptureConfiguration = new DataCaptureConfiguration(); newDataCaptureConfiguration.SetData(reader); DataCaptureConfigurationCollection.Add(newDataCaptureConfiguration); } DataCaptureConfigurationCollection.InsertSpName = "spInsertDataCaptureConfiguration"; DataCaptureConfigurationCollection.UpdateSpName = "spUpdateDataCaptureConfiguration"; DataCaptureConfigurationCollection.DeleteSpName = "spDeleteDataCaptureConfiguration"; return(DataCaptureConfigurationCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }