public void checkadmin(string user, string pass)
        {
            string connstr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\umair\source\repos\Lib Mang Sys\Lib Mang Sys\Database1.mdf;Integrated Security=True";

            using (SqlConnection conn = new SqlConnection(connstr))
            {
                try
                {
                    conn.Open();
                    string        query   = "Select * from dbo.Admin";
                    SqlCommand    command = new SqlCommand(query, conn);
                    SqlDataReader reader  = command.ExecuteReader();
                    while (reader.Read())
                    {
                        string username = reader.GetString(reader.GetOrdinal("Name"));
                        string password = reader.GetString(reader.GetOrdinal("Password"));
                        if (user == username && pass == password)
                        {
                            Admin_Login a = new Admin_Login();
                            a.Hide();
                            Admin_Panel b = new Admin_Panel();
                            b.Show();
                        }
                        else
                        {
                            MessageBox.Show("wrong");
                        }
                    }
                }
                catch (Exception)
                {
                }
            }
        }
Esempio n. 2
0
        /// <summary>
        /// calling nest pannel by making object
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnNewUser_Click(object sender, EventArgs e)
        {
            Admin_Panel newUser = new Admin_Panel();

            newUser.Show();
            this.Hide();
        }
Esempio n. 3
0
        private void login_button_Click(object sender, EventArgs e) // 로그인 버튼
        {
            // 어떤 항목이 입력되지 않았다면
            if (loginid_textBox.Text == "" || loginpw_textBox.Text == "")
            {
                MessageBox.Show("아이디와 비밀번호를 입력해 주세요!", "로그인 오류");
            }
            // 로그인 성공
            else
            {
                string loginQuery = "SELECT user_id, user_pw FROM user_register WHERE (user_id = '" + loginid_textBox.Text + "' and user_pw = '" + loginpw_textBox.Text + "')";
                // 이름, 아이디, 비밀번호, 연락처를 DB에 저장
                connection.Open();
                MySqlCommand    command = new MySqlCommand(loginQuery, connection);
                MySqlDataReader reader  = command.ExecuteReader();

                try//예외 처리
                {
                    // 아이디가 없거나 비밀번호가 틀렸다면
                    if (!reader.Read())
                    {
                        MessageBox.Show("아이디가 없거나 비밀번호가 틀렸습니다!", "로그인 실패");
                    }
                    // 로그인 성공시
                    else
                    {
                        LoginID = loginid_textBox.Text;

                        if (LoginID == "admin")
                        {
                            MessageBox.Show("관리자 접속", "관리자 모드");
                            loginid_textBox.Clear();
                            loginpw_textBox.Clear();
                            connection.Close();
                            Main_Panel.Hide();
                            Admin_Panel.Show();
                            try
                            {
                                // book_register 테이블을 register_listView에 출력
                                connection.Open();

                                Admin_book_register_listview(); // 현재 보유 도서 리스트뷰 갱신

                                // book_retnal 테이블을 rental-listView에 출력
                                string           book_rental_Querry = "SELECT * FROM book_rental";
                                MySqlCommand     com = new MySqlCommand(book_rental_Querry, connection);
                                MySqlDataAdapter dap = new MySqlDataAdapter(book_rental_Querry, connection);
                                DataTable        dtp = new DataTable();
                                dap.Fill(dtp);
                                Admin_Book_Rental_List_listView.Items.Clear(); // View가 중복조회 되는것을 방지한다.

                                for (int i = 0; i < dtp.Rows.Count; i++)
                                {
                                    DataRow      drp      = dtp.Rows[i];
                                    ListViewItem listitem = new ListViewItem(drp["book_name"].ToString());
                                    listitem.SubItems.Add(drp["book_author"].ToString());
                                    listitem.SubItems.Add(drp["book_publisher"].ToString());
                                    listitem.SubItems.Add(drp["book_code"].ToString());
                                    listitem.SubItems.Add(drp["book_userid"].ToString());
                                    listitem.SubItems.Add(drp["book_userhp"].ToString());
                                    listitem.SubItems.Add(drp["book_deadline"].ToString());
                                    Admin_Book_Rental_List_listView.Items.Add(listitem);
                                }
                            }
                            catch (Exception ex)
                            {
                                MessageBox.Show(ex.Message);
                            }
                            finally
                            {
                                connection.Close();
                            }
                            Admin_Panel.Show();
                        }
                        else
                        {
                            MessageBox.Show(LoginID + "님 환영합니다.", "로그인 성공");
                            loginid_textBox.Clear();
                            loginpw_textBox.Clear();
                            connection.Close();
                            Book_Rental_List_View("SELECT * FROM book_register");
                            Main_Panel.Hide();
                            Book_Rental_List_Panel.Show();
                            Notice();
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "예기치 못한 오류 발생");
                    connection.Close();
                }
            }
        }
Esempio n. 4
0
        //function for database calling
        /// <summary>
        /// database calling
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnLogin_Click(object sender, EventArgs e)
        {
            DBConnection    dc        = new DBConnection();
            String          sql_login = "******" + txtUserName.Text + "' AND Password= '******'";
            MySqlCommand    cmd       = new MySqlCommand(sql_login, dc.Db_Connect());
            MySqlDataReader r         = cmd.ExecuteReader();


            if (r.Read())
            {
                //retrieveing value from column and sending value to the top declare variable(line 18) for Bug Entry Form.
                String idpass = r.GetString("User_Id");
                usridpass = idpass;


                String unamepass = r.GetString("UserName");
                usrnamepass = unamepass;

                String usertype = r.GetString("Usr_Type");
                usrtypepass = usertype;
                //Checking User Types
                switch (usertype)
                {
                case "Developer":
                    MessageBox.Show("welcome to Bug Tracking System (Developer)");
                    BugSolutionForm pp = new BugSolutionForm();
                    pp.Show();
                    break;

                case "Admin":
                    MessageBox.Show("welcome to Bug Tracking System (Admin)");
                    Admin_Panel ap = new Admin_Panel();
                    ap.Show();
                    break;

                case "Tester":
                    MessageBox.Show("welcome to Bug Tracking System (Tester)");
                    BugEntryForm tp = new BugEntryForm();
                    tp.Show();

                    //  tp.lbl_Usershow.Text = idpass;

                    break;

                default:
                    MessageBox.Show(usertype);
                    MessageBox.Show("welcome to BugTracking System (error!!!!!!)");
                    BugEntryForm err = new BugEntryForm();
                    err.Show();
                    break;
                }

                //for hiding loginpanel
                this.Hide();

                //for closing database connection
                dc.CloseConnection();
            }

            else
            {
                MessageBox.Show("Username or Password incorrect!!!");
            }
        }