Algoritmik tillar va dasturlash

FOYDALANILGAN ADABIYOTLAR
1. Сергей Тепляков. Паттерны проектирования на платформе .NET 2.
3. Date C.J. An Introduction to Database Systems (8 th edition). Addison-Wesley: 2003. – P. 1034.
4. Основы систем баз данных: Учебник. / Е. Ж. Айтхожаева – Алматы: КазНИТУ имени К. И. Сатпаева, 2016. – 279 с. Ил. 38. Табл. 8. Библиогр. –53 назв.
5. Андон Ф., Резниченко В. Язык запросов SQL: Учеб. курс. – СПб.: Питер, 2006. – 416 с.
6. Бейли Л. Изучаем SQL /Пер. с англ. – СПб.: Питер, 2012. – 573 с.
7.https://xabar.uz/uz/talim/talim-tizimini-isloh-qilishni-nimadan-boshlash-kerak
8.https://tdi.uz/activity/monitoring/
9. Unity и C#. Геймдев от идеи до реализации | Гибсон Бонд Гибсон Бонд
Джереми
10. Ицик Бен-Ган. Microsoft SQL Server 2012. Основы T-SQL
11. Дж. Скит. C# для профессионалов. Тонкости программирования
12. Joe Duffy. Concurrent Programming on Windows
13. Эрик Фримен и др. Head First. Паттерны проектирования
14. Сергей Тепляков. Паттерны проектирования на платформе .NET


ILOVALAR
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 Prekt_TTJ

{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)

{
new Register().Show();
this.Hide();
}

private void button2_Click(object sender, EventArgs e)

{
new Login().Show();
this.Hide();
}

private void panel1_Paint(object sender, PaintEventArgs e)

{

}
private void button4_Click(object sender, EventArgs e)

{
new Davomat().Show();
this.Hide();
}

private void Form1_Load(object sender, EventArgs e)

{

}

private void button5_Click(object sender, EventArgs e)
{
new Navbatchilar().Show();
this.Hide();
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Npgsql;
using System.Data;

namespace Prekt_TTJ

{
public partial class Register : Form
{
public Register()
{
InitializeComponent();
}

// table tebl

// create table talaba
//(
// id serial primary key,
// ismi character varying(150) not null,
// familyasi character varying(150) not null,
// tel character varying(150) not null,
// jinsi character varying(150) not null,
// fakulteti character varying(150) not null,
// guruhi character varying(150) not null,
// viloyati character varying(150) not null,
// tumani character varying(150) not null,
// qavat character varying not null,
// hona character varying not null,
// sana character varying not null,
// oylik character varying(150) not null,
// tolov int not null
//)

private static string Host = "localhost";

private static string User = "postgres";
private static string DBname = "TTJ";
private static string Password = "1234";
private static string Port = "5432";

string connString = String.Format(

"Server={0}; Username={1}; Database={2}; Port={3}; Password={4}; SSLMode=Prefer",
Host,
User,
DBname,
Port,
Password);

private NpgsqlConnection conn;

private NpgsqlCommand cmd;
private string sql = null;
private DataTable dt;
private DataTable dt1;

string[] fakultet = new string[2] { "Amaliy matematika", "Psixologiya" };

string[] qizlar = new string[2] { "1-qavat", "2-qavat" };
string[] bolar = new string[2] { "3-qavat","4-qavat" };
string[] jinsi = new string[2] { "O`g`il bola","Qiz bola" };
string[] viloyat = new string[13] { "Andijon", "Buxoro", "JIzzax", "Namangan", "Farg'ona", "Toshkent", "Sirdaryo", "Samarqand", "Surhandaryo", "Qashqadaryo", "Navoi", "Xorazim", "Qoraqolpoqiston R" };
int vil = 0;
int h = 0;

private void panel1_Paint(object sender, PaintEventArgs e)

{

}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
comboBox1.Items.Clear();
comboBox2.Items.Clear();

foreach (string i in viloyat)

{
comboBox1.Items.Add(i);
}
comboBox6.Items.Clear();
foreach(string i in jinsi)
{
comboBox6.Items.Add(i);
}
comboBox5.Items.Clear();
comboBox4.Items.Clear();
comboBox3.Items.Clear();
foreach (string i in fakultet)
{
comboBox3.Items.Add(i);
}
}

private void label7_Click(object sender, EventArgs e)

{

}

private void Register_Load(object sender, EventArgs e)
{
conn = new NpgsqlConnection(connString);
try
{
// load

conn.Open();

sql = @"select *from student";
cmd = new NpgsqlCommand(sql, conn);
cmd.ExecuteNonQuery();
dt = new DataTable();
dt.Load(cmd.ExecuteReader());
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt;
conn.Close();

foreach (string i in jinsi)

{
comboBox6.Items.Add(i);
}
foreach (string i in fakultet)
{
comboBox3.Items.Add(i);
}

foreach (string i in viloyat)

{
vil = 1;
comboBox1.Items.Add(i);
}
}catch(Exception ex)
{
MessageBox.Show("Baza bilan bog'lanishda xatolik!!!" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}

}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string[] andijon = new string[14] { "Andijon", "Asaka","Baliqchi","Bo`z","Buloqboshi","Izboskan","Jalaquduq","Xo`jabod","Qo`rg'ontepa","Marhamat","Oltinko`l","Paxtaobod","Shaxrihon","Ulug`nor" };
string[] buxoro = new string[11] { "Jondor", "Olot","Buxoro","G`ijduvon","Kogon","Qorako`l","Qoroulbozor","Peshku","Romitan","Shofirkon","Vobkent" };
string[] jizzax = new string[12] { "Zomin", "Baxmal","Arnosoy","Zafarabod","G`allarol","Paxtakor","Zarbdor","Yangiobod","Mirzacho`l","Sharof Rashidov","Do`stlik","Forish" };
string[] namangan = new string[11] { "Chortoq", "Chust","Kosonsoy","Mingbuloq","Namangan","Norin","Pop","To`raqo`rg`on","Uchqo`rg`on","Uychi","Yangiqo`rg`on" };
string[] fargona = new string[16] { "Oltiariq", "Bog`dod","Beshariq","Buvayda","Dang`ara","Farg`ona","Furqot","Qo`shtepa","Quva","Rishton","Shox","Toshloq","Uchko`prik","Yozyovon","O`zbekiston","Quvasoy" };
string[] toshkent = new string[14] { "Bekobod", "Bo`stonliq", "Bo`ka", "Chinoz", "Qibray", "Ohangaron", "Oqqo`rg`on", "Parkent", "Pishkent", "Quyi chirchiq","O`rta chirchiq","Yangiyo`l","Yuqori chirchiq","Zargiota" };

string[] sirdaryo = new string[10] { "Oqoltin", "Boyovut","Guliston","Xovis","Mirzaobod","Sayxunobod","Sardabo","Sirdaryo","Yangiyer","Shirin" };

string[] samarqand = new string[14] { "Bulung`ir", "Ishtixon","Jomboy","Kataqo`rg`on","Narpay","Nurabod","Oqdaryo","Paxtachi","Payariq","Pasdarg`om","Samarqand","Toyloq","Urgut","Qo`shrabod" };
string[] surhondaryo = new string[13] { "Angor","Boysun","Denov","Jarqo`rg`on","Qiziriq","Qumqo`rg`on","Muzrabod","Oltinsoy","Sarosiyo","Sherobod","Sho`rchi","Termiz", "Uzun" };
string[] qashqadaryo = new string[14] { "Chiroqchi","Dehqonobod","G'uzor","Qamashi","Qarshi","Koson","Kasbi","Kitob","Mirishkor","Muborak","Nishon","Shaxrishabz","Yakkabog'", "Ko'kdala" };
string[] navoi = new string[8] { "Konimex","Karmana","Qiziltepa","Xatirchi","Navbohor","Nurota","Tomdi", "Uchquduq" };
string[] xorazim = new string[11] { "Bog`dod","Gurlan","Xonqa","Hozarasp","Xiva","Qo`shko`prok","Shovot","Urganch","Yangibozor", "Tuproqqa`la","Yangiariq" };
string[] qoraqolpoqiston = new string[16] { "Amudaryo","Beruniy", "Chimboy","Elikqala","Kegayli","Mo'ynoq","Nukus","Qangliko'l","Qo`ng`irot","Qorao`zak","Shumanay","Taxtako`rik","To`rtko`l","Xo`jayli","Taxiatosh","Bo`zatov" };
if (vil == 1)
{
// Andijon
if (comboBox1.SelectedIndex == 0)
{
comboBox2.Items.Clear();
foreach (string i in andijon)
{
comboBox2.Items.Add(i);
}
}
// Buxora
if (comboBox1.SelectedIndex == 1)
{
comboBox2.Items.Clear();
foreach (string i in buxoro)
{
comboBox2.Items.Add(i);
}
}
// Jizzax
if (comboBox1.SelectedIndex == 2)
{
comboBox2.Items.Clear();
foreach (string i in jizzax)
{
comboBox2.Items.Add(i);
}
}
// Namangan
if (comboBox1.SelectedIndex == 3)
{
comboBox2.Items.Clear();
foreach (string i in namangan)
{
comboBox2.Items.Add(i);
}
}
// Farg'ona
if (comboBox1.SelectedIndex == 4)
{
comboBox2.Items.Clear();
foreach (string i in fargona)
{
comboBox2.Items.Add(i);
}
}
// Toshkent
if (comboBox1.SelectedIndex == 5)
{
comboBox2.Items.Clear();
foreach (string i in toshkent)
{
comboBox2.Items.Add(i);
}
}
// Sirdaryo
if (comboBox1.SelectedIndex == 6)
{
comboBox2.Items.Clear();
foreach (string i in sirdaryo)
{
comboBox2.Items.Add(i);
}
}
// Samarqand
if (comboBox1.SelectedIndex == 7)
{
comboBox2.Items.Clear();
foreach (string i in samarqand)
{
comboBox2.Items.Add(i);
}
}
// Surhondaryo
if (comboBox1.SelectedIndex == 8)
{
comboBox2.Items.Clear();
foreach (string i in surhondaryo)
{
comboBox2.Items.Add(i);
}
}
// Qashqadaryo
if (comboBox1.SelectedIndex == 9)
{
comboBox2.Items.Clear();
foreach (string i in qashqadaryo)
{
comboBox2.Items.Add(i);
}
}
// Navoi
if (comboBox1.SelectedIndex == 10)
{
comboBox2.Items.Clear();
foreach (string i in navoi)
{
comboBox2.Items.Add(i);
}
}
// Xorazim
if (comboBox1.SelectedIndex == 11)
{
comboBox2.Items.Clear();
foreach (string i in xorazim)
{
comboBox2.Items.Add(i);
}
}