RMyENb8Y

1using System;
2using System.Collections.Generic;
3using System.ComponentModel;
4using System.Data;
5using System.Diagnostics;
6using System.Drawing;
7using System.Linq;
8using System.Text;
9using System.Threading;
10using System.Threading.Tasks;
11using System.Windows.Forms;
12using MySql.Data.Common;
13using MySql.Data.MySqlClient;
14
15namespace WindowsFormsApp5
16{
17    public partial class Form1 : Form
18    {
19       
20        public Form1()
21        {
22            InitializeComponent();
23            tabControl1.TabPages.Remove(tabPage7);
24        }
25
26        private void Form1_Load(object sender, EventArgs e)
27        {
28            textBox2.Text = "Нажмите кнопку 'Обновить'!";
29            textBox3.Text = "Нажмите кнопку 'Обновить'!";
30            textBox4.Text = "Нажмите кнопку 'Обновить'!";
31            textBox5.Text = "Нажмите кнопку 'Обновить'!";
32            textBox6.Text = "Нажмите кнопку 'Обновить'!";
33        }
34
35        private void button1_Click(object sender, EventArgs e)
36        {
37            string connStr = "server=localhost;user=root;database=anabd;password=;SslMode=none;";
38            MySqlConnection conn = new MySqlConnection(connStr);
39            conn.Open();
40            #region program
41            //HelloText
42            string hellotext = "SELECT hellotext FROM program";
43            MySqlCommand commandhellotext = new MySqlCommand(hellotext, conn);
44            string rhellotext = commandhellotext.ExecuteScalar().ToString();
45            this.label1.Text = rhellotext;
46            //version
47            string version = "SELECT version FROM program";
48            MySqlCommand commandversion = new MySqlCommand(version, conn);
49            string rversion = commandversion.ExecuteScalar().ToString();
50            this.label3.Text = rversion;
51            //build
52            string build = "SELECT build FROM program";
53            MySqlCommand commandbuild = new MySqlCommand(build, conn);
54            string rbuild = commandbuild.ExecuteScalar().ToString();
55            //secret
56            string secret = "SELECT secretkey FROM program";
57            MySqlCommand commandsecret = new MySqlCommand(secret, conn);
58            string rsecret = commandsecret.ExecuteScalar().ToString();
59            //namec
60            string namec = "SELECT name FROM about";
61            MySqlCommand commandnamec = new MySqlCommand(namec, conn);
62            string rnamec = commandnamec.ExecuteScalar().ToString();
63            this.label15.Text = rnamec;
64            //addresc
65            string addresc = "SELECT addres FROM about";
66            MySqlCommand commandaddresc = new MySqlCommand(addresc, conn);
67            string raddresc = commandaddresc.ExecuteScalar().ToString();
68            this.label16.Text = raddresc;
69            //repairc
70            string repairc = "SELECT repair FROM about";
71            MySqlCommand commandrepairc = new MySqlCommand(repairc, conn);
72            string rrepairc = commandrepairc.ExecuteScalar().ToString();
73            this.label17.Text = rrepairc;
74            //phone
75            string phonec = "SELECT phone FROM about";
76            MySqlCommand commandphonec = new MySqlCommand(phonec, conn);
77            string rphonec = commandphonec.ExecuteScalar().ToString();
78            this.label18.Text = rphonec;
79            //mail
80            string mailc = "SELECT mail FROM about";
81            MySqlCommand commandmailc = new MySqlCommand(mailc, conn);
82            string rmailc = commandmailc.ExecuteScalar().ToString();
83            this.label19.Text = rmailc;
84            this.label2.Text = rbuild;
85            #endregion
86            dataGridView1.Rows.Add(10);
87            dataGridView2.Rows.Add(5);
88            dataGridView3.Rows.Add(5);
89            dataGridView4.Rows.Add(5);
90            #region users
91            //users
92            for (int i = 1; i <= 3; i++)
93            {
94                string id = "SELECT id FROM users WHERE id = " +i;
95                string name = "SELECT name FROM users WHERE id = " + i;
96                string surname = "SELECT surname FROM users WHERE id = " + i;
97                string login = "SELECT login FROM users WHERE id = " + i;
98                string email = "SELECT email FROM users WHERE id = " + i;
99                string password = "SELECT password FROM users WHERE id = " + i;
100                string group = "SELECT group1 FROM users WHERE id = " + i;
101                MySqlCommand commandid = new MySqlCommand(id, conn);
102                MySqlCommand commandname = new MySqlCommand(name, conn);
103                MySqlCommand commandsurname = new MySqlCommand(surname, conn);
104                MySqlCommand commandlogin = new MySqlCommand(login, conn);
105                MySqlCommand commandemail = new MySqlCommand(email, conn);
106                MySqlCommand commandpassword = new MySqlCommand(password, conn);
107                MySqlCommand commandgroup1 = new MySqlCommand(group, conn);
108                string requstid = commandid.ExecuteScalar().ToString();
109                string requstname = commandname.ExecuteScalar().ToString();
110                string requstsurname = commandsurname.ExecuteScalar().ToString();
111                string requstlogin = commandlogin.ExecuteScalar().ToString();
112                string requstemail = commandemail.ExecuteScalar().ToString();
113                string requstpassword = commandpassword.ExecuteScalar().ToString();
114                string requstgroup1 = commandgroup1.ExecuteScalar().ToString();
115                dataGridView1.Rows[i].Cells[0].Value = requstid;
116                dataGridView1.Rows[i].Cells[1].Value = requstname;
117                dataGridView1.Rows[i].Cells[2].Value = requstsurname;
118                dataGridView1.Rows[i].Cells[3].Value = requstlogin;
119                dataGridView1.Rows[i].Cells[4].Value = requstemail;
120                if (requstgroup1 == "0")
121                {
122                    dataGridView1.Rows[i].Cells[5].Value = "Пользователь";
123                }
124                if (requstgroup1 == "1")
125                {
126                    dataGridView1.Rows[i].Cells[5].Value = "Администратор";
127                }
128                if (requstgroup1 == "2")
129                {
130                    dataGridView1.Rows[i].Cells[5].Value = "Курер";
131                }
132            }
133            #endregion
134            #region stock
135            //stock
136            for (int i = 1; i <= 1; i++)
137            {
138                string stockid = "SELECT id FROM stock WHERE id = " + i;
139                string stockmark = "SELECT mark FROM stock WHERE id = " + i;
140                string stockmodel = "SELECT model FROM stock WHERE id = " + i;
141                string stockamount = "SELECT amount FROM stock WHERE id = " + i;
142                string stockpurchase = "SELECT purchase FROM stock WHERE id = " + i;
143                string stockvalue = "SELECT value FROM stock WHERE id = " + i;
144                string stockwhen = "SELECT when1 FROM stock WHERE id = " + i;
145                MySqlCommand commandstockid = new MySqlCommand(stockid, conn);
146                MySqlCommand commandstockmark = new MySqlCommand(stockmark, conn);
147                MySqlCommand commandstockmodel = new MySqlCommand(stockmodel, conn);
148                MySqlCommand commandstockamount = new MySqlCommand(stockamount, conn);
149                MySqlCommand commandstockpurchase = new MySqlCommand(stockpurchase, conn);
150                MySqlCommand commandstockvalue = new MySqlCommand(stockvalue, conn);
151                MySqlCommand commandstockwhen = new MySqlCommand(stockwhen, conn);
152                string rstockid = commandstockid.ExecuteScalar().ToString();
153                string rstockmark = commandstockmark.ExecuteScalar().ToString();
154                string rstockmodel = commandstockmodel.ExecuteScalar().ToString();
155                string rstockamount = commandstockamount.ExecuteScalar().ToString();
156                string rstockpurchase = commandstockpurchase.ExecuteScalar().ToString();
157                string rstockvalue = commandstockvalue.ExecuteScalar().ToString();
158                string rstockwhen = commandstockwhen.ExecuteScalar().ToString();
159                dataGridView2.Rows[i].Cells[0].Value = rstockid;
160                dataGridView2.Rows[i].Cells[1].Value = rstockmark;
161                dataGridView2.Rows[i].Cells[2].Value = rstockmodel;
162                dataGridView2.Rows[i].Cells[3].Value = rstockamount;
163                dataGridView2.Rows[i].Cells[4].Value = rstockpurchase;
164                dataGridView2.Rows[i].Cells[5].Value = rstockvalue;
165                dataGridView2.Rows[i].Cells[6].Value = rstockwhen;
166            }
167            #endregion
168            #region orders
169            //orders
170            for (int i = 1; i <= 1; i++)
171            {
172                string ordersid = "SELECT id FROM orders WHERE id = " + i;
173                string ordersname = "SELECT name FROM orders WHERE id = " + i;
174                string orderssurname = "SELECT surname FROM orders WHERE id = " + i;
175                string ordersmark = "SELECT mark FROM orders WHERE id = " + i;
176                string ordersmodel = "SELECT model FROM orders WHERE id = " + i;
177                string ordersquantity = "SELECT quantity FROM orders WHERE id = " + i;
178                string ordersphone = "SELECT phone FROM orders WHERE id = " + i;
179                string ordersproblem = "SELECT problem FROM orders WHERE id = " + i;
180                MySqlCommand commandordersid = new MySqlCommand(ordersid, conn);
181                MySqlCommand commandordersname = new MySqlCommand(ordersname, conn);
182                MySqlCommand commandorderssurname = new MySqlCommand(orderssurname, conn);
183                MySqlCommand commandordersmark = new MySqlCommand(ordersmark, conn);
184                MySqlCommand commandordersmodel = new MySqlCommand(ordersmodel, conn);
185                MySqlCommand commandordersquantity = new MySqlCommand(ordersquantity, conn);
186                MySqlCommand commandordersphone = new MySqlCommand(ordersphone, conn);
187                MySqlCommand commandordersproblem = new MySqlCommand(ordersproblem, conn);
188                string rordersid = commandordersid.ExecuteScalar().ToString();
189                string rordersname = commandordersname.ExecuteScalar().ToString();
190                string rorderssurname = commandorderssurname.ExecuteScalar().ToString();
191                string rordersmark = commandordersmark.ExecuteScalar().ToString();
192                string rordersmodel = commandordersmodel.ExecuteScalar().ToString();
193                string rorderskquantity = commandordersquantity.ExecuteScalar().ToString();
194                string rordersphone = commandordersphone.ExecuteScalar().ToString();
195                string rordersproblem = commandordersproblem.ExecuteScalar().ToString();
196                dataGridView3.Rows[i].Cells[0].Value = rordersid;
197                dataGridView3.Rows[i].Cells[1].Value = rordersname;
198                dataGridView3.Rows[i].Cells[2].Value = rorderssurname;
199                dataGridView3.Rows[i].Cells[3].Value = rordersmark;
200                dataGridView3.Rows[i].Cells[4].Value = rordersmodel;
201                dataGridView3.Rows[i].Cells[5].Value = rorderskquantity;
202                dataGridView3.Rows[i].Cells[6].Value = rordersphone;
203                dataGridView3.Rows[i].Cells[7].Value = rordersproblem;
204            }
205            #endregion
206            #region goods
207            for (int i = 1; i <= 1; i++)
208            {
209                string goodsid = "SELECT id FROM goods WHERE id = " +1;
210                string goodsmark = "SELECT mark FROM goods WHERE id = " + 1;
211                string goodsmodel = "SELECT model FROM goods WHERE id = " + 1;
212                string goodsquantity = "SELECT quantity FROM goods WHERE id = " + 1;
213                string goodspurchase = "SELECT purchase FROM goods WHERE id = " + 1;
214                string goodsprice = "SELECT price FROM goods WHERE id = " + 1;
215                string goodsdate = "SELECT date FROM goods WHERE id = " + 1;
216                MySqlCommand commandgoodsid = new MySqlCommand(goodsid, conn);
217                MySqlCommand commandgoodsmark = new MySqlCommand(goodsmark, conn);
218                MySqlCommand commandgoodsmodel = new MySqlCommand(goodsmodel, conn);
219                MySqlCommand commandgoodsquantity = new MySqlCommand(goodsquantity, conn);
220                MySqlCommand commandgoodspurchase = new MySqlCommand(goodspurchase, conn);
221                MySqlCommand commanddersprice = new MySqlCommand(goodsprice, conn);
222                MySqlCommand commanddersdate = new MySqlCommand(goodsdate, conn);
223                string rgoodsid = commandgoodsid.ExecuteScalar().ToString();
224                string rgoodsmark = commandgoodsmark.ExecuteScalar().ToString();
225                string rgoodsmodel = commandgoodsmodel.ExecuteScalar().ToString();
226                string rgoodsquantity = commandgoodsquantity.ExecuteScalar().ToString();
227                string rgoodspurchase = commandgoodspurchase.ExecuteScalar().ToString();
228                string rgoodsprice = commanddersprice.ExecuteScalar().ToString();
229                string rgoodsdate = commanddersdate.ExecuteScalar().ToString();
230                dataGridView4.Rows[i].Cells[0].Value = rgoodsid;
231                dataGridView4.Rows[i].Cells[1].Value = rgoodsmark;
232                dataGridView4.Rows[i].Cells[2].Value = rgoodsmodel;
233                dataGridView4.Rows[i].Cells[3].Value = rgoodsquantity;
234                dataGridView4.Rows[i].Cells[4].Value = rgoodspurchase;
235                dataGridView4.Rows[i].Cells[5].Value = rgoodsprice;
236                dataGridView4.Rows[i].Cells[6].Value = rgoodsdate;
237            }
238            
239            
240            
241            #endregion
242
243
244            dataGridView1.Rows[0].Cells[0].Value = "Индификатор";
245            dataGridView1.Rows[0].Cells[1].Value = "Имя";
246            dataGridView1.Rows[0].Cells[2].Value = "Фамилия";
247            dataGridView1.Rows[0].Cells[3].Value = "Логин";
248            dataGridView1.Rows[0].Cells[4].Value = "Почта";
249            dataGridView1.Rows[0].Cells[5].Value = "Группа";
250
251            dataGridView2.Rows[0].Cells[0].Value = "Индификатор";
252            dataGridView2.Rows[0].Cells[1].Value = "марка";
253            dataGridView2.Rows[0].Cells[2].Value = "Модель";
254            dataGridView2.Rows[0].Cells[3].Value = "Кол-во";
255            dataGridView2.Rows[0].Cells[4].Value = "Закупка";
256            dataGridView2.Rows[0].Cells[5].Value = "Цена";
257            dataGridView2.Rows[0].Cells[6].Value = "Когда";
258
259            dataGridView3.Rows[0].Cells[0].Value = "Индификатор";
260            dataGridView3.Rows[0].Cells[1].Value = "Имя";
261            dataGridView3.Rows[0].Cells[2].Value = "Фамилия";
262            dataGridView3.Rows[0].Cells[3].Value = "Марка";
263            dataGridView3.Rows[0].Cells[4].Value = "Модуль";
264            dataGridView3.Rows[0].Cells[5].Value = "Кол-во";
265            dataGridView3.Rows[0].Cells[6].Value = "Телефон";
266            dataGridView3.Rows[0].Cells[7].Value = "Проблема";
267
268            dataGridView4.Rows[0].Cells[0].Value = "Индификатор";
269            dataGridView4.Rows[0].Cells[1].Value = "Марка";
270            dataGridView4.Rows[0].Cells[2].Value = "Модуль";
271            dataGridView4.Rows[0].Cells[3].Value = "Кол-во";
272            dataGridView4.Rows[0].Cells[4].Value = "Закупка";
273            dataGridView4.Rows[0].Cells[5].Value = "Цена";
274            dataGridView4.Rows[0].Cells[6].Value = "Дата";
275
276            textBox2.Text = rhellotext;
277            textBox3.Text = rsecret;
278            textBox4.Text = rversion;
279            textBox5.Text = rbuild;
280            
281
282            conn.Close();
283        }
284
285        private void label48_Click(object sender, EventArgs e)
286        {
287
288        }
289
290        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
291        {
292            
293        }
294
295        private void button2_Click(object sender, EventArgs e)
296        {
297            MessageBox.Show("Вся информация перезаписанна", "Сохранение");
298        }
299
300        private void button3_Click_1(object sender, EventArgs e)
301        {
302            dataGridView1.Rows.Add(1);
303        }
304
305        private void button5_Click(object sender, EventArgs e)
306        {
307            dataGridView2.Rows.Add(1);
308        }
309
310        private void button4_Click(object sender, EventArgs e)
311        {
312            MessageBox.Show("Вся информация перезаписанна", "Сохранение");
313        }
314
315        private void button6_Click(object sender, EventArgs e)
316        {
317            MessageBox.Show("Вся информация перезаписанна", "Сохранение");
318        }
319
320        private void button7_Click(object sender, EventArgs e)
321        {
322            dataGridView3.Rows.Add(1);
323        }
324
325        private void button8_Click(object sender, EventArgs e)
326        {
327            MessageBox.Show("Вся информация перезаписанна", "Сохранение");
328        }
329
330        private void button9_Click(object sender, EventArgs e)
331        {
332            dataGridView4.Rows.Add(1);
333        }
334
335        private void button10_Click(object sender, EventArgs e)
336        {
337            textBox1.Visible = true;
338            MessageBox.Show("Введите секретный код для получение доступа", "Вход");
339            button10.Visible = false;
340            button11.Visible = true;
341        }
342
343        private void button11_Click(object sender, EventArgs e)
344        {
345            string connStr = "server=localhost;user=root;database=anabd;password=;SslMode=none;";
346            MySqlConnection conn = new MySqlConnection(connStr);
347            conn.Open();
348            string secretkey = "SELECT secretkey FROM program";
349            MySqlCommand commandsecretkey = new MySqlCommand(secretkey, conn);
350            string rsecretkey = commandsecretkey.ExecuteScalar().ToString();
351            if(textBox1.Text == rsecretkey)
352            {
353                MessageBox.Show("Вы ввели верный код","Логин");
354                tabControl1.TabPages.Add(tabPage7);
355                textBox1.Visible = false;
356                button11.Visible = false;
357                button13.Visible = true;
358            }
359            else
360            {
361                MessageBox.Show("Вы ввели не верный код", "Логин");
362            }
363            conn.Close();
364        }
365
366        private void button13_Click(object sender, EventArgs e)
367        {
368            tabControl1.TabPages.Remove(tabPage7);
369            button10.Visible = true;
370            textBox1.Text = null;
371            button13.Visible = false;
372        }
373
374        private void textBox2_TextChanged(object sender, EventArgs e)
375        {
376
377        }
378
379        private void textBox3_TextChanged(object sender, EventArgs e)
380        {
381
382        }
383    }
384}