public void Test_DeleteTitle() { var data = new AdoData(); var actual = data.DeleteTitle(title); Assert.True(actual); }
public void Test_DeleteMonster() { var data = new AdoData(); var actual = data.DeleteMonster(monster); Assert.True(actual); }
public void Test_UpdateMonsterType() { var data = new AdoData(); var actual = data.UpdateMonsterType(monsterType); Assert.True(actual); }
public void Test_GetTitles() { var data = new AdoData(); var actual = data.GetTitles(); Assert.NotNull(actual.Count); }
public void Test_GetMonsterType() { AdoData data = new AdoData(); var actual = data.GetMonsterTypes(); Assert.NotNull(actual); }
public static void PlayWithAdo() { var ado = new AdoData(); //ado.ReadDisconnected(); ado.ReadConnected(); }
public void Test_GetTitle() { AdoData data = new AdoData(); var actual = data.GetTitles(); Assert.NotNull(actual); }
public void Test_UpdateGender() { var data = new AdoData(); var actual = data.UpdateGender(gender2); Assert.True(actual); }
public void Test_InsertGender() { var data = new AdoData(); var actual = data.InsertGender(gender); Assert.True(actual); }
public void Test_GetGenders() { AdoData data = new AdoData(); var actual = data.GetGender(); Assert.NotNull(actual); }
//[Theory(gender = new Models.Gender() { Name = "blah", Active = true})] //[Theory(gender = new Models.Gender() { Name = "blah", Active = true })] //[Theory(gender = new Models.Gender() { Name = "blah", Active = true })] public void Theory_InsertGender(Models.Gender gender) { var data = new AdoData(); var actual = data.InsertGender(gender); Assert.True(actual); }
public void Test_GetRecentGender() { AdoData data = new AdoData(); var expected = 21; var actual = data.GetRecentGender(); Assert.Equal(expected, actual); }
public void Test_GetTitles() { AdoData data = new AdoData(); var expected = 3; var actual = data.GetTitles(); Assert.Equal(expected, actual.Count); }
//Negative tests public void Test_GetRecentGenders() { AdoData data = new AdoData(); var expected = 5; var actual = data.GetGenders(); Assert.Equal(expected, actual.Count); }
public void Test_GetMonsters() { AdoData data = new AdoData(); var expected = 0; var actual = data.GetMonsters(); Assert.Equal(expected, actual.Count); }
public void Test_InsertMonster() { var data = new AdoData(); var expected = new Model.Monster() { GenderID = 3, TitleID = 2, TypeID = 2, Name = "AdoInsert", PicturePath = "pathz", Active = false }; var actual = data.InsertMonster(expected); Assert.True(actual); }
public void Test_GetGenders() { //arrange AdoData data = new AdoData(); var expected = 3; //act var actual = data.GetGenders(); //assert Assert.Equal(expected, actual.Count); }
public void Test_InsertMonster() { AdoData data = new AdoData(); var monster = new DataAccess.Models.Monster(); monster.Name = "Dracula"; monster.GenderId = 1; monster.TitleId = 1; monster.TypeId = 1; monster.PicturePath = "x"; monster.Active = true; var actual = data.InsertMonster(monster); }
public void Test_incomplete() { AdoData data = new AdoData(); Console.WriteLine(data.GetInComplete()); }
public static void PlayWithAdo2() { var actor = new AdoData(); actor.ReadConnected(); }
public void Test_TopGenders() { AdoData data = new AdoData(); Console.WriteLine(data.GetTopGender()); }
public static void Main(string[] args) { while (true) { Console.Clear(); Console.WriteLine("Mediathek...\n"); Console.WriteLine("1. Alle Alben anzeigen ->" + "\t" + "5. Album löschen ->"); Console.WriteLine("2. Album mit Songs anzeigen ->" + "\t" + "6. Alben nach Genre ->"); Console.WriteLine("3. Neues Album hinzufügen ->" + "\t" + "7. Alben nach Datum ->"); Console.WriteLine("4. Änderungen ->" + "\t\t" + "8. Song suchen ->"); Console.WriteLine("9. Exit"); string Eingabe = Console.ReadLine(); if (Eingabe == "1") { var test1 = new AdoData(); List <Album> list = test1.GetAllAlbum(); if (list != null) { foreach (Album album in list) { Console.WriteLine(album.interpret + " " + album.title + " " + album.genre + " " + album.datum); } } } else if (Eingabe == "2") { var test2 = new AdoData(); List <Album> list = test2.GetAllAlbum(); List <Song> songlist = test2.GetSongsFromAlbum(); Console.WriteLine("Album mit Songs: "); Console.Write("Interpret: "); string interpret = Console.ReadLine(); Console.Write("Albumtitel: "); string title = Console.ReadLine(); var t = list.Where(p => p.interpret == interpret && p.title == title); foreach (Album album in t) { var test = from a in t join so in songlist on a.albumID equals so.albumID select new { Interpret = a.interpret, Album = a.title, Song = so.songtitle }; //foreach (var aso in test) //{ // Console.WriteLine(aso); //} foreach (var item in test) { Console.WriteLine("{0,-10} {1,-10} {2,-10}", item.Interpret, item.Album, item.Song); } Console.WriteLine("Songs in Album: {0} ", test.Count()); Console.WriteLine(System.Environment.NewLine); } } else if (Eingabe == "3") { Console.Write("Geben Sie den Interpreten ein: "); string interpret = Console.ReadLine(); Console.Write("Geben Sie den Albumtitel ein: "); string title = Console.ReadLine(); Console.Write("Geben Sie die Genre ein: "); string genre = Console.ReadLine(); Album neuAlbum = new Album(interpret, title, genre); var test3 = new AdoData(); test3.InsertAlbum(neuAlbum); } else if (Eingabe == "4") { var test4 = new AdoData(); List <Album> list = test4.GetAllAlbum(); if (list != null) { foreach (Album album in list) { Console.WriteLine(album.interpret + " " + album.title + " " + album.genre); } } Console.Write("Änderungen Album: "); Console.Write("\nInterpret: "); string interpret = Console.ReadLine(); Console.Write("Album Titel: "); string title = Console.ReadLine(); Console.Write("Genre: "); string genre = Console.ReadLine(); var test = list.Where(p => p.interpret == interpret && p.title == title && p.genre == genre); foreach (Album album in test) { Console.WriteLine("Was wollen Sie Ändern? "); Console.Write(album.interpret + " : "); album.interpret = Console.ReadLine(); Console.Write(album.title + " : "); album.title = Console.ReadLine(); Console.Write(album.genre + " : "); album.genre = Console.ReadLine(); //Console.Write(album.imagepath + " :"); //Console.ReadLine(); Console.Write(album.datum + " : "); album.datum = Convert.ToInt32(Console.ReadLine()); test4.UpdateAlbum(album); } } else if (Eingabe == "5") { var test5 = new AdoData(); List <Album> list = test5.GetAllAlbum(); foreach (Album album in list) { Console.WriteLine(album.interpret + " " + album.title + " " + album.genre); } Console.WriteLine("\nWelcher Album soll gelöscht werden: "); Console.Write("Geben Sie den Interpreten ein: "); string interpret = Console.ReadLine(); Console.Write("Geben Sie den Albumtitel ein: "); string title = Console.ReadLine(); Console.Write("Geben Sie die Genre ein: "); string genre = Console.ReadLine(); var test = list.Where(p => p.interpret == interpret && p.title == title && p.genre == genre); foreach (Album album in test) { //Console.WriteLine(album.interpret); test5.DeleteAlbum(album); } } else if (Eingabe == "6") { var test6 = new AdoData(); List <Album> list = test6.GetAllAlbum(); Console.WriteLine("Geben Sie die Genre ein: "); string genre = Console.ReadLine(); var test = list.Where(p => p.genre == genre); foreach (Album album in test) { Console.WriteLine(album.title + " " + album.interpret); } } else if (Eingabe == "7") { var test7 = new AdoData(); List <Album> list = test7.GetAllAlbum(); Console.WriteLine("Alben von alt nach neu:"); var test = from l in list orderby l.datum ascending select l; foreach (var album in test) { Console.WriteLine(album.datum + " " + album.interpret + " " + album.title); } } else if (Eingabe == "8") { var test8 = new AdoData(); List <Album> list = test8.GetAllAlbum(); List <Song> songlist = test8.GetSongsFromAlbum(); Console.WriteLine("Gesuchter Song: "); string songtitle = Console.ReadLine(); var t = songlist.Where(p => p.songtitle == songtitle); foreach (Song song in t) { var test = from so in t join a in list on so.albumID equals a.albumID select new { Interpret = a.interpret, Album = a.title, Song = so.songtitle }; //foreach (var aso in test) //{ // Console.WriteLine(aso); //} foreach (var item in test) { Console.WriteLine("Gefunden in: "); Console.WriteLine("{0,-10} {1,-10} {2,-10}", item.Interpret, item.Album, item.Song); } } } else if (Eingabe == "9") { System.Environment.Exit(0); } else { Console.WriteLine("Fehler in der Eingabe..."); } Console.ReadLine(); } }