static void testRepo()
{
TitlesDBRepository repoTitles = new TitlesDBRepository("DESKTOP-E94DLUN\\SQLEXPRESS", "Libraries");
CharactersDBRepository repoCharacters = new CharactersDBRepository("DESKTOP-E94DLUN\\SQLEXPRESS", "Libraries");
foreach (Title title in repoTitles.FindAll())
{
Console.WriteLine(title);
}
Console.WriteLine();
foreach (Character character in repoCharacters.FindAll())
{
Console.WriteLine(character);
}
Console.WriteLine("\n" + repoTitles.FindOne(2) + "\n");
repoTitles.Add(new Title(7, "newTitle7"));
foreach (Title title in repoTitles.FindAll())
{
Console.WriteLine(title);
}
Console.WriteLine("\n" + repoTitles.Remove(7) + "\n");
foreach (Title title in repoTitles.FindAll())
{
Console.WriteLine(title);
}
try
{
//repoTitles.Add(new Title(1, "newTitle7"));
repoTitles.Remove(-1);
}
catch (Exception exc)
{
Console.WriteLine("Exception caught: " + exc.Message);
}
repoTitles.Update(new Title(6, "newTitle6 updated2"));
foreach (Title title in repoTitles.FindAll())
{
Console.WriteLine(title);
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Libraries libraries = new Libraries();
TitlesDBRepository repoTitles = new TitlesDBRepository("DESKTOP-E94DLUN\\SQLEXPRESS", "Libraries");
CharactersDBRepository repoCharacters = new CharactersDBRepository("DESKTOP-E94DLUN\\SQLEXPRESS", "Libraries");
OneToManyService <int, Title, int, Character> service = new OneToManyService <int, Title, int, Character>(repoTitles, repoCharacters, new CharacterValidator());
libraries.MyService = service;
Console.WriteLine("bla");
Application.Run(libraries);
}
static void testService()
{
TitlesDBRepository repoTitles = new TitlesDBRepository("DESKTOP-E94DLUN\\SQLEXPRESS", "Libraries");
CharactersDBRepository repoCharacters = new CharactersDBRepository("DESKTOP-E94DLUN\\SQLEXPRESS", "Libraries");
OneToManyService <int, Title, int, Character> service = new OneToManyService <int, Title, int, Character>(repoTitles, repoCharacters, new CharacterValidator());
foreach (Title title in service.GetParents())
{
Console.WriteLine(title);
}
Console.WriteLine();
foreach (Character character in service.GetRecordsForParentId(1))
{
Console.WriteLine(character);
}
Console.WriteLine();
service.Add(new Character(4, 2, "char1", "Primary"));
foreach (Character character in service.GetRecordsForParentId(2))
{
Console.WriteLine(character);
}
Console.WriteLine();
service.Update(new Character(4, 2, "char1 updated", "Secondary"));
foreach (Character character in service.GetRecordsForParentId(2))
{
Console.WriteLine(character);
}
Console.WriteLine();
service.Remove(4);
foreach (Character character in service.GetRecordsForParentId(2))
{
Console.WriteLine(character);
}
Console.WriteLine();
}
