private void button7_Click(object sender, EventArgs e) { int c = 0; string x = ""; login log = new login(x); log.ShowDialog(); string user = log.val1; string pass = log.val2; if (user == "" || pass == "") { } else { db.sql.Close(); db.sql.Open(); SqlCommand cmd = new SqlCommand("select * from log where pass='******' and user_name='" + user + "'", db.sql); SqlDataReader r = cmd.ExecuteReader(); while (r.Read()) { c++; } if (c > 0) { MessageBox.Show("Login Sucessfull"); label18.Text = "admin"; richTextBox11.Visible = true; button6.Visible = true; button7.Visible = false; } else { MessageBox.Show("Failed to Login"); } db.sql.Close(); } }
private void button1_Click(object sender, EventArgs e) { try { int c = 0; string x = ""; login log = new login(x); log.ShowDialog(); string user = log.val1; string pass = log.val2; string type = log.val3; if (user == "" || pass == "") { } else { db.sql.Open(); SqlCommand cmd = new SqlCommand("select * from log where pass='******' and user_name='" + user + "' and type='" + type + "'", db.sql); SqlDataReader r = cmd.ExecuteReader(); while (r.Read()) { c++; } if (c > 0) { MessageBox.Show("Login Sucessfull"); if (type == "Admin") { aDMINToolStripMenuItem.Visible = true; accountsToolStripMenuItem.Visible = true; hOSPITALToolStripMenuItem.Visible = true; dIAGNOSTICToolStripMenuItem.Visible = true; button2.Visible = true; button1.Visible = false; pHARMACYToolStripMenuItem.Visible = true; lABToolStripMenuItem.Visible = true; //button7.Visible = true; //dOCTORToolStripMenuItem.Visible = true; emergencyToolStripMenuItem.Visible = true; //pRESCRIPTIONToolStripMenuItem.Visible = true; //button3.Visible = true; label2.Text = "User: "******"Manager") { accountsToolStripMenuItem.Visible = true; hOSPITALToolStripMenuItem.Visible = true; dIAGNOSTICToolStripMenuItem.Visible = true; button2.Visible = true; button1.Visible = false; pHARMACYToolStripMenuItem.Visible = true; lABToolStripMenuItem.Visible = true; //button7.Visible = true; //dOCTORToolStripMenuItem.Visible = true; emergencyToolStripMenuItem.Visible = true; //pRESCRIPTIONToolStripMenuItem.Visible = true; //button3.Visible = true; label2.Text = "User: "******"Diagnostic") { //hOSPITALToolStripMenuItem.Visible = true; dIAGNOSTICToolStripMenuItem.Visible = true; eXPENSEToolStripMenuItem1.Visible = true; //lABToolStripMenuItem.Visible = true; // dOCTORToolStripMenuItem.Visible = true; // pRESCRIPTIONToolStripMenuItem.Visible = true; emergencyToolStripMenuItem.Visible = true; //button7.Visible = true; button2.Visible = true; button1.Visible = false; //button3.Visible = true; label2.Text = "User: "******"Lab") { // hOSPITALToolStripMenuItem.Visible = true; //dIAGNOSTICToolStripMenuItem.Visible = true; //pHARMACYToolStripMenuItem.Visible = true; lABToolStripMenuItem.Visible = true; // dOCTORToolStripMenuItem.Visible = true; // pRESCRIPTIONToolStripMenuItem.Visible = true; // emergencyToolStripMenuItem.Visible = true; // button7.Visible = true; button2.Visible = true; button1.Visible = false; // button3.Visible = true; label2.Text = "User: "******"Admission") { hOSPITALToolStripMenuItem.Visible = true; //dIAGNOSTICToolStripMenuItem.Visible = true; //pHARMACYToolStripMenuItem.Visible = true; // lABToolStripMenuItem.Visible = true; //dOCTORToolStripMenuItem.Visible = true; //pRESCRIPTIONToolStripMenuItem.Visible = true; emergencyToolStripMenuItem.Visible = true; eXPENSEToolStripMenuItem1.Visible = true; // button7.Visible = true; button2.Visible = true; button1.Visible = false; // button3.Visible = true; label2.Text = "User: "******"Pharmachy") { //hOSPITALToolStripMenuItem.Visible = true; //dIAGNOSTICToolStripMenuItem.Visible = true; //pHARMACYToolStripMenuItem.Visible = true; // lABToolStripMenuItem.Visible = true; //dOCTORToolStripMenuItem.Visible = true; pRESCRIPTIONToolStripMenuItem.Visible = true; //emergencyToolStripMenuItem.Visible = true; eXPENSEToolStripMenuItem1.Visible = true; // button7.Visible = true; button2.Visible = true; button1.Visible = false; // button3.Visible = true; label2.Text = "User: "******"Failed to Login"); } db.sql.Close(); } } catch { } }