private void btExcelGroupList_Click(object sender, EventArgs e)
{
switch (Registry_Class.DirPath == "Empry" || Registry_Class.OrganizationName == "Empty" ||
Registry_Class.DocBM == 0.0 || Registry_Class.DocTM == 0.0 ||
Registry_Class.DocRM == 0.0 || Registry_Class.DocLM == 0.0)
{
case (true):
ApplicationConfigurationForm configurationForm = new ApplicationConfigurationForm();
configurationForm.ShowDialog();
break;
case (false):
btExcelGroupList.Enabled = false;
DataBaseTables tables = new DataBaseTables();
tables.qrDiscipline = "select [dbo].[Discipline].[Prefix]+' '+[dbo].[Discipline].[The_name_of_the_discipline] from [dbo].[Group] join [dbo].[Burden] on [dbo].[Burden].[Group_ID] = [dbo].[Group].[ID_Group] join [dbo].[Discipline] on [dbo].[Discipline].[ID_Discipline] = [dbo].[Burden].[Discipline_ID] where [dbo].[Group].[Group_name] = '" + cbGroup.Text + "'";
tables.qrStudent = "select [Surname_Student]+' '+SUBSTRING([Name_Student],1,1)+'. '+SUBSTRING([Middle_name_Student],1,1)+'.' from [dbo].[Student] where [dbo].[Student].[Group_ID] = " + cbGroup.SelectedValue.ToString();
tables.dtDisciplineFill();
tables.dtStudentFill();
ExcelDocument document = new ExcelDocument();
document.Group_name = cbGroup.Text;
document.dtDiscipline = tables.dtDiscipline;
document.dtStudents = tables.dtStudent;
document.GroupDisciplineCreate();
btExcelGroupList.Enabled = true;
break;
}
}
private void ltbDisciplineFill()
{
Action action = () =>
{
tablesDiscipline.dtDisciplineFill();
tablesDiscipline.dependency.OnChange += onchangeDisciplineBurden;
ltbDiscipline.DataSource = tablesDiscipline.dtDiscipline;
ltbDiscipline.ValueMember = "ID_Discipline";
ltbDiscipline.DisplayMember = "Discipline_Info";
};
Invoke(action);
}
private void fillDiccipline()
{
Action action = () =>
{
dataTable.dtDisciplineFill();
dataTable.dependency.OnChange += onchange_Diacipline;
ltbDiscipline.DataSource = dataTable.dtDiscipline;
ltbDiscipline.ValueMember = "ID_Discipline";
ltbDiscipline.DisplayMember = "Discipline_Info";
};
Invoke(action);
}
