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

namespace DBaoBookingManagement
{
    /// <summary>
    /// 所有數據操作類的父類
    /// </summary>
    public class DataAccessor
    {
        //獲取sql連接
        private SqlConnection GetSqlConnection()
        {
            string strConn="Data Source=.;Initial Catalog=DBaoBooking;User ID=sa;Password=";
            return new SqlConnection(strConn);
        }

        //執行對sql server數據庫的編錄操作，成功返回true，失敗為false
        protected bool ExecuteSqlNoneQuery(string sql)
        {
            SqlConnection conn = null;
            try
            {
                conn = GetSqlConnection();
                conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                return true;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }

        protected DataTable Query(string sql)
        {
            SqlConnection conn = null;
            try
            {
                conn = GetSqlConnection();
                conn.Open();
                SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
                DataTable dt = new DataTable();
                adapter.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }
    }
}