public static BillPayItemList LoadBillPaySchedule()
{
BillPayItemList list = new BillPayItemList();
SqlParamsColl paramList = new SqlParamsColl();
SqlTools.ExecuteReader("dbo.Admin_LoadBillPaySchedule", paramList, reader =>
{
while (reader.Read())
{
BillPayItem item = new BillPayItem();
PopulateFromReader(reader, item);
list.Add(item);
}
});
return list;
}
public static BillPayItemList LoadCustomerBillPayList(int CustomerId)
{
BillPayItemList list = new BillPayItemList();
SqlParamsColl paramList = new SqlParamsColl();
paramList.Add("@CustomerId", SqlDbType.Int, CustomerId);
SqlTools.ExecuteReader("dbo.BillPay_LoadByCustomer", paramList, reader =>
{
while (reader.Read())
{
BillPayItem item = new BillPayItem();
PopulateFromReader(reader, item);
list.Add(item);
}
});
return list;
}
