private void dgTopTracks_Load(long ArtistID) { try { LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); dgTopTracks.DataSource = db.FIND_TOP_TRACKS(ArtistID); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void dgSimilarArtists_Load(long ArtistID) { try { LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); dgSimilarArtists.DataSource = db.GET_SIMILAR_ARTISTS(ArtistID); } catch (Exception e) { MessageBox.Show(e.Message); } }
private void tagSearch(String tag) { try { LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); dgArtists.DataSource = db.FIND_ARTISTS_WITH_TAG(tag); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void artistSearch() { try { LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); dataGridView1.DataSource = db.ARTIST_SEARCH(textBox1.Text); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void userTagKeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { try { LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); db.REMOVE_TAG(userID, frmMain.ArtistID, dgUserTags.SelectedCells[0].Value.ToString()); this.RefreshUserControl(); } catch (Exception e_userTagKeyDown) { MessageBox.Show(e_userTagKeyDown.Message); } } }
private void btnAddTag_Click(object sender, EventArgs e) { try { string input = Microsoft.VisualBasic.Interaction.InputBox("Enter tag", "Add a tag", "", -1, -1); LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); db.TAG_ARTIST(userID, frmMain.ArtistID, input); } catch (Exception exc) { if (exc.InnerException != null) { MessageBox.Show(exc.InnerException.Message); } else { MessageBox.Show(exc.Message); } } this.RefreshUserControl(); }
private void dgUserTags_Load(long ArtistID) { try { LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); var tags = (from tag in db.lnkUserTagArtists join tagInfos in db.tblTags on tag.TagID equals tagInfos.tagID where tag.UserID == userID && tag.ArtistID == frmMain.ArtistID group tagInfos by tagInfos.tagValue into tagGroup select new { tagValue = tagGroup.Key, count = tagGroup.Count() } ).Distinct().OrderByDescending(x => x.count).Take(20); dgUserTags.DataSource = tags.ToList(); } catch (Exception e) { MessageBox.Show(e.Message); } }
private void OtherUserGrid_Load(long artistID, long user_ID) { LastFMBrowser.Models.LastFMDataEntities db = new LastFMBrowser.Models.LastFMDataEntities(); dgOtherUsers.DataSource = db.FIND_ARTIST_LISTENERS(user_ID, artistID); }