private void textBox1_TextChanged(object sender, EventArgs e)
{
Homepage p = new Homepage();
}
private void button3_Click(object sender, EventArgs e)
{
Homepage f1 = new Homepage();
f1.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
if (radioButton1.Checked)
{
using (SqlConnection conn = new SqlConnection())
{
string cn = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\123\\Downloads\\course-project-bhwain (1)\\course-project-bhwain\\course-project-bhwain\\course-project-bhwain\\Database\\Games.mdf;Integrated Security=True;Connect Timeout=30";
//conn.ConnectionString = "Server= (LocalDB)/MSSQLLocalDB; Database= Games; Integrated Security=True;";
conn.ConnectionString = cn;
conn.Open();
SqlCommand command = new SqlCommand("SELECT * FROM [Customers] WHERE CONVERT(VARCHAR, EmailID) = '" + LogEmailBox.Text + "' and CONVERT(VARCHAR, Password_2) = '" + LogPasswordBox.Text + "';", conn);
Console.WriteLine("Check1");
Console.WriteLine(LogEmailBox.Text);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
Console.WriteLine("Check2");
string myString = String.Format("{0}", reader["EmailID"]);
Console.WriteLine("::" + myString);
if (myString != null)
{
string message = "Successfully Logged in";
string caption = "Login";
MessageBoxButtons buttons = MessageBoxButtons.OK;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
// Closes the parent form.
this.Close();
}
login_email = String.Format("{0}", reader["EmailID"]);
login_password = String.Format("{0}", reader["Password_2"]);
login_name = String.Format("{0}", reader["Name"]);
Console.WriteLine(myString);
Form f1 = new Homepage();
this.Hide();
f1.ShowDialog();
}
}
else
{
Console.WriteLine("Check3");
string message = "No such user exists";
string caption = "Login";
MessageBoxButtons buttons = MessageBoxButtons.OK;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
// Closes the parent form.
this.Close();
}
}
}
conn.Close();
}
}
else if (radioButton2.Checked)
{
using (SqlConnection conn = new SqlConnection())
{
string cn = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\123\\Downloads\\course-project-bhwain (1)\\course-project-bhwain\\course-project-bhwain\\course-project-bhwain\\Database\\Games.mdf;Integrated Security=True;Connect Timeout=30";
//conn.ConnectionString = "Server= (LocalDB)/MSSQLLocalDB; Database= Games; Integrated Security=True;";
conn.ConnectionString = cn;
conn.Open();
SqlCommand command = new SqlCommand("SELECT * FROM [Employees] WHERE CONVERT(VARCHAR, email) = '" + LogEmailBox.Text + "' and CONVERT(VARCHAR, Password_2) = '" + LogPasswordBox.Text + "';", conn);
Console.WriteLine("Check1");
Console.WriteLine(LogEmailBox.Text);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
Console.WriteLine("Check2");
string myString = String.Format("{0}", reader["email"]);
Console.WriteLine("::" + myString);
if (myString != null)
{
string message = "Successfully Logged in";
string caption = "Login";
MessageBoxButtons buttons = MessageBoxButtons.OK;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
// Closes the parent form.
this.Close();
}
login_email = String.Format("{0}", reader["email"]);
login_password = String.Format("{0}", reader["Password_2"]);
login_name = String.Format("{0}", reader["Name"]);
developerid = String.Format("{0}", reader["Developers_idDevelopers"]);
Console.WriteLine(myString);
Form f1 = new DevForm(login_email, login_password, login_name, developerid);
this.Hide();
f1.ShowDialog();
}
}
else
{
Console.WriteLine("Check3");
string message = "No such user exists";
string caption = "Login";
MessageBoxButtons buttons = MessageBoxButtons.OK;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
// Closes the parent form.
this.Close();
}
}
}
conn.Close();
}
}
}
