Пример #1
0
        //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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        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;
        }
Пример #4
0
        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;
        }