예제 #1
0
        private void btn_logout_Click(object sender, EventArgs e)
        {
            this.Hide();

            Form1         showLogin     = new Form1();
            frm_dashboard showDashboard = new frm_dashboard();

            showDashboard.dbCommandLogs(Session.FullName.ToString() + " signed out. ");
            showLogin.Show();
        }
예제 #2
0
 public docuForm()
 {
     InitializeComponent();
     db = new frm_dashboard();
 }
예제 #3
0
 public Guest_frm()
 {
     InitializeComponent();
     db = new frm_dashboard();
 }
예제 #4
0
        public void checkCredentials(string username, string password)
        {
            try
            {
                conn = new MySqlConnection(cs);
                conn.Open();
                //Console.WriteLine("MySQL version : {0}", conn.ServerVersion);

                query             = conn.CreateCommand();
                query.CommandText = "select count(*) from account_table where username= '******' and password='******'";
                adapt             = new MySqlDataAdapter(query);
                dataTable         = new DataTable();
                adapt.Fill(dataTable);

                if (dataTable.Rows[0][0].ToString() == "1")
                {
                    query.CommandText = "select type from account_table where username= '******' and password='******'";
                    adapt             = new MySqlDataAdapter(query);
                    dataTable         = new DataTable();
                    adapt.Fill(dataTable);



                    if (dataTable.Rows[0][0].ToString() == "admin")
                    {
                        //create session
                        query.CommandText = "select * from account_table where username= '******' and password='******'";
                        adapt             = new MySqlDataAdapter(query);
                        dataTable         = new DataTable();
                        adapt.Fill(dataTable);

                        Session.Id       = Convert.ToInt32(dataTable.Rows[0][0].ToString());
                        Session.Username = dataTable.Rows[0][1].ToString();
                        Session.FullName = dataTable.Rows[0][2].ToString();
                        Session.Type     = dataTable.Rows[0][3].ToString();

                        this.Hide();

                        frm_dashboard showDashboard = new frm_dashboard();
                        showDashboard.dbCommandLogs(Session.FullName.ToString() + " logged in. ");
                        showDashboard.Show();
                    }
                    else if (dataTable.Rows[0][0].ToString() == "coordinator")
                    {
                        //create session
                        query.CommandText = "select * from account_table where username= '******' and password='******'";
                        adapt             = new MySqlDataAdapter(query);
                        dataTable         = new DataTable();
                        adapt.Fill(dataTable);

                        Session.Id       = Convert.ToInt32(dataTable.Rows[0][0].ToString());
                        Session.Username = dataTable.Rows[0][1].ToString();
                        Session.FullName = dataTable.Rows[0][2].ToString();
                        Session.Type     = dataTable.Rows[0][3].ToString();

                        this.Hide();

                        frm_dashboard showDashboard = new frm_dashboard();
                        showDashboard.dbCommandLogs(Session.FullName.ToString() + " logged in. ");
                        showDashboard.Show();
                    }
                }
                else if (dataTable.Rows[0][0].ToString() == "2")
                {
                    MessageBox.Show("Error: Duplicated Account!");
                }
                else
                {
                    MessageBox.Show("Username or Password is incorrect!");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error:", ex.ToString());
                // MessageBox.Show("Error:", ex.ToString());
                MessageBox.Show("connection failed.");
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }