public static List <SalaryAdjustment> RePackage(SqlDataReader dr)
{
var salaryAdjustmentList = new List <SalaryAdjustment>();
if (dr.HasRows)
{
var salaryAdjustmentSalaryAdjustmentId = dr.GetOrdinal("SalaryAdjustmentId");
var salaryAdjustmentPercentIncrease = dr.GetOrdinal("PercentIncrease");
var salaryAdjustmentEffectiveDate = dr.GetOrdinal("EffectiveDate");
while (dr.Read())
{
var salaryAdjustment = new SalaryAdjustment();
salaryAdjustment.SalaryAdjustmentId = Convert.ToInt32(dr[salaryAdjustmentSalaryAdjustmentId]);
salaryAdjustment.PercentIncrease = Convert.ToDecimal(dr[salaryAdjustmentPercentIncrease]);
salaryAdjustment.EffectiveDate = Convert.ToDateTime(dr[salaryAdjustmentEffectiveDate]);
salaryAdjustmentList.Add(salaryAdjustment);
}
}
return(salaryAdjustmentList);
}
public static bool Create(List <int> employeeIdList, SalaryAdjustment salaryAdj)
{
return(SalaryAdjustmentSQL.Create(employeeIdList, salaryAdj));
}
public static List <SalaryAdjustment> GetSalaryAdjustmentsByEmpId(int employeeId, SalaryAdjustmentGetType type)
{
return(SalaryAdjustment.RePackage(SalaryAdjustmentSQL.GetSalaryAdjustmentByEmpId(employeeId, type)));
}
public static List <int> GetEmployeeIds(int salaryAdjId)
{
return(SalaryAdjustment.RePackageEmpIdList(SalaryAdjustmentSQL.GetEmployeeIds(salaryAdjId)));
}