public static clsListAccount getThisClientAccounts(string clientNumber)
        {
            // // TEXT FILES VERSION ----
            //clsListAccount allAccounts = new clsListAccount();
            // StreamReader myfil = new StreamReader("Accounts.txt");
            // while (myfil .EndOfStream == false)
            // {
            //     string num = myfil.ReadLine();
            //     string typ = myfil.ReadLine();
            //     int day = Convert .ToInt32 ( myfil.ReadLine());
            //     int month = Convert.ToInt32(myfil.ReadLine());
            //     int year = Convert.ToInt32(myfil.ReadLine());
            //     string stat = myfil.ReadLine();
            //     decimal bal = Convert.ToDecimal(myfil.ReadLine());

            //     string clientID = myfil.ReadLine();

            //     if(clientID == clientNumber)
            //     {
            //         clsAccount anAcc = new clsAccount(num, typ, day, month, year, stat, bal);
            //         allAccounts.Add(anAcc);
            //     }

            // }
            // myfil.Close();
            // return allAccounts;


            // // ----DATABASE VERSION ---
            clsListAccount  allAccounts = new clsListAccount();
            OleDbConnection mycon       = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\15148\source\repos\2020\group07478\prjWinCsReviewOOP\prjWinCsReviewOOP\databases\DBBank2003.mdb");

            mycon.Open();
            string          sql    = "SELECT [Number],Type,OpenDay,OpenMonth,OpenYear,Status,Balance,ClientID FROM Accounts WHERE ClientID='" + clientNumber + "'";
            OleDbCommand    mycmd  = new OleDbCommand(sql, mycon);
            OleDbDataReader myRder = mycmd.ExecuteReader();

            while (myRder.Read())
            {
                string  num   = myRder["Number"].ToString();
                string  typ   = myRder["Type"].ToString();
                int     day   = Convert.ToInt32(myRder["OpenDay"].ToString());
                int     month = Convert.ToInt32(myRder["OpenMonth"].ToString());
                int     year  = Convert.ToInt32(myRder["OpenYear"].ToString());
                string  stat  = myRder["Status"].ToString();
                decimal bal   = Convert.ToDecimal(myRder["Balance"].ToString());

                clsAccount anAcc = new clsAccount(num, typ, day, month, year, stat, bal);
                allAccounts.Add(anAcc);
            }
            myRder.Close();
            mycon.Close();
            return(allAccounts);
        }
Beispiel #2
0
 private void btnNextAccount_Click(object sender, EventArgs e)
 {
     foreach (clsAccount itm in currentClient.Accounts.Elements)
     {
         if (itm.Type == cboAccounts.SelectedItem.ToString())
         {
             currentAccount = itm;
         }
     }
     this.Height = 464;
     //MessageBox.Show(currentAccount.Consult());
 }