public string OrderGridRead() { #region Deklaracje repozytoriow IOrderRepository orderRepository = new OrderRepository(); ILoadRepository loadRepository = new LoadRepository(); IRouteRepository routeRepository = new RouteRepository(); IStatusOrderRepository statusOrderRepository = new StatusOrderRepository(); ICustomerRepository customerRepository = new CustomerRepository(); #endregion #region Wypelnianie OrderListModelu string orderName = ""; string status = ""; string from = ""; string to = ""; string customerInformation = ""; DateTime date; #endregion List <OrderListModel> ordersListResult = new List <OrderListModel>(); List <Order> orders = orderRepository.getAllOrders(); foreach (var order in orders) { if (order.idLoad.HasValue) { orderName = loadRepository.getLoadNameById(order.idLoad.GetValueOrDefault()); } if (order.idStatus.HasValue) { status = statusOrderRepository.getStatusOrderNameById(order.idStatus.GetValueOrDefault()); } if (order.idRoutes.HasValue) { Tuple <string, string> route = routeRepository.getRouteStartEndById(order.idRoutes.GetValueOrDefault()); from = route.Item1; to = route.Item2; } if (order.idCustomer.HasValue) { customerInformation = customerRepository.getCustomerInformationById(order.idCustomer.GetValueOrDefault()); } date = order.CreatedAt; OrderListModel singleOrder = new OrderListModel { id = order.id, OrderName = orderName, Status = status, From = from, To = to, Customer = customerInformation, Date = date }; ordersListResult.Add(singleOrder); } return(JsonConvert.SerializeObject(ordersListResult)); }