private static void CreateSkeleton(Worksheet worksheet, DataTable dataTable)
{
var classRoomNumbers = new HashSet <string>();
foreach (DataRow row in dataTable.Rows)
{
var number = row[2].ToString();
if (!classRoomNumbers.Contains(number))
{
classRoomNumbers.Add(number);
}
}
var len = classRoomNumbers.Count;
for (int i = 0; i < 7; i++)
{
var start = 4 + i * len;
worksheet.Range[worksheet.Cells[start, 1], worksheet.Cells[start + len - 1, 1]].Merge();
worksheet.Cells[start, 1] = i + 1;
worksheet.Range[worksheet.Cells[start, 2], worksheet.Cells[start + len - 1, 2]].Merge();
worksheet.Cells[start, 2] = LessonTimeDto.GetPeriodFromNumber(i + 1);
}
ClassRooms = classRoomNumbers.ToList();
}
private static void FillData(Worksheet worksheet, DataTable dataTable)
{
var currentDayName = string.Empty;
int currentLessonTimeNumber = -1;
string currentLessonTime = string.Empty;
var currentDayTimeCell = new CellIndex(4, 1);
string currentClassRoom = string.Empty;
var currentClassRoomCell = new CellIndex(4, 2);
string currerntTeacher = string.Empty;
var currentTeacherCell = new CellIndex(4, 3);
foreach (DataRow dataRow in dataTable.Rows)
{
var dayTimeWasChanged = false;
var dayName = dataRow[1].ToString();
var lessonTimeNumber = int.Parse(dataRow[2].ToString());
if (string.IsNullOrEmpty(currentDayName) || currentDayName != dayName)
{
dayTimeWasChanged = true;
currentDayName = dayName;
}
if (currentLessonTimeNumber != lessonTimeNumber)
{
dayTimeWasChanged = true;
currentLessonTimeNumber = lessonTimeNumber;
currentLessonTime = LessonTimeDto.GetPeriodFromNumber(lessonTimeNumber);
}
if (dayTimeWasChanged)
{
worksheet.Range[worksheet.Cells[currentDayTimeCell.x, currentDayTimeCell.y],
worksheet.Cells[currentDayTimeCell.x, lastWeekYIndex - 1]].Cells.Borders[XlBordersIndex.xlEdgeBottom].Weight = 2d;
worksheet.Cells[currentDayTimeCell.x, currentDayTimeCell.y] = currentDayName + "\n" + currentLessonTime;
currentDayTimeCell.x++;
}
var classRoom = dataRow[3].ToString();
if (currentClassRoom != classRoom || dayTimeWasChanged)
{
worksheet.Range[worksheet.Cells[currentClassRoomCell.x, currentClassRoomCell.y],
worksheet.Cells[currentClassRoomCell.x, lastWeekYIndex - 1]].Cells.Borders[XlBordersIndex.xlEdgeBottom].Weight = 2d;
if (currentClassRoomCell.x % 2 == 0)
{
worksheet.Range[worksheet.Cells[currentClassRoomCell.x, currentClassRoomCell.y],
worksheet.Cells[currentClassRoomCell.x, lastWeekYIndex - 1]]
.Interior.Color = XlRgbColor.rgbLightGray;
}
currentClassRoom = classRoom;
worksheet.Cells[currentClassRoomCell.x, currentClassRoomCell.y] = currentClassRoom;
currentClassRoomCell.x++;
// if dayTime Cell was not changed we need to merge cells
if (!dayTimeWasChanged)
{
var previousXCoord = currentDayTimeCell.x - 1;
worksheet.Range[worksheet.Cells[previousXCoord, currentDayTimeCell.y],
worksheet.Cells[currentDayTimeCell.x++, currentDayTimeCell.y]].Merge();
}
}
var teacher = dataRow[4].ToString() + " " + dataRow[5].ToString();
if (currerntTeacher != teacher || dayTimeWasChanged)
{
currerntTeacher = teacher;
worksheet.Cells[currentTeacherCell.x, currentTeacherCell.y] = currerntTeacher;
lastXIndex = currentTeacherCell.x;
currentTeacherCell.x++;
}
var weekNumber = dataRow[0].ToString();
var weekXCoord = currentTeacherCell.x - 1;
var weekYCoord = WeekNumberCellIndex[weekNumber].y;
worksheet.Cells[weekXCoord, weekYCoord] = dataRow[6].ToString() + " " + dataRow[7].ToString();
// Console.WriteLine($"{dataRow[0]}, {dataRow[1]}, {dataRow[2]}, {dataRow[3]}, {dataRow[4]}, {dataRow[5]}, {dataRow[6]}");
dayTimeWasChanged = false;
}
}