Statistics.cs

using Microsoft.Data.SqlClient;
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.Windows.Forms.DataVisualization.Charting;

namespace ConstHard
{
    public partial class Statistics : Form
    {
        public Statistics()
        {
            InitializeComponent();
        }

        private void userstat_Click(object sender, EventArgs e)
        {
            string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\temp\Register.mdf;Integrated Security=True;Connect Timeout=30";

            string query = @"
        SELECT r.Username, COUNT(t.Id) AS TaskCount
        FROM Tasks t
        JOIN Registpeople r ON t.CreatedByUserId = r.Id
        WHERE t.Status = 'Finalized'
        GROUP BY r.Username
        ORDER BY r.Username";

            DataTable dt = new DataTable();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                using (SqlCommand cmd = new SqlCommand(query, conn))
                using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
                {
                    adapter.Fill(dt);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error loading statistics: " + ex.Message);
                return;
            }

            // Diagram tisztítása
            chart1.Series.Clear();
            chart1.ChartAreas.Clear();
            chart1.Legends.Clear();

            // ChartArea létrehozása
            chart1.ChartAreas.Add(new ChartArea("MainArea"));

            Legend legend = new Legend("UsersLegend");
            legend.Docking = Docking.Right;
            chart1.Legends.Add(legend);

            // Színek tömbje
            Color[] colors = new Color[] { Color.Green,  Color.Purple, Color.Brown, Color.Cyan, Color.Magenta};

           
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string username = dt.Rows[i]["Username"].ToString();
                int taskCount = Convert.ToInt32(dt.Rows[i]["TaskCount"]);

                Series series = new Series(username)
                {
                    ChartType = SeriesChartType.Column,
                    Color = colors[i % colors.Length],
                    IsValueShownAsLabel = true,
                    Legend = "UsersLegend"
                };

                // Egy pontot adunk hozzá a series-hez (a feladatok számával)
                series.Points.AddXY(username, taskCount);

                chart1.Series.Add(series);
            }

            // Tengelyek beállítása
            var chartArea = chart1.ChartAreas[0];
            chartArea.AxisX.Interval = 5;
            chartArea.AxisY.Title = "Number of finalized tasks";
            chartArea.AxisY.Interval = 1;
            chart1.Invalidate();
 }


        private void taskstatus_Click(object sender, EventArgs e)
        {

            string connectionString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\temp\\Register.mdf;Integrated Security=True;Connect Timeout=30";
            string query = @"
        SELECT Status, COUNT(*) AS TaskCount
        FROM Tasks
        GROUP BY Status";

            using (SqlConnection connection = new SqlConnection(connectionString))
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                try
                {
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();

                    chart2.Series.Clear();
                    chart2.Titles.Clear();
                    chart2.Titles.Add("Tasks by Status");

                    Series series = new Series();
                    series.ChartType = SeriesChartType.Pie;
                    series.IsValueShownAsLabel = true;

                    while (reader.Read())
                    {
                        string status = reader["Status"].ToString();
                        int count = Convert.ToInt32(reader["TaskCount"]);
                        series.Points.AddXY(status, count);
                    }

                    chart2.Series.Add(series);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error loading task status chart: " + ex.Message);
                }
            }
        }

        public DataTable GetFinalizedTaskCountsPerUser(string connectionString)
        {
            throw new NotImplementedException();
        }
    }
}