public Account(String s, String CNP, String emailAddress, Hash_SHA256 encryptionInstance, Login loginFormInstance) { InitializeComponent(); loginInstance = loginFormInstance; helperNightMode.setColorTheme(Settings.Default.isNightMode, this); userReceiverText += s + "!"; lbUser_Logged.Text += userReceiverText; this.CNP = CNP; this.currentUserEmailAddress = emailAddress; verifyIfStudent(); encryptionClassInstance = encryptionInstance; hashingForm = new Hashing(this, encryptionClassInstance); try { string query = "Select * from Credite where CNP='" + CNP + "'"; OleDbCommand command = new OleDbCommand(query, connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); if (isStudent) { lvCredite.Columns.Add("Perioada de gratie"); lvCredite.Size = new Size(lvCredite.Width + 150, lvCredite.Height); lvCredite.Columns[lvCredite.Columns.Count - 1].Width = 150; } while (reader.Read()) { if (reader["dobanda"].ToString() == "3") { CreditStudiu c = new CreditStudiu(DateTime.Parse(reader["dataCredit"].ToString()), double.Parse(reader["sumaAprobata"].ToString()), int.Parse(reader["perioadaCredit"].ToString()), int.Parse(reader["perioadaDeGratie"].ToString())); ListViewItem item = lvCredite.Items.Add((lvCredite.Items.Count + 1).ToString()); item.SubItems.Add(c.GetDateTime.ToShortDateString()); item.SubItems.Add(c.CuantumCredit.ToString()); item.SubItems.Add(c.PerioadaCredit.ToString()); item.SubItems.Add(c.CalculeazaDobanda().ToString()); item.SubItems.Add(c.CalculeazaCredit().ToString()); item.SubItems.Add(CreditStudiu.DOBANDA.ToString() + "%"); item.SubItems.Add(c.PerioadaDeGratie.ToString() + " luni"); listaCredite.Add(c); cuantumTotalCredite += c.CalculeazaCredit(); } else { Credite c = new Credite(DateTime.Parse(reader["dataCredit"].ToString()), double.Parse(reader["sumaAprobata"].ToString()), int.Parse(reader["perioadaCredit"].ToString())); ListViewItem item = lvCredite.Items.Add((lvCredite.Items.Count + 1).ToString()); item.SubItems.Add(c.GetDateTime.ToShortDateString()); item.SubItems.Add(c.CuantumCredit.ToString()); item.SubItems.Add(c.PerioadaCredit.ToString()); item.SubItems.Add(c.CalculeazaDobanda().ToString()); item.SubItems.Add(c.CalculeazaCredit().ToString()); item.SubItems.Add(Credite.DOBANDA.ToString() + "%"); listaCredite.Add(c); cuantumTotalCredite += c.CalculeazaCredit(); } } reader.Close(); connection.Close(); counterForListaCredite = listaCredite.Count; //Console.WriteLine("Counter initial: " + counterForListaCredite); } catch (Exception ex) { MessageBox.Show(ex.Message); } }