private void ChangeButton_Click(object sender, RoutedEventArgs e) { if (concertListView.SelectedItem == null) { MessageBox.Show("errror"); return; } ConcertEvent Value = (ConcertEvent)concertListView.SelectedItem; ChangeConcertWindow changeConcert = new ChangeConcertWindow(Value.ID); changeConcert.Show(); Close(); }
private void RemoveButton_Click(object sender, RoutedEventArgs e) { if (concertListView.SelectedItem == null) { MessageBox.Show("errror"); return; } ConcertEvent Value = (ConcertEvent)concertListView.SelectedItem; concertRepositoty.Delete(Value); concertRepositoty.DeleteFromCache(Value.ID); concertListView.ItemsSource = concertRepositoty.GetListFromCache(); concertListView.Items.Refresh(); }
private void AddButton_Click(object sender, RoutedEventArgs e) { ConcertEvent concert = new ConcertEvent(); concert.BeginningDate = this.BeginingDate.SelectedDate; concert.EndDate = this.EndDate.SelectedDate; concert.Country = this.CountryTextBox.Text; concert.City = this.CitytextBox.Text; concert.Address = this.AddresTextBox.Text; concert.ConcertTypeId = concertTypeRepositoty.Get(p => p.Name == this.TypeComboBox.Text).First().ID; concert.ConcertPlaceTypeId = concertPlaceTypeRepository.Get(p => p.Name == this.TypePlaceComboBox.Text).First().ID; concert.Description = this.DescriptionTextBox.Text; concertRepositoty.Insert(concert); if (workerListView.Items != null) { concert.ConcertMarks = null; //ICollection<ConcertMarks> concertMarks = new System.Collections.ObjectModel.Collection<ConcertMarks>(); for (int i = 0; i < workerListView.Items.Count; i++) { Items Value = (Items)workerListView.Items[i]; ConcertMarks concertMark = new ConcertMarks(); concertMark.NumOfMarks = Value.mark; concertMark.ConcertEventID = concert.ID; concertMark.WorkerID = Value.wrk.ID; concertMarksRepositoty.Insert(concertMark); } concertRepositoty.Update(concert); } concertRepositoty.UpdateCache(concert, concert.ID); MessageBox.Show("добавлен"); Close_Click(sender, e); //this.btnReload_Click(sender, e); }
private void AddButton_Click(object sender, RoutedEventArgs e) { ConcertEvent concert = concertRepositoty.FindByID(id); concert.BeginningDate = this.BeginingDate.SelectedDate; concert.EndDate = this.EndDate.SelectedDate; concert.Country = this.CountryTextBox.Text; concert.City = this.CitytextBox.Text; concert.Address = this.AddresTextBox.Text; concert.ConcertTypeId = concertTypeRepositoty.Get(p => p.Name == this.TypeComboBox.Text).First().ID; concert.ConcertPlaceTypeId = concertPlaceTypeRepository.Get(p => p.Name == this.TypePlaceComboBox.Text).First().ID; concert.Description = this.DescriptionTextBox.Text; concertRepositoty.Modified(concert); concertRepositoty.Update(concert); concertRepositoty.UpdateCache(concert, concert.ID); MessageBox.Show("changed"); Close_Click(sender, e); }
private void AddWorkerButton_Click(object sender, RoutedEventArgs e) { List <Worker> wrList = new List <Worker>(); if (workerListView.Items != null) { for (int i = 0; i < workerListView.Items.Count; i++) { Items Value = (Items)workerListView.Items[i]; wrList.Add(Value.wrk); } } AddWorkersToConcertWindow addWorker = new AddWorkersToConcertWindow(wrList); this.Visibility = Visibility.Collapsed; addWorker.ShowDialog(); if (addWorker.DialogResult.HasValue && addWorker.DialogResult.Value) { workerListView.Items.Add(new Items { wrk = addWorker.Worker, mark = addWorker.Mark }); ConcertEvent concert = concertRepositoty.GetByIdFromCahce(id); ConcertMarks concertMark = new ConcertMarks(); concertMark.NumOfMarks = addWorker.Mark; concertMark.ConcertEventID = concert.ID; concertMark.WorkerID = addWorker.Worker.ID; concertMarksRepositoty.Insert(concertMark); } this.Visibility = Visibility.Visible; workerListView.Items.Refresh(); }
public void SetValue() { List <Items> wrList = (List <Items>)lessonGrid.ItemsSource; for (int column = 1; column < DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + 1; column++) { DateTime dt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, column); LessonEvent lsnEvent = new LessonEvent(); if (lessonRepository.IsExist(p => p.Date == dt)) { lsnEvent = lessonRepository.GetAllFromCache().Where(d => d.Date == dt).First(); } //lsnEvent = lessonRepository.Get(d => d.Date == dt).First(); ConcertEvent concEvent = new ConcertEvent(); if (concertRepository.IsExist(p => dt >= p.BeginningDate && dt <= p.EndDate)) { concEvent = concertRepository.GetListFromCache().Where(p => dt >= p.BeginningDate && dt <= p.EndDate).First(); //concEvent = concertRepository.Get(p => dt >= p.BeginningDate && dt <= p.EndDate).First(); } for (int row = 0; row < workerRepository.GetAllFromCache(1).Count(); row++) { int wrId = wrList[row].wrk.ID; DataGridRow r = lessonGrid.GetRow(row); if (lessonMarkRepository.IsExist(p => p.LessonEventID == lsnEvent.ID && p.IsVisited == true && p.WorkerID == wrId)) { lessonGrid.GetCell(r, column).Background = new SolidColorBrush(Colors.Red); } if (concertMarkRepository.IsExist(p => p.ConcertEventID == concEvent.ID && p.WorkerID == wrId)) { lessonGrid.GetCell(r, column).Background = new SolidColorBrush(Colors.Green); } } } GridSum(wrList); }
public ChangeConcertWindow(int id) { this.id = id; InitializeComponent(); concertRepositoty = new ConcertEventRepository(new ApplicationContext()); workerRepositoty = new WorkerRepository(new ApplicationContext()); concertMarksRepositoty = new ConcertMarksRepository(new ApplicationContext()); concertTypeRepositoty = new ConcertTypeRepository(new ApplicationContext()); concertPlaceTypeRepository = new ConcertPlaceTypeRepository(new ApplicationContext()); ConcertEvent concert = concertRepositoty.GetByIdFromCahce(id); this.BeginingDate.SelectedDate = concert.BeginningDate; this.EndDate.SelectedDate = concert.EndDate; this.CountryTextBox.Text = concert.Country; this.CitytextBox.Text = concert.City; this.AddresTextBox.Text = concert.Address; this.TypeComboBox.SelectedItem = concertTypeRepositoty.FindByID(concert.ConcertTypeId).Name; this.TypePlaceComboBox.SelectedItem = concertPlaceTypeRepository.FindByID(concert.ConcertPlaceTypeId).Name; this.DescriptionTextBox.Text = concert.Description; TypeComboBox.ItemsSource = concertTypeRepositoty.getAll().Select(p => p.Name); TypePlaceComboBox.ItemsSource = concertPlaceTypeRepository.getAll().Select(p => p.Name); IEnumerable <ConcertMarks> concertMarks; concertMarks = concertMarksRepositoty.getAll().Where(p => p.ConcertEventID == id); foreach (ConcertMarks conMark in concertMarks) { workerListView.Items.Add(new Items { wrk = workerRepositoty.GetByIdFromCahce(conMark.WorkerID), mark = conMark.NumOfMarks }); } }
private void SaveExelButton_Click(object sender, RoutedEventArgs e) { List <Items> wrList = (List <Items>)lessonGrid.ItemsSource; Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); excel.Visible = true; Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(System.Reflection.Missing.Value); Microsoft.Office.Interop.Excel.Worksheet sheet1 = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1]; for (int j = 0; j < lessonGrid.Columns.Count; j++) { Microsoft.Office.Interop.Excel.Range myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[1, j + 1]; sheet1.Cells[1, j + 1].Font.Bold = true; sheet1.Columns[j + 1].ColumnWidth = 15; myRange.Value2 = lessonGrid.Columns[j].Header; } for (int i = 0; i < lessonGrid.Columns.Count; i++) { DateTime dt; ConcertEvent concEvent = new ConcertEvent(); LessonEvent lsnEvent = new LessonEvent(); if (i != 0 && i != lessonGrid.Columns.Count && i != lessonGrid.Columns.Count - 1) { dt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, i); concEvent = new ConcertEvent(); if (concertRepository.IsExist(p => dt >= p.BeginningDate && dt <= p.EndDate)) { concEvent = concertRepository.GetListFromCache().Where(p => dt >= p.BeginningDate && dt <= p.EndDate).First(); } lsnEvent = lessonRepository.GetAllFromCache().Where(d => d.Date == dt).First(); } for (int j = 0; j < lessonGrid.Items.Count; j++) { int wrId = wrList[j].wrk.ID; DataGridRow r = lessonGrid.GetRow(j); TextBlock b = lessonGrid.Columns[i].GetCellContent(lessonGrid.Items[j]) as TextBlock; Microsoft.Office.Interop.Excel.Range myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[j + 2, i + 1]; if (lessonMarkRepository.IsExist(p => p.LessonEventID == lsnEvent.ID && p.IsVisited == true && p.WorkerID == wrId)) { lessonGrid.GetCell(r, i).Background = new SolidColorBrush(Colors.Red); myRange.Value2 = 1.ToString(); } else if (concertMarkRepository.IsExist(p => p.ConcertEventID == concEvent.ID && p.WorkerID == wrId)) { lessonGrid.GetCell(r, i).Background = new SolidColorBrush(Colors.Green); double mark = concertMarkRepository.Get(p => p.ConcertEventID == concEvent.ID && p.WorkerID == wrId).First().NumOfMarks; TimeSpan d1 = concEvent.EndDate.Value - concEvent.BeginningDate.Value; myRange.Value2 = "(концерт)" + Math.Round((mark / (double)d1.Days), 2).ToString(); } else { myRange.Value2 = b.Text; } } } workbook.SaveAs("отчёт за " + DateTime.Now.Month + " месяц"); excel.Quit(); }