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