public static CustomList <EmployeeHKInfo> GetAllEmployeeHKInfo(Int64 empKey) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <EmployeeHKInfo> EmployeeHKInfoCollection = new CustomList <EmployeeHKInfo>(); IDataReader reader = null; String sql = "select *from EmployeeHKInfo where EmpKey=" + empKey; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { EmployeeHKInfo newEmployeeHKInfo = new EmployeeHKInfo(); newEmployeeHKInfo.SetData(reader); EmployeeHKInfoCollection.Add(newEmployeeHKInfo); } EmployeeHKInfoCollection.InsertSpName = "spInsertEmployeeHKInfo"; EmployeeHKInfoCollection.UpdateSpName = "spUpdateEmployeeHKInfo"; EmployeeHKInfoCollection.DeleteSpName = "spDeleteEmployeeHKInfo"; return(EmployeeHKInfoCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<EmployeeHKInfo> GetAllEmployeeHKInfo(Int64 empKey) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<EmployeeHKInfo> EmployeeHKInfoCollection = new CustomList<EmployeeHKInfo>(); IDataReader reader = null; String sql = "select *from EmployeeHKInfo where EmpKey=" + empKey; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { EmployeeHKInfo newEmployeeHKInfo = new EmployeeHKInfo(); newEmployeeHKInfo.SetData(reader); EmployeeHKInfoCollection.Add(newEmployeeHKInfo); } EmployeeHKInfoCollection.InsertSpName = "spInsertEmployeeHKInfo"; EmployeeHKInfoCollection.UpdateSpName = "spUpdateEmployeeHKInfo"; EmployeeHKInfoCollection.DeleteSpName = "spDeleteEmployeeHKInfo"; return EmployeeHKInfoCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }