private void button2_Click(object sender, EventArgs e) { management m = new management(); m.Show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { string userName = (string)comboBox1.SelectedItem; //unregistering user try { //you need to add your server name to connect on your computer String conString = "server=DESKTOP-C7FFPE6\\MSSQLSERVER01; database=patientMoniter; Integrated Security=SSPI;"; String Query = "DELETE FROM checkingUser WHERE userName='******'"; SqlConnection connect = new SqlConnection(conString); SqlCommand command = new SqlCommand(Query, connect); SqlDataReader reader; connect.Open(); reader = command.ExecuteReader(); while (reader.Read()) { } connect.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } try { //you need to add your server name to connect on your computer String conString2 = "server=DESKTOP-C7FFPE6\\MSSQLSERVER01; database=patientMoniter; Integrated Security=SSPI;"; String Query2 = "DELETE FROM loginUser WHERE userName='******'"; SqlConnection connect2 = new SqlConnection(conString2); SqlCommand command2 = new SqlCommand(Query2, connect2); SqlDataReader reader2; connect2.Open(); reader2 = command2.ExecuteReader(); while (reader2.Read()) { } connect2.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("user unregistered"); management mn = new management(); mn.Show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.textBox1.Text)) { MessageBox.Show("enter Password!!"); } else { // authenticating login string userName = (String)comboBox1.SelectedItem; try { //you need to add your server name to connect on your computer String conString = "server=DESKTOP-C7FFPE6\\MSSQLSERVER01; database=patientMoniter; Integrated Security=SSPI;"; String Query = "select * from managerLogin where managerName='" + userName + "'"; SqlConnection connect = new SqlConnection(conString); SqlCommand command = new SqlCommand(Query, connect); SqlDataReader reader; connect.Open(); reader = command.ExecuteReader(); string password = ""; while (reader.Read()) { password = (string)reader["password"]; } String eneteredPassword = textBox1.Text; if (eneteredPassword == password) { management c = new management(); c.Show(); this.Hide(); } else { MessageBox.Show("Wrong Password"); } connect.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void button2_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.textBox2.Text)) { MessageBox.Show("enter password!!"); } else { List <String> userNames = new List <string>(); bool flag = false; try { //you need to add your server name to connect on your computer String conString = "server=DESKTOP-C7FFPE6\\MSSQLSERVER01; database=patientMoniter; Integrated Security=SSPI;"; String Query = "select * from checkingUser"; SqlConnection connect = new SqlConnection(conString); SqlCommand command = new SqlCommand(Query, connect); SqlDataReader reader; connect.Open(); reader = command.ExecuteReader(); while (reader.Read()) { userNames.Add((string)reader["userName"]); } connect.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } //registering user in data base string userName = textBox1.Text; string password = textBox2.Text; for (int i = 0; i < userNames.Count; i++) { if (userNames[i] == userName) { flag = false; MessageBox.Show("user already exists"); } else { flag = true; } } if (flag == true) { try { //you need to add your server name to connect on your computer String conString3 = "server=DESKTOP-C7FFPE6\\MSSQLSERVER01; database=patientMoniter; Integrated Security=SSPI;"; String Query3 = "INSERT INTO loginUser (userName, password) VALUES('" + userName + "', '" + password + "')"; SqlConnection connect3 = new SqlConnection(conString3); SqlCommand command3 = new SqlCommand(Query3, connect3); SqlDataReader reader3; connect3.Open(); reader3 = command3.ExecuteReader(); while (reader3.Read()) { } connect3.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } try { //you need to add your server name to connect on your computer String conString2 = "server=DESKTOP-C7FFPE6\\MSSQLSERVER01; database=patientMoniter; Integrated Security=SSPI;"; String Query2 = "INSERT INTO checkingUser (userName,checking,time) VALUES('" + userName + "','-','-')"; SqlConnection connect2 = new SqlConnection(conString2); SqlCommand command2 = new SqlCommand(Query2, connect2); SqlDataReader reader2; connect2.Open(); reader2 = command2.ExecuteReader(); while (reader2.Read()) { } connect2.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("new user Added"); } else { management mng = new management(); mng.Show(); this.Hide(); } } }