Дата регистрации 16 Май 2025
0 ПродажTashkilot miqyosida masofadan muloqot qilish.
![1.2.2-rasm.
Loyiha uchun kerak bo‘lgan turni tanlash oynasi(Bizga keragi windowsform
oynasini tanlang)
Настройкановогопроекта menyusi ochiladi va biz endi yaratmoqchi
bo‘lgan dasturimiz nomini Project name bandiga yozamiz. Tayyor endi “ Далее ”
tugmasini bosamiz .
Bundan tashqari siz ushbu bo‘limda dastur qayerda saqlanishi kerakligini
ham kiritib ketishingiz mumkin. Buning uchun “Location” qismidagi ... (uch
nuqta) ustiga bosib xotiradagi kerakli joyni tanlab qo‘yasiz.
O‘zi aslida Visual Studio sizga “Form1[Design]” loyiha qismini ochib
beradi lekin agarda sizda ochilmasa “ Обозревательрешений ” dan “Form1” ni
topib ustiga sichqonchaning chap tugmasini ikki marotaba bosamiz (keyingi
o‘rinlarda ushbu jarayon double-click deb yuritiladi. Visual Studio da Windows
Form ko‘rinishidagi dasturlarni yaratishda e’tiborimizni qaratishimiz zarur bo‘lgan
asosiy 4 ta qism to‘g‘risida to‘xtalib o‘tamiz.
1.2.3-rasm
Solution Explorer yaratilgan loyihaning qismlari, fayllari, kodlari,
resurs(manba)lari shu oynada ko‘rinib turadi.
12](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_12.png?v=1)
![using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Drawing.Printing;
using System.IO;
using System.Configuration;
namespace XodimHujjatlari
{
publicpartialclass Admin : Form
{
string admin, path = "" ;
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrings[ "MTMDB" ].ConnectionString);
int index,index1;
public Admin (String admin)
{
this .admin = admin;
InitializeComponent();
}
privatevoid Admin_Load( object sender, EventArgs e)
{
label1.Text = admin;
}
privatevoid panel4_Paint( object sender, PaintEventArgs e)
{
}
privatevoid button1_Click( object sender, EventArgs e)
{
try
{
path = "" ;
panel4.Visible = true ;
label5.Text = label3.Text;
pictureBox2.Image = Properties.Resources.ish;
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
DataTable table = new DataTable();
cmd.CommandText = $"select w.Id, w.pasport as 'Pasport serya
raqami', w.lavozim, w.kelgan as 'Ishga kelgan vaqti' from Worker w " ;
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
table.Columns.Add( "Mehnat shartnomasi" );
table.Columns.Add( "Ro'yxatdan o'tganlar" );
for ( int i=0; i<table.Rows.Count; i++)
{
DataTable ish = new DataTable();
30](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_30.png?v=1)
![if (table.Rows[i][2].Equals( "Hisobchi" ))
cmd.CommandText = $"select * from Hisobchi where
id= {table.Rows[i][0]} " ;
else
cmd.CommandText = $"select * from Ishchi where
id= {table.Rows[i][0]} " ;
connection.Open();
ish.Load(cmd.ExecuteReader());
connection.Close();
if (ish.Rows.Count > 0)
{
table.Rows[i][5] = "O'tgan" ;
}
else table.Rows[i][5] = "O'tmagan" ;
table.Rows[i][4] = " ?????? Open fayl" ;
}
DataTable table1 = new DataTable();
cmd.CommandText = $"select * from Lavozim" ;
connection.Open();
table1.Load(cmd.ExecuteReader());
connection.Close();
for ( int i=0; i<table1.Rows.Count; i++)
{
comboBox2.Items.Add(table1.Rows[i][1]);
}
dataGridView1.DataSource = table;
panel4.Visible = true ;
panel5.Visible = false ;
} catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button2_Click( object sender, EventArgs e)
{
try
{
while (comboBox2.Items.Count!=0)
comboBox2.Items.RemoveAt(0);
panel4.Visible = true ;
label5.Text = label4.Text;
pictureBox2.Image =
Properties.Resources.businessmen_podium_standing_three_podiums_bars_reaching_up_77
922530;
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
DataTable table = new DataTable();
cmd.CommandText = $"select * from Lavozim" ;
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
dataGridView2.DataSource = table;
31](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_31.png?v=1)
![}
}
privatevoid dataGridView2_CellClick( object sender, DataGridViewCellEventArgs e)
{
index = e.RowIndex;
if (e.RowIndex!=-1 && e.RowIndex != dataGridView2.Rows.Count)
{
textBox3.Text =
dataGridView2.Rows[e.RowIndex].Cells[1].Value.ToString();
}
}
privatevoid button7_Click( object sender, EventArgs e)
{
try
{
if (index != -1 && index != dataGridView2.Rows.Count - 1)
{
if (!textBox3.Text.Equals( "" ))
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
DataTable table = new DataTable();
cmd.CommandText = $"select * from Lavozim where
nomi=' {textBox3.Text} ' and id!= {dataGridView2.Rows[index].Cells[0].Value} " ;
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
if (table.Rows.Count < 1)
{
cmd.CommandText = $"update Lavozim set
nomi=' {textBox3.Text} ' where id= {dataGridView2.Rows[index].Cells[0].Value} " ;
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show( "Muavfaqiyatli yangilandi" );
dataGridView2.Rows[index].Cells[1].Value =
textBox3.Text;
textBox3.Text = "" ;
}
else
{
MessageBox.Show( "Bunday lavozim bor" );
textBox3.Text = "" ;
}
}
else
{
MessageBox.Show( "Maydonni to'ldiring" );
}
}
else
{
33](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_33.png?v=1)
![MessageBox.Show( "O'zgartirilayotgan satrni tanlang" );
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button9_Click( object sender, EventArgs e)
{
try
{
if (index != -1 && index != dataGridView2.Rows.Count - 1)
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"delete from Lavozim where
id= {dataGridView2.Rows[index].Cells[0].Value} " ;
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show( "O'chirildi" );
textBox3.Text = "" ;
dataGridView2.Rows.RemoveAt(index);
}
else
{
MessageBox.Show( "O'chirilayotgan satrni tanlang" );
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button3_Click( object sender, EventArgs e)
{
try
{
if (!textBox1.Text.Equals( "" ) && comboBox2.SelectedIndex>-1 && !path.Equals( "" ))
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
DataTable table = new DataTable();
cmd.CommandText = $"select * from Worker where
pasport=' {textBox1.Text} '" ;
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
String s = DateTime.Now.ToString( "yyyy-MM-dd" );
34](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_34.png?v=1)
![if (table.Rows.Count < 1)
{
cmd.CommandText = $"insert into
Worker(pasport,lavozim,kelgan,shartnoma,format) values(' {textBox1.Text} ',
' {comboBox2.SelectedItem} ',' {s} ',@shart,' {path.Substring(path.LastIndexOf( '.' ))} ')
" ;
FileStream fs = new FileStream(path, FileMode.Open,
FileAccess.Read);
Byte[] qa = new Byte[fs.Length];
fs.Read(qa, 0, qa.Length);
fs.Close();
SqlParameter prm = new SqlParameter( "@shart" ,
SqlDbType.VarBinary, qa.Length, ParameterDirection.Input, false , 0, 0, null ,
DataRowVersion.Current, qa);
cmd.Parameters.Add(prm);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
DataTable table1 = new DataTable();
cmd.CommandText = $"select w.Id, w.pasport as 'Pasport
serya raqami', w.lavozim, w.kelgan as 'Ishga kelgan vaqti' from Worker w " ;
connection.Open();
table1.Load(cmd.ExecuteReader());
connection.Close();
table1.Columns.Add( "Mehnat shartnomasi" );
table1.Columns.Add( "Ro'yxatdan o'tganlar" );
for ( int i = 0; i < table1.Rows.Count; i++)
{
DataTable ish = new DataTable();
cmd.CommandText = $"select * from Ishchi where
id= {table1.Rows[i][0]} " ;
connection.Open();
ish.Load(cmd.ExecuteReader());
connection.Close();
if (ish.Rows.Count > 0)
{
table1.Rows[i][5] = "O'tgan" ;
}
else
{
DataTable his = new DataTable();
cmd.CommandText = $"select * from Hisobchi where
id= {table1.Rows[i][0]} " ;
connection.Open();
his.Load(cmd.ExecuteReader());
connection.Close();
if (his.Rows.Count > 0)
{
table1.Rows[i][5] = "O'tgan" ;
}
else
table1.Rows[i][5] = "O'tmagan" ;
}
table1.Rows[i][4] = " ?????? Open fayl" ;
35](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_35.png?v=1)
![}
dataGridView1.DataSource = table1;
MessageBox.Show( "Qo'shildi" );
textBox1.Text =textBox4.Text=path= "" ;
}
else
{
MessageBox.Show( "Bunday ishchi bor" );
textBox1.Text = "" ;
}
}
else
{
MessageBox.Show( "Maydonni to'ldiring" );
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button4_Click( object sender, EventArgs e)
{
try
{
if (index1 != -1 && index1 != dataGridView1.Rows.Count - 1)
{
if (!textBox1.Text.Equals( "" ) && comboBox2.SelectedIndex!=-1)
{
bool hisob = false ;
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
DataTable table = new DataTable();
if (dataGridView1.Rows[index1].Cells[2].Value.Equals( "Hisobchi" ))
hisob = true ;
cmd.CommandText = $"select * from Worker where
pasport=' {textBox1.Text} ' and id!= {dataGridView1.Rows[index1].Cells[0].Value} " ;
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
if (table.Rows.Count < 1)
{
if (path.Equals( "" ))
{
if (hisob && comboBox2.SelectedItem.Equals( "Hisobchi" ))
{
cmd.CommandText = $"update Worker set
pasport=' {textBox1.Text} ', lavozim=' {comboBox2.SelectedItem} ' where
id= {dataGridView1.Rows[index1].Cells[0].Value} " ;
connection.Open();
cmd.ExecuteNonQuery();
36](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_36.png?v=1)
![connection.Close();
MessageBox.Show( "Muavfaqiyatli yangilandi" );
dataGridView1.Rows[index1].Cells[1].Value =
textBox1.Text;
dataGridView1.Rows[index1].Cells[2].Value =
comboBox2.SelectedItem;
}
else
{
if (!hisob)
{
cmd.CommandText = $"update Worker set
pasport=' {textBox1.Text} ', lavozim=' {comboBox2.SelectedItem} ' where
id= {dataGridView1.Rows[index1].Cells[0].Value} " ;
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show( "Muavfaqiyatli
yangilandi" );
dataGridView1.Rows[index1].Cells[1].Value
= textBox1.Text;
dataGridView1.Rows[index1].Cells[2].Value
= comboBox2.SelectedItem;
}
else
MessageBox.Show( "Hisobchi ishchini
lavozimini o'zgartira olmaysiz" );
}
}
else
{
if (hisob && comboBox2.SelectedItem.Equals( "Hisobchi" ))
{
cmd.CommandText = $"update Worker set
pasport=' {textBox1.Text} ', lavozim=' {comboBox2.SelectedItem} ', shartnoma=@shart,
format=' {path.Substring(path.LastIndexOf( '.' ))} ' where
id= {dataGridView1.Rows[index1].Cells[0].Value} " ;
FileStream fs = new FileStream(path,
FileMode.Open, FileAccess.Read);
Byte[] qa = new Byte[fs.Length];
fs.Read(qa, 0, qa.Length);
fs.Close();
SqlParameter prm = new SqlParameter( "@shart" ,
SqlDbType.VarBinary, qa.Length, ParameterDirection.Input, false , 0, 0, null ,
DataRowVersion.Current, qa);
cmd.Parameters.Add(prm);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show( "Muavfaqiyatli yangilandi" );
dataGridView1.Rows[index1].Cells[1].Value =
textBox1.Text;
37](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_37.png?v=1)
![dataGridView1.Rows[index1].Cells[2].Value =
comboBox2.SelectedItem;
}
else
{
if (!hisob)
{
cmd.CommandText = $"update Worker set
pasport=' {textBox1.Text} ', lavozim=' {comboBox2.SelectedItem} ', shartnoma=@shart,
format=' {path.Substring(path.LastIndexOf( '.' ))} ' where
id= {dataGridView1.Rows[index1].Cells[0].Value} " ;
FileStream fs = new FileStream(path,
FileMode.Open, FileAccess.Read);
Byte[] qa = new Byte[fs.Length];
fs.Read(qa, 0, qa.Length);
fs.Close();
SqlParameter prm = new
SqlParameter( "@shart" , SqlDbType.VarBinary, qa.Length, ParameterDirection.Input,
false , 0, 0, null , DataRowVersion.Current, qa);
cmd.Parameters.Add(prm);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show( "Muavfaqiyatli
yangilandi" );
dataGridView1.Rows[index1].Cells[1].Value
= textBox1.Text;
dataGridView1.Rows[index1].Cells[2].Value
= comboBox2.SelectedItem;
}
else
MessageBox.Show( "Hisobchi ishchini
lavozimini o'zgartira olmaysiz" );
}
}
textBox1.Text = "" ;
}
else
{
MessageBox.Show( "Bunday ishchi bor" );
textBox1.Text = "" ;
}
}
else
{
MessageBox.Show( "Maydonni to'ldiring" );
}
}
else
{
MessageBox.Show( "O'zgartirilayotgan satrni tanlang" );
}
38](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_38.png?v=1)
![}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button5_Click( object sender, EventArgs e)
{
try
{
if (index != -1 && index != dataGridView2.Rows.Count - 1)
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
connection.Open();
cmd.CommandText = $"delete from oylik where
ishchiId= {dataGridView1.Rows[index1].Cells[0].Value} " ;
cmd.ExecuteNonQuery();
cmd.CommandText = $"delete from Ishchi where
id= {dataGridView1.Rows[index1].Cells[0].Value} " ;
cmd.ExecuteNonQuery();
cmd.CommandText = $"delete from Hisobchi where
id= {dataGridView1.Rows[index1].Cells[0].Value} " ;
cmd.ExecuteNonQuery();
cmd.CommandText = $"delete from Worker where
id= {dataGridView1.Rows[index1].Cells[0].Value} " ;
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show( "O'chirildi" );
path = "" ;
textBox1.Text = "" ;
dataGridView1.Rows.RemoveAt(index1);
}
else
{
MessageBox.Show( "O'chirilayotgan satrni tanlang" );
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid textBox2_TextChanged( object sender, EventArgs e)
{
try
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
DataTable table = new DataTable();
39](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_39.png?v=1)
![cmd.CommandText = $"select w.Id, w.pasport as 'Pasport serya
raqami', w.lavozim, w.kelgan as 'Ishga kelgan vaqti' from Worker w where (pasport
like '% {textBox2.Text} ' or pasport like '% {textBox2.Text} %' or pasport like
' {textBox2.Text} %')" ;
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
table.Columns.Add( "Mehnat shartnomasi" );
table.Columns.Add( "Ro'yxatdan o'tganlar" );
for ( int i = 0; i < table.Rows.Count; i++)
{
DataTable ish = new DataTable();
if (table.Rows[i][2].Equals( "Hisobchi" ))
cmd.CommandText = $"select * from Hisobchi where
id= {table.Rows[i][0]} " ;
else
cmd.CommandText = $"select * from Ishchi where
id= {table.Rows[i][0]} " ;
connection.Open();
ish.Load(cmd.ExecuteReader());
connection.Close();
if (ish.Rows.Count > 0)
{
table.Rows[i][5] = "O'tgan" ;
}
else table.Rows[i][5] = "O'tmagan" ;
table.Rows[i][4] = " ?????? Open fayl" ;
}
dataGridView1.DataSource = table;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid label3_Click( object sender, EventArgs e)
{
}
privatevoid button10_Click( object sender, EventArgs e)
{
this .Close();
new Bosh().Show();
}
privatevoid Print(Panel pl)
{
PrinterSettings ps = new PrinterSettings();
}
privatevoid printDocument1_PrintPage( object sender,
System.Drawing.Printing.PrintPageEventArgs e)
40](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_40.png?v=1)
![{
e.Graphics.DrawString( "Salom" , new Font( "Times new Romans" , 16,
FontStyle.Bold), Brushes.Black, new PointF(55, 140));
}
privatevoid label1_Click( object sender, EventArgs e)
{
}
privatevoid label2_Click( object sender, EventArgs e)
{
}
privatevoid textBox4_Click( object sender, EventArgs e)
{
openFileDialog1.Filter = "Select
file(*.pdf;*.docx;*.doc;*.xlsx;*.ppt;*.txt)|
*.pdf;*.docx;*.doc;*.xlsx;*.ppt;*.txt" ;
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
textBox4.Text = openFileDialog1.FileName;
path = openFileDialog1.FileName;
}
}
privatevoid dataGridView1_CellClick( object sender, DataGridViewCellEventArgs e)
{
index1 = e.RowIndex;
if (index1!=-1 && index1 != dataGridView1.Rows.Count)
{
textBox1.Text =
dataGridView1.Rows[index1].Cells[1].Value.ToString();
comboBox2.SelectedItem =
dataGridView1.Rows[index1].Cells[2].Value.ToString();
textBox4.Text = "Fayl" ;
}
if (e.ColumnIndex == 4)
{
DataGridViewRow row = dataGridView1.Rows[index1];
int d = int .Parse(row.Cells[0].Value.ToString());
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select shartnoma,format from Worker where
id= {d} " ;
DataTable table1 = new DataTable();
connection.Open();
table1.Load(cmd.ExecuteReader());
connection.Close();
var name = row.Cells[1].Value.ToString();
var fayl = (Byte[])(table1.Rows[0][0]);
var format = table1.Rows[0][1];
41](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_41.png?v=1)
![var newFileName = name + format;
File.WriteAllBytes(newFileName, fayl);
System.Diagnostics.Process.Start(newFileName);
}
if (e.ColumnIndex==5 &&
dataGridView1.Rows[e.RowIndex].Cells[5].Value.Equals( "O'tgan" ))
{
int f= int .Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
if (dataGridView1.Rows[e.RowIndex].Cells[2].Value.Equals( "Hisobchi" ))
{
this .Close();
new Form2(f, admin).Show();
}
else
{
this .Close();
new Malumot(f, admin).Show();
}
}
}
}
}
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;
using System.Data.SqlClient;
using System.Configuration;
namespace XodimHujjatlari
{
publicpartialclass Kirish : Form
{
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrings[ "MTMDB" ].ConnectionString);
int k;
Form f;
string comand;
public Kirish ( int i,Form f)
{
this .k = i;
this .f = f;
InitializeComponent();
}
privatevoid Form1_Load( object sender, EventArgs e)
{
42](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_42.png?v=1)
![switch (k)
{
case 1:
{
comand = $"select * from Admin where login=@login and
parol=@parol" ;
panel2.Visible = true ;
panel1.Visible = false ;
break ;
}
case 2:
{
panel2.Visible = false ;
panel1.Visible = true ;
break ;
}
case 3:
{
comand = $"select * from Hisobchi where login=@login and
parol=@parol" ;
panel2.Visible = true ;
panel1.Visible = false ;
label1.Visible = true ;
break ;
}
}
}
privatevoid button2_Click( object sender, EventArgs e)
{
try
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = comand;
cmd.Parameters.AddWithValue( "@login" , textBox4.Text);
cmd.Parameters.AddWithValue( "@parol" , textBox3.Text);
DataTable table = new DataTable();
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
if (table.Rows.Count > 0)
{
this .Close();
f.Hide();
if (k == 1) new Admin(table.Rows[0][1].ToString()).Show();
if (k == 3) new oylik( int .Parse(table.Rows[0][0].ToString())).Show();
}
else
{
MessageBox.Show( "Login yoki parolingiz xato" );
textBox4.Text = textBox3.Text = "" ;
}
43](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_43.png?v=1)
![}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button1_Click( object sender, EventArgs e)
{6
this .Close();
}
privatevoid label1_Click( object sender, EventArgs e)
{
panel2.Visible = false ;
panel1.Visible = true ;
}
privatevoid button3_Click( object sender, EventArgs e)
{
try
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
if (k==3)
cmd.CommandText = $"select * from Worker where
pasport=' {textBox2.Text} ' and lavozim='Hisobchi'" ;
else
cmd.CommandText = $"select * from Worker where
pasport=' {textBox2.Text} '" ;
DataTable table = new DataTable();
connection.Open();
table.Load(cmd.ExecuteReader());
connection.Close();
if (table.Rows.Count > 0)
{
if (k==2)
cmd.CommandText = $"select * from Ishchi where
id= {table.Rows[0][0]} " ;
else
cmd.CommandText = $"select * from Hisobchi where
id= {table.Rows[0][0]} " ;
DataTable table1 = new DataTable();
connection.Open();
table1.Load(cmd.ExecuteReader());
connection.Close();
if (table1.Rows.Count < 1)
{
this .Close();
f.Hide();
if (k==2)
new Regstr( int .Parse(table.Rows[0][0].ToString())).Show();
44](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_44.png?v=1)
![if (k == 3)
new Ishchi ( int .Parse(table.Rows[0][0].ToString()), table.Rows[0]
[1].ToString()).Show();
}
else
{
MessageBox.Show( "Bu passportdan oldin ro'yxatdan o'tgan" );
}
}
else
{
MessageBox.Show( "Siz ro'yxatdan o'tmagansiz" );
textBox2.Text= "" ;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid label8_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.Data.SqlClient;
using System.Windows.Forms;
using System.Configuration;
namespace XodimHujjatlari
{
publicpartialclass oylik : Form
{
int id, ishId;
bool ishchi = true ;
DataTable qiymat;
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrings[ "MTMDB" ].ConnectionString);
public oylik ( int id)
{
this .id = id;
InitializeComponent();
45](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_45.png?v=1)
![}
privatevoid oylik_Load( object sender, EventArgs e)
{
try
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select * from Hisobchi where id= {id} " ;
DataTable kim = new DataTable();
connection.Open();
kim.Load(cmd.ExecuteReader());
connection.Close();
label1.Text = kim.Rows[0][4] + "" + kim.Rows[0][3] + "
profilingizga xush kelibsiz" ;
cmd.CommandText = $"select i.id,i.ism+i.familya as 'Ism
familiya', i.tel as 'telefon nomer',lavozim as 'Lavozimi' from Ishchi i inner join
Worker w on i.id=w.id " ;
DataTable data = new DataTable();
connection.Open();
data.Load(cmd.ExecuteReader());
connection.Close();
dataGridView1.DataSource = data;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button1_Click( object sender, EventArgs e)
{
try
{
ishchi = true ;
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select i.id,i.ism+i.familya as 'Ism
familiya', i.tel as 'telefon nomer',lavozim as 'Lavozimi' from Ishchi i inner join
Worker w on i.id=w.id " ;
DataTable data = new DataTable();
connection.Open();
data.Load(cmd.ExecuteReader());
connection.Close();
dataGridView1.DataSource = data;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
46](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_46.png?v=1)
![catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid dataGridView1_CellClick( object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.RowIndex != dataGridView1.Rows.Count - 1 && ishchi)
{
ishId
= int .Parse( dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
textBox6.Text =
dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
ishchi = false ;
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select i.id,i.ism+i.familya as 'Ism
familiya', o.olgavVaqt as 'Oxirgi oylik sanasi',o.kun as 'Ish kuni', o.miqdor as
'Oylik miqdori(so`m)', h.familya+h.ism as 'Oylik chiqargan hisobchi' from oylik o
inner join Ishchi i on i.id=ishchiId inner join Hisobchi h on h.id=o.hisobchiId
where i.id= {dataGridView1.Rows[e.RowIndex].Cells[0].Value} " ;
DataTable data = new DataTable();
connection.Open();
data.Load(cmd.ExecuteReader());
connection.Close();
dataGridView1.DataSource = data;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button4_Click( object sender, EventArgs e)
{
this .Close();
new Bosh().Show();
}
privatevoid label1_Click( object sender, EventArgs e)
{
}
privatevoid button3_Click( object sender, EventArgs e)
{
48](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_48.png?v=1)
![SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrings[ "MTMDB" ].ConnectionString);
public Ishchi ( int id, string pas)
{
this .id = id;
this .pas = pas;
InitializeComponent();
}
privatevoid Ishchi_Load( object sender, EventArgs e)
{
textBox6.Text = pas;
}
privatevoid button2_Click( object sender, EventArgs e)
{
try
{
if (!textBox1.Text.Equals( "" ) && !textBox2.Text.Equals( "" ) && !
textBox4.Text.Equals( "" ) && !img.Equals( "" ) && !textBox5.Text.Equals( "" ))
{
if (textBox4.Text.Equals(textBox5.Text))
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select * from Hisobchi where
login=' {textBox2.Text} '" ;
DataTable data = new DataTable();
connection.Open();
data.Load(cmd.ExecuteReader());
connection.Close();
if (data.Rows.Count < 1)
{
FileStream fs1 = new FileStream(img, FileMode.Open,
FileAccess.Read);
Byte[] rasm = new Byte[fs1.Length];
fs1.Read(rasm, 0, rasm.Length);
fs1.Close();
string jins = radioButton1.Checked ? radioButton1.Text : radioButton2.Text;
cmd.CommandText = $"insert into
Hisobchi(id,login,parol,ism,familya,tel,jins,rasm) " +
$"values ( {id} , ' {textBox2.Text} ', ' {textBox4.Text} ', ' {textBox1.Text} ',
' {textBox3.Text} ',' {maskedTextBox1.Text} ',' {jins} ', @fayl)" ;
SqlParameter p2 = new SqlParameter( "@fayl" ,
SqlDbType.VarBinary, rasm.Length, ParameterDirection.Input, false , 0, 0, null ,
DataRowVersion.Current, rasm);
cmd.Parameters.Add(p2);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show( "Muavfaqiyatli ro'yxatdan o'tdingiz" );
textBox1.Text = textBox2.Text = textBox3.Text =
textBox4.Text = textBox5.Text = textBox6.Text = maskedTextBox1.Text = img = "" ;
50](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_50.png?v=1)
![using System.Configuration;
namespace XodimHujjatlari
{
publicpartialclass oylik : Form
{
int id, ishId;
bool ishchi = true ;
DataTable qiymat;
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrings[ "MTMDB" ].ConnectionString);
public oylik ( int id)
{
this .id = id;
InitializeComponent();
}
privatevoid oylik_Load( object sender, EventArgs e)
{
try
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select * from Hisobchi where id= {id} " ;
DataTable kim = new DataTable();
connection.Open();
kim.Load(cmd.ExecuteReader());
connection.Close();
label1.Text = kim.Rows[0][4] + "" + kim.Rows[0][3] + "
profilingizga xush kelibsiz" ;
cmd.CommandText = $"select i.id,i.ism+i.familya as 'Ism
familiya', i.tel as 'telefon nomer',lavozim as 'Lavozimi' from Ishchi i inner join
Worker w on i.id=w.id " ;
DataTable data = new DataTable();
connection.Open();
data.Load(cmd.ExecuteReader());
connection.Close();
dataGridView1.DataSource = data;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid button1_Click( object sender, EventArgs e)
{
try
{
ishchi = true ;
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
52](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_52.png?v=1)
![}
else
cmd.CommandText = $"select i.id,i.ism+i.familya as 'Ism
familiya', o.olgavVaqt as 'Oxirgi oylik sanasi',o.kun as 'Ish kuni', o.miqdor as
'Oylik miqdori(so`m)', h.familya+h.ism as 'Oylik chiqargan hisobchi' from oylik o
inner join Ishchi i on i.id=ishchiId inner join Hisobchi h on h.id=o.hisobchiId "
+
$"where (i.ism like '% {textBox2.Text} ' or i.ism like '% {textBox2.Text} %' or i.ism
like ' {textBox2.Text} %' or i.familya like '% {textBox2.Text} ' or i.familya like '%
{textBox2.Text} %' or i.familya like ' {textBox2.Text} %')" ;
DataTable data = new DataTable();
connection.Open();
data.Load(cmd.ExecuteReader());
connection.Close();
dataGridView1.DataSource = data;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
}
}
privatevoid dataGridView1_CellClick( object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.RowIndex != dataGridView1.Rows.Count - 1 && ishchi)
{
ishId
= int .Parse( dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
textBox6.Text =
dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
ishchi = false ;
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select i.id,i.ism+i.familya as 'Ism
familiya', o.olgavVaqt as 'Oxirgi oylik sanasi',o.kun as 'Ish kuni', o.miqdor as
'Oylik miqdori(so`m)', h.familya+h.ism as 'Oylik chiqargan hisobchi' from oylik o
inner join Ishchi i on i.id=ishchiId inner join Hisobchi h on h.id=o.hisobchiId
where i.id= {dataGridView1.Rows[e.RowIndex].Cells[0].Value} " ;
DataTable data = new DataTable();
connection.Open();
data.Load(cmd.ExecuteReader());
connection.Close();
dataGridView1.DataSource = data;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
connection.Close();
54](https://docx.uz/documents/2d031bda-6339-4245-8716-8aa76699ba1a/page_54.png?v=1)
-
Похожие документы
- Avtobus yo‘nalishlari va chiptalar sotuvini boshqarish tizimi uchun ma’lumotlar bazasi
- Restorandagi stol bron qilish tizimi uchun ma’lumotlar bazasini yaratish
- Microsoft Publisher dasturi ishlatilishi
- Pythonda sanoq sistemalari va kompleks sonlar bilan ishlash
- Zamonaviy kompyuterlar va ulaming arxitekturasi. Xotira qurilmasi, axborotlami kiritish - chiqarish qurilmalari