// загружает компетенции для специализации
private void LoadCompetence(string id_specialty, long id_specialization)
{
string sqlQuery = "SELECT * FROM COMPETENCE WHERE ID_specialty = @id_specialty AND (ID_specialization IS NULL OR ID_specialization = @id_specialization)";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_specialty", id_specialty);
command.Parameters.AddWithValue("@id_specialization", id_specialization);
ManagerDataCompetence.LoadData(command);
SetOptionGridComp();
}
private void LoadAssessmentDiscipline(int semester)
{
string sqlQuery = "SELECT b.ID, b.NameDiscipline, a.ID_student, a.ID_discipline, a.Assessment, a.Semester " +
"FROM Assessment_Discipline a, WorkProgramm b WHERE a.Semester = @sem AND a.ID_student = @id_stud AND a.ID_discipline = b.ID";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@sem", Convert.ToInt64(semester));
command.Parameters.AddWithValue("@id_stud", id_student);
managerDataDiscipAssessment.LoadData(command);
SQLiteCommand commandUpdate = new SQLiteCommand("UPDATE Assessment_Discipline SET Assessment = @ass WHERE ID_student = @id_stud AND ID_discipline = @id_disp AND semester = @sem");
commandUpdate.Parameters.AddWithValue("@id_stud", id_student);
commandUpdate.Parameters.Add(new SQLiteParameter("@id_disp", DbType.Int64, "ID_discipline"));
commandUpdate.Parameters["@id_disp"].SourceVersion = DataRowVersion.Original;
commandUpdate.Parameters.Add(new SQLiteParameter("@ass", DbType.Int64, "Assessment"));
commandUpdate.Parameters.AddWithValue("@sem", Convert.ToInt64(semester));
SQLiteCommand commandDelete = new SQLiteCommand(" ");
managerDataDiscipAssessment.InitialCommandUpdate(commandUpdate);
managerDataDiscipAssessment.InitialCommandDelete(commandDelete);
dataGridViewDiscip.Columns["ID"].Visible = false;
dataGridViewDiscip.Columns["ID_student"].Visible = false;
dataGridViewDiscip.Columns["ID_discipline"].Visible = false;
dataGridViewDiscip.Columns["Semester"].Visible = false;
dataGridViewDiscip.Columns["NameDiscipline"].HeaderText = "Название дисциплины";
dataGridViewDiscip.Columns["NameDiscipline"].Width = 300;
dataGridViewDiscip.Columns["NameDiscipline"].ReadOnly = true;
dataGridViewDiscip.Columns["Assessment"].HeaderText = "Оценка";
dataGridViewDiscip.Columns["Assessment"].Width = 100;
}
private void LoadGroup()
{
string sqlQuery = "SELECT * FROM StudyGroup";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
managerDataGroup.LoadData(command);
dataGridViewGroup.Columns["ID"].Visible = false;
dataGridViewGroup.Columns["ID_specialization"].Visible = false;
dataGridViewGroup.Columns["NumGroup"].HeaderText = "Номер группы";
dataGridViewGroup.Columns["NumGroup"].Width = 200;
dataGridViewGroup.Columns["Kurs"].HeaderText = "Курс";
}
private void FormStudent_Load(object sender, EventArgs e)
{
string sqlSelect = "SELECT * FROM Student " +
"WHERE ID_group = @id_group";
SQLiteCommand command = new SQLiteCommand(sqlSelect);
command.Parameters.AddWithValue("@id_group", id_group);
managerStudent.LoadData(command);
dataGridView1.Columns["ID"].Visible = false;
dataGridView1.Columns["id_group"].Visible = false;
dataGridView1.Columns["FIO"].HeaderText = "Ф.И.О.";
dataGridView1.Columns["FIO"].Width = 500;
}
private void LoadSpecialty()
{
ManagerDataSpecialization.ClearDataGrid();
string sqlQuery = "SELECT * FROM Specialty";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
ManagerDataSpecialty.LoadData(command);
dataGridViewSpecialty.Columns["KOD"].HeaderText = "Код";
dataGridViewSpecialty.Columns["KOD"].ReadOnly = true;
dataGridViewSpecialty.Columns["KOD"].Width = 100;
dataGridViewSpecialty.Columns["Name"].HeaderText = "Название";
dataGridViewSpecialty.Columns["Name"].Width = 500;
}
private void LoadCompetenceChosenDiscipline(long id_specialization, long id_work_programm)
{
string sqlQuery = "SELECT ID, KOD, NAME FROM COMPETENCE, Competence_Discipline " +
"WHERE ID = ID_competence AND ID_discipline = @id_disp";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_spec", id_specialization);
command.Parameters.AddWithValue("@id_disp", id_work_programm);
ManagerDataCompChosenDiscipline.LoadData(command);
dataGridCompChosenDiscip.Columns["ID"].Visible = false;
dataGridCompChosenDiscip.Columns["KOD"].HeaderText = "Код";
dataGridCompChosenDiscip.Columns["NAME"].HeaderText = "Содержание компетенции";
dataGridCompChosenDiscip.Columns["NAME"].Width = 400;
}
private void FormDiscipline_Load(object sender, EventArgs e)
{
string sqlSelect = "SELECT ID, NameDiscipline, ID_specialization FROM WorkProgramm " +
"WHERE ID_specialization = @id_spec AND SEMESTER LIKE @sem ";
SQLiteCommand command = new SQLiteCommand(sqlSelect);
command.Parameters.AddWithValue("@id_spec", id_specialization);
command.Parameters.AddWithValue("@sem", "%" + semester + "%");
managerDiscipline.LoadData(command);
dataGridView1.Columns["ID"].Visible = false;
dataGridView1.Columns["ID_specialization"].Visible = false;
dataGridView1.Columns["NameDiscipline"].HeaderText = "Название дисциплины";
dataGridView1.Columns["NameDiscipline"].Width = 500;
}
private void LoadListView()
{
string sqlQuery = "SELECT ID, KOD, NAME FROM COMPETENCE " +
"WHERE ID_specialty = @id_specialty AND (ID_specialization IS NULL OR ID_specialization = @id_specialization)";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_specialty", id_specialty);
command.Parameters.AddWithValue("@id_specialization", id_specialization);
manager.LoadData(command);
dataGridView1.Columns["ID"].Visible = false;
dataGridView1.Columns["KOD"].HeaderText = "Код";
dataGridView1.Columns["KOD"].Width = 100;
dataGridView1.Columns["Name"].HeaderText = "Содержание компетенции";
dataGridView1.Columns["Name"].Width = 500;
}
private void LoadSpecialization(string id_fk)
{
string sqlQuery = "SELECT * FROM Specialization WHERE specialty_fk = @id_param";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_param", id_fk);
ManagerDataSpecialization.LoadData(command);
dataGridViewSpecialization.Columns["Number"].HeaderText = "Номер";
dataGridViewSpecialization.Columns["Name"].HeaderText = "Название";
dataGridViewSpecialization.Columns["Number"].Width = 100;
dataGridViewSpecialization.Columns["Name"].Width = 500;
dataGridViewSpecialization.Columns["ID"].Visible = false;
dataGridViewSpecialization.Columns["specialty_fk"].Visible = false;
}
private void LoadDiscipline(long id_specialization)
{
string sqlQuery = "SELECT * FROM WorkProgramm WHERE id_specialization = @id_param";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_param", id_specialization);
ManagerDataDiscipline.LoadData(command);
dataGridViewDiscip.Columns["ID"].Visible = false;
dataGridViewDiscip.Columns["id_specialization"].Visible = false;
dataGridViewDiscip.Columns["FormReport"].Visible = false;
dataGridViewDiscip.Columns["NameDiscipline"].HeaderText = "Название дисциплины";
dataGridViewDiscip.Columns["NameDiscipline"].Width = 400;
dataGridViewDiscip.Columns["NameDiscipline"].DisplayIndex = 0;
dataGridViewDiscip.Columns["Semester"].HeaderText = "Семестры отчётности";
dataGridViewDiscip.Columns["Semester"].DisplayIndex = 1;
}
// загружает список дисциплин, которые формируют выбранную компетенцию для определённой специализации
private void LoadDisciplineChosenCompetence(long id_competence, long id_specialization)
{
string sqlQuery = "SELECT ID, NameDiscipline, Weight, ID_competence, ID_discipline FROM WorkProgramm, Competence_Discipline " +
"WHERE ID = ID_discipline AND ID_competence = @id_comp AND ID_specialization = @id_spec";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_comp", id_competence);
command.Parameters.AddWithValue("@id_spec", id_specialization);
ManagerDataDisciplineChosenCompetence.LoadData(command);
dataGridDisciplineChosenCompetence.Columns["ID"].Visible = false;
dataGridDisciplineChosenCompetence.Columns["ID_competence"].Visible = false;
dataGridDisciplineChosenCompetence.Columns["ID_discipline"].Visible = false;
dataGridDisciplineChosenCompetence.Columns["Weight"].HeaderText = "Вес";
dataGridDisciplineChosenCompetence.Columns["NameDiscipline"].HeaderText = "Название дисциплины";
dataGridDisciplineChosenCompetence.Columns["NameDiscipline"].Width = 400;
dataGridDisciplineChosenCompetence.Columns["NameDiscipline"].ReadOnly = true;
}
private void LoadStudent(long id_group)
{
string sqlQuery = "SELECT * FROM Student WHERE ID_group = @id_group";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_group", id_group);
managerDataStudent.LoadData(command);
SQLiteCommand commandInsert = new SQLiteCommand("INSERT INTO Student(FIO, ID_group) VALUES(@FIO, @ID_group)");
commandInsert.Parameters.Add(new SQLiteParameter("@FIO", DbType.String, "FIO"));
commandInsert.Parameters.AddWithValue("@ID_group", id_group);
managerDataStudent.InitialCommandInsert(commandInsert);
dataGridViewStudent.Columns["ID"].Visible = false;
dataGridViewStudent.Columns["ID_group"].Visible = false;
dataGridViewStudent.Columns["FIO"].HeaderText = "Ф.И.О.";
dataGridViewStudent.Columns["FIO"].Width = 500;
}
// загружает компетенции для специализации
private void LoadCompetence()
{
string sqlQuery = "SELECT * FROM COMPETENCE WHERE ID_specialty = @id_specialty AND (ID_specialization IS NULL OR ID_specialization = @id_specialization) ORDER BY ID";
SQLiteCommand command = new SQLiteCommand(sqlQuery);
command.Parameters.AddWithValue("@id_specialty", kod_specialty);
command.Parameters.AddWithValue("@id_specialization", id_specialization);
ManagerDataCompetence.LoadData(command);
dataGridViewCompetence.Columns["ID"].Visible = false;
dataGridViewCompetence.Columns["id_specialization"].Visible = false;
dataGridViewCompetence.Columns["id_specialty"].Visible = false;
dataGridViewCompetence.Columns["Name"].HeaderText = "Содержание компетенции";
dataGridViewCompetence.Columns["Name"].Width = 600;
dataGridViewCompetence.Columns["Name"].DisplayIndex = 2;
dataGridViewCompetence.Columns["KOD"].HeaderText = "Код";
dataGridViewCompetence.Columns["KOD"].DisplayIndex = 1;
}
