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();
}
}
}
