public void TestFindAll() { IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); IList <Artist> entities = dao.findAll(); Assert.AreEqual(entities.Count, 3); }
public PerformanceService(DbConnection connection) : base(connection) { performanceDao = DaoFactory.CreatePerformanceDao(Connection); artistDao = DaoFactory.CreateArtistDao(Connection); venueDao = DaoFactory.CreateVenueDao(Connection); }
/// <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 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)); }
public static void ClassInitialize(TestContext testContext) { db = new MYSQLDatabase("Server = localhost; Database = ufotest; Uid = root;"); catdao = new CategoryDao(db); coudao = new CountryDao(db); adao = new ArtistDao(db); couS = ServiceFactory.CreateCountryService(db); }
public void TestFindById() { IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); Artist artist = dao.findById(1); Assert.AreEqual(artist.Id, 1); Assert.AreEqual(artist.Name, "Larry Page"); }
/// <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); }
void InsertDummyData(IArtistDao dao) { CreateTestData(); foreach (var item in items) { dao.Insert(item); } }
public CountryService(IDatabase db) { if (db is MYSQLDatabase) { couDao = new CountryDao(db); aDao = new ArtistDao(db); } else { throw new NotSupportedException("Database not supported"); } }
public void TestFindByUniqueProperty() { IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); PropertyInfo info = typeof(Artist).GetProperty("Email"); Artist artist = dao.findByUniqueProperty(info, "*****@*****.**"); Assert.AreEqual(artist.Id, 1); Assert.AreEqual(artist.Email, "*****@*****.**"); Assert.AreEqual(artist.Name, "Larry Page"); }
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 CheckIsCatagoryInUse(Catagory catagory) { IArtistDao dao = DALFactory.CreateArtistDao(database); if (dao.findByProperty(typeof(Artist).GetProperty("Catagory"), catagory).Count() > 0) { return(true); } return(false); }
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 void TestUpdate() { IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); Artist artist = dao.findById(1); artist.Email = "*****@*****.**"; dao.Update(artist); Artist result = dao.findById(1); Assert.AreEqual(result.Email, artist.Email); }
public Artist SaveArtist(Artist artist) { IArtistDao dao = DALFactory.CreateArtistDao(database); if (artist.Id != null && artist.Id > 0) { dao.Update(artist); return(artist); } artist = dao.Insert(artist); return(artist); }
public void TestFindByIdAndCheckFetchCatagory() { IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); Artist artist = dao.findById(1); Assert.AreEqual(artist.Id, 1); Assert.AreEqual(artist.Name, "Larry Page"); ICatagoryDao catDao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase()); Catagory cat = catDao.findById(1); Assert.AreEqual(artist.Catagory.Id, cat.Id); }
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 Task <bool> CheckEmailIsAvailable(string email, Artist artist) { return(Task <bool> .Run(() => { IArtistDao dao = DALFactory.CreateArtistDao(database); IList <Artist> artists = dao.findByProperty(typeof(Artist).GetProperty("Email"), email); if (artists != null && artists.Count > 0) { if (artists.Count == 1 && artists.First().Id == artist.Id) { return true; } return false; } return true; })); }
private static void CreateArtists() { Console.WriteLine("Insert Artists "); Random r = new Random(); RootObject generatedEntries = FetchPersons(); IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); ICatagoryDao catagoryDao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase()); generatedEntries.results.ToList().ForEach(x => { Console.WriteLine(x.user.name.first); Artist artist = new Artist(); artist.Catagory = catagoryDao.findById(r.Next(1, 10)); artist.Name = x.user.name.first + " " + x.user.name.last; artist.Email = x.user.email; artist.Country = "AUT"; artist.Picture = GetBase64EncodedImageFromUrl(x.user.picture.thumbnail); dao.Insert(artist); Console.WriteLine("Inserted "); }); }
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 void TestInsert() { PropertyInfo info = typeof(Artist).GetProperty("Email"); Artist artist = new Artist(); artist.Email = "*****@*****.**"; artist.Name = "UnitTestArtist"; artist.Link = "I do not have any Link"; artist.Country = "AUT"; IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase()); dao.Insert(artist); Artist result = dao.findByUniqueProperty(info, "*****@*****.**"); Assert.AreEqual(result.Email, artist.Email); Assert.AreEqual(result.Name, artist.Name); Assert.AreEqual(result.Link, artist.Link); Assert.AreEqual(result.Country, artist.Country); }
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 ArtistProcessDb() { //Получаем объект для работы с художниками в базе _artistDao = DaoFactory.GetArtistDao(); }
public ArtistService(IArtistDao artistDao, IArtistFactory artistFactory) { _artistDao = artistDao; _artistFactory = artistFactory; }
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 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 Artist QueryArtistById(string id) { IArtistDao dao = DALFactory.CreateArtistDao(database); return(dao.findByUniqueProperty(typeof(Artist).GetProperty("Email"), id)); }
public IList <Artist> QueryArtists() { IArtistDao dao = DALFactory.CreateArtistDao(database); return(dao.findAllWithoutDeleted()); }
public void MyTestInitialize() { aDao = DALFactory.CreateArtistDao(database); }
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); } }
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(); }