コード例 #1
0
ファイル: SongHandler.cs プロジェクト: andrade-lucas/FreeTone
        public ICommandResult Handle(UpdateSongCommand command)
        {
            var  singerQuery = _singerRepository.GetById(command.SingerId);
            var  albumQuery  = _albumRepository.GetById(command.AlbumId);
            Name singerName  = new Name(singerQuery.FirstName, singerQuery.LastName);

            Singer singer = new Singer(singerQuery.Id, singerName, singerQuery.Nationality, singerQuery.About, singerQuery.Image);
            Album  album  = new Album(albumQuery.Id, albumQuery.Title, null, null, albumQuery.Image);
            Song   song   = new Song(command.Id, command.Title, singer, album, command.Url, command.PublishedDate);

            AddNotifications(song.Notifications);

            if (Invalid)
            {
                return(new CommandResult(false, MessagesUtil.FormFail, Notifications));
            }

            bool result = _repository.Update(song);

            if (!result)
            {
                return(new CommandResult(false, MessagesUtil.UpdateError, Notifications));
            }

            return(new CommandResult(true, MessagesUtil.UpdatedSuccess));
        }
コード例 #2
0
ファイル: SampleData.cs プロジェクト: knegna/WEBN3
        public static void Initialize(AlbumContext context)
        {
            Singer EdSheeran = new Singer {
                Name = "EdSheeran", Birthdate = "10.10.2000"
            };
            Singer Adelle = new Singer {
                Name = "Adelle", Birthdate = "15.01.1999"
            };
            Singer MJaskon = new Singer {
                Name = "MichaleJackson", Birthdate = "07.02.1989"
            };
            Singer NBHD = new Singer {
                Name = "The Neighbourhood", Birthdate = "09.10.1985"
            };

            if (!context.Singers.Any())
            {
                context.Singers.AddRange(EdSheeran, Adelle, MJaskon, NBHD);
                context.SaveChanges();
            }

            if (!context.Albums.Any())
            {
                context.Albums.AddRange(
                    new Album {
                    Pevets = EdSheeran,
                    Date   = "14.02.15",
                    Name   = "Love"
                },
                    new Album {
                    Pevets = Adelle,
                    Name   = "heart",
                    Date   = "18.09.19"
                },
                    new Album {
                    Pevets = MJaskon,
                    Name   = "Sing",
                    Date   = "09.08.17"
                },
                    new Album {
                    Pevets = EdSheeran,
                    Name   = "Dance",
                    Date   = "2.12.18"
                },
                    new Album
                {
                    Pevets = NBHD,
                    Name   = "Grey",
                    Date   = "03.02.2018"
                },
                    new Album
                {
                    Pevets = NBHD,
                    Name   = "Black",
                    Date   = "18.08.2015"
                }
                    );
                context.SaveChanges();
            }
        }
    public static async Task Run(string connectionString)
    {
        using var context = new SpannerSampleDbContext(connectionString);
        var singer = new Singer
        {
            SingerId  = Guid.NewGuid(),
            FirstName = "Yvette",
            LastName  = "Wendelson",
            // SpannerDate is specifically designed to map a DATE column in a Cloud Spanner
            // database to a property of an entity. DateTime properties will by default be
            // mapped to TIMESTAMP columns.
            BirthDate = new SpannerDate(1980, 10, 17),
        };
        await context.Singers.AddAsync(singer);

        await context.SaveChangesAsync();

        // Commonly used properties and methods of SpannerDate are mapped to the equivalent Cloud Spanner functions.
        var singersBornIn1980 = await context.Singers
                                .Where(s => s.BirthDate.GetValueOrDefault().Year == 1980)
                                .OrderBy(s => singer.LastName)
                                .ToListAsync();

        foreach (var s in singersBornIn1980)
        {
            Console.WriteLine($"Born in 1980: {s.FullName} ({s.BirthDate})");
        }
    }
コード例 #4
0
    //歌曲下载地址 : http://music.163.com/song/media/outer/url?id=ID数字.mp3
    protected override async Task ParseInfo(string id)
    {
        var detailResult = await HttpUtil.Get($"https://api.imjad.cn/cloudmusic/?type=detail&id={id}");

        var detailData = JObject.Parse(detailResult);
        var songResult = await HttpUtil.Get($"https://api.imjad.cn/cloudmusic/?type=song&id={id}");

        var songData   = JObject.Parse(songResult);
        var songRoot   = songData["data"][0];
        var detailRoot = detailData["songs"][0];

        Name     = detailRoot.Value <string>("name");
        Album    = detailRoot["al"].Value <string>("name");
        CoverUrl = detailRoot["al"].Value <string>("picUrl");
        foreach (var token in detailRoot["ar"])
        {
            Singer.Add(token.Value <string>("name"));
        }
        Mp3Urls.Add(songRoot.Value <string>("url"));
        Mp3Urls.RemoveAll((_) => string.IsNullOrEmpty(_));
        if (Mp3Urls.Count == 0)
        {
            throw new Exception($"歌曲 {Name} 暂时不支持下载,也不支持试听");
        }
    }
