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