public partial class Form3 : Form
{
    Bitmap image1;
    Bitmap image2;

    public Form3()
    {
        InitializeComponent();
    }

    private void btnBrowse_Click(object sender, EventArgs e)
    {
        openFileDialog1.InitialDirectory = "c:\";
        openFileDialog1.FilterIndex = 2;
        openFileDialog1.RestoreDirectory = true;

        if (openFileDialog1.ShowDialog() == DialogResult.OK)
        {
            txtPicture.Text = openFileDialog1.FileName;
            pictureBox1.Image = new Bitmap(openFileDialog1.FileName);
            MemoryStream ms = new MemoryStream();
            pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
            byte[] img = ms.GetBuffer();
            ms.Close();

            using (var ms1 = new MemoryStream(img))
            {
                image1 = new Bitmap(ms1);
            }
        }
    }

    private void txtLogin_Click(object sender, EventArgs e)
    {
        string connectionString = "server=localhost; uid=root; password=p@ssw0rd; database=it3527_project;";
        MySqlConnection cn = new MySqlConnection(connectionString);
        cn.Open();
        string a = "SELECT count(*) FROM piclogin WHERE username = @user";
        MySqlCommand cmd = new MySqlCommand(a, cn);
        cmd.Parameters.AddWithValue("@user", txtUsername.Text);
        int temp = Convert.ToInt32(cmd.ExecuteScalar().ToString());

        if (temp == 1)
        {
            string aa = "SELECT * FROM piclogin WHERE username = @user";
            MySqlCommand cmd2 = new MySqlCommand(aa, cn);
            cmd2.Parameters.AddWithValue("@user", txtUsername.Text);
            MySqlDataReader dr = cmd2.ExecuteReader();
            while (dr.Read())
            {
                byte[] imgs = (byte[])dr["picture"];

                using (var ms = new MemoryStream(imgs))
                {
                    image2 = new Bitmap(ms);
                }

                if (compare(image1, image2))
                {
                    MessageBox.Show("Login Successful!");
                }

                else
                {
                    MessageBox.Show("Failed!");
                }
            }
        }

        else
        {
            MessageBox.Show("Please Enter A Valid User!");
        }
    }

    private bool compare(Bitmap bmp1, Bitmap bmp2)
    {
        bool equals = true;
        bool flag = true;

        if (bmp1.Size == bmp2.Size)
        {
            for (int x = 0; x < bmp1.Width; ++x)
            {
                for (int y = 0; y < bmp1.Height; ++y)
                {
                    if (bmp1.GetPixel(x, y) != bmp2.GetPixel(x, y))
                    {
                        equals = false;
                        flag = false;
                        break;
                    }
                }
                if (!flag)
                {
                    break;
                }
            }
        }
        else
        {
            equals = false;
        }
        return equals;
    }
}

public partial class Form2 : Form
{
    Bitmap image1;

    public Form2()
    {
        InitializeComponent();
    }

    private void btnBrowse_Click(object sender, EventArgs e)
    {
        openFileDialog1.InitialDirectory = "c:\";
        openFileDialog1.FilterIndex = 2;
        openFileDialog1.RestoreDirectory = true;

        if (openFileDialog1.ShowDialog() == DialogResult.OK)
        {
            txtPicture.Text = openFileDialog1.FileName;
            image1 = new Bitmap(openFileDialog1.FileName);
            pictureBox1.Image = image1;
        }


    }

    private void btnBack_Click(object sender, EventArgs e)
    {
        this.Hide();
        Form1 a = new Form1();
        a.Show();
    }

    private void txtRegister_Click(object sender, EventArgs e)
    {
        string connectionString = "server=localhost; uid=root; password=p@ssw0rd; database=it3527_project;";
        MySqlConnection cn = new MySqlConnection(connectionString);
        cn.Open();
        MemoryStream ms = new MemoryStream();
        pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
        byte[] img = ms.GetBuffer();
        ms.Close();

        string insert = "INSERT INTO piclogin (username, password, picture) VALUES (@username, @password, @picture)";
        MySqlCommand cmd = new MySqlCommand(insert, cn);
        cmd.Parameters.AddWithValue("@username", txtUsername.Text);
        cmd.Parameters.AddWithValue("@password", txtPassword.Text);
        cmd.Parameters.AddWithValue("@picture", img);
        MySqlDataReader dr = cmd.ExecuteReader();
        dr.Close();

        MessageBox.Show("Register Successfully!");
    }
}

public partial class Register : Window
{
    Bitmap display;
    BitmapImage im1;

    public Register()
    {
        InitializeComponent();
    }

    private void txtBrowse_Click(object sender, RoutedEventArgs e)
    {
        Microsoft.Win32.OpenFileDialog openfile = new Microsoft.Win32.OpenFileDialog();
        openfile.Filter = "JPEG Files (*.jpeg)|*.jpeg|PNG Files (*.png)|*.png|JPG Files (*.jpg)|*.jpg|GIF Files (*.gif)|*.gif|BMP Files (*.bmp)|*.bmp";
        Nullable<bool> result = openfile.ShowDialog();
        if (result == true)
        {
            txtPicture.Text = openfile.FileName;
            display = new Bitmap(openfile.FileName);
            picture.Source = new BitmapImage(new Uri(openfile.FileName));
            im1 = new BitmapImage(new Uri(openfile.FileName));
        }
    }

