コード例 #1
0
ファイル: SignUpExecuter.cs プロジェクト: yarden95c/DBProject
        public List <int> AddArtistsToUser(User user, List <string> artistsNames)
        {
            List <MySqlCommand> commands  = new List <MySqlCommand>();
            List <Artist>       artists   = new List <Artist>();
            List <int>          artistsId = new List <int>();

            foreach (string artistName in artistsNames)
            {
                Artist artist = EntitiesFactory.GetArtistFromArtistName(artistName, conn);
                if (artist != null)
                {
                    artists.Add(artist);
                }
            }

            foreach (Artist artist in artists)
            {
                commands.Add(GetAddArtistCommand(user.Id, artist.Id));
                artistsId.Add(int.Parse(artist.Id));
            }

            conn.ExecuteUpdateCommands(commands);
            return(artistsId);
        }