Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 student_progress
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- Start();
- }
- // functions
- int id = -1;
- PgSQL pgsql = null;
- DataTable table = null;
- DataTable student = null;
- DataTable teacher = null;
- DataTable discipline = null;
- DataTable faculty = null;
- DataTable cathedra = null;
- DataTable speciality = null;
- DataTable form_study = null;
- DataTable group = null;
- string pageName = "1";
- void Start()
- {
- pgsql = new PgSQL("Server=localhost;Port=5432;Database=dump;User Id=postgres;Password=77Cnekmt;");
- grid.MultiSelect = false;
- getRecordsForComboBox();
- showTable();
- }
- void getRecordsForComboBox()
- {
- student = pgsql.OutTable("get_student");
- teacher = pgsql.OutTable("get_teacher");
- discipline = pgsql.OutTable("get_discipline");
- faculty = pgsql.OutTable("get_faculty");
- cathedra = pgsql.OutTable("get_cathedra");
- speciality = pgsql.OutTable("get_speciality");
- form_study = pgsql.OutTable("get_form_study");
- group = pgsql.OutTable("get_group");
- statStudBox.DataSource = student.DefaultView;
- statStudBox.DisplayMember = "Наименование";
- statStudBox.ValueMember = "#";
- statStudBox.Text = null;
- statTeachBox.DataSource = teacher.DefaultView;
- statTeachBox.DisplayMember = "Наименование";
- statTeachBox.ValueMember = "#";
- statTeachBox.Text = null;
- statDiscBox.DataSource = discipline.DefaultView;
- statDiscBox.DisplayMember = "Наименование";
- statDiscBox.ValueMember = "#";
- statDiscBox.Text = null;
- cathFacBox.DataSource = faculty.DefaultView;
- cathFacBox.DisplayMember = "Наименование";
- cathFacBox.ValueMember = "#";
- cathFacBox.Text = null;
- specCathBox.DataSource = cathedra.DefaultView;
- specCathBox.DisplayMember = "Наименование";
- specCathBox.ValueMember = "#";
- specCathBox.Text = null;
- grSpecBox.DataSource = speciality.DefaultView;
- grSpecBox.DisplayMember = "Наименование";
- grSpecBox.ValueMember = "#";
- grSpecBox.Text = null;
- studFormBox.DataSource = form_study.DefaultView;
- studFormBox.DisplayMember = "Наименование";
- studFormBox.ValueMember = "#";
- studFormBox.Text = null;
- statGrBox.DataSource = group.DefaultView;
- statGrBox.DisplayMember = "Наименование";
- statGrBox.ValueMember = "#";
- statGrBox.Text = null;
- studGrBox.DataSource = group.DefaultView;
- studGrBox.DisplayMember = "Наименование";
- studGrBox.ValueMember = "#";
- studGrBox.Text = null;
- teachCathBox.DataSource = cathedra.DefaultView;
- teachCathBox.DisplayMember = "Наименование";
- teachCathBox.ValueMember = "#";
- teachCathBox.Text = null;
- }
- private void showTable()
- {
- switch (pageName)
- {
- case "1":
- table = pgsql.OutTable("show_statement");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- case "2":
- table = pgsql.OutTable("show_student");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- case "3":
- table = pgsql.OutTable("show_discipline");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- case "4":
- table = pgsql.OutTable("show_teacher");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- case "5":
- table = pgsql.OutTable("show_faculty");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- case "6":
- table = pgsql.OutTable("show_cathedra");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- case "7":
- table = pgsql.OutTable("show_speciality");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- case "8":
- table = pgsql.OutTable("show_group");
- grid.DataSource = table.DefaultView;
- grid.Columns[0].Visible = false;
- break;
- }
- }
- private void editForRow()
- {
- id = -1;
- int num = grid.SelectedRows[0].Index;
- if (num == -1) throw new Exception("Не выбрана строка для изменения!");
- id = Convert.ToInt32(table.Rows[num][0]);
- switch (pageName)
- {
- case "1":
- statTermBox.Text = table.Rows[num][1].ToString();
- statDiscBox.Text = table.Rows[num][2].ToString();
- statTeachBox.Text = table.Rows[num][3].ToString();
- statGrBox.Text = table.Rows[num][4].ToString();
- statStudBox.Text = table.Rows[num][5].ToString();
- statAttBox.Text = table.Rows[num][6].ToString();
- statRatBox.Text = table.Rows[num][7].ToString();
- statDatBox.Text = table.Rows[num][8].ToString();
- break;
- case "2":
- studNameBox.Text = table.Rows[num][1].ToString();
- studRbBox.Text = table.Rows[num][2].ToString();
- studGrBox.Text = table.Rows[num][3].ToString();
- studPhoneBox.Text = table.Rows[num][4].ToString();
- studFormBox.Text = table.Rows[num][5].ToString();
- studYearBox.Text = table.Rows[num][6].ToString();
- break;
- case "3":
- discNameBox.Text = table.Rows[num][1].ToString();
- break;
- case "4":
- teachNameBox.Text = table.Rows[num][1].ToString();
- teachPhoneBox.Text = table.Rows[num][2].ToString();
- teachCathBox.Text = table.Rows[num][3].ToString();
- break;
- case "5":
- facNameBox.Text = table.Rows[num][1].ToString();
- break;
- case "6":
- cathNameBox.Text = table.Rows[num][1].ToString();
- cathFacBox.Text = table.Rows[num][2].ToString();
- cathPhoneBox.Text = table.Rows[num][3].ToString();
- cathMrgBox.Text = table.Rows[num][4].ToString();
- break;
- case "7":
- specNameBox.Text = table.Rows[num][1].ToString();
- specCathBox.Text = table.Rows[num][2].ToString();
- specCodeBox.Text = table.Rows[num][3].ToString();
- break;
- case "8":
- grNumbBox.Text = table.Rows[num][1].ToString();
- grSpecBox.Text = table.Rows[num][2].ToString();
- grHmBox.Text = table.Rows[num][3].ToString();
- grPplnBox.Text = table.Rows[num][4].ToString();
- break;
- }
- cancelEditButton.Enabled = true;
- saveEditButton.Enabled = true;
- addButton.Enabled = false;
- editButton.Enabled = false;
- grid.Enabled = false;
- }
- private void saveEditForRecord()
- {
- switch (pageName)
- {
- case "1":
- pgsql.AddEditStat("update_statement", Convert.ToInt32(statStudBox.SelectedValue), Convert.ToInt32(statTeachBox.SelectedValue), Convert.ToInt32(statDiscBox.SelectedValue), statRatBox.Text, statDatBox.Text, Convert.ToInt32(statTermBox.Text), Convert.ToInt32(statGrBox.SelectedValue), statAttBox.Text, id);
- break;
- case "2":
- pgsql.AddEditStudent("update_student", studNameBox.Text, studPhoneBox.Text, studYearBox.Text, Convert.ToInt32(studFormBox.SelectedValue), Convert.ToInt32(studGrBox.SelectedValue), studRbBox.Text, id);
- break;
- case "3":
- pgsql.AddEditDisc("update_discipline", discNameBox.Text, id);
- break;
- case "4":
- pgsql.AddEditTeacher("update_teacher", teachNameBox.Text, teachPhoneBox.Text, Convert.ToInt32(teachCathBox.SelectedValue), id);
- break;
- case "5":
- pgsql.AddEditFaculty("update_faculty", facNameBox.Text, id);
- break;
- case "6":
- pgsql.AddEditCathedra("update_cathedra", cathNameBox.Text, Convert.ToInt32(cathFacBox.SelectedValue), cathPhoneBox.Text, cathMrgBox.Text, id);
- break;
- case "7":
- pgsql.AddEditSpec("update_speciality", specNameBox.Text, specCodeBox.Text, Convert.ToInt32(specCathBox.SelectedValue), id);
- break;
- case "8":
- pgsql.AddEditGroup("update_group", grNumbBox.Text, Convert.ToInt32(grSpecBox.SelectedValue), grHmBox.Text, Convert.ToInt32(grPplnBox.Text), id);
- break;
- }
- cancelEditButton.Enabled = false;
- saveEditButton.Enabled = false;
- addButton.Enabled = true;
- grid.Enabled = true;
- editButton.Enabled = true;
- Cancel();
- getRecordsForComboBox();
- showTable();
- id = -1;
- }
- private void Cancel()
- {
- switch (pageName)
- {
- case "1":
- statStudBox.Text = null;
- statDiscBox.Text = null;
- statTeachBox.Text = null;
- statRatBox.Text = null;
- statDatBox.Text = null;
- statTermBox.Text = null;
- statAttBox.Text = null;
- statGrBox.Text = null;
- break;
- case "2":
- studNameBox.Text = null;
- studRbBox.Text = null;
- studGrBox.Text = null;
- studPhoneBox.Text = null;
- studYearBox.Text = null;
- studFormBox.Text = null;
- break;
- case "3":
- discNameBox.Text = null;
- break;
- case "4":
- teachNameBox.Text = null;
- teachPhoneBox.Text = null;
- teachCathBox.Text = null;
- break;
- case "5":
- facNameBox.Text = null;
- break;
- case "6":
- cathNameBox.Text = null;
- cathFacBox.Text = null;
- cathPhoneBox.Text = null;
- cathMrgBox.Text = null;
- break;
- case "7":
- specNameBox.Text = null;
- specCathBox.Text = null;
- specCodeBox.Text = null;
- break;
- case "8":
- grNumbBox.Text = null;
- grSpecBox.Text = null;
- grHmBox.Text = null;
- grPplnBox.Text = null;
- break;
- }
- cancelEditButton.Enabled = false;
- saveEditButton.Enabled = false;
- addButton.Enabled = true;
- editButton.Enabled = true;
- grid.Enabled = true;
- id = -1;
- }
- private void addRecord()
- {
- switch (pageName)
- {
- case "1":
- pgsql.AddEditStat("insert_statement", Convert.ToInt32(statStudBox.SelectedValue), Convert.ToInt32(statTeachBox.SelectedValue), Convert.ToInt32(statDiscBox.SelectedValue), statRatBox.Text, statDatBox.Text, Convert.ToInt32(statTermBox.Text), Convert.ToInt32(statGrBox.SelectedValue), statAttBox.Text);
- break;
- case "2":
- pgsql.AddEditStudent("insert_student", studNameBox.Text, studPhoneBox.Text, studYearBox.Text, Convert.ToInt32(studFormBox.SelectedValue), Convert.ToInt32(studGrBox.SelectedValue), studRbBox.Text);
- break;
- case "3":
- pgsql.AddEditDisc("insert_discipline", discNameBox.Text);
- break;
- case "4":
- pgsql.AddEditTeacher("insert_teacher", teachNameBox.Text, teachPhoneBox.Text, Convert.ToInt32(teachCathBox.SelectedValue));
- break;
- case "5":
- pgsql.AddEditFaculty("insert_faculty", facNameBox.Text);
- break;
- case "6":
- pgsql.AddEditCathedra("insert_cathedra", cathNameBox.Text, Convert.ToInt32(cathFacBox.SelectedValue), cathPhoneBox.Text, cathMrgBox.Text);
- break;
- case "7":
- pgsql.AddEditSpec("insert_speciality",specNameBox.Text, specCodeBox.Text, Convert.ToInt32(specCathBox.SelectedValue));
- break;
- case "8":
- pgsql.AddEditGroup("insert_group", grNumbBox.Text, Convert.ToInt32(grSpecBox.SelectedValue), grHmBox.Text, Convert.ToInt32(grPplnBox.Text));
- break;
- }
- Cancel();
- getRecordsForComboBox();
- showTable();
- id = -1;
- }
- private void deleteRecord()
- {
- id = -1;
- int num = grid.SelectedRows[0].Index;
- if (num == -1) throw new Exception("Не выбрана строка для удаления!");
- id = Convert.ToInt32(table.Rows[num][0]);
- switch (pageName)
- {
- case "1":
- pgsql.Del("remove_statement", id);
- break;
- case "2":
- pgsql.Del("remove_student", id);
- break;
- case "3":
- pgsql.Del("remove_discipline", id);
- break;
- case "4":
- pgsql.Del("remove_teacher", id);
- break;
- case "5":
- pgsql.Del("remove_faculty", id);
- break;
- case "6":
- pgsql.Del("remove_cathedra", id);
- break;
- case "7":
- pgsql.Del("remove_speciality", id);
- break;
- case "8":
- pgsql.Del("remove_group", id);
- break;
- }
- getRecordsForComboBox();
- showTable();
- id = -1;
- }
- // buttons
- private void addButton_Click(object sender, EventArgs e)
- {
- try
- {
- addRecord();
- }
- catch (Exception q)
- {
- MessageBox.Show(q.Message);
- }
- }
- private void editButton_Click(object sender, EventArgs e)
- {
- try
- {
- editForRow();
- }
- catch (Exception q)
- {
- MessageBox.Show(q.Message);
- }
- }
- private void cancelEditButton_Click(object sender, EventArgs e)
- {
- try
- {
- Cancel();
- }
- catch (Exception q)
- {
- MessageBox.Show(q.Message);
- }
- }
- private void saveEditButton_Click(object sender, EventArgs e)
- {
- try
- {
- saveEditForRecord();
- }
- catch (Exception q)
- {
- MessageBox.Show(q.Message);
- }
- }
- private void deleteButton_Click(object sender, EventArgs e)
- {
- try
- {
- deleteRecord();
- }
- catch (Exception q)
- {
- MessageBox.Show(q.Message);
- }
- }
- // focus
- private void tabPage1_Enter(object sender, EventArgs e)
- {
- pageName = "1";
- showTable();
- }
- private void tabPage2_Enter(object sender, EventArgs e)
- {
- pageName = "2";
- showTable();
- }
- private void tabPage4_Enter(object sender, EventArgs e)
- {
- pageName = "4";
- showTable();
- }
- private void tabPage3_Enter(object sender, EventArgs e)
- {
- pageName = "3";
- showTable();
- }
- private void tabPage5_Enter(object sender, EventArgs e)
- {
- pageName = "5";
- showTable();
- }
- private void tabPage6_Enter(object sender, EventArgs e)
- {
- pageName = "6";
- showTable();
- }
- private void tabPage7_Enter(object sender, EventArgs e)
- {
- pageName = "7";
- showTable();
- }
- private void tabPage8_Enter(object sender, EventArgs e)
- {
- pageName = "8";
- showTable();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement