private void btnEnter_Click(object sender, EventArgs e)
{
try
{
Human_Resources HR = new Human_Resources(); // Create an object for the HR class
string userNm = txtUsername.Text;
string userPass = txtPassword.Text;
string confirm = txtConfirm.Text;
string writeLoginTable = "INSERT INTO Login VALUES(@Username, @Password, @Question, @Answer)";
string readLogintable = "SELECT * FROM Login";
if (validateUserInput(userNm, userPass, confirm))
{
int x = createUser(writeLoginTable, readLogintable, userNm, userPass);
string updateQueiry = "UPDATE Employees SET UserID = '" + x.ToString() + "' WHERE Id = '" + int.Parse(txtId.Text) + "'";
HR.updatedata(updateQueiry);
MessageBox.Show("User Successfully created!");
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string updateQueiry = "UPDATE Sales_Order SET " + columnComboBox.Text + " = '" + txtNewVal.Text + "' WHERE salesOrder_ID = '" + float.Parse(txtIdUp.Text) + "'";
HR.updatedata(updateQueiry);
readAll();
}
private void button1_Click(object sender, EventArgs e)
{
if (tmp[2] == textBox1.Text)
{
Human_Resources HR = new Human_Resources();
New_password NP = new New_password();
NP.ShowDialog();
MessageBox.Show(NP.getPass);
string updateQueiry = "UPDATE Login SET Password = '******' WHERE Id = '" + int.Parse(tmp[0]) + "'";
HR.updatedata(updateQueiry);
MessageBox.Show("New Password Created");
this.Close();
}
else
{
errorProvider1.SetError(textBox1, "Wrong answer!");
}
}
