using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Butata_Game
{
    public partial class Form1 : Form
    {
        public string LoginName = "";
        public Form1()
        {
            InitializeComponent();
            textBox1.Focus();
        }

        private void button5_Click(object sender, EventArgs e)//login
        {
            string UserName = textBox1.Text;
            string Password = textBox2.Text;
            const int AuthorizeCount = 10;

            SqlConnection conn = new SqlConnection("server=DESKTOP-MPM95IN; database=FirstDB;Integrated Security=true;");

            conn.Open();

            string sqlstr = "select * from Hr where 庫存異動權限=1; ";

            SqlCommand cmd = new SqlCommand(sqlstr, conn);

            SqlDataReader dr = cmd.ExecuteReader();

            string[] Authorizer = new string[AuthorizeCount];
            string[] AuthorizerID = new string[AuthorizeCount];
            int counter = 0;
            while (dr.Read())
            {
                AuthorizerID[counter] = dr["身分證字號"].ToString().Substring(0, 10);
                Authorizer[counter] = dr["員工編號"].ToString().Substring(0, 7);
                if (UserName == Authorizer[counter] && Password == AuthorizerID[counter])
                {
                    LoginName = UserName;
                    Open();
                    break;
                }
                else if (AdminLogin(UserName, Password))//admin login
                {
                    LoginName = "Admin";
                    Open();
                    break;
                }
                else
                    counter++;
            }

            cmd.Cancel();

            dr.Close();

            conn.Close();

            conn.Dispose();

            button5.Enabled = false;

            textBox1.Clear();
            textBox2.Clear();
        }


        private void Open()
        {
            label1.Enabled = true;
            label2.Enabled = true;
            label3.Enabled = true;
            MessageBox.Show("登入成功", "注意");
            pictureBox1.Visible = true;
            textBox1.Enabled = false;
            textBox2.Enabled = false;
        }

        private bool AdminLogin(string u, string p)
        {
            if (u == "admin" && p == "12345")
            {
                return true;
            }
            else
                return false;
        }



        private void button1_Click(object sender, EventArgs e)//log out
        {
            textBox1.Clear();
            textBox2.Clear();

            MessageBox.Show("登出", "注意");

            Application.Exit();
        }

        private void textBox2_KeyDown(object sender, KeyEventArgs e)//enter
        {
            if (e.KeyCode == Keys.Enter)

            {
                button5_Click(sender, e);
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {
            label6.Enabled = true;
            label6.Visible = true;
            label7.Enabled = true;
            label7.Visible = true;
        }

        private void label2_Click(object sender, EventArgs e)
        {
            label8.Visible = true;
            label8.Enabled = true;
            label9.Visible = true;
            label9.Enabled = true;
        }

        private void label3_Click(object sender, EventArgs e)
        {
            label11.Enabled = true;
            label11.Visible = true;
        }

        private void label6_Click(object sender, EventArgs e)//進貨驗收
        {
            Purchase f2 = new Purchase();

            f2.ReferenceForm(this);

            f2.StartPosition = FormStartPosition.CenterScreen;

            f2.Show();
        }



        private void label11_Click(object sender, EventArgs e)//採購驗收
        {
            PurchaseOrder f3 = new PurchaseOrder();

            f3.ReferenceForm(this);

            f3.StartPosition = FormStartPosition.CenterScreen;

            f3.Show();

        }

        private void label9_Click(object sender, EventArgs e)//客戶管理
        {
            CustomerManage f4 = new CustomerManage();

            f4.ReferenceForm(this);

            f4.StartPosition = FormStartPosition.CenterScreen;

            f4.Show();
        }

        private void label8_Click(object sender, EventArgs e)//訂單管理
        {
            OrderManage f5 = new OrderManage();

            f5.ReferenceForm(this);

            f5.StartPosition = FormStartPosition.CenterScreen;

            f5.Show();
        }

        private void label7_Click(object sender, EventArgs e)//銷貨出庫
        {
            OrderSend f6 = new OrderSend();

            f6.ReferenceForm(this);

            f6.StartPosition = FormStartPosition.CenterScreen;

            f6.Show();
        }

        private void pictureBox1_Click(object sender, EventArgs e)//搜尋
        {
            Serach f7 = new Serach();

            f7.ReferenceForm(this);

            f7.StartPosition = FormStartPosition.CenterScreen;

            f7.Show();
        }
    }
}