public ActionResult Index() { AlbumView av = new AlbumView(); av.Albums = Repo.SelectAllAlbums(); return(View(av)); }
public ActionResult Edit(Guid albumId) { AlbumView av = new AlbumView(); if (Repo.IsAlbumSpecial(albumId)) { string userId = User.Identity.GetUserId(); var userManager = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>(); if (userManager.IsInRole(userId, "Admin")) { av.Album = Repo.SelectAlbumByID(albumId); return(PartialView(av)); } else { ModelState.AddModelError("error", "Error: Only admin can edit this album."); return(new EmptyResult()); } } else { av.Album = Repo.SelectAlbumByID(albumId); return(PartialView(av)); } }
private async Task <StackLayout> GetArtistAlbums() { var ArtistAlbums = await GetAlbumDetails.ByArtistId(ArtistId); var NumberOfAlbums = ArtistAlbums.Number_Of_Albums; var Artist = ConvertJuxString.Decode(ArtistAlbums.Artist); var Albums = ArtistAlbums.Albums; var stack = new StackLayout(); await Task.Run(() => { foreach (var Album in Albums) { var albumView = new AlbumView(); albumView.Artist = Artist; albumView.Album = ConvertJuxString.Decode(Album.Title); albumView.ImageUrl = Album.Album_Picture; albumView.AlbumId = Album.Id; albumView.Year = Album.Date; stack.Children.Add(albumView); } }); return(stack); }
void bwCDList_DoWork(object sender, DoWorkEventArgs e) { SafeObservableCollection <AlbumItem> items = new SafeObservableCollection <AlbumItem>(); int count = 0; Big3.Hitbase.DataBaseEngine.Condition searchCondition = Big3.Hitbase.DataBaseEngine.Condition.Combine(Condition, ConditionFromTree); using (DataBaseView view = AlbumView.CreateView(this.DataBase, this.CdListFields.GetFields(), new SortFieldCollection(), 0, searchCondition)) { object[] values; while ((values = view.Read()) != null) { AlbumItem newItem = new AlbumItem(); newItem.ID = (int)values[0]; newItem.Items = new object[values.Length - 1]; FillRowValues(newItem, values); items.AddItemFromThread(newItem); count++; } } e.Result = items; }
public void SaveAlbum(AlbumView album, BitmapImage image) { if (Albums.FirstOrDefault(a => a.Equals(album)) is AlbumView albumView) { albumView.Thumbnail = image ?? MusicImage.DefaultImage; } }
private void DropShadowControl_DataContextChanged(FrameworkElement sender, DataContextChangedEventArgs args) { AlbumView album = sender.DataContext as AlbumView; if (album == null || album.DontLoad || !sender.IsPartiallyVisible(AlbumsGridView)) { return; } LoadThumbnail(album); }
private void DropShadowControl_EffectiveViewportChanged(FrameworkElement sender, EffectiveViewportChangedEventArgs args) { AlbumView album = sender.DataContext as AlbumView; if (album == null || album.DontLoad || !ImageHelper.NeedsLoading(sender, args)) { return; } LoadThumbnail(album); }
private async Task <StackLayout> AlbumStackAsync() { StackLayout albumStack = new StackLayout(); var JuxResults = await ArtistOrAlbumSearchAsync(); if (JuxResults != null) { var ResultCount = JuxResults.Results.Count; var CountMatch = 0; string Artist = ""; string Album = ""; string Url = ""; int Id = 0; await Task.Run(() => { for (int i = 0; i <= ResultCount - 1; i++) { albumView = new AlbumView(); Artist = ConvertJuxString.Decode(JuxResults.Results[i].Artist); Album = ConvertJuxString.Decode(JuxResults.Results[i].Album); Url = JuxResults.Results[i].Album_Picture; Id = JuxResults.Results[i].Id; albumView.Artist = Artist; albumView.Album = Album; albumView.AlbumId = Id; albumView.ImageUrl = Url; albumView.DownloadCount = $" "; if (Album.ToLower().Contains(SearchText.ToLower())) { CountMatch += 1; albumStack.Children.Add(albumView); } } if (CountMatch < 1) { albumStack.Children.Add(new Label { Text = $"Nothing was found for {SearchText}, try with another Title.", FontSize = 15, TextColor = Color.White, LineBreakMode = LineBreakMode.WordWrap, HorizontalTextAlignment = TextAlignment.Center }); } }); } return(albumStack); }
public ActionResult Carousel() { //宣告一個新頁面模型 AlbumView Data = new AlbumView(); //新增頁面模型中的分頁(只顯示第一頁) Data.Paging = new ForPaging(1); //從Service中取得頁面所需陣列資料 Data.FileList = albumService.GetDataList(Data.Paging); //將頁面資料傳入View中 return(View(Data)); }
private void UpdateAlbumItem(AlbumItem albumItem) { DataBaseView view = AlbumView.CreateView(DataBase, CdListFields.GetFields(), CdListSort, albumItem.ID); object[] values = view.Read(); FillRowValues(albumItem, values); ListCollectionView lcv = this.dataGrid.ItemsSource as ListCollectionView; lcv.Refresh(); }
//一開始載入Action,並設定初始頁數為1 public ActionResult List(int Page = 1) { //宣告一個新頁面模型 AlbumView Data = new AlbumView(); //新增頁面模型中的分頁 Data.Paging = new ForPaging(Page); //從Service中取得頁面所需陣列資料 Data.FileList = albumService.GetDataList(Data.Paging); //將頁面資料傳入View中 return(PartialView(Data)); }
public AlbumDialog(AlbumDialogOption option, AlbumView album) { this.InitializeComponent(); switch (option) { case AlbumDialogOption.Properties: break; case AlbumDialogOption.AlbumArt: break; } AlbumArtController.SetAlbumArt(album); }
void ReleaseDesignerOutlets() { if (AlbumView != null) { AlbumView.Dispose(); AlbumView = null; } if (SongTableView != null) { SongTableView.Dispose(); SongTableView = null; } }
private void GridView_ItemClick(object sender, ItemClickEventArgs e) { if (AlbumsGridView.SelectionMode != ListViewSelectionMode.None) { return; } AlbumView album = (AlbumView)e.ClickedItem; if (album.Songs == null) { album.SetSongs(AlbumPage.SearchAlbumSongs(album.Name, album.Artist)); } Frame.Navigate(typeof(AlbumPage), e.ClickedItem); }
private async void LoadThumbnail(AlbumView album) { string before = album.ThumbnailSource; if (album.Songs == null) { album.SetSongs(AlbumPage.SearchAlbumSongs(album.Name, album.Artist)); } await album.SetThumbnailAsync(); if (album.ThumbnailSource != before && AlbumInfoList.FirstOrDefault(a => a.Equals(album)) is AlbumInfo albumInfo) { albumInfo.Thumbnail = album.ThumbnailSource; } }
public static async void HandleCommand(string text) { string play = Helper.Localize("Play"); if (text.StartsWith(play)) { string keyword = text.Substring(play.Length); var result = await SearchHelper.Search(keyword); if (result.Result == null) { Helper.ShowNotification("NoResults"); return; } switch (result.SearchType) { case SearchType.Artists: Playlist artist = result.Result as Playlist; MediaHelper.ShuffleAndPlay(artist.Songs); Helper.ShowNotificationWithoutLocalization(Helper.LocalizeMessage("SearchResultArtist", artist.Name), 5000); break; case SearchType.Albums: AlbumView album = result.Result as AlbumView; MediaHelper.ShuffleAndPlay(album.Songs); Helper.ShowNotificationWithoutLocalization(Helper.LocalizeMessage("SearchResultAlbum", album.Name), 5000); break; case SearchType.Playlists: AlbumView playlist = result.Result as AlbumView; MediaHelper.ShuffleAndPlay(playlist.Songs); Helper.ShowNotificationWithoutLocalization(Helper.LocalizeMessage("SearchResultPlaylist", playlist.Name), 5000); break; case SearchType.Folders: GridFolderView folder = result.Result as GridFolderView; MediaHelper.ShuffleAndPlay(folder.Songs); Helper.ShowNotificationWithoutLocalization(Helper.LocalizeMessage("SearchResultFolder", folder.Name), 5000); break; case SearchType.Songs: Music music = result.Result as Music; MediaHelper.SetMusicAndPlay(music); Helper.ShowNotificationWithoutLocalization(Helper.LocalizeMessage("SearchResultMusic", music.Name), 5000); break; } } }
private void SearchPlaylistView_ItemClick(object sender, ItemClickEventArgs e) { AlbumView playlist = (AlbumView)e.ClickedItem; if (playlist.Name == MenuFlyoutHelper.NowPlaying) { Frame.Navigate(typeof(NowPlayingPage)); } else if (playlist.Name == MenuFlyoutHelper.MyFavorites) { Frame.Navigate(typeof(MyFavoritesPage)); } else { Frame.Navigate(typeof(PlaylistsPage), e.ClickedItem); } }
public static int EvaluatePlaylist(AlbumView item, string keyword) { if (item == null) { return(0); } if (item.Name == keyword) { return(96); } if (item.Name.Contains(keyword)) { return(86); } return(0); }
public static void FindAlbum(string title) { string selectString = @"SELECT a.title t, m.title FROM music m, album a WHERE a.title LIKE '%" + title + "%' AND m.id_album = a.id"; SqlConnection connection = new SqlConnection(ConnectionString); connection.Open(); SqlCommand cmd = new SqlCommand(selectString, connection); var rdr = cmd.ExecuteReader(); // Appel de la vue pour les details d'un album var view = new AlbumView(); view.showOneAlbum(rdr); connection.Close(); }
public async void SetAlbumArt(AlbumView album) { CurrentAlbum = album; RemoveAlbumArtWarningTextBlock.Text = Helper.LocalizeMessage("RemoveAlbumArt", string.IsNullOrEmpty(CurrentAlbum.Name) ? Helper.LocalizeMessage("UnknownAlbum") : CurrentAlbum.Name); foreach (var music in CurrentAlbum.Songs) { var thumbnail = await Helper.GetStorageItemThumbnailAsync(music, 1024); if (thumbnail.IsThumbnail()) { AlbumArt.Source = thumbnail.ToBitmapImage(); AlbumArt.Visibility = Visibility.Visible; return; } } AlbumArt.Visibility = Visibility.Collapsed; }
public static void albumList() { string selectString = @"SELECT a.title, a.artist, a.available, m.description FROM album a, musicGenre m WHERE a.id_genre = m.id"; SqlConnection connection = new SqlConnection(ConnectionString); connection.Open(); SqlCommand cmd = new SqlCommand(selectString, connection); var rdr = cmd.ExecuteReader(); // Appel de la vue pour un album var view = new AlbumView(); view.showAllAlbum(rdr); connection.Close(); }
public HttpResponseMessage IncreaseView([FromUri] int id) { using (var db = new OnlineMusicEntities()) { var album = (from a in db.Albums where a.Id == id select a).FirstOrDefault(); if (album == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không tìm thấy album id=" + id)); } else if (album.Songs.Count > 0) { var views = (from v in db.AlbumViews where v.AlbumId == id select v).FirstOrDefault(); // Create new if song hasn't view yet if (views == null) { views = new AlbumView() { Ip = "", AlbumId = id, Timestamp = DateTime.Now, Views = 0 }; db.AlbumViews.Add(views); } else { // Reset view hour if (views.Timestamp.Date.CompareTo(DateTime.Now.Date) != 0 || views.Timestamp.Hour != DateTime.Now.Hour) { views.Ip = ""; views.Timestamp = DateTime.Now; } } string ip = HttpContext.Current.Request.UserHostAddress.Trim(); // If IP hasn't view yet then increase view of song if (!views.Ip.Contains(ip)) { views.Ip += " " + ip; views.Views++; } db.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK)); } }
[HttpPost] //設定此Action只接受頁面POST資料傳入 //使用Bind的Inculde來定義只接受的欄位,用來避免傳入其他不相干值 public ActionResult Upload([Bind(Include = "upload")] AlbumView File) { //檢查是否有上傳檔案 if (File.upload != null) { //將檔案和伺服器上路徑合併 string Url = Path.Combine(Server.MapPath("~/Upload/") , File.upload.FileName); //將檔案儲存於伺服器上 File.upload.SaveAs(Url); //藉由Service將檔案資料存入資料庫 albumService.UploadFile(File.upload.FileName, Url , File.upload.ContentLength , File.upload.ContentType, User.Identity.Name); } //重新導向頁面至開始頁面 return(RedirectToAction("Index")); }
public List <AlbumView> GetAlbumList(string userid) { List <AlbumView> albums = new List <AlbumView>(); var pics = _db.Pictures.Where(t => t.Album.UserId == userid).GroupBy(t => t.Album.Name); foreach (var p in pics) { var item = p.OrderByDescending(t => t.UploadTime).FirstOrDefault(); AlbumView album = new AlbumView { Id = item.AlbumId, Name = p.Key, LastImg = PICURL + item.Url }; albums.Add(album); } return(albums); }
private AlbumView getAlbumViewModel(int albumId) { var queriedAlbumItem = _context.Albums.Where(a => a.id == albumId).First(); var photoList = _context.Photos.Where(s => s.album_id == queriedAlbumItem.id); var albumViewModel = new AlbumView(); albumViewModel.id = queriedAlbumItem.id; albumViewModel.photoList = photoList; albumViewModel.name = queriedAlbumItem.name; albumViewModel.owner_id = queriedAlbumItem.owner_id; if (queriedAlbumItem.owner_id == User.FindFirst("emails").Value) { albumViewModel.permission_level = 2; } else { albumViewModel.permission_level = _context.Permissions.Where(s => s.album_id == albumId && s.user_id == User.FindFirst("emails").Value).First().permission_level; } return(albumViewModel); }
private void PlaylistGridView_ItemClick(object sender, ItemClickEventArgs e) { if (PlaylistsGridView.SelectionMode != ListViewSelectionMode.None) { return; } AlbumView album = (AlbumView)e.ClickedItem; if (album.Name == MenuFlyoutHelper.NowPlaying) { Frame.Navigate(typeof(NowPlayingPage)); } else if (album.Name == MenuFlyoutHelper.MyFavorites) { Frame.Navigate(typeof(MyFavoritesPage)); } else { Frame.Navigate(typeof(AlbumPage), album); } }
public static async Task <SearchResult> Search(string keyword) { List <SearchResult> results = new List <SearchResult>(); Playlist artist = (await Task.Run(() => SearchArtists(MusicLibraryPage.AllSongs, keyword, SortBy.Artist)))?.FirstOrDefault(); results.Add(new SearchResult(SearchType.Artists, artist, EvaluateArtist(artist, keyword))); Music music = (await Task.Run(() => SearchSongs(MusicLibraryPage.AllSongs, keyword, SortBy.Artist)))?.FirstOrDefault(); results.Add(new SearchResult(SearchType.Artists, artist, EvaluateMusic(music, keyword))); AlbumView album = (await Task.Run(() => SearchAlbums(MusicLibraryPage.AllSongs, keyword, SortBy.Artist)))?.FirstOrDefault(); results.Add(new SearchResult(SearchType.Artists, album, EvaluateAlbum(album, keyword))); GridFolderView folder = (await Task.Run(() => SearchFolders(Settings.settings.Tree, keyword, SortBy.Artist)))?.FirstOrDefault(); results.Add(new SearchResult(SearchType.Folders, folder, EvaluateFolder(folder, keyword))); AlbumView playlist = (await Task.Run(() => SearchPlaylists(Settings.settings.Playlists, keyword, SortBy.Artist)))?.FirstOrDefault(); results.Add(new SearchResult(SearchType.Playlists, playlist, EvaluatePlaylist(playlist, keyword))); results.Sort((r1, r2) => r2.Score - r1.Score); return(results[0]); }
private async Task <StackLayout> GetAlbum() { var Results = await GetAlbumDetails.ById(AlbumId); var Album = Results.AlbumInformation; var Title = ConvertJuxString.Decode(Album.Album); var Artist = ConvertJuxString.Decode(Album.Artist); string Year = Convert.ToDateTime(ConvertJuxString.Decode(Album.Date)).Year.ToString(); var stack = new StackLayout(); await Task.Run(() => { var albumView = new AlbumView(); albumView.Artist = Artist; albumView.Album = Title; albumView.ImageUrl = Album.High_Quality_Picture; albumView.AlbumId = AlbumId; albumView.Year = Year; stack.Children.Add(albumView); }); return(stack); }
public void DeletePhoto(AlbumView data) { _AlbumServices.DeletePhoto(data.p_Id); }
private void Search() { Big3.Hitbase.DataBaseEngine.Condition sel = new Big3.Hitbase.DataBaseEngine.Condition(); // Diese Sachen direkt speichern, wenn einmal gesucht wurde. Settings.SetValue("LinkSameNumber", checkBoxSameTrackCount.IsChecked == true ? (int)1 : (int)0); Settings.SetValue("LinkNotLinked", checkBoxNotAssigned.IsChecked == true ? (int)1 : (int)0); // Nur CDs. sel.Add(Field.AlbumType, Operator.Equal, 0); if (this.checkBoxNotAssigned.IsChecked == true) { sel.Add(Field.Identity, Operator.Empty, 0); } if (this.checkBoxSameTrackCount.IsChecked == true) { sel.Add(Field.NumberOfTracks, Operator.Equal, cdInDrive.NumberOfTracks); } if (textBoxArtist.Text != "") { sel.Add(Field.ArtistCDName, Operator.Contains, textBoxArtist.Text); } if (textBoxTitle.Text != "") { sel.Add(Field.Title, Operator.Contains, textBoxTitle.Text); } SortFieldCollection sortKeys = new SortFieldCollection(); sortKeys.Add(Field.ArtistCDName); sortKeys.Add(Field.Title); FieldCollection fc = new FieldCollection(); fc.Add(Field.ArtistCDName); fc.Add(Field.Title); fc.Add(Field.TotalLength); fc.Add(Field.NumberOfTracks); List <CDItemResult> items = new List <CDItemResult>(); using (DataBaseView albumView = AlbumView.CreateView(dataBase, fc, sortKeys, 0, sel)) { object[] values; while ((values = albumView.Read()) != null) { CDItemResult newItem = new CDItemResult(); newItem.CDID = (int)values[0]; newItem.Artist = (string)values[1]; newItem.Title = values[2] is DBNull ? "" : (string)values[2]; newItem.Length = (int)values[3]; newItem.NumberOfTracks = (int)values[4]; items.Add(newItem); } } DataGridResult.ItemsSource = items; return; }
public List<AlbumView> getAlbumList(string userid) { List<AlbumView> alist = new List<AlbumView>(); string SQLStatement = "SELECT * FROM album WHERE user_id='"+ userid +"\'" ; // Create a SqlDataAdapter to get the results as DataTable SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(SQLStatement, conn); // Create a new DataTable DataTable dtResult = new DataTable(); // Fill the DataTable with the result of the SQL statement SQLDataAdapter.Fill(dtResult); foreach (DataRow drRow in dtResult.Rows) { AlbumView al = new AlbumView(); al._id = Convert.ToInt32(drRow["_id"].ToString()); al.user_id = drRow["user_id"].ToString(); al.name = drRow["name"].ToString(); al.face_addr = drRow["face_addr"].ToString(); al.size = Convert.ToInt32(drRow["size"].ToString()); al.file_path = drRow["file_path"].ToString(); al.network_addr = drRow["network_addr"].ToString(); al.descript = drRow["descript"].ToString(); alist.Add(al); } return alist; }