public InterpretDTO getInterpretByName(string name) { List <InterpretDTO> interprets = new List <InterpretDTO>(); MySqlConnection mysqlcon = DatabaseConnection.getInstance().getConnection(); MySqlCommand command = mysqlcon.CreateCommand(); command.CommandText = "SELECT * FROM tbl_Interpret WHERE name = '" + name + "';"; mysqlcon.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { InterpretDTO i = new InterpretDTO(reader["name"].ToString(), reader["foundationYear"].ToString(), reader["land"].ToString()); interprets.Add(i); } mysqlcon.Close(); if (interprets.Count == 0) { return(null); } else { return(interprets[0]); } }
private void button1_Click(object sender, EventArgs e) { FunctionController fc = new FunctionController(); InterpretDTO iDTO = new InterpretDTO(edDetailEditingInterpretName.Text, edDetailEditingInterpretFoundationYear.Text, edDetailEditingInterpretLand.Text); fc.updateInterpret(iDTO); }
public void Init() { _interpret1Id = 1; _interpret1 = new InterpretDTO { Name = "No name", Language = Language.Slovak, ID = _interpret1Id }; _event1Id = 1; _event1 = new EventDTO { Name = "Deň matiek v Púchove", Place = "Púchov Kultúrny dom", Time = new DateTime(2017, 5, 14), InterpretId = _interpret1Id, ID = _event1Id }; _event2Id = 2; _event2 = new EventDTO { Name = "Vianočné trhy 2016", Place = "Terchová Amfiteáter", Time = new DateTime(2016, 12, 25), InterpretId = _interpret1Id, ID = _event2Id }; _interpretService.CreateInterpret(_interpret1); _eventService.CreateEvent(_event1, _interpret1Id); _eventService.CreateEvent(_event2, _interpret1Id); }
public void CreateAlbumTest() { Assert.AreEqual(2, _albumService.ListAlbums(null).Count()); var interpret3 = new InterpretDTO { ID = 3, Name = "Kabat", Language = Language.Czech, IsPublic = false }; _interpretService.CreateInterpret(interpret3); var album3 = new AlbumDTO { ID = 3, InterpretId = _interpret1Id, Name = "Dole v dole", Year = 2003 }; _albumService.CreateAlbum(album3, interpret3.ID); Assert.AreEqual(3, _albumService.ListAlbums(null).Count()); }
public void create() { InterpretDTO iDTO = new InterpretDTO(name, foundationYear, land); InterpretDAO iDAO = new InterpretDAO(); iDAO.insertInterpret(iDTO); }
private void alsFavoritMarkierenToolStripMenuItem_Click(object sender, EventArgs e) { FunctionController fc = new FunctionController(); string selectedInterpret = treeMain.SelectedNode.Name; InterpretDTO iDTO = fc.getInterpretByName(selectedInterpret); favInterprets.Add(iDTO); updateFavs(); }
public void MakeInterpretPublic(InterpretDTO interpretDto) { using (var uow = UnitOfWorkProvider.Create()) { var interpret = _interpretRepository.GetById(interpretDto.ID); Mapper.Map(interpretDto, interpret); _interpretRepository.Update(interpret); uow.Commit(); } }
public void insertInterpret(InterpretDTO obj) { MySqlConnection mysqlcon = DatabaseConnection.getInstance().getConnection(); MySqlCommand command = mysqlcon.CreateCommand(); command.CommandText = "INSERT INTO tbl_interpret(name, foundationyear, land) VALUES ('" + obj.getName() + "', '" + obj.getFoundationYear() + "', '" + obj.getLand() + "');"; mysqlcon.Open(); command.ExecuteNonQuery(); mysqlcon.Close(); }
public int CreateInterpret(InterpretDTO interpretDto) { Interpret interpret; using (var uow = UnitOfWorkProvider.Create()) { interpret = Mapper.Map <Interpret>(interpretDto); _interpretRepository.Insert(interpret); uow.Commit(); } return(interpret.ID); }
public void updateInterpret(InterpretDTO obj, int id) { MySqlConnection mysqlcon = DatabaseConnection.getInstance().getConnection(); MySqlCommand command = mysqlcon.CreateCommand(); command.CommandText = "UPDATE tbl_interpret SET name = @colName, foundationyear = @colFoundationyear, land = @colLand WHERE id_interpret = " + id + ";"; command.Parameters.AddWithValue("colName", obj.getName()); command.Parameters.AddWithValue("colFoundationyear", obj.getFoundationYear()); command.Parameters.AddWithValue("colLand", obj.getLand()); mysqlcon.Open(); command.ExecuteNonQuery(); mysqlcon.Close(); }
private void treeMain_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { FunctionController fc = new FunctionController(); string typeOfNode = getTypeOfNode(e.Node); setDetailEditingPanelsInvisible(); if (typeOfNode == "interpret") { String interpretName = e.Node.Text; InterpretDTO iDTO = fc.getInterpretByName(interpretName); löschenToolStripMenuItem.Enabled = true; alsFavoritMarkierenToolStripMenuItem.Enabled = true; pnDetailEditingInterpret.Visible = true; edDetailEditingInterpretName.Text = iDTO.getName(); edDetailEditingInterpretFoundationYear.Text = iDTO.getFoundationYear(); edDetailEditingInterpretLand.Text = iDTO.getLand(); edDetailEditingInterpretNoOfAlbums.Text = fc.getAlbumsByInterpret(iDTO.getName()).Count.ToString(); } else if (typeOfNode == "album") { String albumName = e.Node.Text; AlbumDTO aDTO = fc.getAlbumByName(albumName); List <SongDTO> songs = new List <SongDTO>(); listSongs.Items.Clear(); pnDetailEditingAlbum.Visible = true; edDetailEditingAlbumName.Text = aDTO.getName(); edDetailEditingAlbumInterpret.Text = fc.getInterpretNameById(aDTO.getInterpret()); edDetailEditingAlbumYear.Text = aDTO.getReleaseYear(); edDetailEditingAlbumGenre.Text = fc.getGenreById(aDTO.getGenre()); if (aDTO.getCoverpath() != null && aDTO.getCoverpath() != "") { pictureBox1.Image = Image.FromFile(aDTO.getCoverpath()); pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; } else { pictureBox1.Image = null; } songs = fc.getAllSongsByAlbum(albumName); foreach (SongDTO song in songs) { listSongs.Items.Add(song.getTrackNo() + " - " + song.getName() + " | " + song.getDuration()); } } }
public void Init() { _interpret1Id = 1; _interpret1 = new InterpretDTO { ID = _interpret1Id, Name = "System of a down", Language = Language.English, IsPublic = false }; _interpret2Id = 2; _interpret2 = new InterpretDTO { ID = _interpret2Id, Name = "Linkin Park", Language = Language.English, IsPublic = false }; _interpretService.CreateInterpret(_interpret1); _interpretService.CreateInterpret(_interpret2); _album1Id = 1; _album1 = new AlbumDTO { ID = _album1Id, InterpretId = _interpret1Id, Name = "Toxicity", Year = 2001 }; _album2Id = 2; _album2 = new AlbumDTO { ID = _album2Id, InterpretId = _interpret2Id, Name = "Meteora", Year = 2003 }; _albumService.CreateAlbum(_album1, _interpret1Id); _albumService.CreateAlbum(_album2, _interpret2Id); }
public List <InterpretDTO> getAllFromDb() { List <InterpretDTO> interprets = new List <InterpretDTO>(); MySqlConnection mysqlcon = DatabaseConnection.getInstance().getConnection(); MySqlCommand command = mysqlcon.CreateCommand(); command.CommandText = "SELECT * FROM tbl_Interpret ORDER BY name ASC;"; mysqlcon.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { InterpretDTO i = new InterpretDTO(reader["name"].ToString(), reader["foundationYear"].ToString(), reader["land"].ToString()); interprets.Add(i); } mysqlcon.Close(); return(interprets); }
public void CreateSongTest() { Assert.AreEqual(3, _songService.ListSongs(null).Count()); var interpret3 = new InterpretDTO { Name = "Coldplay", Language = Language.English, ID = 3, IsPublic = false }; _interpretService.CreateInterpret(interpret3); var album3 = new AlbumDTO { ID = 3, InterpretId = interpret3.ID, Name = "Ghost stories", Year = 2014 }; _albumService.CreateAlbum(album3, interpret3.ID); var song4 = new SongDTO { ID = 4, Name = "A sky full of stars", Added = new DateTime(2016, 11, 6), AlbumId = album3.ID, Genre = Genre.Pop, IsPublic = false }; _songService.CreateSong(song4, album3.ID); Assert.AreEqual(4, _songService.ListSongs(null).Count()); }
public void EditInterpret(InterpretDTO interpretDto, int[] albumIds, int[] eventIds) { using (var uow = UnitOfWorkProvider.Create()) { var interpret = _interpretRepository.GetById(interpretDto.ID); Mapper.Map(interpretDto, interpret); if (albumIds != null) { if (albumIds.Length != 0) { var albums = _albumRepository.GetByIds(albumIds); interpret.Albums.RemoveAll(album => !albums.Contains(album)); interpret.Albums.AddRange(albums.Where(album => !interpret.Albums.Contains(album))); } else { interpret.Albums.Clear(); } } if (eventIds != null) { if (eventIds.Length != 0) { var events = _eventRepository.GetByIds(eventIds); interpret.Events.RemoveAll(e => !events.Contains(e)); interpret.Events.AddRange(events.Where(e => !interpret.Events.Contains(e))); } else { interpret.Events.Clear(); } } _interpretRepository.Update(interpret); uow.Commit(); } }
public void Init() { var guid = _userAccountService.CreateAccount("Martin", "Password", "*****@*****.**"); _userService.CreateUser(guid.ID); _playlist1Id = 1; _playlist1 = new PlaylistDTO { Name = "Favorite songs", Created = new DateTime(2016, 10, 10), ID = _playlist1Id, UserId = 1 }; _playlist2Id = 2; _playlist2 = new PlaylistDTO { Name = "Best songs", Created = new DateTime(2016, 1, 1), ID = _playlist2Id, UserId = 1 }; _playlistService.CreatePlaylist(_playlist1, 1); _playlistService.CreatePlaylist(_playlist2, 1); _interpret1 = new InterpretDTO { Name = "System of a down", Language = Language.English, ID = 1 }; _interpret2 = new InterpretDTO { Name = "Linkin Park", Language = Language.English, ID = 2 }; _interpretService.CreateInterpret(_interpret1); _interpretService.CreateInterpret(_interpret2); _album1Id = 1; _album1 = new AlbumDTO { ID = _album1Id, InterpretId = 1, Name = "Toxicity", Year = 2001 }; _album2Id = 2; _album2 = new AlbumDTO { ID = _album2Id, InterpretId = 2, Name = "Meteora", Year = 2003 }; _albumService.CreateAlbum(_album1, _interpret1.ID); _albumService.CreateAlbum(_album2, _interpret2.ID); _song1Id = 1; _song1 = new SongDTO { ID = _song1Id, Name = "Prison Song", Added = new DateTime(2016, 11, 6), AlbumId = _album1Id, Genre = Genre.Rock }; _song2Id = 2; _song2 = new SongDTO { ID = _song2Id, Name = "Deer Dance", Added = new DateTime(2016, 11, 6), AlbumId = _album1Id, Genre = Genre.Rock }; _song3Id = 3; _song3 = new SongDTO { ID = _song3Id, Name = "Numb", Added = new DateTime(2016, 11, 6), AlbumId = _album2Id, Genre = Genre.Rock }; _songService.CreateSong(_song1, _album1Id); _songService.CreateSong(_song2, _album1Id); _songService.CreateSong(_song3, _album2Id); _songlist1Id = 1; _songList1 = new SongListDTO { ID = _songlist1Id, PlaylistId = _playlist1Id, SongId = _song1Id }; _songlist2Id = 2; _songList2 = new SongListDTO { ID = _songlist2Id, PlaylistId = _playlist1Id, SongId = _song2Id }; _songlist3Id = 3; _songList3 = new SongListDTO { ID = _songlist3Id, PlaylistId = _playlist2Id, SongId = _song3Id }; _songlistService.CreateSonglist(_songList1, _song1Id, _playlist1Id); _songlistService.CreateSonglist(_songList2, _song1Id, _playlist1Id); _songlistService.CreateSonglist(_songList3, _song1Id, _playlist2Id); }
public void Init() { _interpret1 = new InterpretDTO { Name = "System of a down", Language = Language.English, ID = 1, IsPublic = false }; _interpret2 = new InterpretDTO { Name = "Linkin Park", Language = Language.English, ID = 2, IsPublic = false }; _interpretService.CreateInterpret(_interpret1); _interpretService.CreateInterpret(_interpret2); _album1Id = 1; _album1 = new AlbumDTO { ID = _album1Id, InterpretId = 1, Name = "Toxicity", Year = 2001 }; _album2Id = 2; _album2 = new AlbumDTO { ID = _album2Id, InterpretId = 2, Name = "Meteora", Year = 2003 }; _albumService.CreateAlbum(_album1, _interpret1.ID); _albumService.CreateAlbum(_album2, _interpret2.ID); _song1Id = 1; _song1 = new SongDTO { ID = _song1Id, Name = "Prison Song", Added = new DateTime(2016, 11, 6), AlbumId = _album1Id, Genre = Genre.Rock, IsPublic = false }; _song2Id = 2; _song2 = new SongDTO { ID = _song2Id, Name = "Deer Dance", Added = new DateTime(2016, 11, 6), AlbumId = _album1Id, Genre = Genre.Rock, IsPublic = false }; _song3Id = 3; _song3 = new SongDTO { ID = _song3Id, Name = "Numb", Added = new DateTime(2016, 11, 6), AlbumId = _album2Id, Genre = Genre.Rock, IsPublic = false }; _songService.CreateSong(_song1, _album1Id); _songService.CreateSong(_song2, _album1Id); _songService.CreateSong(_song3, _album2Id); }
public void Init() { _interpret1Id = 1; _interpret1 = new InterpretDTO { Name = "System of a down", Language = Language.English, ID = _interpret1Id }; _interpret2Id = 2; _interpret2 = new InterpretDTO { Name = "Linkin Park", Language = Language.English, ID = _interpret2Id }; _interpretService.CreateInterpret(_interpret1); _interpretService.CreateInterpret(_interpret2); _album1Id = 1; _album1 = new AlbumDTO { ID = _album1Id, InterpretId = _interpret1Id, Name = "Toxicity", Year = 2003 }; _album2Id = 2; _album2 = new AlbumDTO { ID = _album2Id, InterpretId = _interpret2Id, Name = "Meteora", Year = 2008 }; _albumService.CreateAlbum(_album1, _interpret1Id); _albumService.CreateAlbum(_album2, _interpret2Id); _albumReview1Id = 1; _albumReview1 = new AlbumReviewDTO { ID = _albumReview1Id, AlbumId = _album1.ID, Note = "Perfect album", Rating = 9 }; _albumReview2Id = 2; _albumReview2 = new AlbumReviewDTO { AlbumId = _album2.ID, Note = "Not bad", Rating = 8, ID = _albumReview2Id }; _albumReviewService.CreateAlbumReview(_albumReview1, _album1Id); _albumReviewService.CreateAlbumReview(_albumReview2, _album2Id); }
public void Init() { _interpret1Id = 1; _interpret1 = new InterpretDTO { Name = "System of a down", Language = Language.English, ID = _interpret1Id }; _interpret2Id = 2; _interpret2 = new InterpretDTO { Name = "Linkin Park", Language = Language.English, ID = _interpret2Id }; _interpretService.CreateInterpret(_interpret1); _interpretService.CreateInterpret(_interpret2); _album1Id = 1; _album1 = new AlbumDTO { ID = _album1Id, InterpretId = 1, Name = "Toxicity", Year = 2001 }; _album2Id = 2; _album2 = new AlbumDTO { ID = _album2Id, InterpretId = 2, Name = "Meteora", Year = 2003 }; _albumService.CreateAlbum(_album1, _interpret1.ID); _albumService.CreateAlbum(_album2, _interpret2.ID); _song1Id = 1; _song1 = new SongDTO { ID = _song1Id, Name = "Prison Song", Added = new DateTime(2016, 11, 6), AlbumId = _album1Id, Genre = Genre.Rock }; _song2Id = 2; _song2 = new SongDTO { ID = _song2Id, Name = "Deer Dance", Added = new DateTime(2016, 11, 6), AlbumId = _album1Id, Genre = Genre.Rock }; _song3Id = 3; _song3 = new SongDTO { ID = _song3Id, Name = "Numb", Added = new DateTime(2016, 11, 6), AlbumId = _album2Id, Genre = Genre.Rock }; _songService.CreateSong(_song1, _album1Id); _songService.CreateSong(_song2, _album1Id); _songService.CreateSong(_song3, _album2Id); _songReview1Id = 1; _songReview1 = new SongReviewDTO { ID = _songReview1Id, SongId = _song1.ID, Note = "Perfect album", Rating = 9 }; _songReview2Id = 2; _songReview2 = new SongReviewDTO { SongId = _song2.ID, Note = "Not bad", Rating = 8, ID = _songReview2Id }; _songReviewService.CreateSongReview(_songReview1, _song1Id); _songReviewService.CreateSongReview(_songReview2, _song2Id); }
public void updateInterpret(InterpretDTO obj) { InterpretDAO iDAO = new InterpretDAO(); iDAO.updateInterpret(obj, iDAO.getIdFromDb(obj.getName())); }
public void EditInterpret(InterpretDTO interpretDto, int[] albumIds, int[] eventIds) { _interpretService.EditInterpret(interpretDto, albumIds, eventIds); }
public int CreateInterpret(InterpretDTO interpretDto) { return(_interpretService.CreateInterpret(interpretDto)); }
public void Init() { _interpret1Id = 1; _interpret1 = new InterpretDTO { Name = "System of a down", Language = Language.English, ID = _interpret1Id, IsPublic = false }; _interpret2Id = 2; _interpret2 = new InterpretDTO { Name = "Linkin Park", Language = Language.English, ID = _interpret2Id, IsPublic = false }; _interpret3Id = 3; _interpret3 = new InterpretDTO { Name = "No name", Language = Language.Slovak, ID = _interpret3Id, IsPublic = false }; _album1Id = 4; _album1 = new AlbumDTO { Name = "Toxicity", Year = 2001, InterpretId = _interpret1Id, ID = _album1Id }; _album2Id = 5; _album2 = new AlbumDTO { Name = "Meteora", Year = 2003, InterpretId = _interpret2Id, ID = _album2Id }; _album3Id = 6; _album3 = new AlbumDTO { Name = "V rovnováhe", Year = 2008, InterpretId = _interpret3Id, ID = _album3Id }; _album4Id = 7; _album4 = new AlbumDTO { Name = "Čím to je?!", Year = 2005, InterpretId = _interpret3Id, ID = _album4Id }; _event1Id = 8; _event1 = new EventDTO { Name = "Deň matiek v Púchove", Place = "Púchov Kultúrny dom", Time = new DateTime(2017, 5, 14), InterpretId = _interpret3Id, ID = _event1Id }; _event2Id = 9; _event2 = new EventDTO { Name = "Vianočné trhy 2016", Place = "Terchová Amfiteáter", Time = new DateTime(2016, 12, 25), InterpretId = _interpret3Id, ID = _event2Id }; _interpretService.CreateInterpret(_interpret1); _interpretService.CreateInterpret(_interpret2); _interpretService.CreateInterpret(_interpret3); _albumService.CreateAlbum(_album1, _interpret1Id); _albumService.CreateAlbum(_album2, _interpret2Id); _albumService.CreateAlbum(_album3, _interpret3Id); _albumService.CreateAlbum(_album4, _interpret3Id); _eventService.CreateEvent(_event1, _interpret3Id); _eventService.CreateEvent(_event2, _interpret3Id); }