public PartialViewResult More_Track_Artist(int id) //id la id cua track -> lay id artist tu do
{
List <List <string> > listTrack = new List <List <string> >();
List <List <List <string> > > listInfo = new List <List <List <string> > >();
//lay id cua tat ca cac artist tham gia
List <int> tempIdArtist = db.TRACK_ARTIST.Where(p => p.ID_TRACK == id).Select(p => p.ID_ARTIST).ToList();
//lay id cua tat ca cac track cua cac artist do
List <int> allIdTrackArtist = db.TRACK_ARTIST.Where(x => tempIdArtist.Contains(x.ID_ARTIST)).Select(x => x.ID_TRACK).ToList();
allIdTrackArtist = allIdTrackArtist.Distinct().ToList();
allIdTrackArtist.RemoveAll(x => x == id);
TRACK tempTrack = new TRACK();
foreach (var i in allIdTrackArtist)
{
tempTrack = db.TRACKs.SingleOrDefault(x => x.ID == i);
listTrack.Add(new List <string>()
{
tempTrack.ID.ToString(), tempTrack.NAME, tempTrack.LINK_IMG, tempTrack.LINK, tempTrack.COST.ToString()
});
listInfo.Add(new List <List <string> >()
{
db.TRACK_ARTIST.Where(p => p.ID_TRACK == i).Select(p => p.NAME_ARTIST).ToList(), db.TRACK_ARTIST.Where(p => p.ID_TRACK == i).Select(p => p.NAME_LABEL).Distinct().ToList()
});
}
ViewBag.listTrack = listTrack;
ViewBag.listInfo = listInfo;
return(PartialView());
}
// Track List -----------------------------------------
private List <TRACK> AllTrackList()
{
List <TRACK> list = new List <TRACK>();
try
{
var rows = DbHelper.Query("SELECT * FROM TRACK");
foreach (DataRow row in rows)
{
var trackList = new TRACK();
trackList.TRACK_NAME = (string)row["TRACK_NAME"];
trackList.DURATION = (int)row["DURATION"];
trackList.TRACK_NUMBER = (int)row["TRACK_NUMBER"];
trackList.TRACK_FILE = (string)row["TRACK_FILE"];
list.Add(trackList);
}
return(list);
}
catch (Exception)
{
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);
}
public ActionResult DeleteConfirmed(int id)
{
TRACK track = db.TRACKs.Find(id);
db.TRACKs.Remove(track);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Track/Delete/5
public ActionResult Delete(int id = 0)
{
TRACK track = db.TRACKs.Find(id);
if (track == null)
{
return(HttpNotFound());
}
return(View(track));
}
public ActionResult Edit(TRACK track)
{
if (ModelState.IsValid)
{
db.Entry(track).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(track));
}
public void PlayT5()
{
if (_Track == TRACK.T5)
{
return;
}
_Track = TRACK.T5;
Play();
}
public void PlayT2()
{
if (_Track == TRACK.T2)
{
return;
}
_Track = TRACK.T2;
Play();
}
public ActionResult Create(TRACK track)
{
if (ModelState.IsValid)
{
db.TRACKs.Add(track);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(track));
}
static void Main(string[] args)
{
MusicContext mc = new MusicContext();
TRACK t = new TRACK()
{
TRACK_NAME = "Man who sold is ferrari",
TRACK_ARTIST = 3
};
mc.TRACKs.Add(t);
mc.SaveChanges();
}
static void Main(string[] args)
{
using (UnitOfWork unitOfWork = new UnitOfWork(new CustomMusicContext()))
{
//tracks with where artist id=1
var tracks = unitOfWork.Tracks.GetTracksForArtist(1);
//add new song to prevoius artist
TRACK t = new TRACK()
{
TRACK_NAME = "Comfortably numb",
TRACK_ARTIST = 3
};
unitOfWork.Tracks.Add(t);
unitOfWork.Complete();
var artist = unitOfWork.Tracks.Find(x => x.TRACK_ARTIST == 3).ToList();
}
}
void Awake()
{
_Instance = this;
_Track = TRACK.NONE;
}
