/// <summary> /// returns list of orders /// </summary> /// <returns></returns> public IList <IOrderDTO> GetOrders() { IList <Order> orders = _orderDataAccess.GetOrders(); IList <IOrderDTO> ordersDTO = new List <IOrderDTO>(); IList <ICustomerDTO> customers = _customerBusiness.GetAllCustomers(); foreach (var order in orders) { IOrderDTO orderDTO = new OrderDTO(); orderDTO.Customer_email = customers.Where(c => c.Customer_id == order.Customer_id).Select(c => c.Customer_email).First(); orderDTO.Order_id = order.Order_id; orderDTO.Order_date = order.Order_date; orderDTO.Order_total = order.Order_total; orderDTO.Customer_id = order.Customer_id; orderDTO.Order_status = order.Order_status; orderDTO.Order_address = order.Order_address; orderDTO.Order_mobile = order.Order_mobile; orderDTO.Order_pincode = order.Order_pincode; ordersDTO.Add(orderDTO); } return(ordersDTO); }