    private void btnRegister_Click(object sender, RoutedEventArgs e)
    {

        string connectionString = "server=localhost; uid=root; password=p@ssw0rd; database=it3527_project;";
        MySqlConnection cn = new MySqlConnection(connectionString);
        cn.Open();
        byte[] img;
        JpegBitmapEncoder encoder = new JpegBitmapEncoder();
        encoder.Frames.Add(BitmapFrame.Create(im1));
        using(MemoryStream ms = new MemoryStream())
        {
            encoder.Save(ms);
            img = ms.ToArray();
        }

        string insert = "INSERT INTO piclogin (username, password, picture) VALUES (@username, @password, @picture)";
        MySqlCommand cmd = new MySqlCommand(insert, cn);
        cmd.Parameters.AddWithValue("@username", txtUsername.Text);
        cmd.Parameters.AddWithValue("@password", txtPassword.Text);
        cmd.Parameters.AddWithValue("@picture", img);
        MySqlDataReader dr = cmd.ExecuteReader();
        dr.Close();

        MessageBox.Show("Register Successfully!");
    }

    private void btnBack_Click(object sender, RoutedEventArgs e)
    {
        MainWindow m1 = new MainWindow();
        m1.Show();
        this.Close();
    }
}

public partial class Login : Window
{
    Bitmap imageFromD;
    Bitmap imageFromU;
    BitmapImage imageFromUser;
    BitmapImage imageFromDB;
    byte[] imageFromUserL;

    public Login()
    {
        InitializeComponent();
    }

    private void txtBrowse_Click(object sender, RoutedEventArgs e)
    {
        Microsoft.Win32.OpenFileDialog openfile = new Microsoft.Win32.OpenFileDialog();
        openfile.Filter = "JPG Files (*.jpg)|*.jpg|JPEG Files (*.jpeg)|*.jpeg|PNG Files (*.png)|*.png|GIF Files (*.gif)|*.gif|BMP Files (*.bmp)|*.bmp";
        Nullable<bool> result = openfile.ShowDialog();
        if (result == true)
        {
            txtPicture.Text = openfile.FileName;
            imageFromU = new Bitmap(openfile.FileName);
            picture.Source = new BitmapImage(new Uri(openfile.FileName));
            imageFromUser = new BitmapImage(new Uri(openfile.FileName));
            JpegBitmapEncoder encoder = new JpegBitmapEncoder();
            encoder.Frames.Add(BitmapFrame.Create(imageFromUser));
            using (MemoryStream ms = new MemoryStream())
            {
                encoder.Save(ms);
                imageFromUserL = ms.ToArray();
            }


        }
    }

    private void btnLogin_Click(object sender, RoutedEventArgs e)
    {
         string connectionString = "server=localhost; uid=root; password=p@ssw0rd; database=it3527_project;";
        MySqlConnection cn = new MySqlConnection(connectionString);
        cn.Open();
        string a = "SELECT count(*) FROM piclogin WHERE username = @user";
        MySqlCommand cmd = new MySqlCommand(a, cn);
        cmd.Parameters.AddWithValue("@user", txtUsername.Text);
        int temp = Convert.ToInt32(cmd.ExecuteScalar().ToString());

        if (temp == 1)
        {
            string aa = "SELECT * FROM piclogin WHERE username = @user";
            MySqlCommand cmd2 = new MySqlCommand(aa, cn);
            cmd2.Parameters.AddWithValue("@user", txtUsername.Text);
            MySqlDataReader dr = cmd2.ExecuteReader();
            while (dr.Read())
            {
                byte[] imgs = (byte[])dr["picture"];
                using (var ms = new MemoryStream(imgs))
                {
                    var image = new BitmapImage();
                    image.BeginInit();
                    image.CacheOption = BitmapCacheOption.OnLoad; // here
                    image.StreamSource = ms;
                    image.EndInit();
                    imageFromDB = image;
                }

                using (MemoryStream outStream = new MemoryStream())
                {
                    JpegBitmapEncoder enc = new JpegBitmapEncoder();
                    enc.Frames.Add(BitmapFrame.Create(imageFromDB));
                    enc.Save(outStream);
                    imageFromD = new Bitmap(outStream);
                }

                if (compare(imageFromD,imageFromU))
                {
                    MessageBox.Show("Login Successful!");
                }

                else
                {
                    MessageBox.Show("Failed!");
                }
            }
        }

        else
        {
            MessageBox.Show("Please Enter A Valid User!");
        }

    }



    private bool compare(Bitmap bmp1, Bitmap bmp2)
    {
        bool equals = true;
        bool flag = true;

        if (bmp1.Size == bmp2.Size)
        {
            for (int x = 0; x < bmp1.Width; ++x)
            {
                for (int y = 0; y < bmp1.Height; ++y)
                {
                    if (bmp1.GetPixel(x, y) != bmp2.GetPixel(x, y))
                    {
                        equals = false;
                        flag = false;
                        break;
                    }
                }
                if (!flag)
                {
                    break;
                }
            }
        }
        else
        {
            equals = false;
        }
        return equals;
    }

    private void btnBack_Click(object sender, RoutedEventArgs e)
    {
        MainWindow m1 = new MainWindow();
        m1.Show();
        this.Close();
    }
}