public InfoWorker(Worker worker)
{
int sum = 0;
List <Items> items = new List <Items>();
InitializeComponent();
lessonRepository = new LessonEventRepository(new ApplicationContext());
workerRepository = new WorkerRepository(new ApplicationContext());
lessonMarkRepository = new LessonMarksRepository(new ApplicationContext());
concertRepository = new ConcertEventRepository(new ApplicationContext());
concertMarkRepository = new ConcertMarksRepository(new ApplicationContext());
foreach (ConcertEvent con in concertRepository.Get(p => p.EndDate.Value.Month == DateTime.Now.Month))
{
if (concertMarkRepository.IsExist(p => p.ConcertEventID == con.ID &&
p.WorkerID == worker.ID))
{
Items item = new Items()
{
concert = con,
marks = concertMarkRepository.Get(p => p.ConcertEventID == con.ID &&
p.WorkerID == worker.ID).First().NumOfMarks
};
sum += item.marks;
items.Add(item);
}
}
concertListView.ItemsSource = items;
this.Namelabel.Content = worker.Name;
this.Surnamelabel.Content = worker.Surname;
int lessonVisited = 0;
foreach (LessonEvent lesson in lessonRepository.Get(p => p.Date.Month == DateTime.Now.Month))
{
if (lessonMarkRepository.IsExist(p => p.LessonEventID == lesson.ID &&
p.WorkerID == worker.ID && p.IsVisited == true))
{
lessonVisited++;
}
}
sum += lessonVisited;
this.numOfMakrslabel.Content = sum.ToString();
this.lessonVisitedNumLabel.Content = lessonVisited.ToString();
}
public LessonWindow()
{
InitializeComponent();
List <Items> items = new List <Items>();
lessonRepository = new LessonEventRepository(new ApplicationContext());
workerRepository = new WorkerRepository(new ApplicationContext());
lessonMarkRepository = new LessonMarksRepository(new ApplicationContext());
foreach (Worker wr in workerRepository.GetAllFromCache(1))
{
Items item = new Items()
{
wrk = wr
};
items.Add(item);
}
for (int i = 1; i <= DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month); i++)
{
DataGridCheckBoxColumn chekColumn = new DataGridCheckBoxColumn();
chekColumn.Header = i.ToString();
chekColumn.Binding = new Binding(i.ToString());
chekColumn.IsReadOnly = true;
chekColumn.CellStyle = new Style(typeof(DataGridCell));
chekColumn.CellStyle.Setters.Add(new Setter(DataGridCell.BackgroundProperty, new SolidColorBrush(Colors.LightGray)));
lessonGrid.Columns.Add(chekColumn);
}
DataGridTextColumn num = new DataGridTextColumn();
num.Header = "Sum";
num.Binding = new Binding("Sum");
num.CellStyle = new Style(typeof(DataGridCell));
num.CellStyle.Setters.Add(new Setter(DataGridCell.BackgroundProperty, new SolidColorBrush(Colors.LightGray)));
lessonGrid.Columns.Add(num);
lessonGrid.ItemsSource = items;
//SetValue();
}
