using Community.DAL;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;

namespace Community.Controllers
{
    public class BuildController : ApiController
    {
        public BuildController() { }

        [AcceptVerbs("Get")]
        public DataTable QueryBuildingById(int id)
        {
            return QueryDAL.QueryBuildingById(id);
        }

        [AcceptVerbs("Get")]
        public DataTable QueryHouse(string name, string unit, string num)
        {
            if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(unit) || string.IsNullOrEmpty(num))
            {
                return null;
            }

            return QueryDAL.QueryHouse(name, unit, num);
        }

        [AcceptVerbs("Get")]
        public DataTable QueryHousehold(int id)
        {
            return QueryDAL.QueryHousehold(id);
        }

        [AcceptVerbs("Get")]
        public DataTable QueryHousehold(string name = "")
        {
            return QueryDAL.QueryHousehold(name);
        }

        [AcceptVerbs("Get")]
        public DataTable QueryHouseholdByBuilding(string name, string unit, string num)
        {
            if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(unit) || string.IsNullOrEmpty(num))
            {
                return null;
            }

            return QueryDAL.QueryHouseholdByBuilding(name, unit, num);
        }

        [AcceptVerbs("Get")]
        public DataTable QueryHouseholdByUserId(int id)
        {
            return QueryDAL.QueryHouseholdByUserId(id);
        }

        [AcceptVerbs("Get")]
        public DataTable CountGender(string name = "")
        {
            return QueryDAL.CountGender(name);
        }

        [AcceptVerbs("Get")]
        public DataTable CountNation(string name = "")
        {
            return QueryDAL.CountNation(name);
        }

        [AcceptVerbs("Get")]
        public DataTable CountPolitical(string name = "")
        {
            return QueryDAL.CountPolitical(name);
        }

        [AcceptVerbs("Get")]
        public DataTable CountHouse(string name = "")
        {
            return QueryDAL.CountHouse(name);
        }

        [AcceptVerbs("Get")]
        public DataTable CountStatus(string name = "")
        {
            return QueryDAL.CountStatus(name);
        }
    }
}