//public TrackDisplay GetSelectedSong(string TrackName,string AlbumName,int Price,int Downloads,string Genre,int Length) public TrackDisplay GetSelectedSong(TrackDisplay obj) { //TrackDisplay obj = new TrackDisplay(); //obj.TrackName = TrackName; //obj.AlbumName = AlbumName; //obj.Price = Price; //obj.Downloads = Downloads; //obj.Genre = Genre; //obj.Length = Length; //dal.OpenConn(); //SqlDataAdapter adp = new SqlDataAdapter("select Track.trackName, Album.albumName, Track.price, Track.downloads, Track.genre, Track.[length] from Track, Album, Singer where Track.TrackId = Singer.TrackID and Track.AlbumId = Album.AlbumId", dal.OpenConn()); //DataSet ds = new DataSet(); //int affected = adp.Fill(ds); //dal.CloseConn(); //TrackDisplay obj = new TrackDisplay(); //for (int i = 0; i < affected; i++) //{ // obj.TrackName = ds.Tables[0].Rows[i].ItemArray[0].ToString(); // obj.AlbumName = ds.Tables[0].Rows[i].ItemArray[1].ToString(); // obj.Price = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]); // obj.Downloads = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]); // obj.Genre = ds.Tables[0].Rows[i].ItemArray[4].ToString(); // obj.Length = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[5]); // res.Add(obj); //} return(obj); }
public List <TrackDisplay> GetViewSongs() { List <TrackDisplay> res = new List <TrackDisplay>(); dal.OpenConn(); SqlDataAdapter adp = new SqlDataAdapter("select Track.trackName, Album.albumName, Track.price, Track.downloads, Track.genre, Track.[length] from Track, Album, Singer where Track.TrackId = Singer.TrackID and Track.AlbumId = Album.AlbumId order by Album.Year DESC", dal.OpenConn()); DataSet ds = new DataSet(); int affected = adp.Fill(ds); dal.CloseConn(); TrackDisplay obj = new TrackDisplay(); for (int i = 0; i < affected; i++) { obj.TrackName = ds.Tables[0].Rows[i].ItemArray[0].ToString(); obj.AlbumName = ds.Tables[0].Rows[i].ItemArray[1].ToString(); obj.Price = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]); obj.Downloads = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]); obj.Genre = ds.Tables[0].Rows[i].ItemArray[4].ToString(); obj.Length = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[5]); res.Add(obj); } return(res); }
public void UpdateSongs(TrackDisplay obj) { // dal.OpenConn(); // SqlDataAdapter adp = new SqlDataAdapter("update Track.trackName, Album.albumName, Track.price, Track.downloads, Track.genre, Track.[length] from Track, Album, Singer where Track.TrackId = Singer.TrackID and Track.AlbumId = Album.AlbumId", dal.OpenConn()); // DataSet ds = new DataSet(); // int affected = adp.Fill(ds); // dal.CloseConn(); // TrackDisplay obj = new TrackDisplay(); // for (int i = 0; i < affected; i++) // { // obj.TrackName = ds.Tables[0].Rows[i].ItemArray[0].ToString(); // obj.AlbumName = ds.Tables[0].Rows[i].ItemArray[1].ToString(); // obj.Price = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]); // obj.Downloads = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]); // obj.Genre = ds.Tables[0].Rows[i].ItemArray[4].ToString(); // obj.Length = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[5]); // res.Add(obj); // } // return res; }
public List<TrackDisplay> GetViewSongs() { List<TrackDisplay> res = new List<TrackDisplay>(); dal.OpenConn(); SqlDataAdapter adp = new SqlDataAdapter("select Track.trackName, Album.albumName, Track.price, Track.downloads, Track.genre, Track.[length] from Track, Album, Singer where Track.TrackId = Singer.TrackID and Track.AlbumId = Album.AlbumId order by Album.Year DESC", dal.OpenConn()); DataSet ds = new DataSet(); int affected = adp.Fill(ds); dal.CloseConn(); TrackDisplay obj = new TrackDisplay(); for (int i = 0; i < affected; i++) { obj.TrackName=ds.Tables[0].Rows[i].ItemArray[0].ToString(); obj.AlbumName=ds.Tables[0].Rows[i].ItemArray[1].ToString(); obj.Price=Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2]); obj.Downloads=Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3]); obj.Genre=ds.Tables[0].Rows[i].ItemArray[4].ToString(); obj.Length = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[5]); res.Add(obj); } return res; }