public static CustomList <CmnDocListTableMapping> GetAllCmnTransactionReferenceFind() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <CmnDocListTableMapping> CmnTransRefCollection = new CustomList <CmnDocListTableMapping>(); IDataReader reader = null; String sql = "EXEC spFindDocListTableMaping"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { CmnDocListTableMapping newCmnTransactionReference = new CmnDocListTableMapping(); newCmnTransactionReference.SetData(reader); CmnTransRefCollection.Add(newCmnTransactionReference); } return(CmnTransRefCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList <CmnDocListTableMapping> GetAllCmnDocListTableMapping() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <CmnDocListTableMapping> CmnDocListTableMappingCollection = new CustomList <CmnDocListTableMapping>(); IDataReader reader = null; const String sql = "select * from CmnDocListTableMapping"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { CmnDocListTableMapping newCmnDocListTableMapping = new CmnDocListTableMapping(); newCmnDocListTableMapping.SetData(reader); CmnDocListTableMappingCollection.Add(newCmnDocListTableMapping); } CmnDocListTableMappingCollection.InsertSpName = "spInsertCmnDocListTableMapping"; CmnDocListTableMappingCollection.UpdateSpName = "spUpdateCmnDocListTableMapping"; CmnDocListTableMappingCollection.DeleteSpName = "spDeleteCmnDocListTableMapping"; return(CmnDocListTableMappingCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<CmnDocListTableMapping> GetAllCmnTransactionReferenceFind() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<CmnDocListTableMapping> CmnTransRefCollection = new CustomList<CmnDocListTableMapping>(); IDataReader reader = null; String sql = "EXEC spFindDocListTableMaping"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { CmnDocListTableMapping newCmnTransactionReference = new CmnDocListTableMapping(); newCmnTransactionReference.SetData(reader); CmnTransRefCollection.Add(newCmnTransactionReference); } return CmnTransRefCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList<CmnDocListTableMapping> GetAllCmnDocListTableMapping() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<CmnDocListTableMapping> CmnDocListTableMappingCollection = new CustomList<CmnDocListTableMapping>(); IDataReader reader = null; const String sql = "select * from CmnDocListTableMapping"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { CmnDocListTableMapping newCmnDocListTableMapping = new CmnDocListTableMapping(); newCmnDocListTableMapping.SetData(reader); CmnDocListTableMappingCollection.Add(newCmnDocListTableMapping); } CmnDocListTableMappingCollection.InsertSpName = "spInsertCmnDocListTableMapping"; CmnDocListTableMappingCollection.UpdateSpName = "spUpdateCmnDocListTableMapping"; CmnDocListTableMappingCollection.DeleteSpName = "spDeleteCmnDocListTableMapping"; return CmnDocListTableMappingCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }