Разработка системы тестирования для кандидатов на позиции в компании с целью определения их профессиональной компетенции

this->Close();

}

private: System::Void CandidateTab_Selected(System::Object^ sender, System::EventArgs^ e) {

if (this->CandidateTab->SelectedIndex == 0)

{

this->PassTestButton->Visible = true;

this->ShowTestButton->Visible = false;

}

else if (this->CandidateTab->SelectedIndex == 1)

{

this->PassTestButton->Visible = false;

this->ShowTestButton->Visible = true;

}

}

private: System::Void Candidates_Load(System::Object^ sender, System::EventArgs^ e) {

try

{

RefreshTests();

}

catch (Exception ^ ex)

{

MessageBox::Show("Ошибка соединения с базой даных");

}

}

System::Void RefreshTests()

{

MySqlInterface ^ msi = gcnew MySqlInterface;

DataTable ^ dt = msi->GetCandidateTests(this->_IdUser);

PositionsTestsView->Rows->Clear();

PassedTestsView->Rows->Clear();

if (!PositionsTestsView->Columns->Contains("Id"))

{

PositionsTestsView->Columns->Add("Id", "Id");

}

if (!PositionsTestsView->Columns->Contains("Name"))

{

PositionsTestsView->Columns->Add("Name", "Должность");

}

if (!PassedTestsView->Columns->Contains("Id"))

{

PassedTestsView->Columns->Add("Id", "Id");

}

if (!PassedTestsView->Columns->Contains("Name"))

{

PassedTestsView->Columns->Add("Name", "Должность");

}

if (!PassedTestsView->Columns->Contains("PostingId"))

{

PassedTestsView->Columns->Add("PostingId", "PostingId");

}

if (!PassedTestsView->Columns->Contains("CountPoint"))

{

PassedTestsView->Columns->Add("CountPoint", "Набраные баллы");

}

if (!PassedTestsView->Columns->Contains("NeedPoints"))

{

PassedTestsView->Columns->Add("NeedPoints", "Нужно баллов");

}

if (!PassedTestsView->Columns->Contains("DatePost"))

{

PassedTestsView->Columns->Add("DatePost", "Дата сдачи");

}

if (!PassedTestsView->Columns->Contains("isAccept"))

{

PassedTestsView->Columns->Add("isAccept", "Статус");

}

int postingId = 0;

int rowIndex = 0;

for each (DataRow ^ row in dt->Select())

{

if (int::TryParse(row["PostingId"]->ToString(), postingId))

{

rowIndex = PassedTestsView->Rows->Add();

PassedTestsView->Rows[rowIndex]->Cells["PostingId"]->Value = postingId;

PassedTestsView->Rows[rowIndex]->Cells["Name"]->Value = row["Name"]->ToString();

PassedTestsView->Rows[rowIndex]->Cells["Id"]->Value = row["Id"]->ToString();

PassedTestsView->Rows[rowIndex]->Cells["CountPoint"]->Value = row["CountPoint"]->ToString();

PassedTestsView->Rows[rowIndex]->Cells["NeedPoints"]->Value = row["NeedPoints"]->ToString();

PassedTestsView->Rows[rowIndex]->Cells["DatePost"]->Value = row["DatePost"]->ToString();

PassedTestsView->Rows[rowIndex]->Cells["isAccept"]->Value = int::Parse(row["isAccept"]->ToString()) >= 0 ? (int::Parse(row["isAccept"]->ToString()) > 0 ? "Принят" : "Ожидание") : "Провален";

}

else

{

rowIndex = PositionsTestsView->Rows->Add();

PositionsTestsView->Rows[rowIndex]->Cells["Id"]->Value = row["Id"]->ToString();

PositionsTestsView->Rows[rowIndex]->Cells["Name"]->Value = row["Name"]->ToString();

}

}

PositionsTestsView->Columns["Id"]->Visible = false;

PassedTestsView->Columns["Id"]->Visible = false;

PassedTestsView->Columns["PostingId"]->Visible = false;

}

