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);
}
