private void btnInsertRequest_Click(object sender, EventArgs e) { BLExternals bl = new BLExternals(); if (comboBoxStudents.SelectedItem != null && !String.IsNullOrWhiteSpace(richTxtReason.Text) && richTxtReason.Text != "Va rugam completati un motiv plauzibil (ex. parinte, angajator, pentru practica).\nAdministratorul va aproba sau nu cererea dumneavoastra in functie de acesta.") { bl.InsertRequests(idUser, Convert.ToInt32(comboBoxStudents.SelectedValue), richTxtReason.Text); comboBoxStudents.SelectedItem = null; richTxtReason.Text = ""; MessageBox.Show("Cererea a fost inregistrata cu succes!", "Succes", MessageBoxButtons.OK, MessageBoxIcon.Information); gridAwaitingRequests.DataSource = bl.GetRequests(idUser); gridAwaitingRequests.Columns["StudentName"].HeaderText = "Nume"; gridAwaitingRequests.Columns["StudyGroup"].HeaderText = "Grupa"; gridAwaitingRequests.Columns["Reason"].HeaderText = "Motiv"; gridAwaitingRequests.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DataTable dataTable = bl.GetStudents("", "", idUser); comboBoxStudents.ValueMember = "StudentId"; comboBoxStudents.DisplayMember = "StudentInfo"; comboBoxStudents.DataSource = dataTable; clearFilter(); } else { MessageBox.Show("Va rugam alegeti un student si completati motivul pentru care doriti sa ii vizualizati situatia scolara.", "Atentie", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void ExternalRequestsForm_Load(object sender, EventArgs e) { gridAwaitingRequests.BorderStyle = BorderStyle.None; gridAwaitingRequests.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(168, 218, 220); gridAwaitingRequests.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; gridAwaitingRequests.DefaultCellStyle.SelectionBackColor = Color.FromArgb(29, 53, 87); gridAwaitingRequests.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; gridAwaitingRequests.BackgroundColor = Color.FromArgb(3, 56, 125); gridAwaitingRequests.DefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); gridAwaitingRequests.DefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridAwaitingRequests.AlternatingRowsDefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridAwaitingRequests.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Tai Le", 11); gridAwaitingRequests.EnableHeadersVisualStyles = false; gridAwaitingRequests.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; gridAwaitingRequests.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); gridAwaitingRequests.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gridAcceptedRequests.BorderStyle = BorderStyle.None; gridAcceptedRequests.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(168, 218, 220); gridAcceptedRequests.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; gridAcceptedRequests.DefaultCellStyle.SelectionBackColor = Color.FromArgb(29, 53, 87); gridAcceptedRequests.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; gridAcceptedRequests.BackgroundColor = Color.FromArgb(3, 56, 125); gridAcceptedRequests.DefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); gridAcceptedRequests.DefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridAcceptedRequests.AlternatingRowsDefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridAcceptedRequests.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Tai Le", 11); gridAcceptedRequests.EnableHeadersVisualStyles = false; gridAcceptedRequests.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; gridAcceptedRequests.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); gridAcceptedRequests.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; BLExternals bl = new BLExternals(); DataTable dataTable = bl.GetStudents("", "", idUser); comboBoxStudents.ValueMember = "StudentId"; comboBoxStudents.DisplayMember = "StudentInfo"; comboBoxStudents.DataSource = dataTable; comboBoxStudents.SelectedItem = null; gridAwaitingRequests.DataSource = bl.GetRequests(idUser); gridAwaitingRequests.Columns["StudentName"].HeaderText = "Nume"; gridAwaitingRequests.Columns["StudyGroup"].HeaderText = "Grupa"; gridAwaitingRequests.Columns["Reason"].HeaderText = "Motiv"; gridAwaitingRequests.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gridAwaitingRequests.Columns[2].DefaultCellStyle.WrapMode = DataGridViewTriState.True; gridAwaitingRequests.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; gridAcceptedRequests.DataSource = bl.GetAcceptedRequests(idUser); gridAcceptedRequests.Columns["StudentName"].HeaderText = "Nume"; gridAcceptedRequests.Columns["StudyGroup"].HeaderText = "Grupa"; gridAcceptedRequests.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; richTxtReason.Text = "Va rugam completati un motiv plauzibil (ex. parinte, angajator, pentru practica).\nAdministratorul va aproba sau nu cererea dumneavoastra in functie de acesta."; richTxtReason.Font = new Font(richTxtReason.Font, FontStyle.Italic); richTxtReason.ForeColor = Color.FromArgb(165, 165, 165); richTxtReason.MaxLength = 500; }
private void txtGroupFilter_TextChanged(object sender, EventArgs e) { String name = txtNameFilter.Text; String group = txtGroupFilter.Text; BLExternals bl = new BLExternals(); DataTable dataTable = bl.GetStudents(name, group, idUser); comboBoxStudents.ValueMember = "StudentId"; comboBoxStudents.DisplayMember = "StudentInfo"; comboBoxStudents.DataSource = dataTable; }
private void ExternalsCatalogForm_Load(object sender, EventArgs e) { gridCatalogY1.BorderStyle = BorderStyle.None; gridCatalogY1.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(168, 218, 220); gridCatalogY1.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; gridCatalogY1.DefaultCellStyle.SelectionBackColor = Color.FromArgb(29, 53, 87); gridCatalogY1.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; gridCatalogY1.BackgroundColor = Color.FromArgb(3, 56, 125); gridCatalogY1.DefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); gridCatalogY1.DefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY1.AlternatingRowsDefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY1.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Tai Le", 11); gridCatalogY1.EnableHeadersVisualStyles = false; gridCatalogY1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; gridCatalogY1.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); gridCatalogY1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gridCatalogY2.BorderStyle = BorderStyle.None; gridCatalogY2.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(168, 218, 220); gridCatalogY2.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; gridCatalogY2.DefaultCellStyle.SelectionBackColor = Color.FromArgb(29, 53, 87); gridCatalogY2.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; gridCatalogY2.BackgroundColor = Color.FromArgb(3, 56, 125); gridCatalogY2.DefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); gridCatalogY2.DefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY2.AlternatingRowsDefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY2.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Tai Le", 11); gridCatalogY2.EnableHeadersVisualStyles = false; gridCatalogY2.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; gridCatalogY2.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); gridCatalogY2.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gridCatalogY3.BorderStyle = BorderStyle.None; gridCatalogY3.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(168, 218, 220); gridCatalogY3.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; gridCatalogY3.DefaultCellStyle.SelectionBackColor = Color.FromArgb(29, 53, 87); gridCatalogY3.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; gridCatalogY3.BackgroundColor = Color.FromArgb(3, 56, 125); gridCatalogY3.DefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); gridCatalogY3.DefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY3.AlternatingRowsDefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY3.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Tai Le", 11); gridCatalogY3.EnableHeadersVisualStyles = false; gridCatalogY3.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; gridCatalogY3.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); gridCatalogY3.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gridCatalogY4.BorderStyle = BorderStyle.None; gridCatalogY4.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(168, 218, 220); gridCatalogY4.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal; gridCatalogY4.DefaultCellStyle.SelectionBackColor = Color.FromArgb(29, 53, 87); gridCatalogY4.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke; gridCatalogY4.BackgroundColor = Color.FromArgb(3, 56, 125); gridCatalogY4.DefaultCellStyle.BackColor = Color.FromArgb(241, 250, 238); gridCatalogY4.DefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY4.AlternatingRowsDefaultCellStyle.Font = new Font("Microsoft Tai Le", 10); gridCatalogY4.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Tai Le", 11); gridCatalogY4.EnableHeadersVisualStyles = false; gridCatalogY4.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; gridCatalogY4.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); gridCatalogY4.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; BLExternals bl = new BLExternals(); DataTable dataTable = bl.GetStudents(idUser); comboBoxStudents.ValueMember = "StudentId"; comboBoxStudents.DisplayMember = "StudentInfo"; comboBoxStudents.DataSource = dataTable; comboBoxStudents.SelectedItem = null; gridCatalogY1.Visible = false; gridCatalogY2.Visible = false; gridCatalogY3.Visible = false; gridCatalogY4.Visible = false; lblY1.Visible = false; lblY2.Visible = false; lblY3.Visible = false; lblY4.Visible = false; btnExportExcel.Visible = false; }
private void buttonExportExcel_Click(object sender, EventArgs e) { if (comboBoxStudents.SelectedValue != null) { using (SaveFileDialog sfd = new SaveFileDialog() { Filter = "Excel Workbook|*.xlsx|Excel 97-2003 Workbook|*.xls|Excel Workbook(.csv)|*.csv" }) { sfd.InitialDirectory = "C"; sfd.Title = "SAVE AS EXCEL FILE"; sfd.FileName = "Export note - " + comboBoxStudents.GetItemText(comboBoxStudents.SelectedItem); if (sfd.ShowDialog() == DialogResult.OK) { String path = sfd.FileName; BLExternals bl = new BLExternals(); int studentId = Convert.ToInt32(comboBoxStudents.SelectedValue); int studyYear = bl.GetYear(Convert.ToInt32(comboBoxStudents.SelectedValue)); DataTable tableY1 = bl.GetCatalogInfoPerYear(studentId, 1); DataTable tableY2 = bl.GetCatalogInfoPerYear(studentId, 2); DataTable tableY3 = bl.GetCatalogInfoPerYear(studentId, 3); DataTable tableY4 = bl.GetCatalogInfoPerYear(studentId, 4); tableY1.Columns["CourseName"].ColumnName = "Materie"; tableY1.Columns["PartialExam"].ColumnName = "Examen partial"; tableY1.Columns["FinalExam"].ColumnName = "Examen final"; tableY1.Columns["Laboratory"].ColumnName = "Laborator"; tableY1.Columns["Seminary"].ColumnName = "Seminar"; tableY1.Columns["BonusPoints"].ColumnName = "Puncte bonus"; tableY1.Columns["Total"].ColumnName = "Total"; tableY1.Columns["LastUpdate"].ColumnName = "Ultima actualizare"; Microsoft.Office.Interop.Excel.Application excel; Microsoft.Office.Interop.Excel.Workbook excelworkBook; Microsoft.Office.Interop.Excel.Worksheet excelSheet; Microsoft.Office.Interop.Excel.Range excelCellrange; try { if (studyYear >= 1) { // Start Excel and get Application object. excel = new Microsoft.Office.Interop.Excel.Application(); // for making Excel visible excel.Visible = false; excel.DisplayAlerts = false; // Creation a new Workbook excelworkBook = excel.Workbooks.Add(Type.Missing); // Workk sheet excelSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelworkBook.ActiveSheet; excelSheet.Name = "Catalog"; excelSheet.Cells[1, 1] = comboBoxStudents.GetItemText(comboBoxStudents.SelectedItem) + ", " + DateTime.Now.ToShortDateString(); // loop through each row and add values to our sheet int rowcount = 2; for (int i = 1; i <= tableY1.Columns.Count; i++) { // on the first iteration we add the column headers excelSheet.Cells[2, i] = tableY1.Columns[i - 1].ColumnName; excelSheet.Cells.Font.Color = System.Drawing.Color.Black; } excelSheet.Cells[rowcount + 1, 1] = "Anul 1"; excelSheet.Range[excelSheet.Cells[rowcount + 1, 1], excelSheet.Cells[rowcount + 1, tableY1.Columns.Count]].Merge(); excelSheet.Range[excelSheet.Cells[rowcount + 1, 1], excelSheet.Cells[rowcount + 1, tableY1.Columns.Count]].Cells.Font.Size = 14; excelSheet.Cells[rowcount + 1, 1].Font.Bold = true; excelSheet.Range[excelSheet.Cells[rowcount, 1], excelSheet.Cells[rowcount + 1, tableY1.Columns.Count]].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; rowcount = 3; foreach (DataRow datarow in tableY1.Rows) { rowcount += 1; for (int i = 1; i <= tableY1.Columns.Count; i++) { excelSheet.Cells[rowcount, i] = datarow[i - 1].ToString(); if (i != 1) { excelSheet.Cells[rowcount, i].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; } if (i == tableY1.Columns.Count - 1) { excelSheet.Cells[rowcount, i].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } //for alternate rows if (rowcount > 3) { if (i == tableY1.Columns.Count) { if (rowcount % 2 == 0) { excelCellrange = excelSheet.Range[excelSheet.Cells[rowcount, 1], excelSheet.Cells[rowcount, tableY1.Columns.Count]]; FormattingExcelCells(excelCellrange, "#aec4d1", System.Drawing.Color.Black, false); excelSheet.Cells[rowcount, i - 1].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } } } } } if (studyYear >= 2) { excelSheet.Cells[rowcount + 2, 1] = "Anul 2"; excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY2.Columns.Count]].Merge(); excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY2.Columns.Count]].Cells.Font.Size = 14; excelSheet.Cells[rowcount + 2, 1].Font.Bold = true; excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY2.Columns.Count]].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; rowcount = rowcount + 2; foreach (DataRow datarow in tableY2.Rows) { rowcount += 1; for (int i = 1; i <= tableY2.Columns.Count; i++) { excelSheet.Cells[rowcount, i] = datarow[i - 1].ToString(); if (i != 1) { excelSheet.Cells[rowcount, i].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; } if (i == tableY1.Columns.Count - 1) { excelSheet.Cells[rowcount, i].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } //for alternate rows if (rowcount > 3) { if (i == tableY2.Columns.Count) { if (rowcount % 2 == 0) { excelCellrange = excelSheet.Range[excelSheet.Cells[rowcount, 1], excelSheet.Cells[rowcount, tableY2.Columns.Count]]; FormattingExcelCells(excelCellrange, "#aec4d1", System.Drawing.Color.Black, false); excelSheet.Cells[rowcount, i - 1].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } } } } } } if (studyYear >= 3) { excelSheet.Cells[rowcount + 2, 1] = "Anul 3"; excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY3.Columns.Count]].Merge(); excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY3.Columns.Count]].Cells.Font.Size = 14; excelSheet.Cells[rowcount + 2, 1].Font.Bold = true; excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY3.Columns.Count]].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; rowcount = rowcount + 2; foreach (DataRow datarow in tableY3.Rows) { rowcount += 1; for (int i = 1; i <= tableY3.Columns.Count; i++) { excelSheet.Cells[rowcount, i] = datarow[i - 1].ToString(); if (i != 1) { excelSheet.Cells[rowcount, i].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; } if (i == tableY1.Columns.Count - 1) { excelSheet.Cells[rowcount, i].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } //for alternate rows if (rowcount > 3) { if (i == tableY3.Columns.Count) { if (rowcount % 2 == 0) { excelCellrange = excelSheet.Range[excelSheet.Cells[rowcount, 1], excelSheet.Cells[rowcount, tableY3.Columns.Count]]; FormattingExcelCells(excelCellrange, "#aec4d1", System.Drawing.Color.Black, false); excelSheet.Cells[rowcount, i - 1].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } } } } } } if (studyYear >= 4) { excelSheet.Cells[rowcount + 2, 1] = "Anul 4"; excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY4.Columns.Count]].Merge(); excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY4.Columns.Count]].Cells.Font.Size = 14; excelSheet.Cells[rowcount + 2, 1].Font.Bold = true; excelSheet.Range[excelSheet.Cells[rowcount + 2, 1], excelSheet.Cells[rowcount + 2, tableY4.Columns.Count]].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; rowcount = rowcount + 2; foreach (DataRow datarow in tableY4.Rows) { rowcount += 1; for (int i = 1; i <= tableY4.Columns.Count; i++) { excelSheet.Cells[rowcount, i] = datarow[i - 1].ToString(); if (i != 1) { excelSheet.Cells[rowcount, i].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; } if (i == tableY1.Columns.Count - 1) { excelSheet.Cells[rowcount, i].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } //for alternate rows if (rowcount > 3) { if (i == tableY4.Columns.Count) { if (rowcount % 2 == 0) { excelCellrange = excelSheet.Range[excelSheet.Cells[rowcount, 1], excelSheet.Cells[rowcount, tableY4.Columns.Count]]; FormattingExcelCells(excelCellrange, "#aec4d1", System.Drawing.Color.Black, false); excelSheet.Cells[rowcount, i - 1].Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); } } } } } } // now we resize the columns excelCellrange = excelSheet.Range[excelSheet.Cells[1, 1], excelSheet.Cells[rowcount, tableY1.Columns.Count]]; excelCellrange.EntireColumn.AutoFit(); Microsoft.Office.Interop.Excel.Borders border = excelCellrange.Borders; border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous; border.Weight = 2d; excelCellrange = excelSheet.Range[excelSheet.Cells[1, 1], excelSheet.Cells[2, tableY1.Columns.Count]]; FormattingExcelCells(excelCellrange, "#007099", System.Drawing.Color.White, true); //now save the workbook and exit Excel excelworkBook.SaveAs(path);; excelworkBook.Close(); excel.Quit(); MessageBox.Show("Fisierul a fost exportat cu succes.", "Export", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { excelSheet = null; excelCellrange = null; excelworkBook = null; } } } } }
private void comboBoxStudents_SelectionChangeCommitted(object sender, EventArgs e) { lblSearchMsg.Visible = false; btnExportExcel.Visible = true; gridCatalogY1.Visible = false; gridCatalogY2.Visible = false; gridCatalogY3.Visible = false; gridCatalogY4.Visible = false; lblY1.Visible = false; lblY2.Visible = false; lblY3.Visible = false; lblY4.Visible = false; BLExternals bl = new BLExternals(); int studyYear = bl.GetYear(Convert.ToInt32(comboBoxStudents.SelectedValue)); if (studyYear >= 1) { if (studyYear >= 2) { if (studyYear >= 3) { if (studyYear >= 4) { DataTable tableY4 = bl.GetCatalogInfoPerYear(Convert.ToInt32(comboBoxStudents.SelectedValue), 4); gridCatalogY4.DataSource = tableY4; gridCatalogY4.Columns["CourseName"].HeaderText = "Materie"; gridCatalogY4.Columns["PartialExam"].HeaderText = "Partial"; gridCatalogY4.Columns["FinalExam"].HeaderText = "Final"; gridCatalogY4.Columns["Laboratory"].HeaderText = "Laborator"; gridCatalogY4.Columns["Seminary"].HeaderText = "Seminar"; gridCatalogY4.Columns["BonusPoints"].HeaderText = "Puncte bonus"; gridCatalogY4.Columns["Total"].HeaderText = "Total"; gridCatalogY4.Columns["LastUpdate"].HeaderText = "Ultima actualizare"; gridCatalogY4.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gridCatalogY4.Visible = true; lblY4.Visible = true; } DataTable tableY3 = bl.GetCatalogInfoPerYear(Convert.ToInt32(comboBoxStudents.SelectedValue), 3); gridCatalogY3.DataSource = tableY3; gridCatalogY3.Columns["CourseName"].HeaderText = "Materie"; gridCatalogY3.Columns["PartialExam"].HeaderText = "Partial"; gridCatalogY3.Columns["FinalExam"].HeaderText = "Final"; gridCatalogY3.Columns["Laboratory"].HeaderText = "Laborator"; gridCatalogY3.Columns["Seminary"].HeaderText = "Seminar"; gridCatalogY3.Columns["BonusPoints"].HeaderText = "Puncte bonus"; gridCatalogY3.Columns["Total"].HeaderText = "Total"; gridCatalogY3.Columns["LastUpdate"].HeaderText = "Ultima actualizare"; gridCatalogY3.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gridCatalogY3.Visible = true; lblY3.Visible = true; } DataTable tableY2 = bl.GetCatalogInfoPerYear(Convert.ToInt32(comboBoxStudents.SelectedValue), 2); gridCatalogY2.DataSource = tableY2; gridCatalogY2.Columns["CourseName"].HeaderText = "Materie"; gridCatalogY2.Columns["PartialExam"].HeaderText = "Partial"; gridCatalogY2.Columns["FinalExam"].HeaderText = "Final"; gridCatalogY2.Columns["Laboratory"].HeaderText = "Laborator"; gridCatalogY2.Columns["Seminary"].HeaderText = "Seminar"; gridCatalogY2.Columns["BonusPoints"].HeaderText = "Puncte bonus"; gridCatalogY2.Columns["Total"].HeaderText = "Total"; gridCatalogY2.Columns["LastUpdate"].HeaderText = "Ultima actualizare"; gridCatalogY2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gridCatalogY2.Visible = true; lblY2.Visible = true; } DataTable tableY1 = bl.GetCatalogInfoPerYear(Convert.ToInt32(comboBoxStudents.SelectedValue), 1); gridCatalogY1.DataSource = tableY1; gridCatalogY1.Columns["CourseName"].HeaderText = "Materie"; gridCatalogY1.Columns["PartialExam"].HeaderText = "Partial"; gridCatalogY1.Columns["FinalExam"].HeaderText = "Final"; gridCatalogY1.Columns["Laboratory"].HeaderText = "Laborator"; gridCatalogY1.Columns["Seminary"].HeaderText = "Seminar"; gridCatalogY1.Columns["BonusPoints"].HeaderText = "Puncte bonus"; gridCatalogY1.Columns["Total"].HeaderText = "Total"; gridCatalogY1.Columns["LastUpdate"].HeaderText = "Ultima actualizare"; gridCatalogY1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gridCatalogY1.Visible = true; lblY1.Visible = true; } }