예제 #1
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (textBox1.Text != "" && textBox2.Text != "")
     {
         _dbConnection = new OleDbConnection {
             ConnectionString = "Provider=Microsoft.ACE.OLEDB.15.0;Data Source=C:\\Users\\Malik\\Desktop\\SEF31.accdb;Persist Security Info=False;"
         };
         DataSet      myDataSet   = new DataSet();
         DataTable    myDataTable = new DataTable();
         var          myAdaptor   = new OleDbDataAdapter();
         string       sSelect     = "SELECT * FROM [login] WHERE user_id='" + textBox2.Text + "' AND password="******"";
         OleDbCommand command     = new OleDbCommand(sSelect, _dbConnection);
         myAdaptor.SelectCommand = command;
         myAdaptor.Fill(myDataSet, "login");
         myDataTable = myDataSet.Tables["login"];
         _dbConnection.Close();
         string s      = textBox2.Text;
         int    icount = myDataSet.Tables[0].Rows.Count;
         //MessageBox.Show("Row Count = " + icount);
         // int icount = myDataSet.Tables[0].Rows.Count;
         if (icount > 0)
         {
             // found
             foreach (DataRow datarow in myDataTable.Rows)
             {
                 //MessageBox.Show(datarow["user_role"].ToString());
                 if (datarow["user_role"].ToString() == "admin" && datarow["password"].ToString() == "222")
                 {
                     Registrar myForm = new Registrar();
                     this.Hide();
                     myForm.ShowDialog();
                     this.Close();
                 }
                 else if (datarow["user_role"].ToString() == "staffmanager" && datarow["password"].ToString() == "333")
                 {
                     StaffManager myForm = new StaffManager();
                     this.Hide();
                     myForm.ShowDialog();
                     this.Close();
                 }
                 else if (datarow["user_role"].ToString() == "salesagent" && datarow["password"].ToString() == "444")
                 {
                     SalesAgent myForm = new SalesAgent();
                     this.Hide();
                     myForm.ShowDialog();
                     this.Close();
                 }
                 else if (datarow["user_role"].ToString() == "tourguide" && datarow["password"].ToString() == "555")
                 {
                     TourGuide myForm = new TourGuide();
                     this.Hide();
                     myForm.ShowDialog();
                     this.Close();
                 }
             }
             // }
         }
     }
 }
        private void button3_Click(object sender, EventArgs e)
        {
            SalesAgent myForm = new SalesAgent();

            this.Hide();
            myForm.ShowDialog();
            this.Close();
        }