private void button2_Click(object sender, EventArgs e)
{
this.Hide();
DashboardPage dashboardPage = new DashboardPage(Id);
dashboardPage.Show();
}
private void button1_Click(object sender, EventArgs e)
{
string usr = comboBox1.Text;
if (usr == "Student")
{
try
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-JT5TE1G\\SQLEXPRESS;Initial Catalog=signup;User ID=your_id;Password=you_pass");
con.Open();
//string newcon = "insert into signuptable(Name,ID,Year, Semester, Password) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "', '" + textBox4.Text + "','" + textBox5.Text + "')";
string newcon = "select ID from signuptable1 where ID='" + textBox1.Text + "' and Password='******'";
SqlDataAdapter adp = new SqlDataAdapter(newcon, con);
DataSet ds = new DataSet();
adp.Fill(ds);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count >= 1)
{
id = textBox1.Text;
// MessageBox.Show(id);
DashboardPage dashboardPage = new DashboardPage(id);
dashboardPage.Show();
this.Hide();
}
else
{
label4.Text = "Wrong ID or Password";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (usr == "Admin")
{
string str = textBox1.Text;
string pas = textBox2.Text;
if (str == "Admin" && pas == "Admin")
{
this.Hide();
AdminPanel adminPanel = new AdminPanel();
adminPanel.Show();
}
else
{
MessageBox.Show("Wrong ID or Password");
}
}
else
{
MessageBox.Show("Please Select a User");
}
}
private void button1_Click(object sender, EventArgs e)
{
string pas1 = textBox5.Text;
string pas2 = textBox6.Text;
if (pas1 == pas2)
{
try
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-JT5TE1G\\SQLEXPRESS;Initial Catalog=signup;User ID=your_id;Password=you_pass");
con.Open();
string newcon = "update signuptable1 set Name='" + textBox1.Text + "',ID='" + textBox2.Text + "',Year='" + textBox3.Text + "', Semester='" + textBox4.Text + "', Password='******' where ID='" + Id + "';";
SqlCommand cmd = new SqlCommand(newcon, con);
SqlDataReader dr = cmd.ExecuteReader();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Id = textBox2.Text;
this.Hide();
MessageBox.Show("Your Profile Successfully Saved!");
DashboardPage dashboardPage = new DashboardPage(Id);
dashboardPage.Show();
}
else
{
MessageBox.Show("Your Password do not Match!");
}
}