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