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

namespace DAL
{

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

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

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

            return objInfo;
        }

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

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

            return objItems;
        }

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

    }
}