using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Reflection;
using DBaoBookingManagement.DataAccess;
using DBaoBookingManagement.Entity;

namespace DBaoBookingManagement.BusinessLogic
{
    /// <summary>
    /// 對Hotel表進行業(yè)務邏輯操作
    /// </summary>
    public class HotelBusiness : Business
    {
        private HotelAccessor ha = new HotelAccessor();

        private static HotelBusiness instance = null;
        private HotelBusiness() { }//私有構(gòu)造函數(shù)

        /// <summary>
        /// 獲取HotelBusiness對象
        /// </summary>
        /// <returns></returns>
        public static HotelBusiness GetInstance()
        {
            if (instance == null)
            {
                instance = new HotelBusiness();
            }
            return instance;
        }

        /// <summary>
        /// 根據(jù)ID查詢酒店
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public Hotel QueryById(int id)
        {
            Hotel entity = null;
            try
            {
                DataTable dt = ha.QueryById(id);
                if (dt.Rows.Count > 0)
                {
                    entity = new Hotel();
                    PropertyInfo[] props = typeof(Hotel).GetProperties();
                    for (int j = 0; j < props.Length; j++)
                    {
                        string columnName = props[j].Name;
                        object value = dt.Rows[0][columnName];
                        props[j].SetValue(entity, value, null);
                    }
                }
                return entity;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 查詢所有酒店
        /// </summary>
        /// <returns></returns>
        public Hotel[] QueryAll()
        {
            Hotel[] entityList = null;
            try
            {
                DataTable dt = ha.QueryAll();
                entityList = FillEntityList(entityList, dt);
                return entityList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根據(jù)城市ID查詢酒店
        /// </summary>
        /// <param name="cityId"></param>
        /// <returns></returns>
        public Hotel[] QueryByCityId(int cityId)
        {
            Hotel[] entityList = null;
            try
            {
                DataTable dt = ha.QueryByCityId(cityId);
                entityList = FillEntityList(entityList, dt);
                return entityList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根據(jù)酒店ID刪除酒店
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool DeleteById(int id)
        {
            try
            {
                return ha.DeleteById(id);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 添加酒店
        /// </summary>
        /// <param name="hotelName"></param>
        /// <param name="star"></param>
        /// <param name="description"></param>
        /// <param name="cityId"></param>
        /// <param name="synthesis"></param>
        /// <param name="pets"></param>
        /// <param name="activePlace"></param>
        /// <param name="service"></param>
        /// <param name="net"></param>
        /// <param name="parking"></param>
        /// <param name="cancel"></param>
        /// <param name="children"></param>
        /// <param name="creditcard"></param>
        /// <returns></returns>
        public bool Insert(string hotelName,int star,string description,int cityId,string synthesis,
            string pets,string activePlace,string service,string net,string parking,string cancel,
            string children,string creditcard)
        {
            Hotel entity = new Hotel();
            entity.HotelName = hotelName;
            entity.Star = star;
            entity.Description = description;
            entity.CityId = cityId;
            entity.Synthesis = synthesis;
            entity.Pets = pets;
            entity.ActivePlace = activePlace;
            entity.Service = service;
            entity.Net = net;
            entity.Parking = parking;
            entity.Cancel = cancel;
            entity.Children = children;
            entity.Creditcard = creditcard;
            try
            {
                return ha.Insert(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 修改酒店
        /// </summary>
        /// <param name="id"></param>
        /// <param name="hotelName"></param>
        /// <param name="star"></param>
        /// <param name="description"></param>
        /// <param name="cityId"></param>
        /// <param name="synthesis"></param>
        /// <param name="pets"></param>
        /// <param name="activePlace"></param>
        /// <param name="service"></param>
        /// <param name="net"></param>
        /// <param name="parking"></param>
        /// <param name="cancel"></param>
        /// <param name="children"></param>
        /// <param name="creditcard"></param>
        /// <returns></returns>
        public bool Update(int id,string hotelName,int star,string description,int cityId,string synthesis,
            string pets,string activePlace,string service,string net,string parking,
            string cancel,string children,string creditcard)
        {
            Hotel entity = new Hotel();
            entity.HotelId = id;
            entity.HotelName = hotelName;
            entity.Star = star;
            entity.Description = description;
            entity.CityId = cityId;
            entity.Synthesis = synthesis;
            entity.Pets = pets;
            entity.ActivePlace = activePlace;
            entity.Service = service;
            entity.Net = net;
            entity.Parking = parking;
            entity.Cancel = cancel;
            entity.Children = children;
            entity.Creditcard = creditcard; 
            try
            {
                return ha.Update(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        //填充實體類列表
        private Hotel[] FillEntityList(Hotel[] entityList, DataTable dt)
        {
            if (dt.Rows.Count > 0)
            {
                entityList = new Hotel[dt.Rows.Count];

                //用反射給實體類賦值
                for (int i = 0; i < entityList.Length; i++)
                {
                    Hotel entity = new Hotel();
                    PropertyInfo[] props = typeof(Hotel).GetProperties();
                    for (int j = 0; j < props.Length; j++)
                    {
                        string columnName = props[j].Name;
                        object value = dt.Rows[i][columnName];
                        props[j].SetValue(entity, value, null);
                    }
                    entityList[i] = entity;
                }
            }
            return entityList;
        }
    }
}