public ActionResult detail(int OrderId)
{
ChicCutOrderViewModel result = (from o in _context.Daily_ChicCut_OrderModel
join ca in _context.AccountModel on o.CashierUserId equals ca.UserId
join cashier in _context.EmployeeModel on ca.EmployeeId equals cashier.EmployeeId
join pay in _context.PaymentMethodModel on o.PaymentMethodId equals pay.PaymentMethodId
join staffTmp in _context.EmployeeModel on o.StaffId equals staffTmp.EmployeeId into staffList
from staff in staffList.DefaultIfEmpty()
where o.OrderId == OrderId
select new ChicCutOrderViewModel()
{
OrderId = o.OrderId,
FullName = o.FullName,
Phone = o.Phone,
CashierName = cashier.FullName,
StaffName = staff.FullName,
CreatedDate = o.CreatedDate,
CashierDate = o.CashierDate,
SumPriceOfOrderDetail = o.SumPriceOfOrderDetail,
TotalBillDiscount = o.TotalBillDiscount,
Total = o.Total,
HairStyle = o.Master_ChicCut_HairTypeModel.HairTypeName,
Gender = o.Gender,
PaymentMethod = pay.PaymentMethodName
}).FirstOrDefault();
if (result != null)
{
result.details = (from d in _context.Daily_ChicCut_OrderDetailModel
where d.OrderId == result.OrderId
select new ChicCutOrderDetailViewModel()
{
COGS = d.COGS,
Qty = d.Qty,
ServiceName = d.Master_ChicCut_ServiceModel.ServiceName,
Price = d.Price,
UnitPrice = d.UnitPrice,
}).ToList();
#region #Add List Product vào
var LstProductDetail =
_context.Daily_ChicCut_OrderProductDetailModel.Where(p => p.OrderId == result.OrderId).Select(p => new ChicCutOrderDetailViewModel()
{
COGS = p.COGS,
Price = p.Price,
Qty = p.Qty,
UnitPrice = p.UnitPrice,
ServiceName = _context.ProductModel.Where(pd => pd.ProductId == p.ProductId).Select(pd => pd.ProductName).FirstOrDefault()
}).ToList();
result.details.AddRange(LstProductDetail); // Add Lst Product vào ListService
}
#endregion
return(Json(new
{
Code = System.Net.HttpStatusCode.Created,
Success = true,
Data = result
}));;
}
public ActionResult Edit(int OrderId)
{
ChicCutOrderViewModel result = (from o in _context.Daily_ChicCut_OrderModel
where o.OrderId == OrderId
select new ChicCutOrderViewModel()
{
OrderId = o.OrderId,
PaymentMethodId = o.PaymentMethodId
}).FirstOrDefault();
return(Json(result, JsonRequestBehavior.AllowGet));
}
