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