public OrderDetailDTO GetOrderDetailsByOrderID(int ID) //burayı liste ye çekelim { EfOrderItemDAL forOrderItem = new EfOrderItemDAL(); using (MSSQLDbContext context = new MSSQLDbContext()) { var result = from p in context.Orders join c in context.Users on p.UserID equals c.ID where p.OrderID == ID select new OrderDetailDTO { CustomerID = p.UserID, CustomerName = c.FirstName, CustomerSurname = c.LastName, Deadline = p.Deadline, OrderDate = p.OrderDate, OrderID = p.OrderID, OrderStatus = p.OrderStatus, OrderItem = (from a in context.OrderItems where a.OrderID == p.OrderID select new OrderItem { Amount = a.Amount, OrderID = a.OrderID, orderItemID = a.orderItemID, ProductID = a.ProductID, }).ToList() }; return(result.First());//! } }
public List <OrderDetailDTO> GetOrderDetailsByCustomerID(int ID) { EfOrderItemDAL forOrderItem = new EfOrderItemDAL(); using (MSSQLDbContext context = new MSSQLDbContext()) { var result = from p in context.Orders join c in context.Users on p.UserID equals c.ID where c.ID == ID select new OrderDetailDTO { CustomerID = p.UserID, CustomerName = c.FirstName, CustomerSurname = c.LastName, Deadline = p.Deadline, OrderDate = p.OrderDate, OrderID = p.OrderID, OrderStatus = p.OrderStatus, OrderItem = (from a in context.OrderItems where a.OrderID == p.OrderID select new OrderItem { Amount = a.Amount, OrderID = a.OrderID, orderItemID = a.orderItemID, ProductID = a.ProductID, Product = context.Products.FirstOrDefault(p => p.ProductID == a.ProductID) }).ToList() }; return(result.ToList()); } }