public Task <OrderViewModel.OrderListResult> GetAll()
{
return(Task.Run(() =>
{
OrderViewModel.OrderListResult result = new OrderViewModel.OrderListResult();
result.MyOrderList = _dbRepository.GetAll <Order>().Select(
o => new OrderViewModel.OrderSingleResult()
{ //plan的planId==orderdetail 的 planId 滿足這個條件後的planDate 要等於 orderdetail的planshipDate
OrderDetailList = _dbRepository.GetAll <OrderDetail>().Where(x => x.OrderId == o.OrderId).Select(x => new OrderDetail
{
PlanTitle = x.PlanTitle,
OrderPrice = x.OrderPrice,
OrderQuantity = x.OrderQuantity,
OrderDetailId = x.OrderDetailId,
Condition = x.Condition,
OrderPlanImgUrl = x.OrderPlanImgUrl,
PlanId = x.PlanId,
OrderDetailDes = x.OrderDetailDes,
ProjectId = x.ProjectId,
}).ToList(),
OrderAddress = o.OrderAddress,
OrderConEmail = o.OrderConEmail,
OrderId = o.OrderId,
OrderName = o.OrderName,
OrderTotalAccount = o.OrderTotalAccount,
OrderPhone = o.OrderPhone,
OrderDate = o.OrderDate.Date.ToString("d"),
Condition = o.Condition,
TradeNo = o.TradeNo,
MemberId = o.MemberId,
}).ToList();
return result;
}));
}
public OrderViewModel.OrderListResult GetTodayOrderPrice()
{
var today = DateTime.Now.Day;
//放入OrderVMList
List <OrderViewModel.OrderSingleResult> OrderVMList;
OrderVMList = (from Order in _dbRepository.GetAll <Order>().Where(x => x.CreateTime.Day == today)
join Member in _dbRepository.GetAll <Member>()
on Order.MemberId equals Member.MemberId
orderby Order.OrderDate descending
select new OrderViewModel.OrderSingleResult()
{
OrderId = Order.OrderId,
ShippingDate = Order.ShippingDate,
OrderDate = Order.OrderDate,
MemberId = Order.MemberId,
MemberUserName = Member.MemberUserName,
ShipName = Order.ShipName,
ShipCity = Order.ShipCity,
ShipRegion = Order.ShipRegion,
ShipAddress = Order.ShipAddress,
ShipPostalCode = Order.ShipPostalCode,
InvoiceType = Order.InvoiceType,
InvoiceInfo = Order.InvoiceInfo,
CreateTime = Order.CreateTime,
UpdateTime = Order.UpdateTime,
PaymentType = Order.PaymentType,
PaymentState = Order.PaymentState,
}).ToList();
OrderDetailViewModel.OrderListResult OrderDetailVMList = GetAllOrderDetail();
foreach (var OrderVM in OrderVMList)
{
OrderVM.OrderDetailList =
OrderDetailVMList.OrderDetailList
.Where(OrderDetail => OrderDetail.OrderId == OrderVM.OrderId)
.ToList();
}
var result = new OrderViewModel.OrderListResult();
result.OrderList = OrderVMList;
return(result);
}
