5 I bob. Mashg’ulotlar zalida ishning yuritilishi tizimi tahlili

I. Asosoiy adabiyotlar
1. Xodiev B.Yu. va boshqalar. “Informatika” Oliy o’quv yurtlari uchun darslik -T.: TDIU. 2007y.
2. Alimov R.X., Yulchieva G.T., va boshqalar “Axborot texnologiyalari va tizimlari” darslik-T.: TDIU, 2010y.
3. Балдин К. В., Информационные системы в экономике: Учебник. – 3-е изд. – М.: Издательство – торговая корпорация «Дашков и К˚» 2006 – 395 с.
4. Гаврилов М.В. Информатика информационные технологии: Учебник для студентов вузов. - М.: Гардарики, 2006. - 655 с.
5. G’ulomov S.S, Alimov R.X, va boshqalar. “Axborot tizimlari va texnologiyalari” “Sharq”, T-2000 y.
6. Alimov R.X, Yulchieva G.T., Alishov Sh.A. “Axborot texnologiyasi va tizimlari”. Ma’ruza matnlari. T: - TDIU, 2005 y.
7. Alimov R.X, Begalov B.A., Yulchiеva G.T., Alishov Sh.A. “Iqtisodiyotda axborot tеxnologiyalari”. O`quv q`llanma. T.: - O`YUAJN, 2005 y.
8. Begalov B.A. Axborot-kommunikatsiyalar bozori: shakllanish, tendentsiyalar, ekonometrik modellashtirish va rivojlanish. Monografiya. – Toshkent: Fan, 2001.
II. Intеrnеt saytlari
1. www.edu.uz – O’zbekiston respublikasi oliy va o’rta maxsus ta’lim vazirligi sayti.
2. www.ccitt.uz – O’zbekiston respublikasi Axborot texnologiyalari va kommunikatsiyalarini rivojlantirish vazirligi sayti.
3.www.ictcouncil.gov.uz - Kompyuterlashtirishni rivojlantirish bo’yicha Vazirlar Maxkamasi muvoffiqlashtiruvchi Kengashining sayti.
4. www.ziyonet.uz – Ziyonet internet tarmog’i.
5. www.lex.uz-Qonunlar tog’risidagi sayt


ILOVA
Boshmenu (Admin,User)
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 project1

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

private void button2_Click(object sender, EventArgs e)

{
Form1 form1 = new Form1();
form1.Show();
Visible = false;
}

private void button1_Click(object sender, EventArgs e)

{
Admin_panel admin = new Admin_panel();
admin.Show();
Visible = false;
}

private void label1_Click(object sender, EventArgs e)

{

}

private void panel1_Paint(object sender, PaintEventArgs e)
{

}

private void main_Load(object sender, EventArgs e)
{

}
}
}

Foydalanuvchi uchun 1-oyna
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 project1

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

private void visibleToolStripMenuItem_Click(object sender, EventArgs e)

{

}

private void vScrollBar1_Scroll(object sender, ScrollEventArgs e)
{

}

private void mottoToolStripMenuItem_Click(object sender, EventArgs e)
{
MessageBox.Show("Harakatdan to'xtama!");
}

private void button1_Click(object sender, EventArgs e)

{
Kirish kirish = new Kirish();
kirish.ShowDialog();
}

private void fontDialog1_Apply(object sender, EventArgs e)

{

}

private void label1_Click(object sender, EventArgs e)
{

}

private void button3_Click(object sender, EventArgs e)
{
Form2 form2 = new Form2();
form2.ShowDialog();
}

private void button2_Click(object sender, EventArgs e)

{
Mashqlar mashq = new Mashqlar();
mashq.ShowDialog();
}

private void button5_Click(object sender, EventArgs e)

{
Form3 net = new Form3();
net.ShowDialog();
}

private void button6_Click(object sender, EventArgs e)

{
main Main = new main();
Main.Show();
Visible = false;
}

private void exitToolStripMenuItem_Click(object sender, EventArgs e)

{
this.Close();
}

private void bigToolStripMenuItem_Click(object sender, EventArgs e)

{
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void dataToolStripMenuItem_Click(object sender, EventArgs e)
{
MessageBox.Show(" Bu dastur Xalmuratov Ro'zimboy tomonidan ishlab chiqilgan. Dastur Fitness Club ga boruvchilar uchun kerakli ma'lumotlarga ega.");
}

private void photoToolStripMenuItem_Click(object sender, EventArgs e)

{
Photo ph = new Photo();
ph.ShowDialog();
}

private void button4_Click(object sender, EventArgs e)

{
Other other = new Other();
other.ShowDialog();
}

private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)

{

}

private void label1_Click_1(object sender, EventArgs e)
{

}

private void pictureBox1_Click(object sender, EventArgs e)
{

}

private void button7_Click(object sender, EventArgs e)
{
show_reg sss = new show_reg();
sss.Show();
}

}
}
Login parol

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 project1

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

private void button2_Click(object sender, EventArgs e)

{
main Main = new main();
Main.Show();
Visible = false;
}
public string log = "547";
public string pass = "547";
private void button1_Click(object sender, EventArgs e)
{
if(textBox1.Text == "" && textBox2.Text == "")
{
MessageBox.Show("Plese enter login, password!");
}
else if(textBox1.Text == log && textBox2.Text == pass)
{
My_users reg = new My_users();
reg.Show();
Visible = false;
}
else
{
MessageBox.Show("Wrong login or password!");
textBox1.Text = "";
textBox2.Text = "";
label3.Text = "*** Car number ***";
}
}

private void Admin_panel_Load(object sender, EventArgs e)

{

}
}
}

Admin panel oynasi
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 MySql.Data.MySqlClient;

namespace project1

{
public partial class My_users : Form
{
string ConnectionString = "datasource=localhost;port=3306;username=root;password=";

public My_users()

{
InitializeComponent();
FillDataTable();

}

public void FillDataTable()
{
try
{
// Define the connection credentials
string commandString = "SELECT * FROM fitness_club.fitness_table WHERE `is_deleted`=0";
MySqlConnection conn = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(commandString, conn);
conn.Open();
DataTable dataTable = new DataTable();

MySqlDataAdapter da = new MySqlDataAdapter(cmd);

da.Fill(dataTable);

this.setColumns(dataTable);
dataGridView1.DataSource = dataTable;
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void setColumns(DataTable dt)
{
dt.Columns["id"].ColumnName = "ID";
dt.Columns["first_name"].ColumnName = "Ismi";
dt.Columns["last_name"].ColumnName = "Familyasi";
dt.Columns["day_of_birthday"].ColumnName = "Tug'ilgan kuni";
dt.Columns["phone_number"].ColumnName = "Telefon raqami";
dt.Columns["adress"].ColumnName = "Yashash manzili";
dt.Columns["payment"].ColumnName = "To'lov turi";
dt.Columns["pay"].ColumnName = "To'lagan puli";
dt.Columns["date"].ColumnName = "Kelgan vaqti";
dt.Columns.Remove("is_deleted");
}

private void button1_Click(object sender, EventArgs e)

{
Add_table add = new Add_table();
add.Show();
add.WindowState = FormWindowState.Normal;
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
My_users add = new My_users();
add.Show();
}

private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)

{
Int32 id = (Int32)dataGridView1.Rows.OfType()
.Where(x => x.Index == e.RowIndex).ToArray()[0].Cells["ID"].Value;
try
{
string commandString = "UPDATE fitness_club.fitness_table SET `is_deleted`=1 WHERE `id`='" + id + "';";
MySqlConnection conn = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(commandString, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
this.FillDataTable();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

}

private void My_users_Load(object sender, EventArgs e)
{

}

private void storyToolStripMenuItem_Click(object sender, EventArgs e)
{
story stt = new story();
stt.Show();
}

private void panel1_Paint(object sender, PaintEventArgs e)

{

}
}
}

Oqsil miqdorini aniqlash
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 project1

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

private void Form2_Load(object sender, EventArgs e)

{

}

private void button2_Click(object sender, EventArgs e)
{
Oqsil oqsil = new Oqsil();
oqsil.ShowDialog();
}

double a;

private void button1_Click(object sender, EventArgs e)
{
a = Convert.ToDouble(textBox1.Text)*1.5;
textBox2.Text = Convert.ToString(a);
}

private void button3_Click(object sender, EventArgs e)

{
textBox1.Text = "";
textBox2.Text = "";
}
}
}
Mashq video
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 project1

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

private void button1_Click(object sender, EventArgs e)

{
Yutub1_uy_sharoitida yt1 = new Yutub1_uy_sharoitida();
yt1.ShowDialog();
}

private void button2_Click(object sender, EventArgs e)

{
biceps bic = new biceps();
bic.Show();
}

private void button3_Click(object sender, EventArgs e)

{
oyoq_mashqlari ayaq = new oyoq_mashqlari();
ayaq.Show();
}

private void button4_Click(object sender, EventArgs e)

{
govda gavda = new govda();
gavda.Show();
}

private void button6_Click(object sender, EventArgs e)

{
yelka_mashqlari yel = new yelka_mashqlari();
yel.Show();
}

private void button5_Click(object sender, EventArgs e)

{
press pres = new press();
pres.Show();
}

private void button7_Click(object sender, EventArgs e)

{
triceps tri = new triceps();
tri.Show();
}

private void button8_Click(object sender, EventArgs e)

{
proteyin pro = new proteyin();
pro.Show();
}

private void Form3_Load(object sender, EventArgs e)

{

}
}
}

Protein haqida
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 project1

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

private void Protein_Load(object sender, EventArgs e)

{

}
}
}

User qoshish

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 MySql.Data.MySqlClient;

namespace project1

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

private void Add_table_Load(object sender, EventArgs e)

{

}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
}

private void button1_Click(object sender, EventArgs e)

{

try
{

//This is my connection string i have assigned the database file address path
string MyConnection2 = "datasource=localhost;port=3306;username=root;password=";
//This is my insert query in which i am taking input from the user through windows forms
//string Query = "insert into fitness_club.fitness_table(id,first_name,last_name,day_of_birthday,phone_number,adress,payment,pay,date) values(null, '" + this.textBox1.Text + "','" + this.textBox2.Text + "','" + this.textBox3.Text + "','" + this.textBox4.Text + "','" + this.textBox5.Text + "','"+this.comboBox1.GetItemText(this.comboBox1.SelectedItem) + "','"+this.textBox7.Text + "','"+this.textBox8.Text +"');";
//This is MySqlConnection here i have created the object and pass my connection string.
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
MyConn2.Open();
MySqlCommand MyCommand2 = new MySql.Data.MySqlClient.MySqlCommand();
MyCommand2.Connection = MyConn2;
MyCommand2.CommandText = "INSERT INTO fitness_club.fitness_table SET `first_name`=@first_name, `last_name`=@last_name, `day_of_birthday`=@day_of_birthday,`phone_number`=@phone_number,`adress`=@adress,`payment`=@payment,`pay`=@pay,`date`=@date";
MyCommand2.Prepare();
MyCommand2.Parameters.AddWithValue("@first_name", this.textBox1.Text);
MyCommand2.Parameters.AddWithValue("@last_name", this.textBox2.Text);
MyCommand2.Parameters.AddWithValue("@day_of_birthday", this.textBox3.Text);
MyCommand2.Parameters.AddWithValue("@phone_number", this.textBox4.Text);
MyCommand2.Parameters.AddWithValue("@adress", this.textBox5.Text);
MyCommand2.Parameters.AddWithValue("@payment", this.comboBox1.GetItemText(this.comboBox1.SelectedItem));
MyCommand2.Parameters.AddWithValue("@pay", this.textBox7.Text);
MyCommand2.Parameters.AddWithValue("@date", this.textBox8.Text);
MySqlDataReader MyReader2;
MyReader2 = MyCommand2.ExecuteReader(); // Here our query will be executed and data saved into the database.
MessageBox.Show("Save Data");
while (MyReader2.Read())
{
}
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

private void label3_Click(object sender, EventArgs e)

{

}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox7.Text = "";
textBox8.Text = "";
comboBox1.Text = "";
}

}
}

///
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 project1

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

private void Mashqlar_Load(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 project1

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

private void Oqsil_Load(object sender, EventArgs e)

{

}
}
}

Other
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 project1

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

private void button5_Click(object sender, EventArgs e)

{
this.Close();
}

private void button1_Click(object sender, EventArgs e)

{
Protein pr = new Protein();
pr.ShowDialog();
}

private void button2_Click(object sender, EventArgs e)

{
Ems ems = new Ems();
ems.ShowDialog();
}

private void button3_Click(object sender, EventArgs e)

{
Ozish2 ozish = new Ozish2();
ozish.ShowDialog();
}

private void button4_Click(object sender, EventArgs e)

{
Sport sp = new Sport();
sp.ShowDialog();
}

private void Other_Load(object sender, EventArgs e)

{

}
}
}

Ozish
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 project1

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

private void Ozish2_Load(object sender, EventArgs e)

{

}
}
}

Story
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 MySql.Data.MySqlClient;

namespace project1

{
public partial class story : Form
{
string ConnectionString = "datasource=localhost;port=3306;username=root;password=";
public story()
{
InitializeComponent();
this.FillDataTable();
}

public void FillDataTable()

{
try
{
// Define the connection credentials

string commandString = "SELECT * FROM fitness_club.fitness_table WHERE `is_deleted`=1";

MySqlConnection conn = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(commandString, conn);
conn.Open();
DataTable dataTable = new DataTable();

MySqlDataAdapter da = new MySqlDataAdapter(cmd);

da.Fill(dataTable);

this.setColumns(dataTable);
dataGridView1.DataSource = dataTable;
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void setColumns(DataTable dt)
{
dt.Columns["id"].ColumnName = "ID";
dt.Columns["first_name"].ColumnName = "Ismi";
dt.Columns["last_name"].ColumnName = "Familyasi";
dt.Columns["day_of_birthday"].ColumnName = "Tug'ilgan kuni";
dt.Columns["phone_number"].ColumnName = "Telefon raqami";
dt.Columns["adress"].ColumnName = "Yashash manzili";
dt.Columns["payment"].ColumnName = "To'lov turi";
dt.Columns["pay"].ColumnName = "To'lagan puli";
dt.Columns["date"].ColumnName = "Kelgan vaqti";
dt.Columns.Remove("is_deleted");
}

private void story_Load(object sender, EventArgs e)

{

}
}s

}