public IActionResult showCustomerOrders(showCustomerOrdersRequest request) { //request.NameCustomer = "Jakub"; var response = _service.showCustomerOrders(request); if (response.code == 404) { return(NotFound(response)); } else if (response.code == 500) { return(BadRequest(response)); } else { return(Ok(response)); } }
public showCustomerOrdersResponse showCustomerOrders(showCustomerOrdersRequest request) { var response = new showCustomerOrdersResponse(); DbContextCreate clientContext = new DbContextCreate(); if (request.NameCustomer != null) { var linqQuery = from customer in clientContext.Customers join orders in clientContext.Orders on customer.IdClient equals orders.IdClient where customer.Name == request.NameCustomer select orders; if (linqQuery.Count() == 0) { response.message = "There is no client with this name!"; response.code = 404; return(response); } List <Orders> ordersList = linqQuery.ToList(); List <orderElement> orderElementsList = new List <orderElement>(); foreach (var order in ordersList) { var orderElement = new orderElement(); orderElement.IdOrder = order.IdOrder; orderElement.DateAccepted = order.DateAccepted; orderElement.DateFinished = order.DateFinished; orderElement.Notes = order.IdOrder; List <Confectionery_Order> confectioneryOrderList = _context.Confectionery_Order.Where(c => c.IdOrder == order.IdOrder).ToList(); foreach (var confectionary_order in confectioneryOrderList) { confectionary_order.Confectionery = _context.Confectionery.Where(c => c.IdConfection == confectionary_order.IdConfection).First(); } orderElement.confectionariesOrdersList = confectioneryOrderList; orderElementsList.Add(orderElement); } response.ListOfOrders = orderElementsList; response.code = 200; return(response); } else { var linqQuery = from customer in clientContext.Customers join orders in clientContext.Orders on customer.IdClient equals orders.IdClient select orders; List <Orders> ordersList = linqQuery.ToList(); List <orderElement> orderElementsList = new List <orderElement>(); foreach (var order in ordersList) { var orderElement = new orderElement(); orderElement.IdOrder = order.IdOrder; orderElement.DateAccepted = order.DateAccepted; orderElement.DateFinished = order.DateFinished; orderElement.Notes = order.IdOrder; List <Confectionery_Order> confectioneryOrderList = _context.Confectionery_Order.Where(c => c.IdOrder == order.IdOrder).ToList(); foreach (var confectionary_order in confectioneryOrderList) { confectionary_order.Confectionery = _context.Confectionery.Where(c => c.IdConfection == confectionary_order.IdConfection).First(); } orderElement.confectionariesOrdersList = confectioneryOrderList; orderElementsList.Add(orderElement); } response.ListOfOrders = orderElementsList; response.code = 200; response.message = "You dont provide any name, listing all orders.."; return(response); } }