TableEditor/Form1.cs at master · ddael/TableEditor · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
using DocumentFormat.OpenXml.Drawing;

namespace WinFormsApp1
{
    public partial class Form1 : Form
    {
        private bool MultiFileMode { get; set; } = false;

        private List<Student> data = [];
        private List<Student> filtered = [];

        private string Name = string.Empty;

        public Form1()
        {
            InitializeComponent();
        }

        private void ImportButton_Click(object sender, EventArgs e)
        {
            if (!MultiFileMode)
            {
                using var dialog = new OpenFileDialog { Filter = "Excel Files|*.xlsx;*.xls" };
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    Name = System.IO.Path.GetFileNameWithoutExtension(dialog.SafeFileName);
                    data = Processor.ReadFromFile(dialog.FileName);

                    filtered = data.Select(s => new Student
                    {
                        FullName = s.FullName,
                        Cluster = s.Cluster,
                        Group = s.Group,
                        Tag = s.Tag,
                        Cohort = s.Cohort,
                        Region = s.Region,
                        Results = s.Results
                    }
                    ).ToList();

                    filteredGrid.DataSource = null;
                    filteredGrid.DataSource = filtered;

                    MessageBox.Show($"Импортировано записей: {data.Count}");
                }
            }

            else
            {
                using var dialog = new OpenFileDialog { Filter = "Excel Files|*.xlsx;*.xls", Multiselect = true };
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    var fileNames = dialog.FileNames;

                    foreach ( var file in fileNames )
                    {
                        data.AddRange(Processor.ReadFromFile(file));
                    }

                    filtered = data.Select(s => new Student
                    {
                        FullName = s.FullName,
                        Cluster = s.Cluster,
                        Group = s.Group,
                        Tag = s.Tag,
                        Cohort = s.Cohort,
                        Region = s.Region,
                        Results = s.Results
                    }
                    ).ToList();

                    filteredGrid.DataSource = null;
                    filteredGrid.DataSource = filtered;

                    MessageBox.Show($"Импортировано записей: {data.Count}");
                }
            }
        }

        private void ExportButton_Click(object sender, EventArgs e)
        {
            if(!MultiFileMode)
            {
                if (data.Count == 0)
                {
                    MessageBox.Show("Нет данных для экспорта.");
                    return;
                }

                using var dialog = new SaveFileDialog
                {
                    Filter = "Excel Files|*.xlsx",
                    FileName = $"{Name}_formated"
                };

                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    Processor.WriteToFile(dialog.FileName, data);
                    MessageBox.Show("Файл сохранён.");
                }
            }
            else
            {
                if (data.Count == 0)
                {
                    MessageBox.Show("Нет данных для экспорта.");
                    return;
                }

                using var folderDialog = new FolderBrowserDialog
                {
                    Description = "Выберите папку для создания отчетов по кластерам",
                    InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop)
                };

                if (folderDialog.ShowDialog() == DialogResult.OK)
                {
                    //var folder = folderDialog.SelectedPath;
                    Processor.WriteFilesToDir(folderDialog.SelectedPath, data);
                    MessageBox.Show("Работа сделана.");
                    data = [];
                    filtered = [];
                    filteredGrid.DataSource = null;
                }
            }
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            MultiFileMode = checkBox1.Checked;
        }
    }
}