コード例 #5
0
    public static async Task Run(string connectionString)
    {
        using var context = new SpannerSampleDbContext(connectionString);

        // Singer has a generated column FullName that is the combination of the
        // FirstName and LastName. The value is automatically computed by Cloud Spanner.
        // Setting it manually client side has no effect.
        var singer = new Singer
        {
            SingerId  = Guid.NewGuid(),
            FirstName = "Alice",
            LastName  = "Jameson"
        };
        await context.Singers.AddAsync(singer);

        await context.SaveChangesAsync();

        // Entity Framework will automatically fetch the computed value for FullName
        // from Cloud Spanner after it has been written.
        Console.WriteLine($"Added singer with full name {singer.FullName}");

        // Updating the last name of the singer will also update the full name.
        singer.LastName = "Jameson - Cooper";
        await context.SaveChangesAsync();

        Console.WriteLine($"Updated singer's full name to {singer.FullName}");
    }
コード例 #6
0
        /// <summary>
        /// 获取所有歌手信息
        /// </summary>
        /// <returns></returns>
        public List <Singer> GetAllSingers()
        {
            List <Singer> singers = new List <Singer>();

            try
            {
                sql = "select s.id 编号,s.name 歌手,s.gender 性别,t.singerType 类型,s.photoURL 图片,s.remark 简介,s.addTime 添加时间 from tb_sings s left join tb_singerTypes t on s.singTypeId=t.Id order by addTime desc";
                DataTable dt = DatabaseHelper.GetDataSet(sql).Tables[0];

                foreach (DataRow r in dt.Rows)
                {
                    Singer s = new Singer();
                    s.SingId   = Convert.ToInt32(r["编号"]);
                    s.Name     = r["歌手"].ToString();
                    s.Gender   = r["性别"].ToString();
                    s.Type     = r["类型"].ToString();
                    s.Remake   = r["简介"].ToString();
                    s.PhotoURL = r["图片"].ToString();
                    s.AddTime  = Convert.ToDateTime(r["添加时间"].ToString());
                    singers.Add(s);
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(singers);
        }
コード例 #7
0
        public void OnGet()
        {
            MySqlIntegration sqlInteg = new MySqlIntegration(Configuration.GetConnectionString("sql"));

            try
            {
                sqlInteg.MySqlSelect("singers", new[] { "*" }, "1=1 ORDER BY sequence");
            }
            catch (MySqlException ex)
            {
                ViewData["error"] = JsonConvert.SerializeObject(ex.Message);
            }
            if (sqlInteg.IntegratedResult != null && sqlInteg.IntegratedResult.Count > 0)
            {
                sqlInteg.IntegratedResult.ForEach(element => {
                    Singer singer = null;
                    try
                    {
                        singer = new Singer(element);
                    }
                    catch (NullReferenceException ex)
                    {
                        throw (ex);
                    }
                    if (singer != null)
                    {
                        Singers.Add(singer);
                    }
                });
            }
        }
コード例 #8
0
        public ActionResult OnGetSingers()
        {
            MySqlIntegration sqlInteg = new MySqlIntegration(Configuration.GetConnectionString("sql"));

            try
            {
                sqlInteg.MySqlSelect("singers", new[] { "*" }, "1=1 ORDER BY sequence");
                if (sqlInteg.IntegratedResult.Count > 0)
                {
                    Singers = new List <Singer>();
                    sqlInteg.IntegratedResult.ForEach(element => {
                        Singer singer = null;
                        try
                        {
                            singer = new Singer(element);
                        }
                        catch (NullReferenceException ex)
                        {
                            throw (ex);
                        }
                        if (singer != null)
                        {
                            Singers.Add(singer);
                        }
                    });
                    return(new JsonResult(JsonConvert.SerializeObject(Singers)));
                }
            }
            catch (MySqlException ex)
            {
                JsonThrow(ex);
            }
            return(new JsonResult("[]"));
        }
コード例 #9
0
        /// <summary>
        /// Finds the one singer by identifier.
        /// </summary>
        /// <returns>The one singer by identifier (Singer.Id).</returns>
        /// <param name="id">the id of the singer.</param>
        public async Task <Singer> FindOneSingerById(int id)
        {
            Singer singer = await _context.Singer.Include(x => x.Singarea)
                            .Where(x => x.Id == id).SingleOrDefaultAsync();

            return(singer);
        }
コード例 #10
0
    private static async Task Setup(SpannerSampleDbContext context)
    {
        var singer = new Singer
        {
            SingerId  = Guid.NewGuid(),
            FirstName = "Alice",
            LastName  = "Henderson",
            BirthDate = new SpannerDate(1983, 10, 19),
        };
        await context.Singers.AddAsync(singer);

        await context.Albums.AddRangeAsync(new Album
        {
            AlbumId  = Guid.NewGuid(),
            SingerId = singer.SingerId,
            Title    = "Henderson's first",
        },
                                           new Album
        {
            AlbumId  = Guid.NewGuid(),
            SingerId = singer.SingerId,
            Title    = "Henderson's second",
        },
                                           new Album
        {
            AlbumId  = Guid.NewGuid(),
            SingerId = singer.SingerId,
            Title    = "Henderson's third",
        });

        await context.SaveChangesAsync();
    }
コード例 #11
0
        /// <summary>
        /// Finds the one singer by singer no.
        /// </summary>
        /// <returns>The one singer by singer no.</returns>
        /// <param name="sing_no">Singer no.</param>
        public async Task <Singer> FindOneSingerBySingNo(string sing_no)
        {
            Singer singer = await _context.Singer.Include(x => x.Singarea)
                            .Where(x => x.SingNo == sing_no).SingleOrDefaultAsync();

            return(singer);
        }
コード例 #12
0
        private RenderNote[] BuildRenderNotes(Ust ust, Singer singer)
        {
            var renderNotes = new List <RenderNote>();

            for (int i = 0; i < ust.Notes.Length; i++)
            {
                var renderNote = RenderNote.CreateFromNote(ust.Notes[i]);
                renderNote.Oto = singer.FindOto(renderNote) ?? Oto.CreateDefault();
                renderNotes.Add(renderNote);
            }

            for (int i = 0; i < renderNotes.Count; i++)
            {
                var note = renderNotes[i];
                var next = renderNotes.ElementAtOrDefault(i + 1);
                note.Envelope = new Envelope(note, next);
            }

            var pitchController = new PitchController(ust.Tempo);

            for (int i = 0; i < renderNotes.Count; i++)
            {
                var prev = renderNotes.ElementAtOrDefault(i - 1);
                var curr = renderNotes.ElementAtOrDefault(i);
                var next = renderNotes.ElementAtOrDefault(i + 1);

                pitchController.BuildPitchData(curr, prev, next);
            }

            return(renderNotes.ToArray());
        }
コード例 #13
0
        private string BuildRequest(Ust ust, Singer singer, string output, string resampler, string appendtool, string tempFolder)
        {
            stringBuilder = new StringBuilder();

            var notes = BuildRenderNotes(ust, singer);

            for (int i = 0; i < notes.Length; i++)
            {
                RenderNote note     = notes[i];
                RenderNote next     = notes.ElementAtOrDefault(i + 1);
                var        tempFile = Path.Combine(tempFolder, $"_{i.ToString().PadLeft(3, '0')}_[{note.ParsedLyric}]_[{note.NoteNum}]_[{note.FinalLength}].wav");
                if (note.IsRest)
                {
                    SendRestToAppendTool(note.FinalLength, output, tempFile, ust.Tempo, appendtool);
                }
                else
                {
                    SendToResampler(note, next, tempFile, ust.VoiceDir, ust.Flags, resampler);
                    SendToAppendTool(note, next, tempFile, appendtool, ust.Tempo, output);
                }
            }

            var result = stringBuilder.ToString();

            stringBuilder.Clear();
            stringBuilder = null;
            return(result);
        }
コード例 #14
0
ファイル: SingerService.cs プロジェクト: wajukin/KTV
        /// <summary>
        /// 查询歌手信息
        /// </summary>
        /// <param name="SingerName"></param>
        /// <param name="SingerType"></param>
        /// <returns></returns>
        public List <Singer> GetSingerList(string SingerName, string SingerType)
        {
            try
            {
                StringBuilder sb = new StringBuilder();
                sb.AppendFormat(@"select si.SRI_SingeId,si.SRI_SingePhotoURL,si.SRI_SingerName,
                            st.SRT_SingerTypeName from SingerInfo as si,SingerType as st where 
                            si.SRI_SingeTypeId = st.SRT_SingerTypeId and si.SRI_SingerName like 
                            '%{0}%'", SingerName);
                if (SingerType != "")
                {
                    sb.AppendFormat(" and st.SRT_SingerTypeName = '{0}'", SingerType);
                }
                SqlDataReader reader     = db.GetManyResult(sb.ToString());
                List <Singer> singerList = new List <Singer>();
                while (reader.Read())
                {
                    Singer singer = new Singer();
                    singer.SRI_SingeId1        = Convert.ToInt32(reader["SRI_SingeId"]);
                    singer.SRI_SingePhotoURL1  = reader["SRI_SingePhotoURL"].ToString();
                    singer.SRI_SingerName1     = reader["SRI_SingerName"].ToString();
                    singer.SRT_SingerTypeName1 = reader["SRT_SingerTypeName"].ToString();
                    singerList.Add(singer);
                }

                db.Reader.Close();
                return(singerList);
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #15
0
        public async Task LoadSinger()
        {
            singerdata = await GetSingerResult(keyword);

            if (singerdata != null && singerdata.pics != null)
            {
                SingerName_Text.Text = singerdata.singername;
                Singer_Image.Source  = new Windows.UI.Xaml.Media.Imaging.BitmapImage()
                {
                    UriSource = new Uri(singerdata.imgurl)
                };
                SingerInfo_Text.Text    = String.Format("歌曲 {0}/ 专辑 {1}/MV {2}", singerdata.songcount, singerdata.albumcount, singerdata.mvcount);
                SingerGrid.Visibility   = Visibility.Visible;
                SongScrollViewer.Margin = new Thickness()
                {
                    Top = 100
                };
                MoreSongsContorl.Margin = new Thickness()
                {
                    Top = 70
                };
            }
            else
            {
                SingerGrid.Visibility   = Visibility.Collapsed;
                SongScrollViewer.Margin = new Thickness()
                {
                    Top = 30
                };
                MoreSongsContorl.Margin = new Thickness();
            }
        }
コード例 #16
0
        public async Task <IActionResult> Edit(int id, [Bind("Id,Name")] Singer singer)
        {
            if (id != singer.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(singer);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!SingerExists(singer.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(singer));
        }
コード例 #17
0
        public static Singer CreateSinger(int ID)
        {
            Singer singer = new Singer();

            singer.ID = ID;
            return(singer);
        }
コード例 #18
0
 protected override Drawable CreateSingerInfo(Singer singer)
 {
     return(new DrawableSingerInfo(singer)
     {
         RelativeSizeAxes = Axes.Both,
     });
 }
コード例 #19
0
        public async Task <IActionResult> Edit(Singer singer)
        {
            if (!ModelState.IsValid)
            {
                return(View());
            }

            _context.Attach(singer).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!MovieExists(singer.Id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(RedirectToAction("Index", "Singers"));
        }
    private static async Task <(Singer, Venue)> GetSingerAndVenueAsync(string connectionString)
    {
        using var context     = new SpannerSampleDbContext(connectionString);
        using var transaction = await context.Database.BeginTransactionAsync();

        var venue = await context.Venues.FindAsync("CON");

        if (venue == null)
        {
            venue = new Venue
            {
                Code   = "CON",
                Name   = "Concert Hall",
                Active = true,
            };
            await context.Venues.AddAsync(venue);
        }
        var singer = new Singer
        {
            SingerId  = Guid.NewGuid(),
            FirstName = "Theodore",
            LastName  = "Walterson",
        };
        await context.Singers.AddAsync(singer);

        await context.SaveChangesAsync();

        await transaction.CommitAsync();

        return(singer, venue);
    }
コード例 #21
0
ファイル: DMusic.cs プロジェクト: heroicNeZha/MusicWeb
        public static Music getSongByID(int mid)
        {
            string sql = "SELECT * FROM music LEFT JOIN singer ON MUSIC.Msinger=SINGER.SID Where music.MID = @mid";

            SqlParameter[] parm = new SqlParameter[]
            {
                new SqlParameter("@mid", mid)
            };
            DataTable dt = DBHelper.GetDataTable(sql, parm);

            DBHelper.SqlClose();
            foreach (DataRow row in dt.Rows)
            {
                Music song = new Music();
                song.Mid   = (int)row.ItemArray[0];
                song.Mname = row.ItemArray[1].ToString();
                Singer singer = new Singer();
                singer.Sid        = (int)row.ItemArray[8];
                singer.Sname      = row.ItemArray[9].ToString();
                singer.Sintroduce = row.ItemArray[10].ToString();
                singer.Spic       = row.ItemArray[11].ToString();
                song.Msinger      = singer;
                song.Malbum       = row.ItemArray[3].ToString();
                song.Mresource    = row.ItemArray[4].ToString();
                song.Mlength      = row.ItemArray[5].ToString();
                song.Mclick       = (int)row.ItemArray[6];
                song.Mpic         = row.ItemArray[7].ToString();
                return(song);
            }
            return(null);
        }
コード例 #22
0
        static void Main(string[] args)
        {
            AlbumMusic a = new AlbumMusic()
            {
                NameAlmum = "ss"
            };



            Music m = new Music()
            {
                MusicAddress = "dd",
                MusicName    = "aa",
            };

            Singer s = new Singer()
            {
                SignerName = "bb"
            };

            uowPleerMusic pm = new uowPleerMusic();

            pm.pMusic.Insert(m);
            pm.pAlbumMusic.Insert(a);
            pm.pSinger.Insert(s);

            pm.Save();
        }
コード例 #23
0
 public Band()
 {
     this.drummer    = new Drummer();
     this.bassPlayer = new BassPlayer();
     this.singer     = new Singer();
     this.trianglist = new Trianglist();
 }
コード例 #24
0
        static void Main()
        {
            var particiantsList = Console.ReadLine().Split(", ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList();

            var songsList = Console.ReadLine().Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(x => x.Trim()).ToList();

            var command = Console.ReadLine().Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(x => x.Trim()).ToList();

            var contestResults = new Dictionary <string, Singer>();

            while (command[0] != "dawn")
            {
                var singerName   = command[0];
                var currentSong  = command[1];
                var currentAward = command[2];

                var currentAwardList = new List <string>();
                currentAwardList.Add(currentAward);

                Singer singer = new Singer();

                singer.Awards = currentAwardList;

                bool isInBothLists = particiantsList.Contains(singerName) && songsList.Contains(currentSong);

                if (isInBothLists)
                {
                    if (!contestResults.ContainsKey(singerName))
                    {
                        contestResults.Add(singerName, singer);
                    }


                    if (!contestResults[singerName].Awards.Contains(currentAward))
                    {
                        contestResults[singerName].Awards.Add(currentAward);
                    }
                }

                command = Console.ReadLine().Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(x => x.Trim()).ToList();
            }

            if (contestResults.Count != 0)
            {
                foreach (var singer in contestResults.OrderByDescending(x => x.Value.Awards.Count).ThenBy(x => x.Key))
                {
                    Console.WriteLine($"{singer.Key}: {singer.Value.Awards.Count} awards");

                    foreach (var award in singer.Value.Awards.OrderBy(x => x))
                    {
                        Console.WriteLine($"--{award}");
                    }
                }
            }

            else
            {
                Console.WriteLine("No awards");
            }
        }
コード例 #25
0
        //public delegate void RenderHandler(string output);
        //public event RenderHandler OnRendered = (output) => { };

        public bool Render(Ust ust, Singer singer, string tempFolder, string output, string resampler = "resampler.exe", string appendtool = "wavtool.exe")
        {
            var rendered = false;

            Program.Try(() =>
            {
                var bat     = Path.Combine(tempFolder, @"render.bat");
                var request = BuildRequest(ust, singer, output, resampler, appendtool, tempFolder);

                var deleteCommand = $"del \"{tempFolder}\\*.wav\"\r\n";
                if (!File.Exists(bat))
                {
                    File.Create(bat).Close();
                }
                File.WriteAllText(bat, deleteCommand);
                File.AppendAllText(bat, request);

                File.AppendAllText(bat,
                                   $"@if not exist \"{output}.whd\" goto E \r\n" +
                                   $"@if not exist \"{output}.dat\" goto E \r\n" +
                                   $"copy /Y \"{output}.whd\" /B + \"{output}.dat\" /B \"{output}\" \r\n" +
                                   $"del \"{output}.whd\" \r\n" + $"del \"{output}.dat\" \r\n" + ":E");
                Execute(bat, tempFolder, output);
                rendered = true;
            });

            return(rendered);
        }
コード例 #26
0
 public M(string n, string ad, string d, Singer am)
 {
     this.name        = n;
     this.category    = ad;
     this.director    = d;
     this.SingerMusic = am;
 }
コード例 #27
0
ファイル: DMusic.cs プロジェクト: heroicNeZha/MusicWeb
        public static List <Music> getSongsByRank()
        {
            string sql = "SELECT * FROM music LEFT JOIN singer ON (MUSIC.Msinger=SINGER.SID) ORDER BY Mclick DESC";

            SqlParameter[] parm = new SqlParameter[]
            {
            };
            DataTable dt = DBHelper.GetDataTable(sql, parm);

            DBHelper.SqlClose();
            List <Music> songs = new List <Music>();

            foreach (DataRow row in dt.Rows)
            {
                Music song = new Music();
                song.Mid   = (int)row.ItemArray[0];
                song.Mname = row.ItemArray[1].ToString();
                Singer singer = new Singer();
                singer.Sid        = (int)row.ItemArray[8];
                singer.Sname      = row.ItemArray[9].ToString();
                singer.Sintroduce = row.ItemArray[10].ToString();
                singer.Spic       = row.ItemArray[11].ToString();
                song.Msinger      = singer;
                song.Malbum       = row.ItemArray[3].ToString();
                song.Mresource    = row.ItemArray[4].ToString();
                song.Mlength      = row.ItemArray[5].ToString();
                song.Mclick       = (int)row.ItemArray[6];
                song.Mpic         = row.ItemArray[7].ToString();
                songs.Add(song);
            }
            return(songs);
        }
コード例 #28
0
ファイル: Form1.cs プロジェクト: MiruGrigoras/MusicDB
        private void UpdateSinger_Click(object sender, EventArgs e)
        {
            MyDatabaseEntities rep = new MyDatabaseEntities();

            try
            {
                short  x         = Convert.ToInt16(SingerKeyTextBox.Text);
                Singer newSinger = rep.Singers.First(aux => aux.SingerKey == x);
                if (newSinger != null)
                {
                    newSinger.SingerName  = NameTextBox.Text;
                    newSinger.NoAlbums    = NoAlbumsTextBox.Text;
                    newSinger.NoAwards    = NoAwardsTextBox.Text;
                    newSinger.RecordLabel = RecordLabelTextBox.Text;
                    rep.SaveChanges();
                    MessageBox.Show("The modifying was successful!");
                }
                else
                {
                    MessageBox.Show("The key is not registered!");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Something went wrong!");
            }
        }
コード例 #29
0
        private void btn_createSinger_Click(object sender, EventArgs e)
        {
            try
            {
                Singer singer = new Singer();
                singer.SingerName    = txt_singerName.Text;
                singer.SingerSurname = txt_singerSurname.Text;
                singer.ActiveFrom    = int.Parse(txt_activeSince.Text);

                //Add the singer instance to the database
                dbContext.Singers.Add(singer);
                dbContext.SaveChanges();

                //Show message and reset the fields
                lbl_singerMessage.Text      = "Singer is successfully created. ";
                lbl_singerMessage.ForeColor = Color.DarkOliveGreen;
                txt_singerName.Text         = "";
                txt_singerSurname.Text      = "";
                txt_activeSince.Text        = "";
            }
            catch (Exception ex)
            {
                lbl_singerMessage.Text = "An error has occured. More info: " + ex.Message;
            }
        }
コード例 #30
0
        public void TestUpdate()
        {
            var singers = GetArrayofsingers(_singerRepository.Update(null));

            Assert.AreEqual(singers.Count(), 3, "Doesn't update any data when null is sent.");

            var singer = new Singer()
            {
                Id = 5, FirstName = "Avril", LastName = "Lavigne", Genre = "Bellevilla, Canada"
            };

            singers = GetArrayofsingers(_singerRepository.Update(singer));
            Assert.AreEqual(singers.Count(), 3, "Doesn't update any data for id which doesn't exist is requested to update.");

            //Before update
            Assert.AreEqual(singers[0].Id, 1);
            Assert.AreEqual(singers[0].FirstName, "Chester");
            Assert.AreEqual(singers[0].LastName, "Bennington");
            Assert.AreEqual(singers[0].Genre, "Alternative Rock");

            singer = new Singer()
            {
                Id = 1, FirstName = "Avril", LastName = "Lavigne", Genre = "Pop Punk"
            };
            singers = GetArrayofsingers(_singerRepository.Update(singer));

            //After update
            Assert.AreEqual(singers.Count(), 3);
            Assert.AreEqual(singers[0].Id, 1);
            Assert.AreEqual(singers[0].FirstName, "Avril");
            Assert.AreEqual(singers[0].LastName, "Lavigne");
            Assert.AreEqual(singers[0].Genre, "Pop Punk");
        }
コード例 #31
0
ファイル: Form1.cs プロジェクト: bulutk/BannerRunner
        public Form1()
        {
            InitializeComponent();

            numberOfRunners = DEFAULT_RUNNER_COUNT;
            UrlOfLogin = "******";
            textBoxOfURL.Text = UrlOfLogin;
            textBox1.Text = DEFAULT_RUNNER_COUNT.ToString();
            sing = new Singer();
            totalTryNumber = 0;
        }
コード例 #32
0
ファイル: ProjectSong.cs プロジェクト: Nanook/TheGHOST
        internal ProjectSong(Project project, SongQb songQb)
        {
            _lastChanged = DateTime.MinValue;
            _qbLastChanged = DateTime.MinValue;
            _recordChange = false;

            _project = project;
            _songQb = songQb;
            _artist = this.SongQb.Artist;
            _title = this.SongQb.Title;

            if (_project.Defaults.SongVolumeMode == DefaultSettingMode.Game)
                _year = this.SongQb.Year;
            else
                _year = _project.Defaults.Year;

            if (_project.Defaults.SongVolumeMode == DefaultSettingMode.Game)
                _songVolume = this.SongQb.SongVolume;
            else
                _songVolume = _project.Defaults.SongVolume;

            if (_project.Defaults.GuitarVolumeMode == DefaultSettingMode.Game)
                _guitarVolume = this.SongQb.GuitarVolume;
            else
                _guitarVolume = _project.Defaults.GuitarVolume;

            if (_project.Defaults.SingerMode == DefaultSettingMode.Game)
                _singer = this.SongQb.Singer;
            else
                _singer = _project.Defaults.Singer;

            _originalArtist = true; // this.Song.OriginalArtist;

            _minMsBeforeNotesStart = _project.Defaults.MinMsBeforeNotesStart;
            _startPaddingMs = 0;

            _audio = new ProjectSongAudio(_project, this);
            _notes = new ProjectSongNotes(_project, this);

            _audio.PreviewFadeLength = _project.Defaults.PreviewFadeLength;
            _audio.PreviewLength = _project.Defaults.PreviewLength;
            _audio.PreviewStart = _project.Defaults.PreviewStart;
            _audio.PreviewVolume = _project.Defaults.PreviewVolume;
            _audio.PreviewIncludeGuitar = _project.Defaults.PreviewIncludeGuitar;
            _audio.PreviewIncludeRhythm = _project.Defaults.PreviewIncludeRhythm;

            _notes.HoPoMeasure = _project.Defaults.HoPoMeasure;
            _notes.Gh3SustainClipping = _project.Defaults.Gh3SustainClipping;
            _notes.ForceNoStarPower = _project.Defaults.ForceNoStarPower;
        }
コード例 #33
0
ファイル: Unleashed.cs プロジェクト: ROSSFilipov/CSharp
    public static int IndexOfSinger(this List<Singer> singersList, Singer currentSinger)
    {
        int index = 0;

        for (int i = 0; i < singersList.Count; i++)
        {
            if (singersList[i].Name == currentSinger.Name)
            {
                index = i;
            }
        }

        return index;
    }
コード例 #34
0
ファイル: Unleashed.cs プロジェクト: ROSSFilipov/CSharp
    public static bool ContainsSinger(this List<Singer> singersList, Singer currentSinger)
    {
        bool found = false;

        for (int i = 0; i < singersList.Count; i++)
        {
            if (singersList[i].Name == currentSinger.Name)
            {
                found = true;
                break;
            }
        }

        return found;
    }
コード例 #35
0
ファイル: Form1.cs プロジェクト: omermutcali/BannerRunner
        private EQATEC.Analytics.Monitor.IAnalyticsMonitor _Monitor; //web analytics

        #endregion Fields

        #region Constructors

        public Form1()
        {
            _Monitor = EQATEC.Analytics.Monitor.AnalyticsMonitorFactory.Create("0FEF317EDE3844C28CE7AAAA6C07749D");
            Monitor.Start();
            Monitor.VersionAvailable += new EventHandler<EQATEC.Analytics.Monitor.VersionAvailableEventArgs>(_Monitor_VersionAvailable);
            AppDomain.CurrentDomain.UnhandledException += (s, e) => Monitor.TrackException(e.ExceptionObject as Exception);
            Application.ThreadException += (s, e) => Monitor.TrackException(e.Exception);

            InitializeComponent();

            numberOfRunners = DEFAULT_RUNNER_COUNT;
            UrlOfLogin = "******";
            textBoxOfURL.Text = UrlOfLogin;
            textBox1.Text = DEFAULT_RUNNER_COUNT.ToString();
            sing = new Singer();
            totalTryNumber = 0;
        }
コード例 #36
0
ファイル: ProjectDefaults.cs プロジェクト: Nanook/TheGHOST
        internal ProjectDefaults()
        {
            _minMsBeforeNotesStart = 2000;
            _gh3SustainClipping = true;
            _forceMono = false;
            _forceDownSample = 33075;
            _previewFadeLength = 1000;
            _previewLength = 20000;
            _previewStart = 60000;
            _previewVolume = 100;
            _previewIncludeGuitar = true;
            _previewIncludeRhythm = true;
            _singer = Singer.Male;
            _hopoMeasure = 2.95F;
            _forceNoStarPower = false;
            _songVolume = 0;
            _guitarVolume = 0;
            _year = "";
            _smartModeCrowdImport = false;
            _songVolumeMode = DefaultSettingMode.Game;
            _guitarVolumeMode = DefaultSettingMode.Game;
            _yearMode = DefaultSettingModeBlank.Game;
            _singerMode = DefaultSettingMode.Game;
            _gameId = Game.GH3_Wii;
            _languageId = "";
            _audioExportPlugin = "";
            _audioImportPlugin = "";
            _fileCopyPlugin = "";
            _workingFolder = "";
            _audioGuitarVolume = 100;
            _audioRhythmVolume = 100;
            _audioSongVolume = 100;
            _reapplyAll = false;

            _projectHistory = new List<string>();
        }
コード例 #37
0
ファイル: ODataClient.cs プロジェクト: ZhaoYngTest01/WebApi
 public static Singer CreateSinger(int ID)
 {
     Singer singer = new Singer();
     singer.ID = ID;
     return singer;
 }
コード例 #38
0
ファイル: House.cs プロジェクト: ushibutatory/study-dotnet
 /// <summary>
 /// 新しいインスタンスを生成します。
 /// </summary>
 /// <param name="singer">歌手オブジェクト</param>
 /// <param name="audience">観客オブジェクト</param>
 public House(Singer singer, Audience audience)
 {
     this.Singer = singer;
     this.Audience = audience;
     this.LimitCount = 0;
 }
コード例 #39
0
 protected virtual void ExecuteInsertPerformerCommand(string[] commandWords)
 {
     switch (commandWords[2])
     {
         case "singer":
             var singer = new Singer(commandWords[3]);
             this.InsertPerformer(singer);
             break;
         default:
             break;
     }
 }
コード例 #40
0
ファイル: Unleashed.cs プロジェクト: ROSSFilipov/CSharp
    static void Main(string[] args)
    {
        var collection = new Dictionary<string, List<Singer>>();

        while (true)
        {
            string currentLine = Console.ReadLine();

            if (currentLine == "End")
            {
                break;
            }

            Match concertMatch = Regex.Match(currentLine, "\\s@([a-zA-Z\\s]*?)\\s[0-9]");
            Match singerMatch = Regex.Match(currentLine, "([a-zA-Z\\s]+)@");
            Match tickets = Regex.Match(currentLine, "(\\s[0-9]+)\\s*?([0-9]+)");
            string[] inputSplit = currentLine.Split(new char[0], StringSplitOptions.RemoveEmptyEntries);

            if (concertMatch.Groups.Count != 2 || singerMatch.Groups.Count != 2 || tickets.Groups.Count != 3)
            {
                continue;
            }
            else
            {
                string name = singerMatch.Groups[1].Value.Trim();
                string concert = concertMatch.Groups[1].Value.Trim();
                int ticketPrice = int.Parse(tickets.Groups[1].Value);
                int ticketCount = int.Parse(tickets.Groups[2].Value);

                long currentSale = ticketCount * ticketPrice;

                Singer currentSinger = new Singer(name);

                if (!collection.ContainsKey(concert))
                {
                    collection.Add(concert, new List<Singer>());
                }

                if (!collection[concert].ContainsSinger(currentSinger))
                {
                    collection[concert].Add(currentSinger);
                }

                int singerIndex = collection[concert].IndexOfSinger(currentSinger);
                collection[concert][singerIndex].Sales += currentSale;
            }

        }

        foreach (var item in collection)
        {
            Console.WriteLine("{0}", item.Key);
            var sortedSingers = item.Value.OrderByDescending(x => x.Sales);
            foreach (Singer currentSinger in sortedSingers)
            {
                Console.WriteLine("#  {0} -> {1}", currentSinger.Name, currentSinger.Sales);
            }
        }
    }
コード例 #41
0
        protected virtual string GetSingerReport(Singer singer)
        {
            StringBuilder singerInfo = new StringBuilder();
            singerInfo.Append(singer.Name + ": ");
            if (singer.Songs.Any())
            {
                var songs = singer.Songs
                  .Select(s => s.Title)
                  .OrderBy(s => s);
                singerInfo.Append(string.Join("; ", songs));
            }
            else
            {
                singerInfo.Append("no songs");
            }

            return singerInfo.ToString();
        }