public YearConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
_context.AcademicYears.Load();
this.DataContext = _context.AcademicYears.Local;
}
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();
}
public GroupConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
_context.StudyGroups.Load();
this.DataContext = _context.StudyGroups.Local;
}
public EmployeeConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
_context.Employees.Load();
this.DataContext = _context.Employees.Local;
}
public DisciplineConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
_context.Disciplines.Include(d => d.ReadInSemester).OrderBy(d => d.ReadInSemester.SemesterNumber).ThenBy(d => d.DisciplineName).Load();
this.DataContext = _context.Disciplines.Local;
}
public DisciplineBlacklistConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
_context.BlacklistDisciplines.Load();
this.DataContext = _context.BlacklistDisciplines.Local;
}
public StaticWorkflowConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
_context.StaticWorkflows.Include(s => s.Agreement).Include(s => s.Employee).Include(s => s.Employee2).Include(s => s.Employee3).Include(s => s.Employee4).Include(s => s.Employee5)
.Include(s => s.Semester).Load();
this.DataContext = _context.StaticWorkflows.Local.ToBindingList();
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
var context = DbContextSingleton.GetContext();
Years = new ObservableCollection <YearViewModel>(context.AcademicYears.ToList().Select(s => new YearViewModel {
Id = s.Id, Name = s.FullYearName
}));
yearCombobox.ItemsSource = Years;
}
public DisciplineAssignConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
_context.DisciplineConfig.Include(d => d.Discipline).Include(d => d.Discipline.ReadInSemester)
.Include(d => d.Employee).Include(d => d.Employee2).Include(d => d.Employee3).Include(d => d.Employee4).Include(d => d.Employee5)
.Include(d => d.Agreement).Load();
this.DataContext = _context.DisciplineConfig.Local.ToBindingList();
}
private void Click_Import(object sender, RoutedEventArgs e)
{
SetFrameContent(null);
var context = DbContextSingleton.GetContext();
FileLoader loader = new FileLoader();
WorkflowStaticWorker.ImportWorkflow(context, loader.ImportWorkflow());
SetFrameContent(_successPage);
}
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();
}
public SemesterConfigWindow()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
this.DataContext = _context.Semesters.Local;
}
public WorkflowPage()
{
InitializeComponent();
_context = DbContextSingleton.GetContext();
}
