private void LoadReport(bool isAutumn, YearViewModel yearModel)
{
_reportViewer.Reset();
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
SemesterDataset dataset = new SemesterDataset();
dataset.BeginInit();
reportDataSource1.Name = "DataSet1"; //Name of the report dataset in our .RDLC file
reportDataSource1.Value = dataset.DataTable1;
_reportViewer.LocalReport.DataSources.Add(reportDataSource1);
_reportViewer.LocalReport.DisplayName = "Отчёт за " + (isAutumn?"осенний":"весенний") + " семестр " + " (" + yearModel.Name.Replace('/', '-') + ")";
_reportViewer.LocalReport.ReportPath = @"./Reports/Controls/Semester.rdlc";
dataset.EndInit();
//fill data into adventureWorksDataSet
var context = DbContextSingleton.GetContext();
//var workflows = WorkflowStaticWorker.GetAllWorkflows(context);
var year = context.AcademicYears.FirstOrDefault(y => y.Id == yearModel.Id);
var workflows = WorkflowStaticWorker.GetAllWorkflowBySemesterAndYear(context, isAutumn, year.Id);
var statics = context.StaticWorkflows.Include(s => s.Employee).Include(s => s.Employee2).Include(s => s.Employee3).Include(s => s.Employee4).Include(s => s.Employee5)
.Include(s => s.Agreement).Include(s => s.Semester)
.Where(s => s.IsEnabled && s.Semester.IsAutumn == isAutumn).ToList();
DatatableDataImporter.FillSemesterDataset(dataset.DataTable1, workflows, statics.Select(s => new ExtendedStaticWorkflow(s, year)).ToList());
_reportViewer.RefreshReport();
}
private void LoadReport(YearViewModel yearModel, Employee employee)
{
_reportViewer.Reset();
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
IndPlan dataset = new IndPlan();
dataset.BeginInit();
reportDataSource1.Name = "DataSet1"; //Name of the report dataset in our .RDLC file
reportDataSource1.Value = dataset.DataTable5;
_reportViewer.LocalReport.DataSources.Add(reportDataSource1);
_reportViewer.LocalReport.ReportPath = @"./Reports/Controls/PersonalPlan.rdlc";
_reportViewer.LocalReport.DisplayName = "Индивидуальный план " + employee.FullName + " (" + yearModel.Name.Replace('/', '-') + ")";
dataset.EndInit();
var context = DbContextSingleton.GetContext();
var year = context.AcademicYears.FirstOrDefault(y => y.Id == yearModel.Id);
var workflows = WorkflowStaticWorker.GetAllWorkflowByYear(context, yearModel.Id)
.Where(w => w.EmployeeId == employee.Id).ToList();
var statics = context.StaticWorkflows
.Include(s => s.Employee).Include(s => s.Employee2).Include(s => s.Employee3).Include(s => s.Employee4).Include(s => s.Employee5)
.Include(s => s.Agreement).Include(s => s.Semester)
.Where(s => s.IsEnabled).ToList();
statics = statics.Where(s => s.ContainsEmployeeById(employee.Id)).ToList();
//var ext = statics.Select(s=>new ExtendedStaticWorkflow(s,year)).ToList();
DatatableDataImporter.FillIndPlanDataset(dataset.DataTable5, workflows, statics.Select(s => new ExtendedStaticWorkflow(s, year)).ToList(), employee);
_reportViewer.RefreshReport();
}
private void LoadReport(YearViewModel yearModel)
{
_reportViewer.Reset();
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource2 = new Microsoft.Reporting.WinForms.ReportDataSource();
WorkloadDataset dataset = new WorkloadDataset();
WorkloadDatasetEmployee dataset2 = new WorkloadDatasetEmployee();
dataset.BeginInit();
reportDataSource1.Name = "DataSet1"; //Name of the report dataset in our .RDLC file
reportDataSource1.Value = dataset.DataTable2;
reportDataSource2.Name = "DataSet2";
reportDataSource2.Value = dataset2.DataTable3;
_reportViewer.LocalReport.DataSources.Add(reportDataSource1);
_reportViewer.LocalReport.DataSources.Add(reportDataSource2);
_reportViewer.LocalReport.DisplayName = "Нагрузка " + " (" + yearModel.Name.Replace('/', '-') + ")";
_reportViewer.LocalReport.ReportPath = @"./Reports/Controls/Workload.rdlc";
dataset.EndInit();
var context = DbContextSingleton.GetContext();
var year = context.AcademicYears.FirstOrDefault(y => y.Id == yearModel.Id);
var workflows = WorkflowStaticWorker.GetAllWorkflowByYear(context, yearModel.Id).Where(w => w.Semester.SemesterNumber <= 8);
var statics = context.StaticWorkflows.Include(s => s.Employee).Include(s => s.Employee2).Include(s => s.Employee3).Include(s => s.Employee4).Include(s => s.Employee5)
.Include(s => s.Agreement).Include(s => s.Semester)
.Where(s => s.IsEnabled && s.Semester.SemesterNumber <= 8).ToList();
//var ext = statics.Select(s=>new ExtendedStaticWorkflow(s,year)).ToList();
DatatableDataImporter.FillWorkloadDataset(dataset.DataTable2, workflows.ToList(), statics.Select(s => new ExtendedStaticWorkflow(s, year)).ToList());
DatatableDataImporter.FillWorkloadEmployee(dataset2.DataTable3, workflows.ToList(), statics.Select(s => new ExtendedStaticWorkflow(s, year)).ToList());
_reportViewer.RefreshReport();
}