/// <summary> /// Push other details to CHITIETBAIHAT /// </summary> /// <param name="_track"></param> /// <param name="bh"></param> /// <param name="dc"></param> public static void Write2_CHITIETBAIHAT(Track _track, MusicDBDataContext dc, BAIHAT bh) { CHITIETBAIHAT chitiet = new CHITIETBAIHAT(); chitiet.Ma_BaiHat = bh.Ma_BaiHat; chitiet.ThoiLuong = _track.Duration; chitiet.CoAnhBia = _track.HasCoverArt; chitiet.NgayThemVaoCSDL = _track.DateAdded; chitiet.NamPhatHanh = _track.Year.ToString(); dc.CHITIETBAIHATs.InsertOnSubmit(chitiet); dc.SubmitChanges(); }
/// <summary> /// Update last time play that 'track' /// </summary> /// <param name="track"></param> public static void UpdateLastTimePlay(Track track) { using (dc = new MusicDBDataContext(Properties.Settings.Default.MusicConnectionString)) { CHITIETBAIHAT _ctiet = dc.CHITIETBAIHATs.Single(ctiet => ctiet.Ma_BaiHat == track.ID); if (_ctiet != null) { _ctiet.LanNgheCuoi = DateTime.Now; } dc.SubmitChanges(); } }
/// <summary> /// Update Favourite Only /// </summary> /// <param name="_ID">Song_ID:int</param> /// <param name="_isFavourite">Favourite:Boolean</param> public static void UpdateOnlyFavourite2DB(string _ID, bool _isFavourite) { using (dc = new MusicDBDataContext(Properties.Settings.Default.MusicConnectionString)) { CHITIETBAIHAT _ctiet = dc.CHITIETBAIHATs.Single(ctiet => ctiet.Ma_BaiHat == _ID); if (_ctiet != null) { _ctiet.Rating = _isFavourite; } dc.SubmitChanges(); } }
/// <summary> /// Import basic information of a track to database /// </summary> /// <param name="_track"></param> public static void ImportTrack2Database(MusicDBDataContext dc, Track _track) { if (_track == null) { return; } BAIHAT bh = new BAIHAT(); CHITIETBAIHAT ctbh = new CHITIETBAIHAT(); // If the file path has exist in database so that file has added. Return! if (dc.BAIHATs.Any(s => s.DuongDan == _track.Location)) { return; } // FILL TABLE BAIHAT, CASI, TUA, THELOAI, ALBUM: // 1: Checking and FILL information to Tables: CASI, TUA, THELOAI, ALBUM // 2: Fill table BAIHAT by getting the ID from those tables. bh.DuongDan = _track.Location; bh.Ma_BaiHat = Utils.GenerateID("BAIHAT"); // Check exist and add a new Artist in table bh.Ma_CaSi = Write2_CASI1(_track, dc); // Check exist and add a new Title in table TUA bh.Ma_Tua = Write2_TUA(_track, dc); // Check exist and add a new Album in table ALBUM bh.Ma_Album = Write2_ALBUM(_track, dc); // Check exist and add a new Genre in table THELOAI bh.Ma_TheLoai = Write2_THELOAI(_track, dc); // Check exist and add a new AlbumArtist in table CASI bh.Ma_CaSiAlbum = Write2_CASI2(_track, dc); dc.BAIHATs.InsertOnSubmit(bh); dc.SubmitChanges(); // FILL TABLE CHITIETBAIHAT Write2_CHITIETBAIHAT(_track, dc, bh); //} }