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