public static CustomList <ShiftRuleDetail> GetAllShiftRuleDetail()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <ShiftRuleDetail> ShiftRuleDetailCollection = new CustomList <ShiftRuleDetail>();
IDataReader reader = null;
String sql = "select SRD.*,SP.ALISE from ShiftRuleDetail SRD INNER JOIN ShiftPlan SP ON SP.ShiftID=SRD.ShiftID";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ShiftRuleDetail newShiftRuleDetail = new ShiftRuleDetail();
newShiftRuleDetail.SetDataShiftRoster(reader);
ShiftRuleDetailCollection.Add(newShiftRuleDetail);
}
return(ShiftRuleDetailCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <ShiftRuleDetail> GetAllShiftRuleDetail(int ShiftRuleKey)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <ShiftRuleDetail> ShiftRuleDetailCollection = new CustomList <ShiftRuleDetail>();
IDataReader reader = null;
String sql = "select *from ShiftRuleDetail Where ShiftRuleKey='" + ShiftRuleKey + "'";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ShiftRuleDetail newShiftRuleDetail = new ShiftRuleDetail();
newShiftRuleDetail.SetData(reader);
ShiftRuleDetailCollection.Add(newShiftRuleDetail);
}
return(ShiftRuleDetailCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
