using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;

namespace DAL
{

    /// <summary>
    /// StarDAL類 
    /// </summary>
    public class StarDAL : IDisposable
    {

        public StarInfo Select(int id)
        {
            string strSQL = "SELECT * FROM Star where id=" + id;
            StarInfo objInfo = new StarInfo();

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, strSQL, null))
            {
                if (rdr.Read())
                {
                    objInfo.Id = Convert.ToInt32(rdr["Id"]);
                    objInfo.Star = rdr["Star"].ToString();
                }
            }

            return objInfo;
        }

        public List<StarInfo> SelectAll()
        {
            string strSQL = "SELECT * FROM Star";
            List<StarInfo> objItems = new List<StarInfo>();

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, strSQL, null))
            {
                while (rdr.Read())
                {
                    StarInfo objInfo = new StarInfo();
                    objInfo.Id = Convert.ToInt32(rdr["Id"]);
                    objInfo.Star = rdr["Star"].ToString();
                    objItems.Add(objInfo);
                }
            }

            return objItems;
        }

        #region IDisposable 成員
        public void Dispose()
        {
            GC.SuppressFinalize(this);
        }
        #endregion

    }
}