Example #1
0
        public void GridSum(List <Items> wrList)
        {
            DateTime dt  = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            DateTime dt2 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month));

            IEnumerable <ConcertEvent> concert = concertRepository.Get(p => p.EndDate <= dt2 && p.EndDate >= dt);

            //p.BeginningDate
            //(p => dt2 >= p.EndDate)
            for (int row = 0; row < workerRepository.GetAllFromCache().Count(); row++)
            {
                int sum  = 0;
                int wrId = wrList[row].wrk.ID;

                foreach (ConcertEvent cncrt in concert)
                {
                    if (concertMarkRepository.IsExist(p => p.ConcertEventID == cncrt.ID && p.WorkerID == wrId))
                    {
                        sum += concertMarkRepository.Get(p => p.ConcertEventID == cncrt.ID && p.WorkerID == wrId).First().NumOfMarks;
                    }
                }

                sum += lessonMarkRepository.Get(p => p.WorkerID == wrId && p.IsVisited == true).Count();
                DataGridRow r = lessonGrid.GetRow(row);
                TextBlock   s = (TextBlock)lessonGrid.GetCell(r, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + 1).Content;
                s.Text = sum.ToString();
            }
        }
Example #2
0
        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();
        }