private: System::Void PassTestButton_Click(System::Object^ sender, System::EventArgs^ e) {

MySqlInterface ^ msi = gcnew MySqlInterface;

DataGridViewRow ^ row;

try

{

row = PositionsTestsView->SelectedRows[0];

DataTable ^ question = msi->GetTests(int::Parse(row->Cells["Id"]->Value->ToString()));

DataTable ^ answers;

QuestionAnswers ^ qa = gcnew QuestionAnswers;

try

{

int rowIndex = 0;

int questionIndex = 1;

for each (DataRow ^ rowQuestion in question->Select())

{

qa = gcnew QuestionAnswers(this->_IdUser, int::Parse(row->Cells["Id"]->Value->ToString()));

answers = msi->GetAnswers(int::Parse(rowQuestion["Id"]->ToString()));

qa->Text = "Вопрос " + questionIndex + " из " + question->Rows->Count;

qa->AnswersList->Columns->Add("QuestionId", "QuestionId");

qa->AnswersList->Columns->Add("AnswerId", "AnswerId");

qa->AnswersList->Columns->Add("AnswerText", "Ответ");

qa->QuestionText->Text = rowQuestion["QuestionText"]->ToString();

qa->ShowPicture->ImageLocation = System::IO::Directory::GetCurrentDirectory() + "\\img\\" + rowQuestion["Pict"];

for each(DataRow ^ rowAnswer in answers->Select())

{

rowIndex = qa->AnswersList->Rows->Add();

qa->AnswersList->Rows[rowIndex]->Cells["QuestionId"]->Value = rowAnswer["QuestionId"]->ToString();

qa->AnswersList->Rows[rowIndex]->Cells["AnswerId"]->Value = rowAnswer["Id"]->ToString();

qa->AnswersList->Rows[rowIndex]->Cells["AnswerText"]->Value = rowAnswer["QuestionText"]->ToString();

}

qa->AnswersList->Columns["QuestionId"]->Visible = false;

qa->AnswersList->Columns["AnswerId"]->Visible = false;

qa->ShowDialog();

if (qa->Except)

{

throw gcnew Exception;

}

questionIndex++;

}

msi->SaveTestResult(this->_IdUser, int::Parse(row->Cells["Id"]->Value->ToString()));

MessageBox::Show("Тест завершен");

RefreshTests();

}

catch (Exception ^ e)

{

qa->Close();

}

}

catch (Exception ^ ex)

{

MessageBox::Show("Выберите должность");

}

}

private: System::Void ShowTestButton_Click(System::Object^ sender, System::EventArgs^ e) {

DataGridViewRow ^ row;

try

{

row = PassedTestsView->SelectedRows[0];

TestResults ^ tr = gcnew TestResults(this->_IdUser, this->_IdUser, int::Parse(row->Cells["Id"]->Value->ToString()));

tr->ShowDialog();

}

catch (Exception ^ e)

{

MessageBox::Show("Выберите тест");

}

}

};

}

#pragma once

#include "MySqlInterface.h"

