public static void Convert(EntitiesVMRegistry registry, string targetPath, TeacherVM teacher)
{
try
{
File.Copy(TemplatePath, targetPath, true);
}
catch (Exception e)
{
Console.WriteLine(e);
}
var newFile = new FileInfo(targetPath);
try
{
using (var package = new ExcelPackage(newFile))
{
FillTitle(package.Workbook.Worksheets[1], teacher);
FillSem(package.Workbook.Worksheets[2], 1, teacher);
FillSem(package.Workbook.Worksheets[3], 2, teacher);
FillTotal(package.Workbook.Worksheets[5]);
package.Save();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void Convert(EntitiesVMRegistry registry, string targetPath)
{
//TemplatePath = Path.GetFullPath(TemplatePath);
try
{
File.Copy(TemplatePath, targetPath, true);
}
catch (Exception e)
{
Console.WriteLine(e);
}
var newFile = new FileInfo(targetPath);
try
{
using (var package = new ExcelPackage(newFile))
{
var teachers = registry.Teachers;
var worksheet = package.Workbook.Worksheets[1];
worksheet.Cells[8, 1].RichText[1].Text = ContextSingleton.Instance.EntitiesVmRegistry.Settings[(int)Settings.FullDepartmentName].Value;
worksheet.Cells[8, 1].RichText[3].Text = ContextSingleton.Instance.EntitiesVmRegistry.Settings[(int)Settings.StartYear].Value;
worksheet.Cells[8, 1].RichText[5].Text = ContextSingleton.Instance.EntitiesVmRegistry.Settings[(int)Settings.EndYear].Value;
var row = StartRow;
var counter = 1;
foreach (var teacher in teachers)
{
worksheet.Cells[row, 1].Value = counter++;
worksheet.Cells[row, 2].Value = teacher.Surname_N_P;
worksheet.Cells[row, 3].Value = teacher.Rate;
worksheet.Cells[row, 4].Value = teacher.Post.LongName;
worksheet.Cells[row, 5].Value = teacher.AcademicDegree;
worksheet.Cells[row, 6].Value = teacher.ActualLoad.Lectures;
worksheet.Cells[row, 7].Value = teacher.ActualLoad.Practical;
worksheet.Cells[row, 8].Value = teacher.ActualLoad.Laboratory;
worksheet.Cells[row, 9].Value = teacher.ActualLoad.Test;
worksheet.Cells[row, 10].Value = teacher.ActualLoad.Consultations;
worksheet.Cells[row, 11].Value = teacher.ActualLoad.Exams;
worksheet.Cells[row, 12].Value = teacher.ActualLoad.Nir;
worksheet.Cells[row, 13].Value = teacher.ActualLoad.CourseDesigning;
worksheet.Cells[row, 14].Value = teacher.ActualLoad.Vkr;
worksheet.Cells[row, 15].Value = teacher.ActualLoad.Gek + teacher.ActualLoad.Gak;
worksheet.Cells[row, 16].Value = teacher.ActualLoad.Rma;
worksheet.Cells[row, 17].Value = teacher.ActualLoad.Rmp;
worksheet.Cells[row, 20].Value = Math.Round(teacher.ActualLoadSum, 2);
row++;
worksheet.InsertRow(row, 1, row - 1);
}
worksheet.DeleteRow(row);
package.Save();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void Convert(EntitiesVMRegistry registry, string targetPath)
{
//TemplatePath = Path.GetFullPath(TemplatePath);
try
{
File.Copy(TemplatePath, targetPath, true);
}
catch (Exception e)
{
Console.WriteLine(e);
}
var newFile = new FileInfo(targetPath);
try
{
using (var package = new ExcelPackage(newFile))
{
var subjects = registry.Subjects;
var worksheet = package.Workbook.Worksheets[1];
worksheet.Cells[10, 1].RichText[1].Text = ContextSingleton.Instance.EntitiesVmRegistry.Settings[(int)Settings.FullDepartmentName].Value;
worksheet.Cells[10, 1].RichText[3].Text = ContextSingleton.Instance.EntitiesVmRegistry.Settings[(int)Settings.StartYear].Value;
worksheet.Cells[10, 1].RichText[5].Text = ContextSingleton.Instance.EntitiesVmRegistry.Settings[(int)Settings.EndYear].Value;
var row = StartRow;
var counter = 1;
foreach (var subject in subjects)
{
if (subject.Entries.Count == 0)
{
continue;
}
worksheet.Cells[row, 1].Value = counter++;
worksheet.Cells[row, 2].Value = subject.Название;
worksheet.Cells[row, 3].Value = subject.Курс + ", ИТ";
worksheet.Cells[row, 4].Value = subject.Семестр / 2 == 0 ? "в" : "о";
worksheet.Cells[row, 5].Value = subject.Поток;
worksheet.Cells[row, 6].Value = subject.ModelObject.Lectures;
worksheet.Cells[row, 7].Value = subject.ModelObject.Practical;
worksheet.Cells[row, 8].Value = subject.ModelObject.Laboratory;
worksheet.Cells[row, 9].Value = subject.ModelObject.Численность;
worksheet.Cells[row, 10].Value = subject.ActualLoad.Lectures;
worksheet.Cells[row, 11].Value = subject.ActualLoad.Practical;
worksheet.Cells[row, 12].Value = subject.ActualLoad.Laboratory;
worksheet.Cells[row, 13].Value = subject.ActualLoad.Test;
worksheet.Cells[row, 14].Value = subject.ActualLoad.Consultations;
worksheet.Cells[row, 15].Value = subject.ActualLoad.Exams;
worksheet.Cells[row, 16].Value = subject.ActualLoad.Nir;
worksheet.Cells[row, 17].Value = subject.ActualLoad.CourseDesigning;
worksheet.Cells[row, 18].Value = subject.ActualLoad.Vkr;
worksheet.Cells[row, 19].Value = subject.ActualLoad.Gek;
worksheet.Cells[row, 20].Value = subject.ActualLoad.Rma;
worksheet.Cells[row, 21].Value = subject.ActualLoad.Rmp;
worksheet.Cells[row, 22].Value = Math.Round(subject.ActualLoadSum, 2);
worksheet.Cells[row, 23].Value = subject.Entries.Select(x => x.Teacher.Surname_N_P)
.Aggregate((s, i) => s + Environment.NewLine + i);
row++;
worksheet.InsertRow(row, 1, row - 1);
}
worksheet.DeleteRow(row);
package.Save();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
