public EvidenceReport(UserSkills curUS, UserEvidence curUE)
{
InitializeComponent();
MySqlConnection conn = ConnectionSingleton.Instance.getSharedConnection();
string sql = "SELECT skills.name FROM skills";
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
conn.Open();
dataAdapter.Fill(ds, "Skills_Table");
conn.Close();
foreach (DataRow row in ds.Tables[0].Rows)
{
this.comboBoxSkill.Items.Add(row[0]);
}
conn = ConnectionSingleton.Instance.getSharedConnection();
sql = "SELECT users.firstname, users.lastname FROM users";
dataAdapter = new MySqlDataAdapter(sql, conn);
ds = new DataSet();
conn.Open();
dataAdapter.Fill(ds, "Users_Table");
conn.Close();
foreach (DataRow row in ds.Tables[0].Rows)
{
this.comboBoxUser.Items.Add(row[0] + " " + row[1]);
}
this.labelAuthro.Text = $@"Author: {DataController.GetDiscreteUser().Firstname} {DataController.GetDiscreteUser().Lastname}";
this.labelCreated.Text = $@"Created At: {DateTime.Now.ToString()}";
this.labelLastEdit.Text = $@"Last Edit At: {DateTime.Now.ToString()}";
this.buttonAddEvidence.Visible = true;
this.buttonSave.Visible = false;
if (curUS != null)
{
us = curUS;
}
if (curUE != null)
{
ue = curUE;
}
}
private void loginButton_Click(object sender, EventArgs e)
{
try
{
DataController.generateDiscreteUser(textBoxUsername.Text, textBoxPassword.Text);
DiscreteUser user = DataController.GetDiscreteUser();
if (!user.IsValid)
{
throw new ArgumentException();
}
else
{
CurrentUser.UserId = user.UserId;
CurrentUser.FullName = $"{user.Firstname} {user.Lastname}";
}
}
catch (ArgumentException)
{
MessageBox.Show("Login Failed!");
return;
}
ViewController.switchForm(new UserDetails());
}
