//Вибір ключового слова зі списку
private void TagsListBox_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
TagsTextBox.Text = TagsListBox.SelectedItem.ToString();
TagsTextBox.Focus();
}
catch (Exception e1)
{
MyMessages.ErrorMessage(e1.Message);
}
}
private void DisciplinesList_SelectedIndexChanged(object sender, EventArgs e)
{
int userid = -1;
string user = OldTeacherLabel.Text.Trim();
TeachersComboBox.Items.Clear();
try
{
string discipline = DisciplinesList.SelectedItem.ToString();
using (MySqlConnection con = DBUtils.GetDBConnection())
{
con.Open();
MySqlCommand cmd = new MySqlCommand("GetUserID", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_username", user);
cmd.Parameters.AddWithValue("_role", 2);
using (MySqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
userid = int.Parse(r["ID"].ToString());
}
}
cmd = new MySqlCommand("SelectNewTeachers", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_idoldteacher", userid);
using (MySqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
TeachersComboBox.Items.Add(r["Teachers"].ToString());
}
}
}
}
catch (Exception e1)
{
if (e1.Message.Contains("Ссылка на объект не указывает на экземпляр объекта"))
{
MyMessages.ErrorMessage("Ви не обрали дисципліну");
}
else
{
MyMessages.ErrorMessage(e1.Message);
}
}
TeachersComboBox.Enabled = true;
}
private int AddNewTag(string tag)
{
int id_tag = -1;
string error = null;
DialogResult affirmative = MyMessages.QuestionMessage("Виявлено ключове слово, якого немає у базу даних. " +
"Бажаєте додати його до бази даних?");
if (affirmative == DialogResult.No)
{
TagsTextErrorProvider.SetError(TagsTextBox, "Оберіть ключове слово");
TagsTextBox.Text = String.Empty;
}
else
{
try
{
using (MySqlConnection con = DBUtils.GetDBConnection())
{
con.Open();
MySqlCommand cmd = new MySqlCommand("AddNewTag", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_Tagname", tag);
int rows = cmd.ExecuteNonQuery();
if (rows >= 0)
{
MessageBox.Show("Ключове слово було додано до бази даних");
}
else
{
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
error = reader["@full_error"].ToString();
}
MyMessages.ErrorMessage(error);
}
id_tag = GetTagID(tag);
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
return(id_tag);
}
private void SelectUsers(string text)
{
MySqlDataAdapter adap = new MySqlDataAdapter();
int g_width = 0;
if (text == UserHintText)
{
text = String.Empty;
}
try
{
using (MySqlConnection con = DBUtils.GetDBConnection())
{
con.Open();
MySqlCommand cmd = new MySqlCommand("ShowUsers", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_name", text);
adap.SelectCommand = cmd;
DataTable table = new DataTable();
adap.Fill(table);
UsersInfoGridView.DataSource = table;
UsersInfoGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
foreach (DataGridViewColumn column in UsersInfoGridView.Columns)
{
if (column.Visible == true)
{
g_width += column.Width;
}
}
Width = g_width + 90;
}
if (FioSort.Checked)
{
UsersInfoGridView.Sort(UsersInfoGridView.Columns[3], ListSortDirection.Ascending);
}
}
catch (Exception e)
{
MyMessages.ErrorMessage(e.Message);
}
}
private void SelectDisciplines(string text)
{
MySqlDataAdapter adap = new MySqlDataAdapter();
DataTable table = new DataTable();
int g_width = 0;
if (text == DisciplineHintText)
{
text = String.Empty;
}
try
{
using (MySqlConnection con = DBUtils.GetDBConnection())
{
con.Open();
MySqlCommand cmd = new MySqlCommand("SelectDisciplineLikeEntered", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_name", text);
adap.SelectCommand = cmd;
adap.Fill(table);
DisciplinesDataGrid.DataSource = table;
DisciplinesDataGrid.Columns[0].HeaderText = "Навчальна дисципліна";
DisciplinesDataGrid.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
foreach (DataGridViewColumn column in DisciplinesDataGrid.Columns)
{
if (column.Visible == true)
{
g_width += column.Width;
}
}
Width = g_width + 95;
}
}
catch (Exception e)
{
MyMessages.ErrorMessage(e.Message);
};
}
private void ConfirmRebuildButton_Click(object sender, EventArgs e)
{
//Studyload.Discipline.Clear();
string discipline = DisciplinesList.SelectedItem.ToString();
//List<string> discipline = new List<string>()
string user = OldTeacherLabel.Text.Trim();
int userid = -1;
string error = null;
Studyload.Studyloadid = -1;
int Reb_s_l = -1;
int disciplines = -1;
try
{
for (int i = 0; i < Studyload.Discipline.Count; i++)
{
disciplines++;
using (MySqlConnection con = DBUtils.GetDBConnection())
{
con.Open();
Studyload.Studyloadid = GetStudyloadId(user, i, con);
MySqlCommand cmd = new MySqlCommand("GetUserId", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_username", Studyload.Newuser);
cmd.Parameters.AddWithValue("_role", 2);
using (MySqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
userid = int.Parse(r["ID"].ToString());
}
}
Reb_s_l = GetStudyloadId(Studyload.Newuser, i, con);
if (Reb_s_l == -1)
{
cmd = new MySqlCommand("RebuildStudyload", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_iduser", userid);
cmd.Parameters.AddWithValue("_Id_s_l", Studyload.Studyloadid);
int rows = cmd.ExecuteNonQuery();
if (rows >= 0)
{
if (Directory.Exists(targetdirectory + Studyload.Discipline[i] + user))
{
Directory.Delete(targetdirectory + Studyload.Discipline[i] + user, true);
}
Studyload.Studyloadid = -1;
}
else
{
using (MySqlDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
error = r["@full_error"].ToString();
}
}
MyMessages.ErrorMessage(error);
}
Studyload.Studyloadid = GetStudyloadId(user, i, con);
if (Studyload.Studyloadid != -1)
{
MyMessages.WarningMessage("Ви перенаправили не всі дисципліни");
}
}
}
}
if (disciplines != -1)
{
MessageBox.Show("Навчальні дисципліни було перенаправлено");
}
DataDeletion.RemoveUser(user, 2);
Studyload.Discipline.Clear();
//Close();
}
catch (Exception e1)
{
MyMessages.ErrorMessage(e1.Message);
}
Close();
}
