public void TestInsert() { Performance performance = new Performance(); IArtistDao artistDao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); Artist artist = artistDao.findById(1); IVenueDao venueDao = DALFactory.CreateVenueDao(DALFactory.CreateDatabase()); Venue venue = venueDao.findById(1); performance.Artist = artist; performance.Venue = venue; performance.StagingTime = DateTime.Now; IPerformanceDao dao = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase()); dao.Insert(performance); IList<Performance> result = dao.findAll(); Assert.AreEqual(result.Count, 3); }
private void SavePerformanceHelper(Performance current) { if (current.Artist != null && current.Artist.Id >= 0 && current.Venue != null && current.Venue.Id > 0) { administrationService.SavePerformance(current); } }
//Load Items Asynchronious public void LoadItems() { IList<PerformanceVM> calculateModels = new List<PerformanceVM>(); Performances.Clear(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler((sender, args) => { IList<Venue> venues = administrationService.GetVenues(); foreach (Venue venue in venues) { IList<Performance> performances = administrationService.GetPerformancesByVenueAndDay(venue, CurrentDate); if (performances.Count > 4) { return; } DateTime d = CurrentDate.Date; Performance col1 = new Performance(); col1.StagingTime = d.AddHours(14); Performance col2 = new Performance(); col2.StagingTime = d.AddHours(15); Performance col3 = new Performance(); col3.StagingTime = d.AddHours(16); Performance col4 = new Performance(); col4.StagingTime = d.AddHours(17); Performance col5 = new Performance(); col5.StagingTime = d.AddHours(18); foreach (Performance p in performances) { if (p.StagingTime.Hour >= 18) { col5 = p; } else if (p.StagingTime.Hour >= 17 ) { col4 = p; } else if (p.StagingTime.Hour >= 16) { col3 = p; } else if (p.StagingTime.Hour >= 15) { col2 = p; } else if (p.StagingTime.Hour >= 14) { col1 = p; } } calculateModels.Add(new PerformanceVM(venue, col1, col2, col3, col4, col5, administrationService,this)); } }); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler((sender, args) => { Performances.Clear(); foreach(PerformanceVM vm in calculateModels) { vm.GroupCheckBox(); Performances.Add(vm); } RaisePropertyChangedEvent(nameof(Performances)); }); worker.RunWorkerAsync(System.Reflection.Assembly.GetExecutingAssembly().Location); }
private static void CreatePerformances() { Console.WriteLine("Insert Performances "); IVenueDao venueDao = DALFactory.CreateVenueDao(DALFactory.CreateDatabase()); IPerformanceDao performanceDao = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase()); IArtistDao artistDao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); int year = 2016; int month = 01; int day = 23; for (int i=0; i<3; i++) { int count = 1; int hour = 14; int min = 00; int second = 00; for (int j = 1; j <= 40; j++) { count++; if(count == 10) { hour= hour +2; count = 1; } DateTime dt = new DateTime(year, month, day, hour, min, second); Venue venue = venueDao.findById(j); Artist artist = artistDao.findById(j); Performance p = new Performance(); p.Artist = artist; p.Venue = venue; p.StagingTime = dt; performanceDao.Insert(p); } day++; } }
private bool ValidateOneItem(Performance current) { foreach (Performance p in this.GetPerformancesToValidate()) { if (p?.Artist?.Id == current?.Artist?.Id && p != current) { DateTime postPoneDate = new DateTime(current.StagingTime.Year, current.StagingTime.Month, current.StagingTime.Day, current.StagingTime.Hour, 0, 0); DateTime currentDate = new DateTime(p.StagingTime.Year, p.StagingTime.Month, p.StagingTime.Day, p.StagingTime.Hour, 0, 0); if (postPoneDate >= currentDate.AddHours(-2) && postPoneDate <= currentDate.AddHours(2)) { return false; } } } return true; }
public PerformanceVM(Venue v, Performance p1, Performance p2, Performance p3, Performance p4, Performance p5,IAdministrationServices service, PerformanceAdministrationVM parent) { this.Artists = new ObservableCollection<Artist>(); this.administrationService = service; this.parent = parent; venue = v; Col1 = p1; Col2 = p2; Col3 = p3; Col4 = p4; Col5 = p5; this.Artists.Clear(); IList<Artist> arts = administrationService.GetArtists(); foreach (Artist artist in arts) { Artists.Add(artist); } RemoveEntryCol1 = new RelayCommand(c => { Col1.Artist = null; RaisePropertyChangedEvent(nameof(ArtistCol1)); RaisePropertyChangedEvent(nameof(ArtistNameCol1)); RaisePropertyChangedEvent(nameof(CountryCol1)); RaisePropertyChangedEvent(nameof(CatagoryCol1)); RaisePropertyChangedEvent(nameof(ColorCol1)); }); RemoveEntryCol2 = new RelayCommand(c => { Col2.Artist = null; RaisePropertyChangedEvent(nameof(ArtistCol2)); RaisePropertyChangedEvent(nameof(ArtistNameCol2)); RaisePropertyChangedEvent(nameof(CountryCol2)); RaisePropertyChangedEvent(nameof(CatagoryCol2)); RaisePropertyChangedEvent(nameof(ColorCol2)); }); RemoveEntryCol3 = new RelayCommand(c => { Col3.Artist = null; RaisePropertyChangedEvent(nameof(ArtistCol3)); RaisePropertyChangedEvent(nameof(ArtistNameCol3)); RaisePropertyChangedEvent(nameof(CountryCol3)); RaisePropertyChangedEvent(nameof(CatagoryCol3)); RaisePropertyChangedEvent(nameof(ColorCol3)); }); RemoveEntryCol4 = new RelayCommand(c => { Col4.Artist = null; RaisePropertyChangedEvent(nameof(ArtistCol4)); RaisePropertyChangedEvent(nameof(ArtistNameCol4)); RaisePropertyChangedEvent(nameof(CountryCol4)); RaisePropertyChangedEvent(nameof(CatagoryCol4)); RaisePropertyChangedEvent(nameof(ColorCol4)); }); RemoveEntryCol5 = new RelayCommand(c => { Col5.Artist = null; RaisePropertyChangedEvent(nameof(ArtistCol5)); RaisePropertyChangedEvent(nameof(ArtistNameCol5)); RaisePropertyChangedEvent(nameof(CountryCol5)); RaisePropertyChangedEvent(nameof(CatagoryCol5)); RaisePropertyChangedEvent(nameof(ColorCol5)); }); SendEmailCol1 = new RelayCommand(c => { IList<Performance> toSend = new List<Performance>(); toSend.Add(Col1); administrationService.SendMail(toSend,toSend); AppMessages.ShowSuccessMessage.Send("Mail sent"); }); SendEmailCol2 = new RelayCommand(c => { IList<Performance> toSend = new List<Performance>(); toSend.Add(Col2); administrationService.SendMail(toSend, toSend); AppMessages.ShowSuccessMessage.Send("Mail sent"); }); SendEmailCol3 = new RelayCommand(c => { IList<Performance> toSend = new List<Performance>(); toSend.Add(Col3); administrationService.SendMail(toSend, toSend); AppMessages.ShowSuccessMessage.Send("Mail sent"); }); SendEmailCol4 = new RelayCommand(c => { IList<Performance> toSend = new List<Performance>(); toSend.Add(Col4); administrationService.SendMail(toSend, toSend); AppMessages.ShowSuccessMessage.Send("Mail sent"); }); SendEmailCol5 = new RelayCommand(c => { IList<Performance> toSend = new List<Performance>(); toSend.Add(Col5); administrationService.SendMail(toSend, toSend); AppMessages.ShowSuccessMessage.Send("Mail sent"); }); }
public bool SavePerformance(Performance p) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); dao.Insert(p); return true; }