internal GenericMusicItem(ALBUM s) { InnerType = MediaType.Album; ContextualID = s.ID; Title = s.Name; var songs = s.Songs.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); var ids = Array.ConvertAll(songs, (a) => { return(int.Parse(a)); }); Description = SmartFormat.Smart.Format(Consts.Localizer.GetString("SmartSongs"), ids.Length); Addtional = s.AlbumArtists.IsNullorEmpty() ? Consts.UnknownArtists : string.Join(Consts.CommaSeparator, s.AlbumArtists.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries)); var songIDs = AsyncHelper.RunSync(async() => await SQLOperator.Current().GetSongsAsync(ids)); var s1 = songIDs.OrderBy(a => a.Track); s1 = s1.OrderBy(a => a.Disc); IDs = s1.Select(b => b.ID).ToArray(); var t = ThreadPool.RunAsync(async work => { s.Songs = string.Join('|', songIDs.Select(x => x.ID.ToString())); if (s.Songs.IsNullorEmpty()) { await SQLOperator.Current().RemoveAlbumAsync(s.ID); } else { await SQLOperator.Current().UpdateAlbumAsync(s); } }); PicturePath = s.PicturePath; }
// Albums ----------------------------------------- private List <ALBUM> AllAlbumList() { List <ALBUM> list = new List <ALBUM>(); try { var rows = DbHelper.Query("SELECT * FROM ALBUMS"); foreach (DataRow row in rows) { var albumList = new ALBUM(); albumList.ALBUM_ID = (int)row["ALBUM_ID"]; albumList.ALBUM_NAME = (string)row["ALBUM_NAME"]; albumList.ALBUM_ART = (string)row["ALBUM_ART"]; albumList.BAND_NAME = (string)row["BAND_NAME"]; albumList.RELEASE_YEAR = (int)row["RELEASE_YEAR"]; albumList.RECORD_LABEL = (string)row["RECORD_LABEL"]; list.Add(albumList); } return(list); } catch (Exception) { return(list); } }
public List<ALBUM> SelectALBUMsAll() { List<ALBUM> list = new List<ALBUM>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<ALBUM_getallResult> lp = db.ALBUM_getall(); foreach (ALBUM_getallResult ALBUM in lp) { ALBUM var1 = new ALBUM(); var1.MaAlbum = ALBUM.MaAlbum ; var1.TenAlbum = ALBUM.TenAlbum ; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }
// ---------- PRIVATE METHODS ------------ // private ALBUM AlbumData(int albumId) { var album = new ALBUM(); var rows = DbHelper.Query("SELECT * FROM ALBUMS JOIN TRACKS ON TRACKS.ALBUM_ID = ALBUMS.ALBUM_ID JOIN ARTISTS ON TRACKS.ARTIST_ID = ARTISTS.ARTIST_ID WHERE ALBUMS.ALBUM_ID =" + albumId); album.ALBUM_ART = (string)rows[0]["ALBUM_ART"]; album.ALBUM_NAME = (string)rows[0]["ALBUM_NAME"]; album.BAND_NAME = (string)rows[0]["BAND_NAME"]; album.RELEASE_YEAR = (int)rows[0]["RELEASE_YEAR"]; foreach (var row in rows) { var track = new TRACK { TRACK_FILE = (string)row["TRACK_FILE"], TRACK_NAME = (string)row["TRACK_NAME"], DURATION = (int)row["DURATION"], TRACK_NUMBER = (int)row["TRACK_NUMBER"], Artist = new ARTIST() }; track.Artist.ARTIST_IMG = (string)row["ARTIST_IMG"]; track.Artist.ARTIST_NAME = (string)row["ARTIST_NAME"]; track.Artist.Tracks.Add(track); track.Album = album; album.Tracks.Add(track); } return(album); }
protected void btnThem_Click(object sender, EventArgs e) { try { //lay thong tin tu textbox ALBUM lpDTO = new ALBUM(); lpDTO.MaAlbum = Convert.ToInt32(this.txtmaalbum.Text); lpDTO.TenAlbum = this.txttenalbum.Text; //Goi ham cap nhat BUSAlbum BUSAlbum = new BUSAlbum(); if (BUSAlbum.Them(lpDTO) == 0) { //Thong bao lbThongBao.Text = "Thêm Thành Công"; lbThongBao.Visible = true; //Response.Redirect("LoaiMatHang.aspx"); } else { lbThongBao.Text = "Thêm Không Thành Công"; lbThongBao.Visible = true; } } catch { lbThongBao.Text = "Thêm Không Thành Công"; lbThongBao.Visible = true; } }
// POST: Admin/Album public ActionResult Sua(ALBUM al) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { ALBUM album = db.ALBUMs.SingleOrDefault(n => n.IdAlbum == al.IdAlbum); if (album != null) { album.TenAlbum = al.TenAlbum; album.AnhDaiDien = al.AnhDaiDien; db.SaveChanges(); } } return(RedirectToAction("Index")); }
public int CapNhat(ALBUM lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); return db.ALBUM_update( lpDTO.MaAlbum, lpDTO.TenAlbum ); } catch (Exception ex) { throw (ex); } }
public int Them(ALBUM lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); db.ALBUM_add( lpDTO.TenAlbum ); return 1; } catch (Exception ex) { throw (ex); //return 0; } }
// POST: Admin/Album public ActionResult Xoa(int id) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { try { ALBUM al = db.ALBUMs.SingleOrDefault(n => n.IdAlbum == id); db.ALBUMs.Remove(al); db.SaveChanges(); } catch { } } return(RedirectToAction("Index")); }
// POST: Admin/Album/Them public ActionResult Them(ALBUM al) { using (Web_KTCKEntities db = new Web_KTCKEntities()) { var checkTenAlbum = db.ALBUMs.SingleOrDefault(n => n.TenAlbum == al.TenAlbum); if (checkTenAlbum == null) { db.ALBUMs.Add(al); db.SaveChanges(); } else { } return(RedirectToAction("Index")); } }
private void AddObjects() { NEWS n = new NEWS { TITLE = "aaa", TIME = DateTime.Now, CONTENT = "jfjjfjjjf" }; Collections.News.Add(n); ALBUM a = new ALBUM { NAME = "Танцы с бубном", }; Collections.Albums.Add(a); FISH f = new FISH { NAME = "Ерш", DESCRIPTION = "blablalalbablalbalbalablalbala" }; Collections.Fishes.Add(f); STATE_INSPECTION i = new STATE_INSPECTION { PHONE = "+5255522", ADDRESS = "HHCKFKVKFV", REGION = "mINSK" }; Collections.Inspectios.Add(i); DIALOG d = new DIALOG { }; USER u = new USER { FIRSTNAME = "alb", LASTNAME = "ert" }; Collections.Friends.Add(u); }
internal Album(ALBUM album) { ID = album.ID; var songs = album.Songs.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); Songs = Array.ConvertAll(songs, (a) => { return(int.Parse(a)); }); Name = album.Name; Genres = album.Genres.IsNullorEmpty() ? null : album.Genres.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries); Year = album.Year; AlbumSort = album.AlbumSort; TrackCount = album.TrackCount; DiscCount = album.DiscCount; AlbumArtists = album.AlbumArtists.IsNullorEmpty() ? null : album.AlbumArtists.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries); AlbumArtistsSort = album.AlbumArtistsSort.IsNullorEmpty() ? null : album.AlbumArtistsSort.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries); ReplayGainAlbumGain = album.ReplayGainAlbumGain; ReplayGainAlbumPeak = album.ReplayGainAlbumPeak; PicturePath = album.PicturePath; }
/// <summary> /// Push album name to ALBUM /// </summary> /// <param name="_track"></param> /// <param name="dc"></param> public static string Write2_ALBUM(Track _track, MusicDBDataContext dc) { if (dc.ALBUMs.Any(alb => alb.Ten_Album == _track.Album)) { return((from alb in dc.ALBUMs where alb.Ten_Album == _track.Album select alb.Ma_Album).FirstOrDefault()); } else { ALBUM album = new ALBUM(); album.Ma_Album = Utils.GenerateID("ALBUM"); album.Ten_Album = _track.Album; dc.ALBUMs.InsertOnSubmit(album); dc.SubmitChanges(); return(album.Ma_Album); } }
public static void TransToAlbumData() { ZoneManager.Instance.picArray = new AlbumPic[Info.items.Count]; for (int i = 0; i < Info.items.Count; i++) { ALBUM a = Info.items [i]; AlbumPic pic = new AlbumPic(); pic.id = a.pic_id; pic.userId = a.user_id; pic.picPath = a.pic_path; pic.order = a.order; List <AlbumData> albums; if (ZoneManager.Instance.id2Album.TryGetValue(a.user_id, out albums)) { } else { albums = new List <AlbumData> (); ZoneManager.Instance.id2Album.Add(a.user_id, albums); } AlbumData datas = null; for (int m = 0; m < albums.Count; m++) { if (albums[m].albumName.Equals(a.album_name)) { datas = albums[m]; } } if (datas == null) { datas = new AlbumData(); datas.isSecret = a.is_secret; datas.albumName = a.album_name; albums.Add(datas); } datas.pics.Add(pic); ZoneManager.Instance.picArray [i] = pic; } }
public int Them(ALBUM lpDTO) { DAOAlbum ALBUM = new DAOAlbum(); return ALBUM.Them(lpDTO); }
public int CapNhat(ALBUM lpDTO) { DAOAlbum ALBUM = new DAOAlbum(); return ALBUM.CapNhat(lpDTO); }