private void button2_Click(object sender, EventArgs e)
        {
            this.Hide();
            this.Close();
            AdminForm AF = new AdminForm();

            AF.ShowDialog();

            this.Close();

            if (AF.i == 1)
            {
                LoginForm L1 = new LoginForm();
                L1.ShowDialog();
            }

            else
            {
                MainForm m1 = new MainForm();
                m1.ShowDialog();
            }
        }
        private void button3_Click(object sender, EventArgs e)
        {
            this.Hide();
            this.Close();
            ReceptionistProfile R1 = new ReceptionistProfile();

            R1.ShowDialog();

            this.Close();

            if (R1.i == 1)
            {
                LoginForm L1 = new LoginForm();
                L1.ShowDialog();
            }

            else
            {
                Receptionist R11 = new Receptionist();
                R11.ShowDialog();
            }
        }
        private void button3_Click(object sender, EventArgs e)
        {
            SQLiteConnection sqlite_conn;
            SQLiteCommand    sqlite_cmd;
            SQLiteDataReader sqlite_datareader;

            if (!File.Exists("ReceptionistLogin.db"))
            {
                sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;New=True;Compress=True;");

                sqlite_conn.Open();

                sqlite_cmd = sqlite_conn.CreateCommand();


                sqlite_cmd.CommandText = "CREATE TABLE Login (Username varchar2 (100) NOT NULL UNIQUE, Password varchar2 (100));";
                sqlite_cmd.ExecuteNonQuery();


                sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('aqibahmed60', 'abcabc');";
                sqlite_cmd.ExecuteNonQuery();

                sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('ossaidahmed', '1234');";
                sqlite_cmd.ExecuteNonQuery();

                sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('HafizHarisAlam', 'otaku');";
                sqlite_cmd.ExecuteNonQuery();


                sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******'and Password='******'";
                sqlite_datareader      = sqlite_cmd.ExecuteReader();

                Receptionists R10 = new Receptionists();
                R10.SetData(textBox1.Text, textBox2.Text);

                if (sqlite_datareader.Read())
                {
                    sqlite_conn.Close();
                    Billing_DB();
                    this.Hide();
                    Receptionist R1 = new Receptionist();
                    R1.ShowDialog();

                    LoginForm L1 = new LoginForm();
                    L1.ShowDialog();
                }

                else
                {
                    MessageBox.Show("Invalid Login", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    textBox1.Clear();
                    textBox2.Clear();
                }

                sqlite_conn.Close();
            }


            else
            {
                sqlite_conn = new SQLiteConnection("Data Source=ReceptionistLogin.db;Version=3;Compress=True;");
                sqlite_conn.Open();
                sqlite_cmd = sqlite_conn.CreateCommand();

                sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******'and Password='******'";

                Receptionists R10 = new Receptionists();
                R10.SetData(textBox1.Text, textBox2.Text);


                sqlite_datareader = sqlite_cmd.ExecuteReader();
                if (sqlite_datareader.Read())
                {
                    this.Hide();
                    sqlite_conn.Close();
                    Receptionist R1 = new Receptionist();
                    R1.ShowDialog();

                    LoginForm L1 = new LoginForm();
                    L1.ShowDialog();
                }

                else
                {
                    MessageBox.Show("Invalid Login", "Login Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    textBox1.Clear();
                    textBox2.Clear();
                }


                sqlite_conn.Close();
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            // We use these three SQLite objects:

            SQLiteConnection sqlite_conn;
            SQLiteCommand    sqlite_cmd;
            SQLiteDataReader sqlite_datareader;

            if (!File.Exists("Login.db"))
            {
                // create a new database connection:
                sqlite_conn = new SQLiteConnection("Data Source=Login.db;Version=3;New=True;Compress=True;");

                // open the connection
                sqlite_conn.Open();

                // create a new SQL command:
                sqlite_cmd = sqlite_conn.CreateCommand();

                // Let the SQLiteCommand object know our SQL-Query:
                sqlite_cmd.CommandText = "CREATE TABLE Login (Username varchar2 (100), Password varchar2 (100));";


                // Now lets execute the SQL ;D
                sqlite_cmd.ExecuteNonQuery();

                // Lets insert something into our new table:
                sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('aqibahmed60', 'abcabc');";

                // And execute this again ;D
                sqlite_cmd.ExecuteNonQuery();

                // ...and inserting another line:
                sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('ossaidahmed', '1234');";

                // And execute this again ;D
                sqlite_cmd.ExecuteNonQuery();

                // ...and inserting another line:
                sqlite_cmd.CommandText = "INSERT INTO Login (Username,Password) VALUES ('HafizHarisAlam', 'otaku');";

                // And execute this again ;D
                sqlite_cmd.ExecuteNonQuery();

                // But how do we read something out of our table ?
                // First lets build a SQL-Query again:
                sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******'and Password='******'";

                Administator A1 = new Administator();

                A1.SetData(textBox1.Text, textBox2.Text);

                // Now the SQLiteCommand object can give us a DataReader-Object:
                sqlite_datareader = sqlite_cmd.ExecuteReader();


                // The SQLiteDataReader allows us to run through the result lines:
                if (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read
                {
                    sqlite_conn.Close();
                    Employee_DB();
                    Product_DB();
                    Package_DB();
                    Total_Cost_DB();
                    Make_Up_DB();
                    Cutting_DB();
                    Nail_Art_DB();
                    this.Hide();
                    MainForm m1 = new MainForm();
                    m1.ShowDialog();

                    LoginForm L1 = new LoginForm();
                    L1.ShowDialog();
                }

                else
                {
                    MessageBox.Show("Invalid Login", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    textBox1.Clear();
                    textBox2.Clear();
                }

                // We are ready, now lets cleanup and close our connection:
                sqlite_conn.Close();
            }


            else
            {
                sqlite_conn = new SQLiteConnection("Data Source=Login.db;Version=3;Compress=True;");
                sqlite_conn.Open();
                sqlite_cmd = sqlite_conn.CreateCommand();

                // But how do we read something out of our table ?
                // First lets build a SQL-Query again:
                sqlite_cmd.CommandText = "SELECT * FROM Login where Username='******'and Password='******'";
                Administator A1 = new Administator();

                A1.SetData(textBox1.Text, textBox2.Text);
                // Now the SQLiteCommand object can give us a DataReader-Object:
                sqlite_datareader = sqlite_cmd.ExecuteReader();

                // The SQLiteDataReader allows us to run through the result lines:
                if (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read
                {
                    this.Hide();
                    sqlite_conn.Close();
                    MainForm m1 = new MainForm();
                    m1.ShowDialog();

                    LoginForm L1 = new LoginForm();
                    L1.ShowDialog();
                }

                else
                {
                    MessageBox.Show("Invalid Login", "Login Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    textBox1.Clear();
                    textBox2.Clear();
                }

                sqlite_conn.Close();
                // We are ready, now lets cleanup and close our connection
            }
        }