База данных "Студенты и преподаватели"

)

go

alter table "Grant"

add constraint PK_GRANT primary key nonclustered (ID_Grant)

go

/*==============================================================*/

/* Table: "Group" */

/*==============================================================*/

create table "Group" (

ID_Group int identity,

Number nvarchar(4) not null,

Speciality nvarchar(6) not null

)

go

alter table "Group"

add constraint PK_GROUP primary key nonclustered (ID_Group)

go

alter table "Group"

add constraint AK_IDENTIFIER_2_GROUP unique (Number)

go

/*==============================================================*/

/* Table: SDegree */

/*==============================================================*/

create table SDegree (

ID_UchStep int identity,

Teachers int not null,

SDegree nvarchar(50) not null,

Date datetime not null

)

go

alter table SDegree

add constraint PK_SDEGREE primary key nonclustered (ID_UchStep)

go

/*==============================================================*/

/* Table: Salary */

/*==============================================================*/

create table Salary (

ID_Zarplata int identity,

Teachers int not null,

Volume money not null,

Date datetime not null

)

go

alter table Salary

add constraint PK_SALARY primary key nonclustered (ID_Zarplata)

go

/*==============================================================*/

/* Table: Speciality */

/*==============================================================*/

create table Speciality (

ID_Spec int identity,

Nspec nvarchar(6) not null,

Name nvarchar(100) not null,

Department nvarchar(10) not null,

StudyCost money not null

)

go

alter table Speciality

add constraint PK_SPECIALITY primary key nonclustered (ID_Spec)

go

alter table Speciality

add constraint AK_IDENTIFIER_2_SPECIALI unique (Name)

go

alter table Speciality

add constraint AK_IDENTIFIER_3_SPECIALI unique (Nspec)

go

/*==============================================================*/

/* Table: Student */

/*==============================================================*/

create table Student (

Nzach nvarchar(5) not null,

FIO nvarchar(50) not null,

Faculty int not null,

"Group" int not null,

StudyForm text not null,

Factory text null,

IsPay bit not null

)

go

alter table Student

add constraint PK_STUDENT primary key nonclustered (Nzach)

go

/*==============================================================*/

/* Table: Subject */

/*==============================================================*/

create table Subject (

Nsubject int not null,

Name nvarchar(50) not null

)

go

alter table Subject

add constraint PK_SUBJECT primary key nonclustered (Nsubject)

go

alter table Subject

add constraint AK_IDENTIFIER_2_SUBJECT unique (Name)

go

/*==============================================================*/

/* Table: Teach */

/*==============================================================*/

create table Teach (

ID_Teach int identity,

Subject int not null,

Teachers int not null,

Date datetime not null

)

go

alter table Teach

add constraint PK_TEACH primary key nonclustered (ID_Teach)

go

/*==============================================================*/

/* Table: Teachers */

/*==============================================================*/

create table Teachers (

Nprep int not null,

FIO nvarchar(50) not null,

Department int not null,

Dolznost nvarchar(50) not null,

DatePrin datetime not null

)

go

alter table Teachers

add constraint PK_TEACHERS primary key nonclustered (Nprep)

go

alter table Exam

add constraint FK_EXAM_IN_SUBJECT foreign key (Subject)

references Subject (Nsubject)

on update cascade

go

alter table Exam

add constraint FK_EXAM_SDAETSA_STUDENT foreign key (Student)

references Student (Nzach)

on update cascade

go

alter table "Grant"

add constraint FK_GRANT_PAY_STUDENT foreign key (Student)

references Student (Nzach)

on update cascade

go

alter table "Group"

add constraint FK_GROUP_BELONGS_SPECIALI foreign key (Speciality)

references Speciality (ID_Spec)

on update cascade

go

alter table SDegree

add constraint "FK_SDEGREE_IS AT_TEACHERS" foreign key (Teachers)

references Teachers (Nprep)

on update cascade

go

alter table Salary

add constraint FK_SALARY_GIVEN1_TEACHERS foreign key (Teachers)

references Teachers (Nprep)

on update cascade

go

alter table Speciality

add constraint FK_SPECIALI_GRADUATE_DEPARTME foreign key (Department)

references Department (ID_Dep)

on update cascade

go

alter table Student

add constraint FK_STUDENT_CONCERNS_GROUP foreign key ("Group")

references "Group" (ID_Group)

on update cascade

go

alter table Student

add constraint FK_STUDENT_REGISTERE_FACULTY foreign key (Faculty)

references Faculty (ID_Faculty)

on update cascade

go

alter table Teach

add constraint FK_TEACH_TEACH_SUBJECT foreign key (Subject)

references Subject (Nsubject)

on update cascade

go

alter table Teach

add constraint FK_TEACH_TEACH2_TEACHERS foreign key (Teachers)

references Teachers (Nprep)

on update cascade

go

alter table Teachers

add constraint FK_TEACHERS_WORKS_DEPARTME foreign key (Department)

references Department (ID_Dep)

on update cascade

go

Приложение 2: исходный текст клиентской программы

MainForm.cs:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace StudentAndTeashers

{

public partial class MainForm : Form

{

public static SqlConnection conDB = new SqlConnection();

public static string constring;

public enum UserType

{

Zero = 0,

Student = 1,

Teacher = 2,

Rector = 3,

Admin = 4,

Abiturient = 5

}

public enum ReportSelected

{

Students = 0,

Teachers = 1,

OneStud=2

}

public static UserType user;

public static ReportSelected rs;

public MainForm()

{

InitializeComponent();

}

private void Edit_Click(object sender, EventArgs e)

{

//создаём форму

EditForm EF = new EditForm();

EF.Show();

}

private void Exit_Click(object sender, EventArgs e)

{

Close();

}

private void Help_Click(object sender, EventArgs e)

{

//создаём форму

AboutProgramm AP = new AboutProgramm();

AP.Show();

}

private void MainForm_Load(object sender, EventArgs e)

{

zast Z = new zast();

Z.ShowDialog();

Microsoft.Data.ConnectionUI.DataConnectionDialog _dialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();

Microsoft.Data.ConnectionUI.DataSource.AddStandardDataSources(_dialog);

Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(_dialog);

constring = _dialog.ConnectionString;

if (_dialog.ConnectionString != "")

{

conDB.ConnectionString = _dialog.ConnectionString;

Password P = new Password();

P.ShowDialog();

if (P.DialogResult != DialogResult.OK) Application.Exit();

switch (user)

{

case UserType.Admin:

отчетToolStripMenuItem.Visible = false;

EditForm EF = new EditForm();

EF.MdiParent = this;

EF.Show();

break;

case UserType.Student:

StudForm SF = new StudForm();

отчетToolStripMenuItem.Visible = true;

студентыToolStripMenuItem.Visible = false;

мояУспеваемостьToolStripMenuItem.Visible = true;

преподавателиToolStripMenuItem.Visible = false;

SF.MdiParent = this;

SF.Show();

break;

case UserType.Teacher:

TeacherForm TF = new TeacherForm();

отчетToolStripMenuItem.Visible = false;

TF.MdiParent = this;

TF.Show();

break;

case UserType.Rector:

RectorForm R = new RectorForm();

студентыToolStripMenuItem.Visible = true;

преподавателиToolStripMenuItem.Visible = true;

мояУспеваемостьToolStripMenuItem.Visible = false;

отчетToolStripMenuItem.Visible = true;

R.MdiParent = this;

R.Show();

break;

case UserType.Abiturient:

AbiturientForm AbF = new AbiturientForm();

отчетToolStripMenuItem.Visible = false;

AbF.MdiParent = this;

AbF.Show();

break;

default: MessageBox.Show("Вы не являетесь зарегестрированным пользователем! \n Попробуйте зайти еще раз", "Вход не произведен", MessageBoxButtons.OK, MessageBoxIcon.Error);

break;

}

this.WindowState = FormWindowState.Maximized;

}

else

{

MessageBox.Show("Сервер не выбран! \n Приложение будет закрыто", "Вход не произведен", MessageBoxButtons.OK, MessageBoxIcon.Error);

Application.Exit();

}

}

private void сменитьПользователяToolStripMenuItem_Click(object sender, EventArgs e)

{

foreach (Form f in MdiChildren)

f.Close();

Password P = new Password();

P.ShowDialog();

if (P.DialogResult != DialogResult.OK) Application.Exit();

switch (user)

{

case UserType.Admin:

отчетToolStripMenuItem.Visible = false;

EditForm EF = new EditForm();

EF.MdiParent = this;

EF.Show();

break;

case UserType.Student:

StudForm SF = new StudForm();

отчетToolStripMenuItem.Visible = true;

студентыToolStripMenuItem.Visible = false;

мояУспеваемостьToolStripMenuItem.Visible = true;

преподавателиToolStripMenuItem.Visible = false;

SF.MdiParent = this;

SF.Show();

break;

case UserType.Teacher:

TeacherForm TF = new TeacherForm();

отчетToolStripMenuItem.Visible = false;

TF.MdiParent = this;

TF.Show();

break;

case UserType.Rector:

RectorForm R = new RectorForm();

студентыToolStripMenuItem.Visible = true;

преподавателиToolStripMenuItem.Visible = true;

отчетToolStripMenuItem.Visible = true;

R.MdiParent = this;

R.Show();

break;

case UserType.Abiturient:

AbiturientForm AbF = new AbiturientForm();

отчетToolStripMenuItem.Visible = false;

AbF.MdiParent = this;

AbF.Show();

break;

default: MessageBox.Show("Вы не являетесь зарегестрированным пользователем! \n Попробуйте зайти еще раз", "Вход не произведен", MessageBoxButtons.OK, MessageBoxIcon.Error);

break;

}

}

private void выходToolStripMenuItem_Click(object sender, EventArgs e)

{

Application.Exit();

}

private void оПрограммеToolStripMenuItem_Click(object sender, EventArgs e)

{

AboutProgramm About = new AboutProgramm();

About.MdiParent = this;

About.Show();

}

private void студентыToolStripMenuItem_Click(object sender, EventArgs e)

{

rs = ReportSelected.Students;

ReportsForm rep = new ReportsForm();

rep.MdiParent = this;

rep.Show();

}

private void преподавателиToolStripMenuItem_Click(object sender, EventArgs e)

{

rs = ReportSelected.Teachers;

ReportsForm rep = new ReportsForm();

rep.MdiParent = this;

rep.Show();

}

private void мояУспеваемостьToolStripMenuItem_Click(object sender, EventArgs e)

{

rs = ReportSelected.OneStud;

ReportsForm rep = new ReportsForm();

rep.MdiParent = this;

rep.Show();

}

}

}

EditForm.cs:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Data.SqlClient;

using System.Windows.Forms;

namespace StudentAndTeashers

{

public partial class EditForm : Form

{

// public static SqlConnection conDB = new SqlConnection();

// string constring = "Data Source=HAMSTER-ПК\\SQLEXPRESS;Initial Catalog=Университет;User ID=sa; Password=sa;";

public EditForm()

{

InitializeComponent();

}

private void EditForm_Load(object sender, EventArgs e)

{

sDegreeTableAdapter.Connection = MainForm.conDB;

salaryTableAdapter.Connection = MainForm.conDB;

grantTableAdapter.Connection = MainForm.conDB;

teachersTableAdapter.Connection = MainForm.conDB;

groupTableAdapter.Connection = MainForm.conDB;

specialityTableAdapter.Connection = MainForm.conDB;

studentTableAdapter.Connection = MainForm.conDB;

departmentTableAdapter.Connection = MainForm.conDB;

teachTableAdapter.Connection = MainForm.conDB;

subjectTableAdapter.Connection = MainForm.conDB;

examTableAdapter.Connection = MainForm.conDB;

facultyTableAdapter.Connection = MainForm.conDB;

this.sDegreeTableAdapter.Fill(this.университетDataSet.SDegree);

this.salaryTableAdapter.Fill(this.университетDataSet.Salary);

this.grantTableAdapter.Fill(this.университетDataSet.Grant);

this.teachersTableAdapter.Fill(this.университетDataSet.Teachers);

this.groupTableAdapter.Fill(this.университетDataSet.Group);

this.specialityTableAdapter.Fill(this.университетDataSet.Speciality);

this.facultyTableAdapter.Fill(this.университетDataSet.Faculty);

this.departmentTableAdapter.Fill(this.университетDataSet.Department);

this.studentTableAdapter.Fill(this.университетDataSet.Student);

this.teachTableAdapter.Fill(this.университетDataSet.Teach);

this.subjectTableAdapter.Fill(this.университетDataSet.Subject);

this.examTableAdapter.Fill(this.университетDataSet.Exam);

comboBoxPay.SelectedIndex = 0;

ButtonAdd.Text = "Добавить";

TextNzach.Visible = true;

TextFIO.Visible = true;

TextFaculty.Visible = true;

comboBoxPay.Visible = true;

TextGroup.Visible = true;

TextStudyForm.Visible = true;

TextFactory.Visible = true;

LabelNzach.Visible = true;

LabelFIO.Visible = true;

LabelFaculty.Visible = true;

LabelStudyPay.Visible = true;

LabelGroup.Visible = true;

LabelStudyForm.Visible = true;

LabelFactory.Visible = true;

}

private void ButtonUpdate_Click(object sender, EventArgs e)

{

}

private void RBAdd_Click(object sender, EventArgs e)

{

TextFIO.Clear();

TextFaculty.Clear();

TextGroup.Clear();

TextStudyForm.Clear();

TextFactory.Clear();

ButtonAdd.Text = "Добавить";

TextNzach.Visible=true;

TextFIO.Visible = true;

TextFaculty.Visible = true;

comboBoxPay.Visible = true;

TextGroup.Visible = true;

TextStudyForm.Visible = true;

TextFactory.Visible = true;

LabelNzach.Visible = true;

LabelFIO.Visible = true;

LabelFaculty.Visible = true;

LabelStudyPay.Visible = true;

LabelGroup.Visible = true;

LabelStudyForm.Visible = true;

LabelFactory.Visible = true;

}

private void RBEdit_Click(object sender, EventArgs e)

{

ButtonAdd.Text ="Изменить";

TextNzach.Visible = false;

TextFIO.Visible = true;

TextFaculty.Visible = true;

comboBoxPay.Visible = true;

TextGroup.Visible = true;

TextStudyForm.Visible = true;

TextFactory.Visible = true;

LabelNzach.Visible = false;

LabelFIO.Visible = true;

LabelFaculty.Visible = true;

LabelStudyPay.Visible = true;

LabelGroup.Visible = true;

LabelStudyForm.Visible = true;

LabelFactory.Visible = true;

}

private void RBDelete_Click(object sender, EventArgs e)

{

ButtonAdd.Text = "Удалить";

TextNzach.Visible = false;

TextFIO.Visible = false;

comboBoxPay.Visible = false;

TextFaculty.Visible =false;

TextGroup.Visible = false;

TextStudyForm.Visible = false;

TextFactory.Visible = false;

LabelNzach.Visible = false;

LabelFIO.Visible = false;

LabelFaculty.Visible =false;

LabelStudyPay.Visible = false;

LabelGroup.Visible = false;

LabelStudyForm.Visible = false;

LabelFactory.Visible = false;

}

private void ButtonAdd_Click(object sender, EventArgs e)

{

if (RBAdd.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE StudentInsert @Nzach,@FIO,@group,@faculty,@fo,@factory,@ispay, @re output";

try

{

com.Parameters.Add("@Nzach", SqlDbType.NVarChar, 5).Value = TextNzach.Text;

com.Parameters.Add("@FIO", SqlDbType.NVarChar, 50).Value = TextFIO.Text;

com.Parameters.Add("@group", SqlDbType.NVarChar, 4).Value = TextGroup.Text;

com.Parameters.Add("@faculty", SqlDbType.NVarChar, 10).Value = TextFaculty.Text;

com.Parameters.Add("@fo", SqlDbType.NVarChar, 10).Value = TextStudyForm.Text;

com.Parameters.Add("@factory", SqlDbType.NVarChar, 100).Value = TextFactory.Text;

if (comboBoxPay.SelectedIndex == 0)

com.Parameters.Add("@ispay", SqlDbType.Bit).Value = "true";

else

com.Parameters.Add("@ispay", SqlDbType.Bit).Value = "False";

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -2:

MessageBox.Show("Нет такой группы", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -1:

MessageBox.Show("Запись с таким номером зачетной книжки уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -3:

MessageBox.Show("Нет такого факультета", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDelete.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE StudentDelete @Nzach,@re output ";

// try

// {

com.Parameters.Add("@Nzach", SqlDbType.NVarChar, 5).Value = TableStudent.Rows[TableStudent.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Нет такой записи", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBEdit.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE StudentUpdate @Nzach,@FIO,@group,@faculty,@fo,@factory,@ispay, @re output";

try

{

com.Parameters.Add("@Nzach", SqlDbType.NVarChar, 5).Value = TableStudent.Rows[TableStudent.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@FIO", SqlDbType.NVarChar, 50).Value = TextFIO.Text;

com.Parameters.Add("@group", SqlDbType.NVarChar, 4).Value = TextGroup.Text;

com.Parameters.Add("@faculty", SqlDbType.NVarChar, 10).Value = TextFaculty.Text;

com.Parameters.Add("@fo", SqlDbType.NVarChar, 10).Value = TextStudyForm.Text;

com.Parameters.Add("@factory", SqlDbType.NVarChar, 100).Value = TextFactory.Text;

if (comboBoxPay.SelectedIndex == 0)

com.Parameters.Add("@ispay", SqlDbType.Bit).Value = "true";

else

com.Parameters.Add("@ispay", SqlDbType.Bit).Value = "false";

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -2:

MessageBox.Show("Нет такой группы", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -1:

MessageBox.Show("Запись с таким номером зачетной книжки уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -3:

MessageBox.Show("Нет такого факультета", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.studentTableAdapter.Fill(this.университетDataSet.Student);

}

private void ButtonConnect_Click(object sender, EventArgs e)

{

}

private void ButtonExit_Click(object sender, EventArgs e)

{

Close();

}

private void RBAddDepartament_Click(object sender, EventArgs e)

{

ButtonDepartamentEdit.Text = "Добавить запись";

textDepartamentShortName.Text = "";

textDepartamentFullName.Text = "";

textDepartamentShortName.Visible = true;

textDepartamentFullName.Visible = true;

LabelDepartamentShortName.Visible = true;

LabelDepartamentFullName.Visible = true;

}

private void RBDeleteDepartament_Click(object sender, EventArgs e)

{

ButtonDepartamentEdit.Text = "Удалить запись";

textDepartamentShortName.Text = "";

textDepartamentShortName.Visible = false;

textDepartamentFullName.Visible = false;

LabelDepartamentShortName.Visible = false;

LabelDepartamentFullName.Visible = false;

}

private void ButtonDepartamentEdit_Click(object sender, EventArgs e)

{

if (RBAddDepartament.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE DepartmentInsert @ShortName ,@FullName, @re output";

try

{

if ((textDepartamentShortName.Text != "") & (textDepartamentFullName.Text != ""))

{

com.Parameters.Add("@ShortName", SqlDbType.NVarChar, 10).Value = textDepartamentShortName.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@FullName", SqlDbType.NVarChar, 100).Value = textDepartamentFullName.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Запись о кафедре с таким названием уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteDepartament.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE DepartmentDelete @ID,@re output ";

com.Parameters.Add("@ID", SqlDbType.Int).Value = DepertamentGridView.Rows[DepertamentGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Нельзя удалить - на кафедре есть преподаватели или специальности!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBEditDepartament.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE DepartmentUpdate @ID, @ShortName ,@FullName, @re output";

try

{

com.Parameters.Add("@ID", SqlDbType.Int).Value = DepertamentGridView.Rows[DepertamentGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@ShortName", SqlDbType.NVarChar, 10).Value = textDepartamentShortName.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@FullName", SqlDbType.NVarChar, 100).Value = textDepartamentFullName.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -2)

{

MessageBox.Show("Кафедра с таким названием уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.departmentTableAdapter.Fill(this.университетDataSet.Department);

}

private void RBAddSalary_CheckedChanged(object sender, EventArgs e)

{

buttonSalary.Text = "Добавить";

labelSalaryTeachers.Visible = true;

textSalaryTeachers.Visible = true;

labelSalaryVolume.Visible = true;

textSalaryVolume.Visible = true;

labelSalaryDate.Visible = true;

textSalaryDate.Visible = true;

textSalaryTeachers.Clear();

textSalaryVolume.Clear();

textSalaryDate.Clear();

}

private void RBUpdateSalary_CheckedChanged(object sender, EventArgs e)

{

buttonSalary.Text = "Изменить";

labelSalaryTeachers.Visible = true;

textSalaryTeachers.Visible = true;

labelSalaryVolume.Visible = true;

textSalaryVolume.Visible = true;

labelSalaryDate.Visible = true;

textSalaryDate.Visible = true;

}

private void RBDeleteSalary_CheckedChanged(object sender, EventArgs e)

{

buttonSalary.Text = "Удалить";

labelSalaryTeachers.Visible = false;

textSalaryTeachers.Visible = false;

labelSalaryVolume.Visible = false;

textSalaryVolume.Visible = false;

labelSalaryDate.Visible = false;

textSalaryDate.Visible = false;

}

private void buttonSalary_Click(object sender, EventArgs e)

{

if (RBAddSalary.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SalaryInsert @Teachers ,@volume, @Date, @re output";

try

{

com.Parameters.Add("@Teachers", SqlDbType.Int).Value = textSalaryTeachers.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@volume", SqlDbType.Money).Value = textSalaryVolume.Text;

com.Parameters.Add("@Date", SqlDbType.DateTime).Value = textSalaryDate.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -2)

{

MessageBox.Show("Введенного преподавателя не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteSalary.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SalaryDelete @ID,@re output ";

try

{

com.Parameters.Add("@ID", SqlDbType.Int).Value = SalaryGridView.Rows[SalaryGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Такой записи не существует!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBUpdateSalary.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SalaryUpdate @ID,@Teachers ,@volume, @Date, @re output";

try

{

com.Parameters.Add("@Teachers", SqlDbType.Int).Value = textSalaryTeachers.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters.Add("@volume", SqlDbType.Money).Value = textSalaryVolume.Text;

com.Parameters.Add("@ID", SqlDbType.Int).Value = SalaryGridView.Rows[SalaryGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Date", SqlDbType.DateTime).Value = textSalaryDate.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -2)

{

MessageBox.Show("Введенного преподавателя не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.salaryTableAdapter.Fill(this.университетDataSet.Salary);

}

private void RBAddGrant_CheckedChanged(object sender, EventArgs e)

{

buttonGrant.Text = "Добавить";

labelGrantStudent.Visible = true;

textGrantStudent.Visible = true;

labelGrantSize.Visible = true;

textGrantSize.Visible = true;

labelGrantDate.Visible = true;

textGrantDate.Visible = true;

textGrantStudent.Clear();

textGrantSize.Clear();

textGrantDate.Clear();

}

private void RBUpdateGrant_CheckedChanged(object sender, EventArgs e)

{

buttonGrant.Text = "Изменить";

labelGrantStudent.Visible = true;

textGrantStudent.Visible = true;

labelGrantSize.Visible = true;

textGrantSize.Visible = true;

labelGrantDate.Visible = true;

textGrantDate.Visible = true;

}

private void RBDeleteGrant_CheckedChanged(object sender, EventArgs e)

{

buttonGrant.Text = "Удалить";

labelGrantStudent.Visible = false;

textGrantStudent.Visible = false;

labelGrantSize.Visible = false;

textGrantSize.Visible = false;

labelGrantDate.Visible = false;

textGrantDate.Visible = false;

}

private void buttonGrant_Click(object sender, EventArgs e)

{

}

private void RBDeleteGrant_CheckedChanged_1(object sender, EventArgs e)

{

buttonGrant.Text = "Удалить";

labelGrantStudent.Visible = false;

textGrantStudent.Visible = false;

labelGrantSize.Visible = false;

textGrantSize.Visible = false;

labelGrantDate.Visible = false;

textGrantDate.Visible = false;

}

private void RBUpdateGrant_CheckedChanged_1(object sender, EventArgs e)

{

buttonGrant.Text = "Изменить";

labelGrantStudent.Visible = true;

textGrantStudent.Visible = true;

labelGrantSize.Visible = true;

textGrantSize.Visible = true;

labelGrantDate.Visible = true;

textGrantDate.Visible = true;

}

private void buttonGrant_Click_1(object sender, EventArgs e)

{

if (RBAddGrant.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE GrantInsert @Student ,@volume, @Date, @re output";

try

{

com.Parameters.Add("@Student", SqlDbType.NVarChar, 5).Value = textGrantStudent.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@volume", SqlDbType.Money).Value = textGrantSize.Text;

com.Parameters.Add("@Date", SqlDbType.DateTime).Value = textGrantDate.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Введенного студента не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteGrant.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE GrantDelete @ID,@re output ";

try

{

com.Parameters.Add("@ID", SqlDbType.Int).Value = GrantGridView.Rows[GrantGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Такой записи не существует!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBUpdateGrant.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE GrantUpdate @ID,@Student ,@volume, @Date, @re output";

try

{

com.Parameters.Add("@Student", SqlDbType.NVarChar, 5).Value = textGrantStudent.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters.Add("@volume", SqlDbType.Money).Value = textGrantSize.Text;

com.Parameters.Add("@ID", SqlDbType.Int).Value = GrantGridView.Rows[GrantGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Date", SqlDbType.DateTime).Value = textGrantDate.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -2)

{

MessageBox.Show("Введенного студента не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.grantTableAdapter.Fill(this.университетDataSet.Grant);

}

private void RBAddTeachers_CheckedChanged(object sender, EventArgs e)

{

buttonTeachers.Text = "Добавить";

textTeachersFIO.Visible = true;

textTeachersDepartament.Visible = true;

textTeachersDolznost.Visible = true;

textTeachersDatePrin.Visible = true;

labelTeachersFIO.Visible = true;

labelTeachersDepartament.Visible = true;

labelTeachersDolznost.Visible = true;

labelTeachersDatePrin.Visible = true;

textTeachersFIO.Clear();

textTeachersDepartament.Clear();

textTeachersDolznost.Clear();

textTeachersDatePrin.Clear();

}

private void RBUpdateTeachers_CheckedChanged(object sender, EventArgs e)

{

buttonTeachers.Text = "Изменить";

textTeachersFIO.Visible = true;

textTeachersDepartament.Visible = true;

textTeachersDolznost.Visible = true;

textTeachersDatePrin.Visible = true;

labelTeachersFIO.Visible = true;

labelTeachersDepartament.Visible = true;

labelTeachersDolznost.Visible = true;

labelTeachersDatePrin.Visible = true;

}

private void RBDeleteTeachers_CheckedChanged(object sender, EventArgs e)

{

buttonTeachers.Text = "Удалить";

textTeachersFIO.Visible = false;

textTeachersDepartament.Visible = false;

textTeachersDolznost.Visible = false;

textTeachersDatePrin.Visible = false;

labelTeachersFIO.Visible = false;

labelTeachersDepartament.Visible = false;

labelTeachersDolznost.Visible = false;

labelTeachersDatePrin.Visible = false;

}

private void buttonTeachers_Click(object sender, EventArgs e)

{

if (RBAddTeachers.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE TeachersInsert @FIO ,@Department, @Dolznost,@DatePrin, @re output";

try

{

com.Parameters.Add("@FIO", SqlDbType.NVarChar, 50).Value = textTeachersFIO.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Department", SqlDbType.NVarChar, 10).Value = textTeachersDepartament.Text;

com.Parameters.Add("@Dolznost", SqlDbType.NVarChar, 50).Value = textTeachersDolznost.Text;

com.Parameters.Add("@DatePrin", SqlDbType.DateTime).Value = textTeachersDatePrin.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Введенной кафедры не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteTeachers.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE TeachersDelete @ID,@re output";

com.Parameters.Add("@ID", SqlDbType.Int).Value = TeachersGridView.Rows[TeachersGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Введенного преподавателя не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBUpdateTeachers.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE TeachersUpdate @ID,@FIO ,@Department, @Dolznost,@DatePrin, @re output";

try

{

com.Parameters.Add("@FIO", SqlDbType.NVarChar, 50).Value = textTeachersFIO.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Department", SqlDbType.NVarChar, 10).Value = textTeachersDepartament.Text;

com.Parameters.Add("@Dolznost", SqlDbType.NVarChar, 50).Value = textTeachersDolznost.Text;

com.Parameters.Add("@ID", SqlDbType.Int).Value = TeachersGridView.Rows[TeachersGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@DatePrin", SqlDbType.DateTime).Value = textTeachersDatePrin.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Введенной кафедры не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.teachersTableAdapter.Fill(this.университетDataSet.Teachers);

}

private void RBAddDepartament_CheckedChanged(object sender, EventArgs e)

{

ButtonDepartamentEdit.Text = "Добавить";

textDepartamentShortName.Visible = true;

LabelDepartamentShortName.Visible = true;

textDepartamentFullName.Visible = true;

LabelDepartamentFullName.Visible = true;

textDepartamentShortName.Clear();

textDepartamentFullName.Clear();

}

private void RBEditDepartament_CheckedChanged(object sender, EventArgs e)

{

ButtonDepartamentEdit.Text = "Изменить";

textDepartamentShortName.Visible = true;

LabelDepartamentShortName.Visible = true;

textDepartamentFullName.Visible = true;

LabelDepartamentFullName.Visible = true;

}

private void RBDeleteDepartament_CheckedChanged(object sender, EventArgs e)

{

ButtonDepartamentEdit.Text = "Удалить";

textDepartamentShortName.Visible = false;

LabelDepartamentShortName.Visible = false;

textDepartamentFullName.Visible = false;

LabelDepartamentFullName.Visible = false;

}

private void buttonFaculty_Click(object sender, EventArgs e)

{

if (RBAddFaculty.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE FacultyInsert @ShortName ,@FullName, @re output";

try

{

if ((textFacultyShortName.Text != "") & (textFacultyShortName.Text != ""))

{

com.Parameters.Add("@ShortName", SqlDbType.NVarChar, 10).Value = textFacultyShortName.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@FullName", SqlDbType.NVarChar, 100).Value = textFacultyFullName.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Запись о факультете с таким названием уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteFaculty.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE FacultyDelete @ID,@re output ";

com.Parameters.Add("@ID", SqlDbType.Int).Value = FacultyGridView.Rows[FacultyGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Нельзя удалить - на факультете есть студенты!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBUpdateFaculty.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE FacultyUpdate @ID, @ShortName ,@FullName, @re output";

try

{

com.Parameters.Add("@ID", SqlDbType.Int).Value = FacultyGridView.Rows[FacultyGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@ShortName", SqlDbType.NVarChar, 10).Value = textFacultyShortName.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@FullName", SqlDbType.NVarChar, 100).Value = textFacultyFullName.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -2)

{

MessageBox.Show("Факультет с таким названием уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.facultyTableAdapter.Fill(this.университетDataSet.Faculty);

}

private void buttonSpec_Click(object sender, EventArgs e)

{

if (RBAddSpeciality.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SpecialityInsert @Nspec ,@Name, @Department,@StudyCost, @re output";

try

{

com.Parameters.Add("@Nspec", SqlDbType.NVarChar, 6).Value = textSpecialitySpec.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = textSpecialityName.Text;

com.Parameters.Add("@Department", SqlDbType.NVarChar, 10).Value = textSpecialityDepartament.Text;

com.Parameters.Add("@StudyCost", SqlDbType.Money).Value = textSpecialityStudyCost.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -1:

MessageBox.Show("Запись о такой специальности уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -2:

MessageBox.Show("Введенная кафедра не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteSpeciality.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SpecialityDelete @ID,@re output ";

// try

// {

com.Parameters.Add("@ID", SqlDbType.Int).Value = SpecialityGridView.Rows[SpecialityGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Нельзя удалить - на специальности есть группы!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBUpdateSpeciality.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SpecialityUpdate @ID,@Nspec ,@Name, @Department,@StudyCost, @re output";

try

{

com.Parameters.Add("@ID", SqlDbType.Int).Value = SpecialityGridView.Rows[SpecialityGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@Nspec", SqlDbType.NVarChar, 6).Value = textSpecialitySpec.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = textSpecialityName.Text;

com.Parameters.Add("@Department", SqlDbType.NVarChar, 10).Value = textSpecialityDepartament.Text;

com.Parameters.Add("@StudyCost", SqlDbType.Money).Value = textSpecialityStudyCost.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -2:

MessageBox.Show("Запись о такой специальности уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -1:

MessageBox.Show("Введенная кафедра не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.specialityTableAdapter.Fill(this.университетDataSet.Speciality);

}

private void buttonSpec_Click_1(object sender, EventArgs e)

{

if (RBAddSpeciality.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SpecialityInsert @Nspec ,@Name, @Department,@StudyCost, @re output";

try

{

com.Parameters.Add("@Nspec", SqlDbType.NVarChar, 6).Value = textSpecialitySpec.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = textSpecialityName.Text;

com.Parameters.Add("@Department", SqlDbType.NVarChar, 10).Value = textSpecialityDepartament.Text;

com.Parameters.Add("@StudyCost", SqlDbType.Money).Value = textSpecialityStudyCost.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -1:

MessageBox.Show("Запись о такой специальности уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -2:

MessageBox.Show("Введенная кафедра не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteSpeciality.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SpecialityDelete @ID,@re output ";

com.Parameters.Add("@ID", SqlDbType.Int).Value = SpecialityGridView.Rows[SpecialityGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Нельзя удалить - на специальности есть группы!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBUpdateSpeciality.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE SpecialityUpdate @ID,@Nspec ,@Name, @Department,@StudyCost, @re output";

try

{

com.Parameters.Add("@ID", SqlDbType.Int).Value = SpecialityGridView.Rows[SpecialityGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@Nspec", SqlDbType.NVarChar, 6).Value = textSpecialitySpec.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = textSpecialityName.Text;

com.Parameters.Add("@Department", SqlDbType.NVarChar, 10).Value = textSpecialityDepartament.Text;

com.Parameters.Add("@StudyCost", SqlDbType.Money).Value = textSpecialityStudyCost.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -2:

MessageBox.Show("Запись о такой специальности уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -1:

MessageBox.Show("Введенная кафедра не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.specialityTableAdapter.Fill(this.университетDataSet.Speciality);

}

private void buttonGroup_Click(object sender, EventArgs e)

{

if (RBAddGroup.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE GroupInsert @number ,@speciality, @re output";

try

{

com.Parameters.Add("@number", SqlDbType.NVarChar, 4).Value = textGroupNumber.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@speciality", SqlDbType.NVarChar, 6).Value = textGroupSpeciality.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -1:

MessageBox.Show("Запись о такой группе уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -2:

MessageBox.Show("Введенная специальность не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBDeleteGroup.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE GroupDelete @ID,@re output ";

com.Parameters.Add("@ID", SqlDbType.Int).Value = GroupGridView.Rows[GroupGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

if (flag == -1)

{

MessageBox.Show("Нельзя удалить - в группе числятся студенты!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

if (RBUpdateGroup.Checked)

{

SqlCommand com = MainForm.conDB.CreateCommand();

com.CommandText = "EXECUTE GroupUpdate @ID,@number ,@speciality, @re output";

try

{

com.Parameters.Add("@ID", SqlDbType.Int).Value = GroupGridView.Rows[GroupGridView.CurrentRow.Index].Cells[0].Value.ToString();

com.Parameters.Add("@number", SqlDbType.NVarChar, 4).Value = textGroupNumber.Text;

com.Parameters.Add("@re", SqlDbType.Int);

com.Parameters["@re"].Direction = ParameterDirection.Output;

com.Parameters.Add("@speciality", SqlDbType.NVarChar, 6).Value = textGroupSpeciality.Text;

MainForm.conDB.Open();

com.ExecuteNonQuery();

MainForm.conDB.Close();

int flag = Convert.ToInt32(com.Parameters["@re"].Value);

switch (flag)

{

case -2:

MessageBox.Show("Запись о такой группе уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -1:

MessageBox.Show("Указанная группа не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

case -3:

MessageBox.Show("Введенной специальности не существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

break;

}

}

catch

{

MainForm.conDB.Close();

MessageBox.Show("Введите корректные данные", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}

this.groupTableAdapter.Fill(this.университетDataSet.Group);

}

private void RBAddFaculty_Click(object sender, EventArgs e)

{

textFacultyShortName.Clear();

textFacultyFullName.Clear();

textFacultyShortName.Visible = true;

textFacultyFullName.Visible = true;

labelFacultyShortName.Visible = true;

labelFacultyFullName.Visible = true;

textFacultyShortName.Clear();

textFacultyFullName.Clear();

buttonFaculty.Text = "Добавить";

}

private void RBUpdateFaculty_Click(object sender, EventArgs e)

{

textFacultyShortName.Visible = true;

textFacultyFullName.Visible = true;

labelFacultyShortName.Visible = true;

labelFacultyFullName.Visible = true;

buttonFaculty.Text = "Изменить";

}

private void RBDeleteFaculty_Click(object sender, EventArgs e)

{

textFacultyShortName.Visible = false;

textFacultyFullName.Visible = false;

labelFacultyShortName.Visible = false;

labelFacultyFullName.Visible = false;

buttonFaculty.Text = "Удалить";

}

private void RBAddSubject_Click(object sender, EventArgs e)

{

textSubjectName.Visible = true;

labelSubjectName.Visible = true;

textSubjectName.Clear();

buttonSubject.Text = "Добавить";

}

private void RBUpdateSubject_Click(object sender, EventArgs e)

{

textSubjectName.Visible = true;

labelSubjectName.Visible = true;

buttonSubject.Text = "Изменить";

}

private void RBDeleteSubject_Click(object sender, EventArgs e)

{

textSubjectName.Visible = false;

labelSubjectName.Visible = false;

buttonSubject.Text = "Удалить";

}

private void RBAddTeach_Click(object sender, EventArgs e)

{

cbTeachSubject.Visible = true;

cbTeachTeachers.Visible = true;

labelTeachSubject.Visible = true;

labelTeachTeachers.Visible = true;

buttonTeach.Text = "Добавить";

}

private void RBUpdateTeach_Click(object sender, EventArgs e)

{

cbTeachSubject.Visible = true;

cbTeachTeachers.Visible = true;

labelTeachSubject.Visible = true;

labelTeachTeachers.Visible = true;

buttonTeach.Text = "Изменить";

}

private void RBDeleteTeach_Click(object sender, EventArgs e)

{

cbTeachSubject.Visible = false;

cbTeachTeachers.Visible = false;

labelTeachSubject.Visible = false;

labelTeachTeachers.Visible = false;

buttonTeach.Text = "Удалить";

}

private void RBAddExam_Click(object sender, EventArgs e)

{

textExamNzach.Visible = true;

textExamNSubject.Visible = true;

textExamMark.Visible = true;

textExamDate.Visible = true;

labelExamNzach.Visible = true;

labelExamNSubject.Visible = true;

labelExamMark.Visible = true;

labelExamDate.Visible = true;

buttonExam.Text = "Добавить";

}

private void RBUpdateExam_Click(object sender, EventArgs e)

{

textExamNzach.Visible = true;

textExamNSubject.Visible = true;

textExamMark.Visible = true;

textExamDate.Visible = true;

labelExamNzach.Visible = true;

labelExamNSubject.Visible = true;

labelExamMark.Visible = true;

labelExamDate.Visible = true;

buttonExam.Text = "Изменить";

}

private void RBDeleteExam_Click(object sender, EventArgs e)

{

textExamNzach.Visible = false;

textExamNSubject.Visible = false;

textExamMark.Visible = false;

textExamDate.Visible = false;

labelExamNzach.Visible = false;

labelExamNSubject.Visible = false;

labelExamMark.Visible = false;

labelExamDate.Visible = false;

buttonExam.Text = "Удалить";

}

private void RBAddSpeciality_Click(object sender, EventArgs e)

{

textSpecialitySpec.Visible = true;

textSpecialityName.Visible = true;

textSpecialityDepartament.Visible = true;

textSpecialityStudyCost.Visible = true;

labelSpecialitySpec.Visible = true;

labelSpecialityName.Visible = true;

labelSpecialityDepartament.Visible = true;

labelSpecialityStudyCost.Visible = true;

buttonSpec.Text = "Добавить";

textSpecialitySpec.Clear();

textSpecialityName.Clear();

textSpecialityDepartament.Clear();

textSpecialityStudyCost.Clear();

}

private void RBUpdateSpeciality_Click(object sender, EventArgs e)

{

textSpecialitySpec.Visible = true;

textSpecialityName.Visible = true;

textSpecialityDepartament.Visible = true;

textSpecialityStudyCost.Visible = true;

labelSpecialitySpec.Visible = true;

labelSpecialityName.Visible = true;

labelSpecialityDepartament.Visible = true;

labelSpecialityStudyCost.Visible = true;

buttonSpec.Text = "Изменить";

}

private void RBDeleteSpeciality_Click(object sender, EventArgs e)

{

textSpecialitySpec.Visible = false;

textSpecialityName.Visible = false;

textSpecialityDepartament.Visible = false;

textSpecialityStudyCost.Visible = false;

labelSpecialitySpec.Visible = false;

labelSpecialityName.Visible = false;

labelSpecialityDepartament.Visible = false;