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();
}
}
}
