//private void btn_signup_Click(object sender, EventArgs e)
        //{

        //    DBcon.con.Open();



        //    cmd.ExecuteNonQuery();
        //    DBcon.con.Close();


        //}

        private void Login_Signup_Load(object sender, EventArgs e)
        {
            LogOutStatus = false;

            panel_login.Hide();
            Signup_panel.Hide();

            //Data Source=DESKTOP-0VTF41Q\SQLEXPRESS;Initial Catalog=TheProject;Integrated Security=True

            conString = "Data Source=" + ServerName + "" + ";Initial Catalog=TheProject;Integrated Security=True";

            if (!CheckDBExists(conString))
            {
                Signup_panel.Show();
            }

            else
            {
                conString = "Data Source=" + ServerName + "" + ";Initial Catalog=TheProject;Integrated Security=True";
                FinalCon.ConnectionString = conString;
                panel_login.Show();
            }
        }
        private void SignUp_button_Click(object sender, EventArgs e)
        {
            string username = textBox_username_signup.Text;
            string pass     = textBox_pass_signup.Text;
            string repass   = textBox_conPass_signup.Text;

            if (pass != repass)
            {
                label_Status_signup.ForeColor = Color.Red;
                label_Status_signup.Text      = "Password Not Matched";
                return;
            }


            conString = "Data Source=" + Environment.MachineName + "" + ";Initial Catalog=;Integrated Security=True";
            SqlConnection Connection = new SqlConnection(conString);
            string        script     = File.ReadAllText(@"..\..\Scripts\script.sql");

            // split script on GO command
            IEnumerable <string> commandStrings = Regex.Split(script, @"^\s*GO\s*$", RegexOptions.Multiline | RegexOptions.IgnoreCase);

            Connection.Open();
            foreach (string commandString in commandStrings)
            {
                if (!string.IsNullOrWhiteSpace(commandString.Trim()))
                {
                    using (var command = new SqlCommand(commandString, Connection))
                    {
                        command.ExecuteNonQuery();
                    }
                }
            }

            Connection.Close();
            conString = "Data Source=" + ServerName + "" + ";Initial Catalog=TheProject;Integrated Security=True";
            FinalCon.ConnectionString = conString;

            //if (pass == repass)
            {
                string sq = @"insert into LoginInfoTable values(@NewName,@NewPass,1)";

                SqlCommand dbCommand = new SqlCommand(sq, FinalCon);
                dbCommand.Parameters.AddWithValue("@NewName", username);
                dbCommand.Parameters.AddWithValue("@NewPass", pass);

                // SqlCommand cmd1 = new SqlCommand();
                //   cmd1.Connection = FinalCon;
                //   cmd1.CommandText = "'" + username + "','" + pass + "',1)";
                FinalCon.Open();
                dbCommand.ExecuteNonQuery();
                FinalCon.Close();

                //    cmd1.CommandText = "insert into LoginInfoTable values('" + username + "','" + pass + "',1)";
                //    FinalCon.Open();
                //   cmd1.ExecuteNonQuery();
                //   FinalCon.Close();

                Signup_panel.Hide();
                panel_login.Show();
                label_Status_signup.ForeColor = Color.Green;
                label_Status_signup.Text      = "Registered Successfully";
            }
        }