private void btnSubmit_Click(object sender, EventArgs e)
{
//sets the value of the selected items in the combo box to respective variables.
que1 = cmbQ1.SelectedItem.ToString();
que3 = cmbQ3.SelectedItem.ToString();
string tittle = lblTittle.Text;
//calling the method Createconnection
my.CreateConnection();
//variable to store the query statement
string query = "insert into Results (Q1,Q2,Q3,Q4,Q5,Q6,Tittle) values" +
"('" + que1 + "','" + que2 + "','" + que3 + "','" + que4 + "','" + que5 + "','" + que6 + "','" + tittle + "')";
// calling the method Reader
SqlDataReader sdr = my.Reader(query);
MessageBox.Show("Thank you for your feedback. We value the infromation you provided");
try
{
while (sdr.Read())
{
}
}
catch (Exception ula)
{
MessageBox.Show(ula.Message);
}
// calling the close connection method.
my.CloseConnection();
MessageBox.Show("Return to home Page.", "info", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
//open the user page
UserPage use = new UserPage();
use.ShowDialog();
}
private void btnLogin_Click(object sender, EventArgs e)
{
// initialize connection
SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\brian\source\repos\krabby-k\C-sharp\NCC-PRO\Database.mdf;Integrated Security=True");
cn.Open();
//variable declaration
string u, p;
u = txtUname.Text;
p = txtPass.Text;
// check if username and password is not null
if (p != "" && u != "")
{
// query to select the account where username and password is provided
SqlCommand cmd = new SqlCommand("select * from Users where Username='******' and Password='******'", cn);
var dr = cmd.ExecuteReader();
// if present
if (dr.Read())
{
dr.Close();
this.Hide();
// we check if the account is an admin account.
if (u == "Admin")
{
// provide a limit to number of login attempts
int loginAttempts = 0;
for (int x = 0; x < 3; x++)
{
// checking if the password is similar to what is in the database
if (p != "Password")
{
loginAttempts++;
}
else
{
break;
}
}
// login attempt more than 2 account is locked.
if (loginAttempts > 2)
{
MessageBox.Show("Account has been Locked!!");
}
// grant access
else
{
AdminPage admin = new AdminPage();
admin.ShowDialog();
}
}
// executed when normal user logs in
else
{
UserPage use = new UserPage();
use.ShowDialog();
}
}
// executed when incorrect Login Details are provided
else
{
dr.Close();
MessageBox.Show("Username and Password does not exist \nor Wrong Username / password ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// must provide username and password to proceed
else
{
MessageBox.Show("Please Enter Username and Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cn.Close();
}