private void mem_Login_Click(object sender, EventArgs e)
{
// Open database to look for correct ID and password.
// The branch and ID is Saved for all other forms.
if ((member_Id.TextLength > 0) && (member_pw.TextLength > 0))
{
string email, pw;
SqlConnection sq = new SqlConnection();
sq.ConnectionString = "Data Source=DESKTOP-863JJKV;Initial Catalog=Project;Integrated Security=True";
SqlCommand cmd = new SqlCommand("select * from [Members] where email=@username and Password=@password ", sq);
cmd.Parameters.AddWithValue("@username", member_Id.Text);
cmd.Parameters.AddWithValue("@password", member_pw.Text);
sq.Open();
SqlDataReader sq_reader = cmd.ExecuteReader();
bool match = false;
while ((sq_reader.Read()))
{
email = sq_reader["email"].ToString();
pw = sq_reader["Password"].ToString();
if ((member_Id.Text.Trim() == email.Trim()) && (member_pw.Text.Trim() == pw.Trim()))
{
match = true;
member_ID = Convert.ToInt32(sq_reader["ID"]);
branch_ID = Convert.ToInt32(sq_reader["Branch_ID"]);
MessageBox.Show("Successful log-in!");
// Passing both these objects for Branch and ID
Member_login member = new Member_login(home, this);
member.Show();
this.Close();
}
}
// If none found.
if (!match)
{
MessageBox.Show("Incorrect credentials, Try again!");
home.Show();
this.Close();
sq_reader.Close();
sq.Close();
}
}
}
private void Back_Click(object sender, EventArgs e)
{
this.Close();
member.Show();
}
private void rated_Click(object sender, EventArgs e)
{
MessageBox.Show("You've successfully rated!");
this.Close();
member.Show();
}