public static CustomList <LeavePolicyMaster> GetLeaveType() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <LeavePolicyMaster> LeavePolicyMasterCollection = new CustomList <LeavePolicyMaster>(); IDataReader reader = null; String sql = "select LeavePolicyID,LeaveType From LeavePolicyMaster"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { LeavePolicyMaster newLeavePolicyMaster = new LeavePolicyMaster(); newLeavePolicyMaster.LeavePolicyID = reader.GetInt32("LeavePolicyID"); newLeavePolicyMaster.LeaveType = reader.GetString("LeaveType"); LeavePolicyMasterCollection.Add(newLeavePolicyMaster); } return(LeavePolicyMasterCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList <LeavePolicyMaster> GetSelectedLeavePolicyMaster(int leavePolicyid) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <LeavePolicyMaster> LeavePolicyMasterCollection = new CustomList <LeavePolicyMaster>(); IDataReader reader = null; String sql = "exec spGetSelectedLeavePolicyInfo " + leavePolicyid; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { LeavePolicyMaster newLeavePolicyMaster = new LeavePolicyMaster(); newLeavePolicyMaster.SetData(reader); LeavePolicyMasterCollection.Add(newLeavePolicyMaster); } LeavePolicyMasterCollection.InsertSpName = "spInsertLeavePolicyMaster"; LeavePolicyMasterCollection.UpdateSpName = "spUpdateLeavePolicyMaster"; LeavePolicyMasterCollection.DeleteSpName = "spDeleteLeavePolicyMaster"; return(LeavePolicyMasterCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }