private void BtCommint_Click(object sender, EventArgs e)
{
switch (tbNewPassword.Text != tbConfPass.Text)
{
case (true):
tbConfPass.Clear();
tbNewPassword.Clear();
break;
case (false):
DataBaseProcedure procedure = new DataBaseProcedure();
DataBaseTables tables = new DataBaseTables();
tables.qrAccess_rights += " and [Access_rights_name] = " +
"'Студент'";
tables.dtAccess_rightsFill();
Int32 Access_Rights_id =
Convert.ToInt32(tables.dtAccess_rights.
Rows[0][0].ToString());
procedure.spProfile_New_User(tbNewLogin.Text,
tbConfPass.Text, Access_Rights_id, 1,
tbImagePath.Text);
procedure.spStudent_Insert(tbNewLogin.Text,
((StudentsForm)parentCreate).tbStudentSurname.Text,
((StudentsForm)parentCreate).tbStudentName.Text,
((StudentsForm)parentCreate).tbStudentMiddleName.Text,
((StudentsForm)parentCreate).mtbTicketNumber.Text,
Convert.ToInt32(((StudentsForm)parentCreate).
cbGroup.SelectedValue.ToString()));
BtCancel_Click(sender, e);
break;
}
}
private void btInsertCom_Click(object sender, EventArgs e)
{
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spCombination_Insert(Convert.ToInt32(ltbPosts.SelectedValue.ToString()),
ltbEmployee.SelectedValue.ToString());
}
private void btInserBurden_Click(object sender, EventArgs e)
{
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spBurden_Insert(ltbEmployeeBurden.SelectedValue.ToString(),
Convert.ToInt32(ltbDiscipline.SelectedValue.ToString()),
Convert.ToInt32(cbGroup.SelectedValue.ToString()), (int)nudCourse.Value);
}
private void btUpdateBurden_Click(object sender, EventArgs e)
{
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spBurden_Update(Convert.ToInt32(dgvBurden.CurrentRow.Cells[0].Value.ToString()),
ltbEmployeeBurden.SelectedValue.ToString(),
Convert.ToInt32(ltbDiscipline.SelectedValue.ToString()),
Convert.ToInt32(cbGroup.SelectedValue.ToString()), (int)nudCourse.Value);
}
private void btUpdateComb_Click(object sender, EventArgs e)
{
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spCombination_Update(Convert.ToInt32(
dgvCombination.CurrentRow.Cells[0].Value.ToString()),
Convert.ToInt32(ltbPosts.SelectedValue.ToString()),
ltbEmployee.SelectedValue.ToString());
}
private void btDeleteComb_Click(object sender, EventArgs e)
{
switch (MessageBox.Show("Удалить совместительство: " + dgvCombination.CurrentRow.Cells[3].Value.ToString() + " " +
dgvCombination.CurrentRow.Cells[4].Value.ToString() + "?", "Удаление совместительство",
MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spCombination_Delete(Convert.ToInt32(
dgvCombination.CurrentRow.Cells[0].Value.ToString()));
break;
}
}
private void btDeleteBurden_Click(object sender, EventArgs e)
{
switch (MessageBox.Show("Удалить нагрузку: " + dgvBurden.CurrentRow.Cells[7].Value.ToString() + " "
+ dgvBurden.CurrentRow.Cells[8].Value.ToString() + " "
+ dgvBurden.CurrentRow.Cells[6].Value.ToString() + "?", "Удаление распределения",
MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spBurden_Delete(Convert.ToInt32(
dgvBurden.CurrentRow.Cells[0].Value.ToString()));
break;
}
}
private void ButtonCommnit_Click(object sender, EventArgs e)
{
switch (comboBoxGroup.Text == ((StudentsForm)parent).cbGroup.Text) //обращаемся напрямую к свойству текст комбобокса без перезаписи значения куда-то еще
{
case (true):
MessageBox.Show("Невозможно изменить группу " + ((StudentsForm)parent).cbGroup.Text + " на " + comboBoxGroup.Text + ". \n Выберите другую группу!");
break;
case (false):
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spStudent_Update(student, ((StudentsForm)parent).tbStudentSurname.Text, ((StudentsForm)parent).tbStudentName.Text, ((StudentsForm)parent).tbStudentMiddleName.Text, ((StudentsForm)parent).mtbTicketNumber.Text, Convert.ToInt32(comboBoxGroup.SelectedValue.ToString()));
break;
}
}
private void BtEnter_Click(object sender, EventArgs e)
{
int acces = 0;
switch (((BurdenCombinationEmployeeForm)parentCheck).OldRole
== Convert.ToInt32(((BurdenCombinationEmployeeForm)parentCheck).
cbAccessRights.SelectedValue.ToString()))
{
case (true):
acces = 1;
break;
case (false):
acces = 0;
break;
}
switch (((BurdenCombinationEmployeeForm)parentCheck).OldPassword
== tbOldPassword.Text)
{
case (true):
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spProfile_Update_User(
((BurdenCombinationEmployeeForm)parentCheck).cbLogin.Text,
tbOldPassword.Text,
Convert.ToInt32(((BurdenCombinationEmployeeForm)parentCheck).
cbAccessRights.SelectedValue.ToString()),
acces, ((BurdenCombinationEmployeeForm)parentCheck).
tbImagePath.Text);
procedure.spEmployee_Update(((BurdenCombinationEmployeeForm)parentCheck)
.cbLogin.Text,
((BurdenCombinationEmployeeForm)parentCheck).tbSurName.Text,
((BurdenCombinationEmployeeForm)parentCheck).tbName.Text,
((BurdenCombinationEmployeeForm)parentCheck).tbMiddleName.Text);
BtCancelCoferm_Click(sender, e);
break;
case (false):
tbConfPass.Clear();
break;
}
}
private void btDelete_Click(object sender, EventArgs e)
{
bool deleteEmployee = false, deleteProfile = false;
switch (MessageBox.Show(
"Удалить сотрудника " + tbSurName.Text + " " + tbName.Text + " " + tbMiddleName.Text + "?", "Удаление сотрудника",
MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
deleteEmployee = true;
break;
}
switch (MessageBox.Show(
"Удалить профиль " + cbLogin.Text + "?", "Удаление профиля",
MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
deleteProfile = true;
break;
}
DataBaseProcedure procedure = new DataBaseProcedure();
switch (deleteEmployee)
{
case (true):
procedure.spEmployee_Delete(cbLogin.Text);
switch (deleteProfile)
{
case (true):
procedure.spProfile_Delete_User(cbLogin.Text);
break;
}
break;
}
}
private void btInsertUpdate_Click(object sender, EventArgs e)
{
switch (tbPassword.Text != tbConfPass.Text)
{
case (true):
tbPassword.Clear();
tbConfPass.Clear();
Registry_Class.error_message += "\n" + DateTime.Now.ToLongDateString() + " пароли не совпадают!";
btError_Click(sender, e);
break;
case (false):
switch (EmployeeCount)
{
case (0):
switch (MessageBox.Show(
"Создать ноую учётную запись:" +
"\n Логин: " + cbLogin.Text + "," +
"\n Права доступа: " + cbAccessRights.Text + "," +
"\n Персональные данные:" +
"\n Фамилия: " + tbSurName.Text + "," +
"\n Имя:" + tbName.Text + "," +
"\n Отчество: " + tbMiddleName.Text + ".", "Создание нового сотрудника",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question))
{
case DialogResult.Yes:
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spProfile_New_User(cbLogin.Text, tbPassword.Text, Convert.ToInt32(cbAccessRights.SelectedValue.ToString()), 0, tbImagePath.Text);
cbLogin.Text = "";
tbPassword.Clear();
tbConfPass.Clear();
tbSurName.Clear();
tbName.Clear();
tbMiddleName.Clear();
tbImagePath.Clear();
break;
}
break;
default:
switch (OldPassword == tbPassword.Text)
{
case (true):
int access = 0;
switch (OldRole == Convert.ToInt32(cbAccessRights.SelectedValue.ToString()))
{
case (true):
access = 1;
break;
case (false):
access = 0;
break;
}
DataBaseProcedure procedure = new DataBaseProcedure();
procedure.spProfile_Update_User(cbLogin.Text, tbPassword.Text,
Convert.ToInt32(cbAccessRights.SelectedValue.ToString()), access, tbImagePath.Text);
procedure.spEmployee_Update(cbLogin.Text, tbSurName.Text,
tbName.Text, tbMiddleName.Text);
break;
case (false):
DynamicObjects dynamicObjects = new DynamicObjects();
dynamicObjects.parentCheck = this;
dynamicObjects.createCheckPass();
break;
}
break;
}
break;
}
}
