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; } }