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();
}
