public static CustomList <HRM_EvalDet> GetAllHRM_EvalDet() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <HRM_EvalDet> HRM_EvalDetCollection = new CustomList <HRM_EvalDet>(); IDataReader reader = null; const String sql = "Select * from HRM_EvalDet"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { HRM_EvalDet newHRM_EvalDet = new HRM_EvalDet(); newHRM_EvalDet.SetData(reader); HRM_EvalDetCollection.Add(newHRM_EvalDet); } HRM_EvalDetCollection.InsertSpName = "spInsertHRM_EvalDet"; HRM_EvalDetCollection.UpdateSpName = "spUpdateHRM_EvalDet"; HRM_EvalDetCollection.DeleteSpName = "spDeleteHRM_EvalDet"; return(HRM_EvalDetCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList <HRM_EvalDet> GetHRM_EvalDet(String EvalKey, int pagetype) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <HRM_EvalDet> HRM_EvalDetCollection = new CustomList <HRM_EvalDet>(); IDataReader reader = null; String sql = " SELECT dbo.HRM_EvalItem.EvalItemKey, Det.EvalRating, Det.ReviewRating, Det.EvalDetKey, Det.EvalKey EvalKey " + " FROM dbo.HRM_EvalItem LEFT JOIN " + " (Select * from dbo.HRM_EvalDet Where EvalKey = '" + EvalKey + "') as Det ON dbo.HRM_EvalItem.EvalItemKey = Det.EvalItemKey " + " Where evalitemtype = " + pagetype + " ORDER BY dbo.HRM_EvalItem.Seq"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { HRM_EvalDet newHRM_EvalDet = new HRM_EvalDet(); newHRM_EvalDet.SetData(reader); HRM_EvalDetCollection.Add(newHRM_EvalDet); } HRM_EvalDetCollection.InsertSpName = "spInsertHRM_EvalDet"; HRM_EvalDetCollection.UpdateSpName = "spUpdateHRM_EvalDet"; HRM_EvalDetCollection.DeleteSpName = "spDeleteHRM_EvalDet"; return(HRM_EvalDetCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }