public void changeCourseCmbExecuted()
{
CoursePairs.Clear();
using (var service = new ClassAdministrationServiceClient(new BasicHttpBinding(), new EndpointAddress(BUTEClassAdministrationClient.Properties.Resources.endpointAddress)))
{
Course[] courses = service.ReadCoursesFromSemester(SelectedSemester.Id);
foreach (var course in courses)
{
CoursePairs.Add(new ComboBoxCoursePair()
{
CourseObject = course,
CourseString = PrettyFormatter.dayFormatter(Convert.ToInt32(course.Day_of_week)) + ' '
+ course.Starting_time + ' '
+ PrettyFormatter.parityFormatter(course.Week_parity)
});
}
}
}
public static void ExportToExcel(string filename, List <Group> groups)
{
String name = "név";
String neptun = "Neptun kód";
// open an Excel application
Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
excelApp.Workbooks.Add();
// work in quiet mode: no prompt to overwrite the file
excelApp.DisplayAlerts = false;
// open the workbook
excelApp.Worksheets.Add();
IEnumerator ws = excelApp.Worksheets.GetEnumerator();
while (excelApp.Worksheets.Count > 1)
{
excelApp.Worksheets[excelApp.Worksheets.Count - 1].Delete();
}
Excel.Worksheet worksheet = excelApp.ActiveSheet;
// a worksheet about the groups, instructors, rooms, etc.
worksheet.Name = "csoportok";
worksheet.Cells[1, 1] = "csoport";
worksheet.Cells[1, 2] = "nap";
worksheet.Cells[1, 3] = "időpont";
worksheet.Cells[1, 4] = "hét";
worksheet.Cells[1, 5] = "terem";
worksheet.Cells[1, 6] = "gyakorlatvezető";
worksheet.Rows[1].Font.Bold = true;
int i = 1;
foreach (var group in groups)
{
i++;
worksheet.Cells[i, 1] = group.Index + ".";
worksheet.Cells[i, 2] = PrettyFormatter.dayFormatter(Convert.ToInt32(group.Course.Day_of_week));
worksheet.Cells[i, 3] = group.Course.Starting_time;
worksheet.Cells[i, 4] = PrettyFormatter.parityFormatter(group.Course.Week_parity);
worksheet.Cells[i, 5] = group.Room.Name;
worksheet.Cells[i, 6] = group.Instructor.Name;
}
// set the columns to fit their width automatically
for (int k = 1; k <= 6; k++)
{
worksheet.Columns[k].AutoFit();
}
// separate worksheet for each group
foreach (var group in groups)
{
// add new worksheet after the current one
worksheet = excelApp.Worksheets.Add(Type.Missing, worksheet);
worksheet.Name = group.Index + ". csoport";
// fill the header
worksheet.Cells[1, 1] = name;
worksheet.Cells[1, 2] = neptun;
worksheet.Rows[1].Font.Bold = true;
int rowOffset = 2;
int j = 0;
foreach (var student in group.Student)
{
worksheet.Cells[j + rowOffset, 1] = student.Name;
worksheet.Cells[j + rowOffset, 2] = student.Neptun;
j++;
}
// set the columns to fit their width automatically
for (int k = 1; k <= 2; k++)
{
worksheet.Columns[k].AutoFit();
}
}
worksheet.SaveAs(filename);
//excelApp.Quit();
}