Файл: Автоматизация деятельности риэлтора.docx

Таким образом, из-за отсутствия одного из разделов выполненная работа частично отвечает поставленным задачам и цели курсовой работы.

СПИСОК ЛИТЕРАТУРЫ

1. 
   Программирование C#| Приложение "Магазин" ч.1. // GTai / YouTube [Сайт]. (08.01.2020). URL: https://www.youtube.com/watch?v=1oM5vBw4Bbk&t=421s (Дата обращения: 21.12.2022)
   
2. 
   Уроки C# .NET Windows Forms / #3 - Подключение MySQL и создание базы данных.// Гоша Дударь / YouTube [Сайт]. (10.09.2019). URL: https://www.youtube.com/watch?v=pNTQy48Pafc&t=1185s (Дата обращения: 23.12.2022)
   
3. 
   Уроки C# .NET Windows Forms / #4 - Авторизация пользователя через базу данных.// Гоша Дударь / YouTube [Сайт]. (15.09.2019). URL: https://www.youtube.com/watch?v=eLQAgHexThM&t=87s (Дата обращения: 23.12.2022)
   
4. 
   C# + MSSQL | Создаём и подключаем базу данных к Windows Forms | SQL Запросы.// CyberDanger / YouTube [Сайт]. (15.06.2021). URL: https://www.youtube.com/watch?v=mWgGsfyaflw&list=PLZ1ih3EaMMaPxxjQcaSN1K-suneVGWMhS(Дата обращения: 24.12.2022)
   
5. 
   C# + MSSQL |РЕГИСТРАЦИЯ И АВТОРИЗАЦИЯ ПОЛЬЗОВАТЕЛЕЙ. // CyberDanger / YouTube [Сайт]. (14.01.2022).URL: https://www.youtube.com/watch?v=x1G3zc6Tzjw&list=PLZ1ih3EaMMaPxxjQcaSN1K-suneVGWMhS&index=2 (Дата обращения: 24.12.2022)
   
6. 
   Lucidchart.com [Сайт]. (2022). URL : https://www.lucidchart.com/pages/ru/erd-%D0%B4%D0%B8%D0%B0%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%B0(дата обращения: 26.12.2022).
   

Приложение А

Исходный код: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;namespace FormsHjemme{public partial class Form1 : Form{public Form1(){InitializeComponent();}private void button2_Click(object sender, EventArgs e){Form3 users = new Form3();users.Show();this.Hide(); }private void label1_Click(object sender, EventArgs e){}private void button1_Click(object sender, EventArgs e){Form2 users = new Form2();users.Show(); this.Hide();}private void button3_Click(object sender, EventArgs e){Form7 reg = new Form7();reg.Show();this.Hide();}}}using MySql.Data.MySqlClient;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;namespace FormsHjemme{public partial class Form2 : Form{public Form2(){InitializeComponent();}private void label1_Click(object sender, EventArgs e){}private void button1_Click(object sender, EventArgs e){}private void label2_Click(object sender, EventArgs e){}private void button1_Click_1(object sender, EventArgs e){}private void textBox1_TextChanged(object sender, EventArgs e){}private void textBox2_TextChanged(object sender, EventArgs e){}private void label3_Click(object sender, EventArgs e){}private void label1_Click_1(object sender, EventArgs e){}private void buttonLogin_Click(object sender, EventArgs e){//String loginUser = login.Text;//String passUser = password.Text;//Class1 db = new Class1();//DataTable table = new DataTable();//MySqlDataAdapter adapter = new MySqlDataAdapter();//MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `login`= @uL AND `password`= @uP", db.getConnection());

---

//command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = loginUser;//command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = passUser;//adapter.SelectCommand = command;//adapter.Fill(table);//if (table.Rows.Count > 0)//{// ////Form4 enter = new Form4();// ////enter.Show();// ////this.Hide();// //var mainManu = new Form4();// //mainManu.Show();// //Hide();// MessageBox.Show("yes");//}//else//{// MessageBox.Show("Нет такого логина или пароля");//}Form4 enter = new Form4();enter.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form3 : Form{public Form3(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){Form4 enter = new Form4();enter.Show();this.Hide();}private void textBox2_TextChanged(object sender, EventArgs e){}private void textBox1_TextChanged(object sender, EventArgs e){}private void label3_Click(object sender, EventArgs e){}private void label2_Click(object sender, EventArgs e){}private void label1_Click(object sender, EventArgs e){}private void button1_Click_1(object sender, EventArgs e){Form10 enter = new Form10();enter.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form4 : Form{public Form4(){InitializeComponent();}private void label1_Click(object sender, EventArgs e){}private void radioButton4_CheckedChanged(object sender, EventArgs e){}private void label2_Click(object sender, EventArgs e){}private void label4_Click(object sender, EventArgs e){}private void label7_Click(object sender, EventArgs e){}private void label8_Click(object sender, EventArgs e){}private void button1_Click(object sender, EventArgs e){Form5 view = new Form5();view.Show();this.Hide();}private void button2_Click(object sender, EventArgs e){Form5 view = new Form5();view.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form5 : Form{public Form5(){InitializeComponent();}private void pictureBox1_Click(object sender, EventArgs e){}private void button1_Click(object sender, EventArgs e){Form4 back = new Form4();back.Show();this.Hide();}private void label4_Click(object sender, EventArgs e){}private void label5_Click(object sender, EventArgs e){}private void label6_Click(object sender, EventArgs e){}private void label9_Click(object sender, EventArgs e){}}}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;namespace FormsHjemme{public partial class Form7 : Form{public Form7(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){Form8 Cust = new Form8();

---

Cust.Show();this.Hide();}private void button2_Click(object sender, EventArgs e){Form9 Sell = new Form9();Sell.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form8 : Form{public Form8(){InitializeComponent();}private void label6_Click(object sender, EventArgs e){}private void button1_Click(object sender, EventArgs e){Form1 save = new Form1();save.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form9 : Form{public Form9(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){Form1 save = new Form1();save.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form10 : Form{public Form10(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){Form12 view = new Form12();view.Show();this.Hide();}private void button2_Click(object sender, EventArgs e){Form12 view = new Form12();view.Show();this.Hide();}private void button3_Click(object sender, EventArgs e){Form11 create = new Form11();create.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form11 : Form{public Form11(){InitializeComponent();}private void label1_Click(object sender, EventArgs e){}private void label6_Click(object sender, EventArgs e){}private void button1_Click(object sender, EventArgs e){Form10 save = new Form10();save.Show();this.Hide();}}}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;namespace FormsHjemme{public partial class Form12 : Form{public Form12(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){Form10 back = new Form10();back.Show();this.Hide();}}}

---