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

namespace DAL
{
    /// <summary>
    /// FriendshipPolicyDAL類 
    /// </summary>
    public class FriendshipPolicyDAL : IDisposable
    {

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

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

            return objInfo;
        }

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

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

            return objItems;
        }

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

    }
}