Файл: Автоматизация деятельности риэлтора.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();

}

}

}

---