public static BillPayPayeeList LoadPayeeList()
        {
            BillPayPayeeList list = new BillPayPayeeList();
            SqlParamsColl paramList = new SqlParamsColl();

            SqlTools.ExecuteReader("dbo.Payee_LoadAll", paramList, reader =>
                {
                    while (reader.Read())
                    {
                        list.Add(PopulateFromReader(reader));
                    }
                });

            return list;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["LoggedInCustomer"] == null)
            {
                Response.Redirect("/Login");
            }

            if (!IsPostBack)
            {
                CustomerDataSource = (Customer)Session["LoggedInCustomer"];
                CustomerAccounts = AccountManager.GetAccountsByCustomer(CustomerDataSource);

                string BPAYId = (string)Page.RouteData.Values["Brn"];

                if (BPAYId != "New" && BPAYId != null && BPAYId != "")
                {
                    int parsedBPAYId = 0;

                    try
                    {
                        parsedBPAYId = Int32.Parse(BPAYId);
                    }
                    catch (FormatException) { }

                    if (parsedBPAYId != 0)
                    {
                        BPAYItem = BillPayManager.GetBillPayItem(parsedBPAYId);
                    }
                }

                if (BPAYItem != null)
                {

                    bool correctOwner = false;

                    // Confirming that BPAY item actually belongs to the logged in user.
                    foreach (Account acc in CustomerAccounts)
                    {
                        if (BPAYItem.PayerAccount == acc.AccountNumber)
                        {
                            correctOwner = true;
                            break;
                        }
                    }

                    if (!correctOwner)
                    {
                        BPAYItem = new BillPayItem();
                        BPAYItem.Id = 0;
                        PageMode = (int)Enums.PageMode.Edit;
                    }
                    else
                    {
                        PageMode = (int)Enums.PageMode.View;
                    }
                }
                else
                {
                    BPAYItem = new BillPayItem();
                    BPAYItem.Id = 0;
                    PageMode = (int)Enums.PageMode.Edit;
                }

                PayeeList = BillPayManager.GetBillPayPayeeList();

                BindData();
            }
        }