/// <summary>
/// 取得不動產實價
/// </summary>
public async Task <Response <List <RealEstatePriceResponse> > > GetRealEstatePrice(RealEstatePriceRequest request)
{
using (IUnitOfWork uow = _unitOfWorkManager.Begin())
{
string sql = "SELECT * FROM Prices WHERE TransactionDate BETWEEN @BeginDate AND @EndDate";
object param = new { request.BeginDate, request.EndDate };
List <RealEstatePriceResponse> response = uow.PricesRepository
.Query <Prices>(sql, param)
.Select(price => new RealEstatePriceResponse
{
PriceID = price.PriceID,
District = price.District,
TransactionSign = price.TransactionSign,
HouseNumberPlate = price.HouseNumberPlate,
AreaSquareMeter = price.AreaSquareMeter,
TransactionDate = price.TransactionDate,
TransactionNumber = price.TransactionNumber,
TotalFlorNumber = price.TotalFlorNumber,
BuildingState = price.BuildingState,
MainUse = price.MainUse,
MainBuildingMaterials = price.MainBuildingMaterials,
CompleteDate = price.CompleteDate,
ShiftingTotalArea = price.ShiftingTotalArea,
Room = price.Room,
Hall = price.Hall,
Health = price.Health,
Compartmented = price.Compartmented,
ManageOrganization = price.ManageOrganization,
TotalPrices = price.TotalPrices,
UnitPrices = price.UnitPrices,
BerthCategory = price.BerthCategory,
BerthAreaSquareMeter = price.BerthAreaSquareMeter,
BerthTotalPrices = price.BerthTotalPrices,
Note = price.Note,
MainBuildingArea = price.MainBuildingArea,
OutbuildingArea = price.OutbuildingArea,
BalconyArea = price.BalconyArea,
Elevator = price.Elevator
})
.ToList();
return(new Response <List <RealEstatePriceResponse> >(response, "success"));
}
}
public async Task <IActionResult> GetRealEstatePrices([FromQuery] RealEstatePriceRequest request)
{
return(Ok(await _realEstatePrice.GetRealEstatePrice(request)));
}