namespace HR {

using namespace System;

using namespace System::ComponentModel;

using namespace System::Collections;

using namespace System::Windows::Forms;

using namespace System::Data;

using namespace System::Drawing;

/// <summary>

/// Сводка для MeetingForm

/// </summary>

public ref class MeetingForm : public System::Windows::Forms::Form

{

private: int _Id = 0;

private: int _IdUser = 0;

private: System::String ^ _Day;

private: System::String ^ _StartTime;

private: System::String ^ _EndTime;

private: System::String ^ _ClientName;

private: System::Windows::Forms::ComboBox^ CandidatesList;

private: System::String ^ _Description;

public:

MeetingForm(void)

{

InitializeComponent();

//

//TODO: добавьте код конструктора

//

}

MeetingForm(int id, int idUser, System::String ^ day, System::String ^ startTime, System::String ^ endTime, System::String ^ clientName, System::String ^ description)

{

this->_Id = id;

this->_IdUser = idUser;

this->_Day = day;

this->_StartTime = startTime;

this->_EndTime = endTime;

this->_ClientName = clientName;

this->_Description = description;

InitializeComponent();

//

//TODO: добавьте код конструктора

//

}

protected:

/// <summary>

/// Освободить все используемые ресурсы.

/// </summary>

~MeetingForm()

{

if (components)

{

delete components;

}

}

private: System::Windows::Forms::Label^ DayTitle;

protected:

private: System::Windows::Forms::Label^ BeginTimeTitle;

private: System::Windows::Forms::Label^ EndTimeTitle;

private: System::Windows::Forms::Label^ ClientTitle;

private: System::Windows::Forms::Label^ DescriptionTitle;

protected:

protected:

private: System::Windows::Forms::DateTimePicker^ Day;

private: System::Windows::Forms::DateTimePicker^ BeginTime;

private: System::Windows::Forms::DateTimePicker^ EndTime;

private: System::Windows::Forms::TextBox^ Description;

private: System::Windows::Forms::TextBox^ Id;

private: System::Windows::Forms::Button^ AddMeetingButton;

private: System::Windows::Forms::Button^ CancelMeetingButton;

protected:

private: System::ComponentModel::IContainer^ components;

private:

/// <summary>

/// Требуется переменная конструктора.

/// </summary>

#pragma region Windows Form Designer generated code

/// <summary>

/// Обязательный метод для поддержки конструктора - не изменяйте

/// содержимое данного метода при помощи редактора кода.

/// </summary>

void InitializeComponent(void)

{

this->DayTitle = (gcnew System::Windows::Forms::Label());

this->BeginTimeTitle = (gcnew System::Windows::Forms::Label());

this->EndTimeTitle = (gcnew System::Windows::Forms::Label());

this->ClientTitle = (gcnew System::Windows::Forms::Label());

this->DescriptionTitle = (gcnew System::Windows::Forms::Label());

this->Day = (gcnew System::Windows::Forms::DateTimePicker());

this->BeginTime = (gcnew System::Windows::Forms::DateTimePicker());

this->EndTime = (gcnew System::Windows::Forms::DateTimePicker());

this->Description = (gcnew System::Windows::Forms::TextBox());

this->Id = (gcnew System::Windows::Forms::TextBox());

this->AddMeetingButton = (gcnew System::Windows::Forms::Button());

this->CancelMeetingButton = (gcnew System::Windows::Forms::Button());

this->CandidatesList = (gcnew System::Windows::Forms::ComboBox());

this->SuspendLayout();

//

// DayTitle

//

this->DayTitle->AutoSize = true;

this->DayTitle->Location = System::Drawing::Point(32, 12);

this->DayTitle->Name = L"DayTitle";

this->DayTitle->Size = System::Drawing::Size(34, 13);

this->DayTitle->TabIndex = 0;

this->DayTitle->Text = L"День";

//

// BeginTimeTitle

//

this->BeginTimeTitle->AutoSize = true;

this->BeginTimeTitle->Location = System::Drawing::Point(25, 38);

this->BeginTimeTitle->Name = L"BeginTimeTitle";

this->BeginTimeTitle->Size = System::Drawing::Size(44, 13);

this->BeginTimeTitle->TabIndex = 1;

this->BeginTimeTitle->Text = L"Начало";

//

// EndTimeTitle

//

this->EndTimeTitle->AutoSize = true;

this->EndTimeTitle->Location = System::Drawing::Point(151, 38);

this->EndTimeTitle->Name = L"EndTimeTitle";

this->EndTimeTitle->Size = System::Drawing::Size(38, 13);

this->EndTimeTitle->TabIndex = 2;

this->EndTimeTitle->Text = L"Конец";

//

// ClientTitle

//

this->ClientTitle->AutoSize = true;

this->ClientTitle->Location = System::Drawing::Point(23, 64);

this->ClientTitle->Name = L"ClientTitle";

this->ClientTitle->Size = System::Drawing::Size(43, 13);

this->ClientTitle->TabIndex = 3;

this->ClientTitle->Text = L"Клиент";

//

// DescriptionTitle

//

this->DescriptionTitle->AutoSize = true;

this->DescriptionTitle->Location = System::Drawing::Point(9, 92);

this->DescriptionTitle->Name = L"DescriptionTitle";

this->DescriptionTitle->Size = System::Drawing::Size(57, 13);

this->DescriptionTitle->TabIndex = 4;

this->DescriptionTitle->Text = L"Описание";

//

// Day

//

this->Day->Location = System::Drawing::Point(72, 9);

this->Day->Name = L"Day";

this->Day->Size = System::Drawing::Size(200, 20);

this->Day->TabIndex = 6;

//

// BeginTime

//

this->BeginTime->Format = System::Windows::Forms::DateTimePickerFormat::Time;

this->BeginTime->Location = System::Drawing::Point(72, 35);

this->BeginTime->Name = L"BeginTime";

this->BeginTime->ShowUpDown = true;

this->BeginTime->Size = System::Drawing::Size(73, 20);

this->BeginTime->TabIndex = 7;

//

// EndTime

//

this->EndTime->Format = System::Windows::Forms::DateTimePickerFormat::Time;

this->EndTime->Location = System::Drawing::Point(195, 35);

this->EndTime->Name = L"EndTime";

this->EndTime->ShowUpDown = true;

this->EndTime->Size = System::Drawing::Size(77, 20);

this->EndTime->TabIndex = 8;

//

// Description

//

this->Description->Location = System::Drawing::Point(72, 89);

this->Description->MaximumSize = System::Drawing::Size(200, 4);

this->Description->MinimumSize = System::Drawing::Size(4, 45);

this->Description->Multiline = true;

this->Description->Name = L"Description";

this->Description->Size = System::Drawing::Size(200, 45);

this->Description->TabIndex = 10;

//

// Id

//

this->Id->Location = System::Drawing::Point(52, 113);

this->Id->MaximumSize = System::Drawing::Size(200, 4);

this->Id->Multiline = true;

this->Id->Name = L"Id";

this->Id->Size = System::Drawing::Size(14, 4);

this->Id->TabIndex = 11;

this->Id->Text = L"0";

this->Id->Visible = false;

//

// AddMeetingButton

//

this->AddMeetingButton->BackColor = System::Drawing::SystemColors::ControlDarkDark;

this->AddMeetingButton->Location = System::Drawing::Point(12, 140);

this->AddMeetingButton->Name = L"AddMeetingButton";

this->AddMeetingButton->Size = System::Drawing::Size(123, 23);

this->AddMeetingButton->TabIndex = 12;

this->AddMeetingButton->Text = L"Сохранить";

this->AddMeetingButton->UseVisualStyleBackColor = false;

this->AddMeetingButton->Click += gcnew System::EventHandler(this, &MeetingForm::AddMeetingButton_Click);

//

// CancelMeetingButton

//

this->CancelMeetingButton->BackColor = System::Drawing::SystemColors::ControlDarkDark;

this->CancelMeetingButton->Location = System::Drawing::Point(153, 140);

this->CancelMeetingButton->Name = L"CancelMeetingButton";

this->CancelMeetingButton->Size = System::Drawing::Size(119, 23);

this->CancelMeetingButton->TabIndex = 13;

this->CancelMeetingButton->Text = L"Отменить";

this->CancelMeetingButton->UseVisualStyleBackColor = false;

this->CancelMeetingButton->Click += gcnew System::EventHandler(this, &MeetingForm::CancelMeetingButton_Click);

//

// CandidatesList

//

this->CandidatesList->FormattingEnabled = true;

this->CandidatesList->Location = System::Drawing::Point(72, 61);

this->CandidatesList->Name = L"CandidatesList";

this->CandidatesList->Size = System::Drawing::Size(200, 21);

this->CandidatesList->TabIndex = 14;

//

// MeetingForm

//

this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);

this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;

this->BackColor = System::Drawing::SystemColors::ControlDarkDark;

this->ClientSize = System::Drawing::Size(284, 174);

this->Controls->Add(this->CandidatesList);

this->Controls->Add(this->CancelMeetingButton);

this->Controls->Add(this->AddMeetingButton);

this->Controls->Add(this->Id);

this->Controls->Add(this->Description);

this->Controls->Add(this->EndTime);

this->Controls->Add(this->BeginTime);

this->Controls->Add(this->Day);

this->Controls->Add(this->DescriptionTitle);

this->Controls->Add(this->ClientTitle);

this->Controls->Add(this->EndTimeTitle);

this->Controls->Add(this->BeginTimeTitle);

this->Controls->Add(this->DayTitle);

this->ForeColor = System::Drawing::SystemColors::ButtonHighlight;

this->FormBorderStyle = System::Windows::Forms::FormBorderStyle::FixedToolWindow;

this->Name = L"MeetingForm";

this->StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;

this->Text = L"Добавить встречу";

this->Load += gcnew System::EventHandler(this, &MeetingForm::MeetingForm_Load);

this->ResumeLayout(false);

this->PerformLayout();

}

#pragma endregion

private: System::Void MeetingForm_Load(System::Object^ sender, System::EventArgs^ e) {

MySqlInterface ^ msi = gcnew MySqlInterface;

try

{

if (this->_Id > 0)

{

this->Id->Text = "" + this->_Id;

this->Day->Text = this->_Day;

this->BeginTime->Text = this->_StartTime;

this->EndTime->Text = this->_EndTime;

this->CandidatesList->ValueMember = "Id";

this->CandidatesList->DisplayMember = "Name";

this->CandidatesList->DataSource = msi->GetCandidates();

this->CandidatesList->Text = this->_ClientName;

this->Description->Text = this->_Description;

}

else

{

this->CandidatesList->ValueMember = "Id";

this->CandidatesList->DisplayMember = "Name";

this->CandidatesList->DataSource = msi->GetCandidates();

this->CandidatesList->SelectedIndex = -1;

}

}

catch (Exception ^ e)

{

MessageBox::Show("Ошибка соединения с базой даных");

}

}

private: System::Void AddMeetingButton_Click(System::Object^ sender, System::EventArgs^ e) {

MySqlInterface ^ msi = gcnew MySqlInterface;

int candidateId = 0;

try

{

msi->AddUpdateMeeting(int::Parse(this->Id->Text), this->_IdUser, this->Day->Value, this->BeginTime->Value, this->EndTime->Value, int::Parse(this->CandidatesList->SelectedIndex == -1 ? "0" : this->CandidatesList->SelectedValue->ToString()), this->Description->Text);

this->Close();

}

catch (Exception ^ e)

{

MessageBox::Show("Ошибка соединения с базой даных");

}

}

private: System::Void CancelMeetingButton_Click(System::Object^ sender, System::EventArgs^ e) {

this->Close();

}

};

}