public static EmpBudgetScheduleCollection GetAllItem()
{
EmpBudgetScheduleCollection collection = new EmpBudgetScheduleCollection();
using (var reader = SqlHelper.ExecuteReader("tblEmpBudgetSchedule_GetAll", null))
{
while (reader.Read())
{
EmpBudgetSchedule obj = new EmpBudgetSchedule();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static EmpBudgetScheduleCollection GetAllByUser(string CreatedUser, int PayType = 0)
{
EmpBudgetScheduleCollection collection = new EmpBudgetScheduleCollection();
using (var reader = SqlHelper.ExecuteReader("tblEmpBudgetSchedule_GetAllByUser", new SqlParameter("@CreatedUser", CreatedUser),
new SqlParameter("@PayType", PayType)))
{
while (reader.Read())
{
EmpBudgetSchedule obj = new EmpBudgetSchedule();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}