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