public void TestFindAll() { IPerformanceDao dao = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase()); IList <Performance> entities = dao.findAll(); Assert.AreEqual(entities.Count, 2); }
public bool SavePerformance(Performance p) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); dao.Insert(p); return(true); }
/// <summary> /// disable an artist and set performances after now /// </summary> /// <param name="artist"></param> /// <returns></returns> public bool DeleteArtist(Artist artist) { IArtistDao dao = DALFactory.CreateArtistDao(database); Artist toDelete = dao.findById(artist.Id); if (toDelete == null) { return(false); } toDelete.Deleted = true; bool success = dao.Update(toDelete); if (success) { IPerformanceDao performanceDao = DALFactory.CreatePerformanceDao(database); IList <Performance> performances = performanceDao.FindPerformanceForArtistsAfterDate(toDelete, DateTime.Now); foreach (Performance p in performances) { Console.WriteLine("found performances " + p.Id + "artist " + p.Artist.Name); p.Canceld = true; success = performanceDao.Update(p); } } return(success); }
public PerformanceService(DbConnection connection) : base(connection) { performanceDao = DaoFactory.CreatePerformanceDao(Connection); artistDao = DaoFactory.CreateArtistDao(Connection); venueDao = DaoFactory.CreateVenueDao(Connection); }
public void TestFindById() { IPerformanceDao dao = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase()); Performance performance = dao.findById(1); Assert.AreEqual(performance.Id, 1); Assert.IsFalse(performance.Canceld); }
public IList <Performance> QueryPerfomancesByArtist(int artistId) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); IArtistDao artistDao = DALFactory.CreateArtistDao(database); Artist a = artistDao.findById(artistId); return(dao.findByProperty(typeof(Performance).GetProperty("Artist"), a)); }
/// <summary> /// Initializes a new instance of the <see cref="ViewerImpl"/> class. /// </summary> public ViewerImpl() { userDao = DalFactory.CreateUserDao(database); artistDao = DalFactory.CreateArtistDao(database); venueDao = DalFactory.CreateVenueDao(database); performanceDao = DalFactory.CreatePerformanceDao(database); categoryDao = DalFactory.CreateCategoryDao(database); }
public bool CanclePerformance(int performanceId) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); Performance p = dao.findById(performanceId); p.Canceld = true; return(dao.Update(p)); }
public IList <Performance> QueryPerfomancesByCatagory(int catagoryId) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); ICatagoryDao catagoryDao = DALFactory.CreateCatagoryDao(database); Catagory c = catagoryDao.findById(catagoryId); return(dao.FindPerformanceByCatagory(c)); }
public IList <Performance> QueryPerfomancesByVenue(int venueId) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); IVenueDao venueDao = DALFactory.CreateVenueDao(database); Venue v = venueDao.findById(venueId); return(dao.findByProperty(typeof(Performance).GetProperty("Venue"), v)); }
void InsertDummyData(IPerformanceDao dao) { CreateTestData(); foreach (var item in items) { dao.Insert(item); } }
public VenueService(IDatabase db) { if (db is MYSQLDatabase) { vdao = new VenueDao(db); pdao = new PerformanceDao(db); } else { throw new NotSupportedException("Database not supported"); } listeners = new List<IVenueListener>(); }
public ManagerImpl() { database = DalFactory.CreateDatabase(); userDao = DalFactory.CreateUserDao(database); artistDao = DalFactory.CreateArtistDao(database); categoryDao = DalFactory.CreateCategoryDao(database); locationDao = DalFactory.CreateLocationDao(database); venueDao = DalFactory.CreateVenueDao(database); performanceDao = DalFactory.CreatePerformanceDao(database); }
public ArtistService(IDatabase db) { if(db is MYSQLDatabase) { aDao = new ArtistDao(db); pDao = new PerformanceDao(db); } else { throw new NotSupportedException("Database not supported"); } listeners = new List<IArtistListener>(); }
public Commander(IDatabase database) { this.database = database; this.artistDao = DALFactory.CreateArtistDao(database); this.categoryDao = DALFactory.CreateCategoryDao(database); this.countryDao = DALFactory.CreateCountryDao(database); this.performanceDao = DALFactory.CreatePerformanceDao(database); this.userDao = DALFactory.CreateUserDao(database); this.venueDao = DALFactory.CreateVenueDao(database); }
public bool PostponePerformance(int performanceId, DateTime date, int venueId) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); IVenueDao venueDao = DALFactory.CreateVenueDao(database); Performance p = dao.findById(performanceId); if (this.CheckPostponeIsPossible(performanceId, date, venueId)) { p.StagingTime = date; Venue v = venueDao.findById(venueId); p.Venue = v; return(dao.Update(p)); } return(false); }
public void TestUpdate() { IPerformanceDao dao = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase()); Performance performance = dao.findById(1); IArtistDao artistDao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); Artist artist = artistDao.findById(2); performance.Artist = artist; performance.StagingTime = DateTime.UtcNow; dao.Update(performance); Performance result = dao.findById(1); //Assert.AreEqual(result.StagingTime, performance.StagingTime); Assert.AreEqual(result.Artist.Id, performance.Artist.Id); }
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); }
public bool CheckPostponeIsPossible(int performanceId, DateTime date, int venueId) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); IVenueDao venueDao = DALFactory.CreateVenueDao(database); Performance toPostpone = dao.findById(performanceId); IList <Performance> otherPerformances = dao.FindPerormanceByDay(date); bool foundConflict = false; foreach (Performance p in otherPerformances) { if (p.Id == toPostpone.Id) { continue; } DateTime postPoneDate = new DateTime(date.Year, date.Month, date.Day, date.Hour, 0, 0); DateTime currentDate = new DateTime(p.StagingTime.Year, p.StagingTime.Month, p.StagingTime.Day, p.StagingTime.Hour, 0, 0); if (toPostpone.Artist.Id == p.Artist.Id) { if (postPoneDate >= currentDate.AddHours(-2) && postPoneDate <= currentDate.AddHours(2)) { foundConflict = true; break; } } if (p.Venue.Id == venueId && postPoneDate == currentDate) { foundConflict = true; break; } } return(!foundConflict); }
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++; } }
public ArtistService(DbConnection connection = null) : base(connection) { artistDao = DaoFactory.CreateArtistDao(Connection); performanceDao = DaoFactory.CreatePerformanceDao(Connection); }
public IList <Performance> QueryPerformancesByVenueAndDay(Venue venue, DateTime day) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.FindPerformanceForVenueByDay(venue, day)); }
public bool DeletePerformancesByDay(DateTime day) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.DeletePerformancesByDay(day)); }
private bool canDeleteVenue(Venue venue) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.findByProperty(typeof(Performance).GetProperty("Venue"), venue).Count <= 0); }
public void Startup() { catdao = new CategoryDao(db); coudao = new CountryDao(db); adao = new ArtistDao(db); vdao = new VenueDao(db); pdao = new PerformanceDao(db); aS = ServiceFactory.CreateArtistService(db); category = RepresentativeData.GetDefaultCategories()[0]; country = RepresentativeData.GetDefaultCountries()[0]; category = catdao.CreateCategory(category.Shortcut, category.Name); country = coudao.CreateCountry(country.Name, country.FlagPath); }
public IList <Performance> QueryPerfomancesByDay(DateTime day) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.FindPerormanceByDay(day)); }
public void Startup() { vdao = new VenueDao(db); catDao = new CategoryDao(db); couDao = new CountryDao(db); adao = new ArtistDao(db); pdao = new PerformanceDao(db); pdao.DeleteAllPerformances(); vdao.DeleteAllVenues(); adao.DeleteAllArtists(); catDao.DeleteAllCategories(); couDao.DeleteAllCountries(); foreach (var item in RepresentativeData.GetDefaultVenues()) { vdao.CreateVenue(item.Name, item.Shortcut, item.Latitude, item.Longitude); } foreach (var item in RepresentativeData.GetDefaultCategories()) { catDao.CreateCategory(item.Shortcut, item.Name); } foreach (var item in RepresentativeData.GetDefaultCountries()) { couDao.CreateCountry(item.Name, item.FlagPath); } foreach (var item in RepresentativeData.GetDefaultArtists()) { adao.CreateArtist(item.Name, item.Email, item.CategoryId, item.CountryId, item.PicturePath, item.VideoPath); } }
public void Startup() { pdao = new PerformanceDao(db); adoa = new ArtistDao(db); countrydao = new CountryDao(db); categorydao = new CategoryDao(db); vdao = new VenueDao(db); ps = ServiceFactory.CreatePerformanceService(db); pdao.DeleteAllPerformances(); adoa.DeleteAllArtists(); countrydao.DeleteAllCountries(); categorydao.DeleteAllCategories(); vdao.DeleteAllVenues(); }
public void MyTestInitialize() { pDao = DALFactory.CreatePerformanceDao(database); }
public IList <Performance> QueryPerformances() { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.findAll()); }
public void Startup() { adao = new ArtistDao(db); catDao = new CategoryDao(db); couDao = new CountryDao(db); pDao = new PerformanceDao(db); pDao.DeleteAllPerformances(); adao.DeleteAllArtists(); catDao.DeleteAllCategories(); couDao.DeleteAllCountries(); foreach (var item in RepresentativeData.GetDefaultCategories()) { catDao.CreateCategory(item.Shortcut, item.Name); } foreach (var item in RepresentativeData.GetDefaultCountries()) { couDao.CreateCountry(item.Name, item.FlagPath); } }