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);
}
}
