public void TestFindAll()
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
IList <Catagory> entities = dao.findAll();
Assert.AreEqual(entities.Count, 2);
}
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 void TestFindById()
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
Catagory cat = dao.findById(1);
Assert.AreEqual(cat.Id, 1);
Assert.AreEqual(cat.Name, "Klassik");
}
public bool DelteCatagory(Catagory catagory)
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(database);
if (this.CheckIsCatagoryInUse(catagory))
{
throw new ElementInUseException($"Can't delete catagory {catagory.Name}. Catagory is assigned");
}
return(dao.Delete(catagory));
}
public Catagory SaveCatagory(Catagory catagory)
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(database);
if (catagory.Id != null && catagory.Id > 0)
{
dao.Update(catagory);
return(catagory);
}
catagory = dao.Insert(catagory);
return(catagory);
}
public void TestUpdate()
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
Catagory cat = dao.findById(1);
cat.Name = "Test";
dao.Update(cat);
Catagory result = dao.findById(1);
Assert.AreEqual(result.Name, cat.Name);
}
private static void CreateCatagories()
{
Console.WriteLine("Insert Catagories ");
ICatagoryDao catagoryDao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
for (int i = 1; i <= 10; i++)
{
Catagory c = new Catagory();
c.Name = "Catagory " + i;
c.Description = "Catagory Description for " + i;
catagoryDao.Insert(c);
}
}
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 TestInsert()
{
Catagory cat = new Catagory();
cat.Name = "UNIT-TEST";
cat.Description = "asdf";
ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
dao.Insert(cat);
PropertyInfo info = typeof(Catagory).GetProperty("Name");
Catagory result = dao.findByUniqueProperty(info, "UNIT-TEST");
Assert.AreEqual(result.Name, cat.Name);
Assert.AreEqual(result.Description, cat.Description);
}
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 IList <Catagory> QueryCatagories()
{
ICatagoryDao dao = DALFactory.CreateCatagoryDao(database);
return(dao.findAll());
}
