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;
using System.IO;
using SixLabors.ImageSharp;
using SixLabors.ImageSharp.Processing;
using SixLabors.ImageSharp.PixelFormats;
namespace Database_Form
{
    public partial class UserInfo : Form
    {
        private string firstName;
        private string lastName;
        private string username;
        public UserInfo(string username)
        {
            InitializeComponent();
            this.username = username;
            // 从数据库中检索人的名字和姓氏
            string matricule = "";
            byte[] imageData = null;
            using (SqlConnection connection = new SqlConnection("我隐藏了这部分代码!!"))
            {
                connection.Open();
                SqlCommand command = new SqlCommand("SELECT Matricule, ProfilePicture FROM Login WHERE Username = @Username", connection);
                command.Parameters.AddWithValue("@Username", username);
                SqlDataReader reader = command.ExecuteReader();
                if (reader.Read())
                {
                    matricule = reader.GetString(0);
                    if (!reader.IsDBNull(1))
                    {
                        imageData = (byte[])reader["ProfilePicture"];
                    }
                }
                reader.Close();
                command = new SqlCommand("SELECT Nom, Prenom FROM Salarie WHERE Matricule = @Matricule", connection);
                command.Parameters.AddWithValue("@Matricule", matricule);
                reader = command.ExecuteReader();
                if (reader.Read())
                {
                    firstName = reader.GetString(0);
                    lastName = reader.GetString(1);
                }
                reader.Close();
            }
            // 设置标签的文本为人的名字和姓氏
            nameLabel.Text = firstName;
            lastNameLabel.Text = lastName;
            // 在图片框中显示个人资料图片
            if (imageData != null)
            {
                using (MemoryStream ms = new MemoryStream(imageData))
                {
                    Image<Rgba32> image = Image.Load<Rgba32>(ms);
                    image.Mutate(x => x.Resize(new Size(pictureBox1.Width, pictureBox1.Height)));
                    pictureBox1.Image = image.ToBitmap();
                }
            }
        }
        private void backButton_Click_1(object sender, EventArgs e)
        {
            MainPage mainPageForm = new MainPage(username);
            mainPageForm.Show();
            this.Close();
        }
        private void UserInfo_Load(object sender, EventArgs e)
        {
        }
        private void label2_Click(object sender, EventArgs e)
        {
        }
        private void pictureBox1_Click(object sender, EventArgs e)
        {
        }
    }
}