protected void btnupdyes_Click(object sender, EventArgs e) { if (this.txtupdtypename.Text == "") { Response.Write("<script>alert('类型名称不能为空!');</script>"); return; } Artists artist1 = new Artists() { Name = this.txtupdtypename.Text }; if (ArtistsManager.UpdArtist(artist1, (int)ViewState["artistid"])) { Response.Write("<script>alert('修改成功!');</script>"); this.paneladd.Visible = false; this.panelupd.Visible = false; this.paneltypes.Visible = true; RepeaterData(); return; } else { Response.Write("<script>alert('修改失败!');</script>"); return; } }
protected void btnyes_Click(object sender, EventArgs e) { if (this.txttypename.Text == "") { Response.Write("<script>alert('类型名称不能为空!');</script>"); return; } Artists artist = new Artists() { Name = this.txttypename.Text }; if (ArtistsManager.AddArtist(artist)) { Response.Write("<script>alert('添加成功!');window.location.href='MusicTypeGL.aspx?nowpage=" + Request.QueryString["nowpage"] == null ? "1" : Request.QueryString["nowpage"] + "';</script>"); this.paneladd.Visible = false; this.panelupd.Visible = false; this.paneltypes.Visible = true; RepeaterData(); } else { Response.Write("<script>alert('添加失败!');</script>"); return; } }
/// <summary> /// Display all artists /// </summary> private void showArtistList() { foreach (Artist artist in ArtistsManager.db_GetAllArtists()) { ArtistNames.Add(artist.name); } }
protected void LinkButton1_Command(object sender, CommandEventArgs e) { this.paneladd.Visible = false; this.panelupd.Visible = true; this.paneltypes.Visible = false; int artistid = int.Parse(e.CommandArgument.ToString()); artist = ArtistsManager.GetById(artistid); this.txtupdtypename.Text = artist.Name; ViewState["artistid"] = int.Parse(e.CommandArgument.ToString()); }
/// <summary> /// Sync Local DB with Server DB /// </summary> public static void SyncLocalDbWithServerDb() { // Delete all local tables AlbumsManager.db_Delete_All(); ArtistsManager.db_Delete_All(); PlaylistsManager.db_Delete_All(); //Get all server tables List <Album> albums = AlbumsNwManager.GetAlbums(); List <Artist> artists = ArtistsNwManager.GetArtists(); List <Playlist> playlists = PlaylistsNwManager.GetPlaylists(); List <Track> tracks = TracksNwManager.GetTracks(); // < sync local tables with server tables > foreach (var item in albums) { AlbumsManager.db_Add_Update_Record(item); } foreach (var item in artists) { ArtistsManager.db_Add_Update_Record(item); } foreach (var item in playlists) { PlaylistsManager.db_Add_Update_Record(item); } foreach (var item in tracks) { TracksManager.db_Add_Update_Record(item); } // </ sync local tables with server tables > // < Add relations to local db > foreach (Album album in albums) { foreach (string artistId in album.artists) { AlbumFromArtistManager.db_Add_Update_Record((int)album.id, Convert.ToInt32(artistId)); } } foreach (Artist artist in artists) { foreach (string trackId in artist.songs) { TrackFromArtistManager.db_Add_Update_Record(Convert.ToInt32(trackId), (int)artist.id); } } // </ Add relations to local db > }
protected void LinkButton2_Command(object sender, CommandEventArgs e) { if (ArtistsManager.RemoveArtist(int.Parse(e.CommandArgument.ToString()))) { Response.Write("<script>alert('删除成功!');</script>"); RepeaterData(); return; } else { Response.Write("<script>alert('删除失败!');</script>"); return; } }
/// <summary> /// Display all tracks from a slected Artists /// </summary> /// <param name="artistName"></param> private void showSelectedArtist(string artistName) { // Find selected Artist in DB Artist currentArtist = ArtistsManager.db_GetAllArtists().Find(x => x.name == artistName); // Find all tracks from selected Artist foreach (Album album in currentArtist.Albums) { foreach (Track track in album.Tracks) { TrackList.Add(new TrackMetadata { Title = track.title, Album = track.Album.name, Genre = track.Metadata.Genre, Year = (track.Metadata.Year).ToString(), Length = track.Metadata.Length.ToString("hh:mm:ss") });; } } ListVisi = Visibility.Visible; }
private void DropData() { this.droptype.DataSource = ArtistsManager.GetAllType(); this.dropsongtype.DataSource = ArtistsManager.GetAllType(); this.droptype.DataTextField = "Name"; this.dropsongtype.DataTextField = "Name"; this.droptype.DataValueField = "ArtistId"; this.dropsongtype.DataValueField = "ArtistId"; this.droptype.DataBind(); this.dropsongtype.DataBind(); this.dropgenre.DataSource = GenresManager.GetAllGenre(); this.dropsingername.DataSource = GenresManager.GetAllGenre(); this.dropgenre.DataTextField = "Name"; this.dropsingername.DataTextField = "Name"; this.dropgenre.DataValueField = "GenreId"; this.dropsingername.DataValueField = "GenreId"; this.dropgenre.DataBind(); this.dropsingername.DataBind(); }
private void RepeaterData() { int nowpage = 1; if (Request.QueryString["nowpage"] != null) { nowpage = int.Parse(Request.QueryString["nowpage"]); } if (nowpage == 1) { hlfirst.Enabled = false; hlprev.Enabled = false; } if (nowpage == pages) { hllast.Enabled = false; hlnext.Enabled = false; } this.Repeater1.DataSource = ArtistsManager.GetAll(nowpage); this.Repeater1.DataBind(); this.lblsum.Text = ArtistsManager.GetSumCount().ToString(); this.lblpage.Text = nowpage.ToString(); this.lblpages.Text = pages.ToString(); if (nowpage != pages) { this.lblone.Text = "7"; } else { this.lblone.Text = (ArtistsManager.GetSumCount() - 7 * (nowpage - 1)).ToString(); } hlfirst.NavigateUrl = "~/MusicGL/MusicTypeGL.aspx?nowpage=" + 1; hlnext.NavigateUrl = "~/MusicGL/MusicTypeGL.aspx?nowpage=" + (nowpage + 1).ToString(); hlprev.NavigateUrl = "~/MusicGL/MusicTypeGL.aspx?nowpage=" + (nowpage - 1).ToString(); hllast.NavigateUrl = "~/MusicGL/MusicTypeGL.aspx?nowpage=" + (pages); }